Data Warehouse Automation Engineer
Lower Manhatten (NOHO)
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 email@example.com 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
Data Vault Modeling and Automation Patterns (Hub, Link, Satellite)
Auditing, logging, and notification of ETL processes
Test Automation and Continuous Integration
CAT development utilizing AnalytixDS.
The position offers competitive rate.
Job Id: 33472