- $94,750.00 -148,460.00/year*
26 Bristol St
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.
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
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
Associated topics: data administrator, data analytic, data center, data manager, data management, data scientist, data warehousing, hbase, mongo database, sql
* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.
Loading some great jobs for you...