We are seeking an experienced and vision driven Senior ETL Automation Tester to architect, build, and maintain our enterprise Data & ETL Quality Assurance automation framework. In this role, you will lead the end to end quality strategy for large scale data pipelines—from test planning and requirement traceability to test execution and automated reporting. The ideal candidate possesses deep expertise in Python, PySpark, Pandas, and Robot Framework, coupled with up-to-date AI driven development tools like GitHub Copilot to accelerate SQL query generation and schema validation across complex data architectures.
Role Details
. Job Title: Senior ETL Automation Tester
. Employment Type: Full time
. Location: Hybrid {Bengaluru or Chennai}
. Experience : 5+
Key Responsibilities
1. Framework Architecture & Technical Leadership
. Architect & Enhance Frameworks: Design, build, and maintain scalable, reusable ETL automation test frameworks using Python, PySpark, Pandas, and Robot Framework.
. Data Orchestration:
Develop PySpark based orchestration mechanisms to execute SQL queries and perform high performance comparisons and validations on large, complex data volumes.
. Data Injection & Feed Handling: Design configurable data injection strategies and validate source feed consumption across varied streaming and batch architectures.
. AI Assisted Engineering: Leverage GitHub Copilot to auto generate complex SQL queries directly from data transformation mapping rules, database schemas, and data models.
2. Test Planning, Strategy & Traceability
. End to End Test Strategy: Formulate comprehensive Test Strategies and detailed Test Plans covering baseline testing, regression, data integrity, and performance validation.
. Requirement Traceability: Construct and maintain a robust Requirement Traceability Matrix (RTM) to ensure 100% test coverage across data transformation rules and business logic.
. Test Data Management: Establish robust tes