ETL Tester
Location : Pune / Chennai / Bangalore
Experience : 3- 6 Years
Job Summary :
We are seeking an experienced Data Tester to design, build, and execute test strategies for data pipelines, ETL workflows, and data warehouse systems. The ideal candidate should have strong knowledge of data validation, automation, and quality assurance processes in data-driven environments.
Roles & Responsibilities :
- Design and implement test strategies for ETL processes, data pipelines, and data warehouse projects.
- Develop and execute automated test scripts for data validation, data transformation, and quality checks.
- Perform data profiling, reconciliation, and consistency checks across multiple data sources.
- Collaborate with data engineers, developers, and BI teams to ensure end-to-end data integrity.
- Validate data against business rules, mapping documents, and transformation logic.
- Conduct regression testing, system integration testing (SIT), and user acceptance testing (UAT) support.
- Identify defects, document issues, and ensure timely closure with development teams.
- Maintain test documentation, test cases, test results, and adhere to testing best practices.
- Ensure compliance with data quality frameworks, governance policies, and standards.
Required Skills & Qualifications :
3- 6 years of experience in data testing, ETL testing, or data warehouse QA roles.Strong SQL skills for data validation and complex query writing.Hands-on experience with ETL tools (Informatica, Talend, DataStage, SSIS, etc.).Experience with data quality tools, automation frameworks, or scripting (Python preferred).Understanding of data models, data mapping, and data transformation logic.Knowledge of cloud platforms (AWS, Azure, GCP) is a plus.Strong analytical, communication, and problem-solving skills.Good to Have :
Experience working in Agile / Scrum environments.Familiarity with BI tools and reporting platforms.Exposure to big data technologies (Spark, Hadoop, Hive).(ref : hirist.tech)