Data Testing Engineer ETL AND Python

Advance Career Solutions; Hyderabad; On-site; INR 800,000 - 2,000,000; Full time

Job summary

Advance Career Solutions in Hyderabad is seeking an experienced Data Testing Engineer with ETL testing, data validation, and Python-based testing. The role focuses on validating data pipelines, testing transformations, and ensuring data quality across data warehouses and ETL processes.

Responsibilities include writing SQL queries, creating Python-based test automation, and reporting defects. Collaboration with data engineers and business teams is essential for timely issue resolution.

Qualifications

• Hands-on ETL testing and data testing experience.
• Proficient in Python for data validation/testing.
• Strong SQL skills including complex queries.
• Experience with source-to-target validation and data transformations.
• Knowledge of databases and data warehousing concepts.
• Experience in defect tracking and test documentation.

Responsibilities

• Perform ETL testing and validate end-to-end data pipelines.
• Validate source-to-target data mapping, transformations, and migrations.
• Write and execute SQL queries to verify data accuracy and completeness.
• Use Python scripts for test automation and data reconciliation.
• Identify, analyze, and report data defects.
• Perform backend testing for data warehouses and databases.
• Collaborate with data engineers, developers, and business teams to resolve issues.
• Prepare test cases, test scenarios, results, and defect reports.

Skills

ETL Testing/Data Testing

Python scripting for data validation

SQL querying

Source-to-target validation

Data warehousing concepts

Defect tracking & test docs

Tools

Informatica

Talend

DataStage

SSIS

Job description

Job Title: Data Testing Engineer ETL + Python
Experience: 512 Years
Job Location: Hyderabad
Notice Period: Immediate to 60 Days Maximum
Interview Mode: Face-to-Face (F2F)
F2F Drive Date: 24th October 2026 (Saturday)

Job Description

We are looking for experienced Data Testing Engineers with strong expertise in ETL testing, data validation, and Python-based testing. The ideal candidate should have hands-on experience in validating data pipelines, testing data transformations, and ensuring data quality across data warehouse and ETL processes.

Key Responsibilities

• Perform ETL testing and validate end-to-end data pipelines.
• Validate source-to-target data mapping, data transformations, and data migration.
• Write and execute SQL queries to verify data accuracy, completeness, and consistency.
• Use Python scripts for test automation, data validation, and reconciliation.
• Identify, analyze, and report data defects and discrepancies.
• Perform backend testing for data warehouses and databases.
• Collaborate with data engineers, developers, and business teams to resolve issues.
• Prepare test cases, test scenarios, test results, and defect reports.

Mandatory Skills

• Strong experience in ETL Testing / Data Testing.
• Hands-on experience with Python scripting for data validation or testing.
• Strong SQL skills, including complex queries and data reconciliation.
• Experience in source-to-target validation and data transformation testing.
• Knowledge of databases and data warehousing concepts.
• Experience in defect tracking and test documentation.

Preferred Skills

• Experience with ETL tools such as Informatica, Talend, DataStage, or SSIS.
• Knowledge of data warehouse testing and data migration testing.
• Exposure to test automation frameworks and Agile methodologies.

Candidate Requirements

• Experience: 5-12 years.
• Location: Hyderabad.
• Candidates must be available for a face-to-face interview drive on 24th October 2026.
• Notice period: Immediate joiners to a maximum of 60 days.