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:
Solid 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.

Valid

📌 Senior ETL Test Engineer (Bengaluru)
🏢 Luxoft
📍 Bengaluru