Key Responsibilities:
- Lead and manage the ETL testing team to ensure effective execution of testing processes.
- Define and drive testing strategies, methodologies, and best practices for ETL projects.
- Develop and oversee the creation of detailed test plans, test cases, and test scripts.
- Validate data across multiple sources, ensuring accurate transformation and loading into target systems.
- Collaborate with development teams to understand system requirements and contribute to ETL design and mapping.
- Ensure high data quality by testing all aspects of extraction, transformation, and loading.
- Track, manage, and resolve defects in close coordination with developers and stakeholders.
- Mentor and support junior ETL testers, promoting skill development and performance growth.
- Develop and maintain automated testing frameworks for recurring test scenarios.
- Conduct complex data validation and reconciliation across various systems and databases.
- Execute performance and regression testing to evaluate ETL stability and scalability.




- Work with business analysts to align testing scenarios with business requirements.
- Generate test reports, dashboards, and documentation to communicate testing progress and defects.
- Identify process inefficiencies and recommend enhancements to optimize ETL testing practices.

Required Skills & Qualifications:
- Bachelor's degree in Computer Science, Information Technology, or related field.
- 5+ years of ETL testing experience, with 2+ years in a leadership or team lead role.
- Extensive experience with ETL tools such as Informatica, Talend, or SSIS.
- Robust understanding of data warehousing concepts and architecture.
- Proficiency in SQL and hands-on experience with databases like Oracle, SQL Server, MySQL, or PostgreSQL.
- Proven track record of creating and executing ETL test plans, test scripts, and test scenarios.
- Experience with data migration, data validation, and integration testing.
- Skilled in performance and regr

📌 ETL Test Lead (Secunderabad)
🏢 Sonata Software
📍 Secunderabad