Data Warehouse Engineer (Snowflake / Informatica)

Hello,

Urgently hiring for the below role with NYS.

Note: We are the direct prime vendors with the State Of New York.

Job Title: Sr Data Warehouse Engineer (Snowflake / Informatica)

Job ID: HBITS-08-14956

Location: 1 Commerce Plaza, Albany, NY 12257 (Hybrid role)

Duration: 30 months

Client / Dept.: New York State Department of Financial Services

Rate: $75/hr on C2C (All incl.)

WebEx interview needed

At least 12+ yrs. of resume needed for submission.

JOB DESCRIPTION:

84 Months Experience in Snowflake data warehouse development and administration.

84 Months Experience in Snowflake performance tuning and improvement.

84 Months Experience in Informatica pipeline development and data transformation.

84 Months Experience in Informatica performance tuning and improvement.

84 Months Experience in RDBMS (Relational Database Management System) and SQL Query development.

48 Months Experience in solution architecture & modeling.

84 Months Experience in database and platform security & governance.

Day to day task to be performed:

Monitor DFS 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.