Data Warehouse Automation Engineer - job id 33472

Your Way To Work™

Data Warehouse Automation Engineer

Market Rate

Lower Manhatten (NOHO)

How to Apply


Jessica Ohmer


(646) 876-9549


(212) 616-4800 ext-570

A Contract position at Premier New York Education Institution.

Pay Options: IC - Self Incorporated or w2.

Contact Jessica Ohmer. call (646)876-9549 / (212)616-4800 ext.570 or email with the Job Code JO33472 or Click the Apply Now button ().

Location: 726 Broadway.

Skills required for the position: ETL.

Detailed Info: The Data Warehouse Automation Engineer will develop Code Automation templates for building out a Data Vault. The candidate must have experience utilizing metadata describing the source to target rules for populating hubs, links, and satellites from source and staging tables. Ability to take data integration patterns and generate the SQL and ETL code for invoking datastage jobs and SnowSQL (ANSI SQL) is required. The Code Automation Scripts will be crested utilizing a combination of Talend Open Studio and Java Scripting.

Development/Computing Environment: Essential Experience:

3+ years Dimensional Modeling and Automation Patterns (Dimensions, Facts, SCD I & II)

5+ years of ETL Development experience

Expert knowledge of ANSI SQL

Knowledge of ETL tools such as DataStage, Talend, Informatica, SSIS

Working knowledge of Semi-Structured data formats such as XML, Json

Excellent communications skills - both written and verbal

Inquisitive, detail oriented, self-starter, can effectively work independently or in a team

Desirable Experience:

Data Vault Modeling and Automation Patterns (Hub, Link, Satellite)

Auditing, logging, and notification of ETL processes

Snowflake DB

Test Automation and Continuous Integration

CAT development utilizing AnalytixDS.

The position offers competitive rate.

Job Id: 33472