ETL Data Testing + Python-K

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

Job summary

Advance Career Solutions is seeking a Senior Specialist ETL Data Testing + Python to join our Hyderabad team. You will validate data pipelines, ensure data quality, and optimize integration across systems.

The role demands hands-on ETL testing experience, Python scripting for data validation, and strong SQL skills to ensure data accuracy and integrity. Collaboration with data engineers and analysts is essential to deliver quality outcomes.

Qualifications

• Proven experience in ETL and data testing.
• Python scripting for data validation and automation.
• Strong SQL skills for data validation and reconciliation.
• Experience validating ETL pipelines and data integration workflows.
• Knowledge of data quality and defect management.

Responsibilities

• Design and execute ETL testing strategies for data pipelines.
• Validate data accuracy, completeness, and integrity across sources and targets.
• Develop Python scripts for test automation and data validation.
• Test ETL workflows, transformations and data integration processes.
• Identify and report data defects and pipeline failures.
• Collaborate with data engineers, analysts and stakeholders to ensure quality.
• Support data governance and data quality initiatives.
• Perform source-to-target data validation and reconciliation.
• Participate in code reviews and maintain test documentation.
• Mentor junior team members and drive automation improvements.

Skills

ETL Testing

Python scripting

SQL

Data validation

Data quality

Job description

Senior Specialist ETL Data Testing + Python

Location: Hyderabad

Interview- F2F drive on saturday(24th oct)
Experience: 5-12 years
Mandatory Skills: ETL Testing + Python
Notice Period: Immediate-60 days

Job Summary

We are looking for an experienced Senior Specialist with strong expertise in ETL testing, data validation, and Python programming to support customer data platform initiatives. The candidate will be responsible for validating data pipelines, ensuring data quality, and optimizing data integration processes across multiple systems.

Key Responsibilities

• Design and execute ETL testing strategies to validate data extraction, transformation, and loading processes.
• Validate data accuracy, completeness, consistency, and integrity across source and target systems.
• Develop and maintain Python scripts for test automation, data validation, and reconciliation.
• Test ETL workflows, data pipelines, transformation logic, and data integration processes.
• Identify, troubleshoot, and report data defects and pipeline failures.
• Collaborate with data engineers, developers, analysts, and business stakeholders to ensure quality delivery.
• Support data architecture, data governance, and data quality initiatives for customer data platforms.
• Perform SQL-based data validation, source-to-target mapping verification, and data reconciliation.
• Participate in code reviews, maintain test documentation, and follow quality assurance best practices.
• Mentor junior team members and contribute to continuous improvements in ETL testing and automation.

Mandatory Skills

• Strong hands-on experience in ETL Testing and Data Testing.
• Proficiency in Python scripting for data validation and test automation.
• Strong SQL skills for data validation, reconciliation, and source-to-target testing.
• Experience testing ETL pipelines, data transformations, and data integration workflows.
• Knowledge of data quality, data integrity, and defect management.
• Strong analytical, troubleshooting, and problem-solving skills.