Position Description

Position Overview

We are seeking an experienced and vision driven Lead 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: Lead ETL Automation Tester
Employment Type: Full time
Location: Hybrid {Bengaluru or Chennai}
Experience : 7+

Key Responsibilities

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.
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 test data management and synthetic data

📌 Lead ETL Automation Tester (Bengaluru)
🏢 CGI
📍 Bengaluru