• Aptask
  • $94,750.00 -148,460.00/year*
  • Oakland Gardens , NY
  • Information Technology
  • Full-Time
  • 64-20 Bell Blvd

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

Associated topics: data administrator, data center, data engineer, data integrity, data scientist, data warehouse, database, etl, sql, teradata

* 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.

Launch your career - Upload your resume now!

Upload your resume

Loading some great jobs for you...