Description

You will own end-to-end ETL testing and data verification for data warehousing workflows.

This role is on-site.

Responsibilities

• Execute software testing and data verification processes to ensure data integrity across tables.
• Develop and run detailed test cases for ETL processes and data warehousing workflows.
• Perform data comparison using advanced SQL queries and joins.
• Manage automated job executions using shell scripting and Autosys.
• Validate complex data models including 3NF, dimensional models, fact loads, and surrogate keys.

Required Skills

• 10+ years of experience in ETL testing and data verification.
• Advanced SQL skills for complex queries and data comparison.
• Proficiency with UNIX and shell scripting.
• Experience with Autosys for job scheduling.
• Hands-on experience with ETL automation using Python, Ruby, Cucumber, or Java.
• Working knowledge of AWS services.
• Strong understanding of 3NF and dimensional modeling.

Preferred Skills

• Experience with data warehousing processes.

Key Skills

Education

Any Graduate