Description

You will own the end-to-end testing of ETL processes, ensuring data integrity and pipeline reliability.

This role is hybrid.

Responsibilities

• Test ETL processes using advanced SQL queries and data comparison across tables.
• Develop and execute automated job executions and shell scripting routines.
• Validate data integrity using knowledge of 3NF and dimensional models.
• Apply ETL concepts including fact loads and surrogate key management.

Required Skills

• 10+ years of experience in ETL Testing.
• Strong proficiency in SQL, including advanced query writing.
• Working knowledge of UNIX environments.
• Experience with job scheduling tools like Autosys.
• Familiarity with ETL concepts (3NF, Dimensional models, facts loads, surrogate keys).
• Hands-on experience with automation testing using Python, Ruby, or Java.
• Experience implementing testing frameworks like Cucumber.

Preferred Skills

• Knowledge of core ETL concepts.

Key Skills

Education

Any Graduate