Senior ETL Test Engineer

Luxoft; Bengaluru; On-site; INR 3,000,000 - 4,200,000; Full time

Job summary

Luxoft is seeking a senior ETL Test Engineer with 7+ years of experience to validate complex data pipelines and data warehouse solutions in Bengaluru. You will design test strategies, write complex SQL, automate data validation, and troubleshoot data discrepancies across Oracle, MongoDB, and cloud storage (AWS S3).

Hands-on API testing with Postman/Swagger is required. The role involves end-to-end testing of batch and real-time data flows, including data extraction, transformation, loading, and

Qualifications

• 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 subqueries, CTEs, aggregations, and analytical functions.
• Hands-on experience testing data warehouse and data migration solutions.

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 real-time and batch data pipelines and data warehousing solutions.
• Perform SQL data verification: record counts, referential integrity, data completeness, and accuracy.
• Develop and maintain reusable Python-based test automation frameworks and scripts.
• Validate data files/datasets stored or processed via AWS S3 and test REST APIs for data flow and error handling.
• Execute functional, integration, regression, system, and data validation testing within enterprise environments.
• Test data warehouse components: fact/dimension tables, staging, aggregates, historical data, and reporting outputs.

Skills

ETL testing

Data Warehouse testing

Python automation

SQL

API testing

Tools

Postman

Swagger

PyTest

MongoDB

AWS S3

Job 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:

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:

Real-time and near-real-time data pipelines

Data warehouse solutions

Data integration processes

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

Write and execute complex SQL queries for:

Record-count verification

Referential integrity checks

Data completeness and accuracy checks

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.

Mandatory Skills Description:

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:

Subqueries

Common table expressions

Aggregations

Analytical functions

Stored procedures

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