Senior Specialist - ETL Data Testing and Python

About the Role

Advance Career Solutions, a prominent IT multinational firm operating across India, is recruiting for a Senior Specialist focused on ETL Data Testing and Python development based in Hyderabad. This role is essential for enabling customer data platform initiatives by validating and ensuring the quality of data pipelines and integration processes.

Responsibilities

• Develop and implement testing approaches for ETL processes to verify data extraction, transformation, and loading stages.
• Ensure the accuracy, consistency, completeness, and integrity of data between source and destination systems.
• Create and manage Python automation scripts for test execution, data validation, and reconciliation tasks.
• Evaluate ETL workflows, data transformation logic, and integration pipelines through rigorous testing.
• Identify, analyze, and document data defects and failures encountered in pipelines.
• Work closely with data engineers, software developers, analysts, and business teams to guarantee the quality of deliverables.
• Assist in data governance, architecture, and quality initiatives for customer data platforms.
• Conduct SQL-based validations including source-to-target mapping verification and data reconciliation activities.
• Contribute to code reviews, maintain comprehensive test documentation, and adhere to quality assurance standards.
• Provide mentorship and guidance to junior team members, promoting continual enhancements in ETL testing and automation.

Requirements

• Extensive practical experience in ETL and data testing disciplines.
• Proficient in Python programming for automating data validation and testing processes.
• Strong command of SQL for conducting data validation, reconciliation, and source-to-target tests.
• Prior experience testing ETL pipelines, data transformations, and integration workflows.
• Understanding of data quality principles, data integrity assurance, and defect management processes.
• Excellent analytical thinking, troubleshooting capabilities, and problem-solving aptitude.

Additional Details

• Employment Location: Hyderabad
• Interview Format: Face-to-face drive scheduled on Saturday, 24th October
• Experience Range: 5 to 12 years
• Notice Period Acceptable: Immediate up to 60 days
• Eligible Educational Backgrounds: B.Tech, B.E., B.Sc, B.C.A. in any specialization