Description

Senior QA Tester - ETL Automation experience (must have criteria), Hyderabad - Hybrid

Syneos Health® is a leading fully-integrated life sciences services organization built to accelerate customer success. We partner with innovators at every point across the drug development and commercialization continuum, helping them navigate complexity, anticipate change and accelerate progress.

Every day we perform better because of how we work together, as one team, each the best at what we do. We bring together talented experts across a broad spectrum of business critical corporate functions. Every role plays an essential part in enabling our customers to achieve their goals. Our teams are agile, collaborative, and committed to delivering—for each other, for our customers, and ultimately for the people who rely on the services we support.

Discover what your 25,000 future colleagues already know:

Why Syneos Health

We are passionate about developing our people, through career development and progression; supportive and engaged line management; technical and therapeutic area training; peer recognition and total rewards program.
We are committed to building an inclusive culture – where you can authentically be yourself. Central to this is our purpose – Driven to Deliver – which captures the passion of our colleagues to show up each day and shape solutions that have the ability to dramatically impact someone's life.
We are continuously building the company we all want to work for and our customers want to work with. Why Because we know that when we bring together smart colleagues from across the world, we can shape the future of healthcare, driving impact for customers and defining the pace of patient progress.

Job Responsibilities

Key Responsibilities

Perform end-to-end ETL/data pipeline testing across multiple data systems
Design and build robust automation frameworks for data validation and reconciliation
Automate source-to-target data comparison, including large-scale data validation
Validate data transformations, mappings, and business rules
Develop reusable automation scripts using Python and/or PySpark
Execute and optimize complex SQL queries for validation
Perform data quality checks, anomaly detection, and consistency validation
Validate data across staging, warehouse, and reporting layers
Implement automated regression testing for data pipelines
Perform root cause analysis for data discrepancies and defects
Work with structured and unstructured data sources (databases, files, APIs, cloud storage)
Collaborate with data engineers, developers, and business stakeholders
Drive continuous improvement in automation coverage and testing processes
Document frameworks, validation logic, and testing approaches

Required Skills

5+ years of experience in ETL/Data Testing with strong automation focus
Strong hands-on expertise in SQL (complex joins, aggregations, performance tuning)
Strong programming skills in Python (mandatory)
Experience with PySpark or large-scale data processing frameworks
Proven experience in ETL/data validation automation
Strong understanding of data pipelines, transformations, and data flows
Experience in data reconciliation and comparison techniques
Knowledge of data quality frameworks and validation strategies
Experience working with multiple data sources (RDBMS, files, APIs, cloud storage)
Strong debugging and problem-solving skills
Preferred Skills
Experience with modern data platforms such as Snowflake, Databricks, or similar
Exposure to data warehousing concepts (star/snowflake schema)
Experience in automation framework design for data testing
Exposure to CI/CD pipelines for test automation
Experience in reporting validation (Power BI or similar tools)
Domain experience in clinical/healthcare data (good to have)

Soft Skills

Strong analytical thinking and attention to detail
Ability to design test strategies and think beyond happy paths
Good communication and stakeholder collaboration
Proactive mindset with ownership and accountability
Ability to work independently and drive quality initiatives

Nice to Have

Experience working with large-scale data platforms or distributed systems and domain exposure to healthcare or clinical data.

Get to know Syneos Health

Over the past 5 years, we have worked with 94% of all Novel FDA Approved Drugs, 95% of EMA Authorized Products and over 200 Studies across 73,000 Sites and 675,000+ Trial patients.

No matter what your role is, you'll take the initiative and challenge the status quo with us in a highly competitive and ever-changing environment. Learn more about Syneos Health.

http://www.syneoshealth.com

Additional Information

Tasks, duties, and responsibilities as listed in this job description are not exhaustive. The Company, at its sole discretion and with no prior notice, may assign other tasks, duties, and job responsibilities. Equivalent experience, skills, and/or education will also be considered so qualifications of incumbents may differ from those listed in the Job Description. The Company, at its sole discretion, will determine what constitutes as equivalent to the qualifications described above. Further, nothing contained herein should be construed to create an employment contract. Occasionally, required skills/experiences for jobs are expressed in brief terms. Any language contained herein is intended to fully comply with all obligations imposed by the legislation of each country in which it operates, including the implementation of the EU Equality Directive, in relation to the recruitment and employment of its employees. The Company is committed to compliance with the Americans with Disabilities Act, including the provision of reasonable accommodations, when appropriate, to assist employees or applicants to perform the essential functions of the job.

Summary

Job Summary We are looking for a Senior ETL Automation Tester with strong expertise in data validation, ETL testing, and automation framework development. The role focuses on ensuring data accuracy, integrity, and consistency across complex data pipelines and systems. The ideal candidate should have hands-on experience in designing scalable automation solutions for ETL/data testing, performing end-to-end validation of data flows, and driving improvements in testing efficiency. Exposure to modern data platforms such as Snowflake, Databricks, or cloud-based data ecosystems is an added advantage.