Description

You will design, develop, and maintain ETL processes to support data warehouse loading. You will own the full lifecycle of data workflows, from gathering requirements to ensuring data integrity through rigorous testing.

Responsibilities

• Gather requirements and develop technical specifications for ETL workflows.
• Design and implement data load types including incremental, full history, and survivorship rules.
• Implement change data capture (CDC) mechanisms and manage ETL job scheduling.
• Develop complex SQL queries and test/debug ETL jobs to ensure data integrity.

Required Skills

• 6 years of experience developing ETL processes and technical specifications.
• 6 years of experience with complex SQL development.
• 6 years of experience testing and debugging ETL pipelines.
• 6 years of experience developing various data load types.
• 4 years of experience implementing change data capture (CDC).
• 2 years of experience with ETL job scheduling.
• 2 years of experience loading data warehouses using ETL tools.
• 2 years of experience with Alteryx.
• Any Graduate degree.

Preferred Skills

• Experience managing multiple ETL tools.
• Experience with data quality tools, frameworks, and source code version control.

Key Skills

Education

Any Graduate