Data Warehouse Engineer (Snowflake / Informatica)

Hybrid in Albany, NY, US • Posted 2 hours ago • Updated 2 hours ago
Contract Independent
Contract Corp To Corp
Contract W2
30 Months
On-site
Up to $75/hr
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • snowflake
  • data warehouse
  • Informatica
  • data transformation
  • RDBMS
  • SQL Query
  • platform security
  • database

Summary

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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10106959
  • Position Id: 9070555
  • Posted 2 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Albany, New York

3d ago

Easy Apply

Third Party, Contract

Depends on Experience

Albany, New York

Yesterday

Easy Apply

Contract

Depends on Experience

Hybrid in Albany, New York

9d ago

Easy Apply

Contract, Third Party

66 - 68

Albany, New York

Today

Contract, Third Party

DOE

Search all similar jobs