Senior ETL Test Engineer
Luxoft · Bengaluru · onsite · Posted 51d ago
Undisclosed4–8 yrsfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
Job Summary
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.
- Design, develop, and execute comprehensive ETL test cases for real-time and near-real-time data pipelines.
- Design, develop, and execute comprehensive ETL test cases for data warehouse solutions.
- Design, develop, and execute comprehensive ETL test cases for data migration initiatives.
- Design, develop, and execute comprehensive ETL test cases for 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.
- Write and execute complex SQL queries for data reconciliation.
- Write and execute complex SQL queries for record-count verification.
- Write and execute complex SQL queries for duplicate detection.
- Write and execute complex SQL queries for referential integrity checks.
- Write and execute complex SQL queries for data completeness and accuracy checks.
- Write and execute complex SQL queries for transformation-rule validation.
- Write and execute complex SQL queries for 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.
Sourced from naukri
Skills
data qualitydata extractionAutomationAzure DevopsData ingestionapisamazon web servicesdata transformationdata reconciliationAWS S3Google DataFlowData MigrationData IntegrationAPI TestingData ValidationMicrosoft AzureData TestingData Pipeline
About Luxoft
Luxoft
IT Services & Consulting
2.3k+
employees
2000
26 years old
Zug, Switzerland
Switzerland
About
Luxoft offers the full spectrum of enterprise technology services, from modernizing legacy IT systems to delivering digital transformation at scale.
Industries
IT Services & Consulting
Employee ratings
832 reviews
3.6/ 5
Culture
3.6
Career growth
2.7
Work-life
3.9
Employees rate it well for
Work Life Balance165Salary128Senior Management87Work Culture76Appraisal64
Find them on