Remote Data Warehouse Developer-III

Summary

The client is seeking a remote Data Warehouse Developer-III with at least 6 years of experience in ETL, preferably 2 years with Alteryx. Responsibilities include gathering requirements, designing ETL jobs, developing various types of data loads, implementing change data capture, testing and debugging ETL, developing complex SQL, and scheduling ETL jobs using different tools such as SSIS, SSRS, SQL Server, Tableau, Semarchy, Git & GitHub. The candidate will also mentor others on ETL development and manage multiple projects and tasks.

Requirements

At least 6 years of experience with ETL tools, preferably 2 years with Alteryx

Responsibilities

• Gathering requirements and developing technical specifications for ETL
• Designing ETL jobs using ETL tools, preferably Alteryx
• Developing various types of data loads (e.g. incremental, history/full, survivorship rules)
• Implementing change data capture
• Testing and debugging ETL jobs
• Developing complex SQL queries
• Scheduling ETL jobs using different tools such as SSIS, SSRS, SQL Server, Tableau, Semarchy, Git & GitHub
• Mentoring others on ETL development