About this role
Job Description
Experience: 6-8 Years Role Summary : We are seeking an experienced ETL Tester to validate enterprise data warehouse solutions built on Snowflake, AWS, Python, and Oracle. The role involves ensuring data accuracy, completeness, integrity, and quality across end-to-end ETL pipelines and cloud-based data platforms.
Key Responsibilities
- Design and execute ETL, integration, regression, and UAT test cases.
- Validate source-to-target mappings, transformation rules, and business logic.
- Perform data reconciliation
- Validate Fact tables, Dimension tables, SCDs, and data warehouse models.
- Test Snowflake objects and AWS data pipelines.
- Develop Python scripts for automated data validation.
- Track defects using JIRA Primary Skills (Mandatory)
- ETL Testing & Data Warehouse Testing
- Data Reconciliation & Data Quality Testing
- Advanced SQL and Data Validation
- Snowflake
- AWS (S3, Step Functions, CloudWatch)
- Oracle Database & PL/SQL
- Python
- Agile/Scrum Qualifications : Bachelor’s degree in Computer Science, IT, Engineering, or related field with 6+ years of ETL/Data Warehouse Testing experience.