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
[email protected] 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 • Resume
• 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.
