1.20. Data Warehouse Developer

Focused HR Solutions • Madison, WI

17h • Remote

About The Position

Our direct client has an opening for a Data Warehouse Developer. This position is for up to 13 months with the option of extension. The manager is also looking for candidates with strong and recent SQL skills. Alteryx experience related to ETL is a plus, as many candidates have experience based more on data prep.

Requirements

• 6 years of experience gathering requirements and developing technical specifications for ETL
• 6 years of experience using ETL tools to design ETL jobs
• 6 years of experience developing various types of data loads (e.g. incremental, history/full, survivorship rules)
• 4 years of experience implementing change data capture (CDC)
• 6 years of experience testing and debugging ETL
• 6 years of recent and strong SQL skills
• 2 years of experience with ETL job scheduling
• 2 years of experience loading data warehouses using ETL tools
• 2 years of experience with Alteryx

Nice To Haves

• Management of multiple ETL tools
• Experience with data quality tools and frameworks
• Using source code version control software

Responsibilities

• Gathering requirements and developing technical specifications for ETL
• Using ETL tools to design ETL jobs
• Developing various types of data loads (e.g. incremental, history/full, survivorship rules)
• Implementing change data capture (CDC)
• Testing and debugging ETL
• Developing complex SQL
• ETL job scheduling
• Loading data warehouses using ETL tools

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed