ETL Data Tester (RARR Job 5991)

The ideal candidate will be responsible for ensuring data quality, accuracy, and integrity across ETL workflows and data pipelines. The role involves validating data transformations, performing database testing, and collaborating with cross-functional teams to resolve data quality issues.

Key Responsibilities

• Design and execute data testing strategies for ETL workflows

• Perform data validation testing to ensure accuracy, completeness, and consistency of data

• Develop and execute test cases for data validation, transformation, and data integration processes

• Use ANSI SQL queries to validate and verify data in databases

• Validate data transformations and data flow across source and target systems

• Analyze test results and identify, document, and track data defects

• Collaborate with data engineers, ETL developers, and business teams to resolve data issues

• Maintain and update test documentation, test cases, and test scripts

• Support implementation of data testing best practices and automation

• Ensure compliance with data governance and data quality standards

• Communicate testing progress, risks, and results to stakeholders

• Mentor junior testers and support continuous improvement in testing processes

Required Skills

• Strong experience in Data Testing

• Good knowledge of ETL Concepts and Data Warehousing

• Hands-on experience with ANSI SQL / Database Testing

• Experience in data validation, data reconciliation, and data quality checks

• Understanding of ETL workflows and data pipelines

• Experience with defect tracking and test management tools

Good to Have Skills

• Experience with ETL tools (Informatica, Talend, SSIS, etc.)

• Knowledge of test automation for data testing

• Exposure to data governance and data quality frameworks