This site uses cookies. To find out more, see our Cookies Policy

Data Warehouse Engineer in New York, NY at Eliassen Group

Date Posted: 6/6/2019

Job Snapshot

  • Employee Type:
  • Location:
    New York, NY
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:

Job Description

Job Description: 
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. 

Essential Experience: 
3+ years Dimensional Modeling and Automation Patterns (Dimensions, Facts, SCD I and 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