Project description

We are seeking a highly experienced and hands-on Senior ETL Test Engineer with at least 7 years of ETL and Data Warehouse testing experience. You will be responsible for validating complex data pipelines, ETL workflows, database transformations, APIs, and data migration processes across enterprise systems.

The three primary requirements for this position are:
Strong hands-on Python automation
Advanced Oracle database and SQL expertise
Extensive hands-on ETL testing experience

You need to have strong data testing capabilities with practical Python automation skills. You should be able to independently design test strategies, write complex SQL queries, automate data validation, investigate data discrepancies, and perform end-to-end testing of batch and real-time data pipelines.

This is a senior, hands-on engineering position that requires direct involvement in testing, automation, troubleshooting, and defect resolution.

Responsibilities

Validate end-to-end ETL workflows, including data extraction, ingestion, transformation, loading, and reporting.

Review and validate source-to-target mappings, data transformation rules, business rules, and data quality requirements.

Design, develop, and execute comprehensive ETL test cases for:

Batch data pipelines

Real-time and near-real-time data pipelines

Data warehouse solutions

Data migration initiatives

Data integration processes

Perform hands-on database testing across Oracle Database and MongoDB environments.

Write and execute complex SQL queries for:

Source-to-target validation

Data reconciliation

Record-count verification

Duplicate detection

Referential integrity checks

Data completeness and accuracy checks

Transformation-rule validation

Aggregation and reporting validation

Develop and maintain reusable test automation frameworks and scripts using Python and PyTest.

Use Python to automate data extraction, comparison, reconciliation, validation, and test reporting activities.

Validate data files and datasets stored, transferred, or processed through AWS S3.

Test REST APIs and verify data flow, payload structure, response codes, error handling, and system-to-system integration.

Use tools such as Postman and Swagger to perform API validation and troubleshooting.

Perform end-to-end testing of data ingestion, transformation, storage, integration, and reporting processes.

Execute functional, integration, regression, system, and data validation testing.

Test data warehouse components, including fact tables, dimension tables, staging layers, aggregates, historical data, and reporting outputs.

Skills

Must have

7+ years of hands-on ETL and Data Warehouse testing experience

Strong hands-on Python development and test automation experience

Advanced hands-on experience with Oracle Database and SQL

Strong experience with ETL testing concepts, methodologies, and validation techniques

Proven ability to write complex SQL queries involving:

Multiple joins

Subqueries

Common table expressions

Aggregations

Analytical functions

Stored procedures

Data reconciliation logic

Strong experience validating source-to-target mappings and complex data transformation rules

Hands-on experience testing data warehouse and data migration solutions

Practical experience with MongoDB and testing MongoDB-based applications

Hands-on experience validating data stored and processed through AWS S3

Strong experience with REST API testing

Experience using Postman, Swagger, or similar API testing tools

Hands-on experience developing automation scripts and frameworks using Python

Practical experience with PyTest or similar Python testing frameworks

Experience performing:

Functional testing

Integration testing

Regression testing

End-to-end testing

Database testing

Data validation testing

Strong knowledge of data reconciliation, data quality, data integrity, and data accuracy validation

Experience with defect management tools such as Jira and/or Azure DevOps

Strong analytical, debugging, troubleshooting, and root cause analysis skills

Excellent stakeholder communication, collaboration, and coordination skills

Ability to work independently in a senior, hands-on testing role

Nice to have

N/A

Other

Languages

English: C1 Advanced

Seniority

Senior

Related jobs

View all vacancies

Automation Test / Lab Support Engineer

Automated Testing Python

United States of America

Dearborn

Senior QA Automation (Python, Java)

Automated Testing Python

Ukraine

Remote Ukraine

Automation Tester

Automated Testing Python

Egypt

Cairo

Bengaluru, India

Req. VR-124700

Automated Testing Python

BCM Industry

21/08/2026

Req. VR-124700

Apply for Senior ETL Test Engineer in Bengaluru

*Indicates a required field

First name

Last name

Your country

Your City

Phone

Specialization

Attach your resume (max file size 1MB; allowed extensions: doc, txt, pdf, docx) Upload resume

Number of years of experience in the specialization you are applying for

What are your monthly gross salary expectations?

Read Explanatory Notes

Under the terms of your specific consent or to perform our obligations under a contract with you, as applicable, we, Luxoft Holding Inc. will manually and electronically process your personal data, specifically your first name, last name, phone number, e-mail address and other data you provide us through this form.

Within this context, we process personal data only for the specific purpose(s) indicated in the individual consent language or other notices provided below.

We will – insofar as reasonably necessary for the purpose you have agreed to and within the scope of applicable laws – transfer your personal data to other entities within the Luxoft Group and to the group of third party recipients listed in our Privacy Notice. Such Recipients can be located outside the European Union (EU) and/or the European Economic Area (EEA) (“Third Countries”). The Third Countries concerned, e.g. the USA, may not have the level of data protection that you enjoy e.g. under the GDPR. This can result in disadvantages such as an impeded enforcement of data subjects’ rights, a lack of control over further processing and access by state authorities. You may only have limited legal remedies against this. Insofar our transfer of your personal data to recipients in Third Countries is not covered by an adequacy decision of the EU Commission, we achieve an adequate level of data protection as further detailed out in our Privacy Notice.

With your consent, we personalise marketing communications to you by way of carrying out marketing research analysis, analysing the surfing-behaviour of our website visitors and to adjust it to their detected tendencies, as well as to plan more efficient future marketing activities. This personalised marketing does not include any automated decision-making activities.

Further information on how we process personal data in general is available in our Privacy Notice. You may withdraw any given consent at any time. The withdrawal of your consent(s) will not affect the lawfulness of processing before its withdrawal. For any request in this context, please e-mail us at: DPO@luxoft.com.

Before uploading CV or any other information to this website, to learn more about your obligations and restrictions arising from the use of this website, please read our Terms of Use.

By clicking the Agree and Send button, you consent that Luxoft Holding Inc. can process your provided personal data for the purpose of processing your application to establish a potential employment, internship or relocation with Luxoft Holding Inc., a relevant affiliate of the Luxoft Group or Luxoft Group’s clients, as applicable. You consent to the retention of your personal data, with the purpose of contacting you for potential future employment opportunities. If you refer a friend, we will process your provided personal data of you and your referral to award you with a bonus for such recommendation. You can withdraw your consent at any time with effect for the future. Before you consent, please click on „Read these Explanatory Notes“ and view our Privacy Notice (e.g. for your data subject rights).

Note: Our system automatically converts each CV into our standardized format, enabling our HR teams to process applications more efficiently.

I consent that Luxoft Holding Inc. and the affiliates of the Luxoft Group can process my personal data for the purpose of sending me regular emails with information about Luxoft as an employer including job vacancies and (ii) marketing communications with information about recruitment-related events, organized webinars, conferences, as well as the Logeek Magazine and other similar publications. I can withdraw my consent at any time with effect for the future. These communications are personalised to my interests in accordance with our Privacy Notice.

Related Jobs

All jobs

MENU

Senior ETL Test Engineer

Project description

Responsibilities

Skills

Other

Related jobs

Automation Test / Lab Support Engineer

Senior QA Automation (Python, Java)

Automation Tester