About the role
Experience Required: 6+ Years
Location: Hyderabad, India
Job Type: Full-time / Permanent
Work Mode: [Onsite / Hybrid / Remote – specify as needed]
Job Summary:We are seeking a highly skilled ETL Test Engineer with a strong background in ETL testing, SQL, Python scripting, and test automation. The ideal candidate will be responsible for validating data pipelines, ensuring data quality, and automating test processes for large-scale data environments.
Key Responsibilities:- Design and execute comprehensive ETL test cases, test scenarios, and test plans.
- Perform data validation, data integrity, and data quality testing across source and target systems.
- Write complex SQL queries to verify data accuracy and transformations.
- Develop and maintain Python scripts to automate data validation and regression tests.
- Work closely with data engineers and analysts to understand ETL workflows and business logic.
- Automate repetitive test cases and integrate them into CI/CD pipelines.
- Conduct root cause analysis of defects and ensure timely resolution.
- Document test results, defects, and provide detailed reports to stakeholders.
- ETL Testing – experience validating data flows, transformations, and load processes
- SQL – strong hands-on experience writing and optimizing complex queries (Oracle, Teradata, or similar)
- Python – experience with scripting for automation, data parsing, and validation
- Automation Tools – experience with test automation frameworks (e.g., PyTest, Selenium, or custom frameworks)
- Data Warehousing Concepts – understanding of star/snowflake schema, fact/dimension tables
- Version Control – Git, Bitbucket
- Bachelor’s degree in Computer Science, Engineering, or related field
- 6+ years of experience in ETL/data warehouse testing
- Excellent understanding of QA methodologies, test planning, and defect management
- Strong problem-solving, analytical, and communication skills
- Experience with Big Data tools (Hadoop, Spark, Hive)
- Knowledge of CI/CD pipelines (Jenkins, Azure DevOps)
- Exposure to cloud data platforms (AWS, GCP, or Azure)
- Experience with BI report validation (Tableau, Power BI)