Key Responsibilities

- Design and execute ETL test strategies, test cases, and test scenarios.
- Validate data across source, staging, and target systems.
- Perform data completeness, accuracy, integrity, transformation, and reconciliation testing.
- Write complex SQL queries for backend and data validation.
- Develop and execute Python scripts for test automation and data validation.
- Test complex data transformations, business rules, mappings, and data pipelines.
- Validate incremental loads, full loads, CDC, and SCD models.
- Perform functional, integration, regression, and end-to-end ETL testing.
- Identify, analyze, and report data defects and coordinate with development/data engineering teams for resolution.
- Maintain automated test scripts and contribute to improving the overall QA automation framework.
- Analyze test results and prepare test reports and quality metrics.
- Participate in Agile ceremonies and collaborate with cross-functional teams.





Required Skills & Experience Technical Skills
- Robust experience in ETL/Data Warehouse Testing.
- SQL - Intermediate to Advanced proficiency.
- Hands-on experience with Python for QA and test automation.
- Strong understanding of ETL concepts and data warehouse architecture.
- Experience testing data extraction, transformation, and loading processes.
- Experience with data validation and reconciliation.
- Good understanding of SCD Type 1 and Type 2.
- Experience with database testing and complex SQL queries.
- Knowledge of API/file/database-based data sources is an advantage.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 ETL Testing with Python Professional (Chennai)
🏢 Perydot
📍 Chennai