Job Title: Database Architect - Expert Task ID: HBITS-08-14956 Position Duration: 30 Months Client: State of NY Agency: Department of Financial Services
Please call
(703) 466-0951 | (571) 351-1868 | (703) 348-3018 or email at
nysreqs@ilinksolutions.com
Description- Monitor Client Snowflake credit usage, adjust resource monitors, and tune virtual warehouses
- Manage Snowflake users and roles, enforce security policies, audit Snowflake access
- Write and tune SQL queries, build Snowflake ELT pipelines, manage compute and cost, and configure security and governance
- Build and update Informatica mappings, and configure workflows.
- Perform unit testing and validate data integrity
- Troubleshoot failures, tune performance
- Documentation ETL process, security policies, system architecture, user guides and etc.
Mandatory Qualifications| 1 | 84 Months Experience in Snowflake data warehouse development and administration. |
| 2 | 84 Months Experience in Snowflake performance tuning and improvement. |
| 3 | 84 Months Experience in Informatica pipeline development and data transformation. |
| 4 | 84 Months Experience in Informatica performance tuning and improvement. |
| 5 | 84 Months Experience in RDBMS (Relational Database Management System) and SQL Query development. |
| 6 | 48 Months Experience in solution architecture & modeling. |
| 7 | 84 Months Experience in database and platform security & governance. |
| Required Documentation | " Re sume
" Copy of Candidate Identification
(i.e., Driver's License/Green Card/Visa and Passport if applicable)
" Any documents referenced in the above Requested Qualifications
(i.e., professional certifications, degrees, etc.) |
i-Link Solutions requires a Bachelor's Degree or its equivalent in Computer Science, Computer Information Systems, Information Systems or a closely related field of study for all positions.
Disclaimer: i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability