BENGALURU · FULLTIME
Senior ETL Automation Tester
Coralai
Bengaluru · onsite · Posted 1d ago
Sourced from
Undisclosed7–11 yrsfulltimeBengaluru
About a minute. You'll make an account on the way through.
agent · working
- Read this posting0.7s
- Found the form on Naukri · 14 questions to answer1.5s
- Decided the answers for all of them3.2s
- Tailor your résumé to this role
- Waiting for you
Section · 01
About this role
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 test data management and synthetic data injection methodologies to simulate production workloads.
3. Reporting, Validation & Quality Assurance
. Advanced Report Validation: Build automated report validation workflows using Pandas alongside Pyodbc, Pandera (data validation/schema enforcement), Pywinauto, and Excel parsing libraries.
. Defect Life Cycle & Execution: Lead test execution cycles, log detailed data defects, collaborate closely with data engineering teams, and deliver accurate execution metrics to stakeholders.
. Mentorship & Process Improvement: Provide technical guidance to QA engineers, champion automation best practices, and continuously refine test processes.
Required Skills & Qualifications
Technical Competencies
. Programming & Scripting: Expert proficiency in Python, including deep familiarity with core libraries (Pandas, Pyodbc, Pandera).
. Big Data & Query Orchestration: Strong experience with PySpark for querying and validating multi gigabyte/terabyte scale datasets.
. Test Automation Frameworks: Proven experience architecting test automation suites using Robot Framework tailored for data and ETL pipelines.
. AI Tooling & Code Generation: Hands on experience utilizing GitHub Copilot (or similar LLM driven developer tools) for automated SQL query generation based on source to target mapping documents.
. SQL & Data Modeling: Advanced SQL skills with deep knowledge of relational databases, data warehousing concepts, and data transformation logic.
. Reporting & UI/Desktop Automation: Experience with Pywinauto and Python Excel libraries (openpyxl, xlsxwriter) for automated report verification.
Professional Experience & Soft Skills
. Experience: 7+ years in Data / ETL Testing, with at least 34years in a technical leadership.
. Testing Lifecycle: Demonstrated mastery of QA methodologies, Test Plan creation, RTM maintenance, execution tracking, and metric reporting.
. Analytical & Problem Solving: Exceptional ability to diagnose complex data discrepancies between source and target systems.
. Communication: Strong communication skills to liaise effectively between business analysts, data architects, and software engineering teams.
Preferred Qualifications
. Experience with Cloud Data Warehouses (e.g., Snowflake, Databricks, BigQuery, AWS Redshift).
. Familiarity with CI/CD integration for test automation suites (e.g., GitHub Actions, Jenkins, Azure DevOps).
. Knowledge of regulatory compliance standards and data governance frameworks.
. 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 test data management and synthetic data injection methodologies to simulate production workloads.
3. Reporting, Validation & Quality Assurance
. Advanced Report Validation: Build automated report validation workflows using Pandas alongside Pyodbc, Pandera (data validation/schema enforcement), Pywinauto, and Excel parsing libraries.
. Defect Life Cycle & Execution: Lead test execution cycles, log detailed data defects, collaborate closely with data engineering teams, and deliver accurate execution metrics to stakeholders.
. Mentorship & Process Improvement: Provide technical guidance to QA engineers, champion automation best practices, and continuously refine test processes.
Required Skills & Qualifications
Technical Competencies
. Programming & Scripting: Expert proficiency in Python, including deep familiarity with core libraries (Pandas, Pyodbc, Pandera).
. Big Data & Query Orchestration: Strong experience with PySpark for querying and validating multi gigabyte/terabyte scale datasets.
. Test Automation Frameworks: Proven experience architecting test automation suites using Robot Framework tailored for data and ETL pipelines.
. AI Tooling & Code Generation: Hands on experience utilizing GitHub Copilot (or similar LLM driven developer tools) for automated SQL query generation based on source to target mapping documents.
. SQL & Data Modeling: Advanced SQL skills with deep knowledge of relational databases, data warehousing concepts, and data transformation logic.
. Reporting & UI/Desktop Automation: Experience with Pywinauto and Python Excel libraries (openpyxl, xlsxwriter) for automated report verification.
Professional Experience & Soft Skills
. Experience: 7+ years in Data / ETL Testing, with at least 34years in a technical leadership.
. Testing Lifecycle: Demonstrated mastery of QA methodologies, Test Plan creation, RTM maintenance, execution tracking, and metric reporting.
. Analytical & Problem Solving: Exceptional ability to diagnose complex data discrepancies between source and target systems.
. Communication: Strong communication skills to liaise effectively between business analysts, data architects, and software engineering teams.
Preferred Qualifications
. Experience with Cloud Data Warehouses (e.g., Snowflake, Databricks, BigQuery, AWS Redshift).
. Familiarity with CI/CD integration for test automation suites (e.g., GitHub Actions, Jenkins, Azure DevOps).
. Knowledge of regulatory compliance standards and data governance frameworks.
Skills:
- Banking
- ETL
- Pandas
- Python
- Robot Framework
- GitHub Copilot
What you can expect from us:
That same commitment to fairness extends to how we use technology. To support our recruitment team, AI tools may be used to help assess applications though they never replace human judgement. All hiring decisions remain entirely in the hands of our recruitment professionals.
Sourced from naukri
Section · 02
Skills
AutomationAgileqtpweb services testingFunctional TestingDatabase TestingRegression Testingsoftware testingPythonJira AtlassianSQLmanual testingJavaTestngAPI TestingAutomation TestingSeleniumCucumber
Section · Company