Job Title: ETL QA Automation EngineerThe Role

The ETL QA Automation Engineer is responsible for hands-on testing, automation, and data validation across ETL pipelines, data integrations, and downstream applications. This role leads the definition and execution of an automation testing strategy for ETL processes, ensuring data accuracy, integrity, and reliability across internal and third‑party data sources.

Working closely with distributed business and technical stakeholders, the ETL QA Automation Engineer identifies data quality issues, analyzes root causes, and drives corrective actions. A successful candidate is motivated to define new QA processes and standards, challenge assumptions, and continuously improve testing practices to deliver high‑quality data products for customers.

Essential Job FunctionsWrite complex SQL queries to validate ETL workflows, transformations, and output datasetsDiscover, troubleshoot, and resolve data quality issues and discrepancies across ETL processesBuild, maintain, and continuously enhance an automated QA framework for ETL testingDefine and maintain ETL test strategies, test plans, test cases, and validation documentationMonitor ingestion and transfer of data from internal and third‑party sources, ensuring accuracy and timelinessValidate complex ETL mappings, transformations, and data logic across environmentsPartner with engineering, product, and data teams to resolve ETL defects and support re‑testingLog, track, and manage ETL defects and enhancements using JIRADocument QA processes and recommend improvements to enhance testing efficiency and effectivenessFacilitate ETL deployments to QA environments and support release readiness activitiesAct as an ETL QA subject matter expert and mentor team members on data quality best practicesEnsure data quality risks and deviations from specifications are escalated to management in a timely mannerQualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below represent the knowledge, skill, and ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Required Skills & ExperienceBachelor’s degree in Computer Science, Information Systems, or equivalent practical experienceAdvanced expertise in SQL with strong understanding of relational data models and database structures4+ years of experience defining, executing, and automating QA test cases with an ETL focus4+ years of hands‑on testing experience with Talend or similar ETL / integration platformsStrong experience testing complex ETL transformations, mappings, and data pipelinesExperience with AWS technologies including S3, Athena, Glue, and RedshiftProven ability to translate manual ETL validation efforts into scalable automated test solutionsStrong analytical and troubleshooting skills with a focus on data integrity and root‑cause analysisExcellent organizational and time management skills with the ability to synthesize business and technical requirementsProficiency with flowcharting and process‑mapping tools such as Lucidchart or VisioStrong written and verbal communication skills with attention to detailAbility to work independently and collaboratively in cross‑functional Agile teamsExperience working with Agile tools such as JIRAPreferred QualificationsExperience using Confluence for documentationExperience with Tableau or other BI and reporting tools

IQVIA is a leading global provider of clinical research services, commercial insights and healthcare intelligence to the life sciences and healthcare industries. We create intelligent connections to accelerate the development and commercialization of innovative medical treatments to help improve patient outcomes and population health worldwide. Learn more at https://jobs.iqvia.com

IQVIA is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other status protected by applicable law. https://jobs.iqvia.com/eoe

IQVIA is committed to integrity in our hiring process and maintains a zero tolerance policy for candidate fraud. All information and credentials submitted in your application must be truthful and complete. Any false statements, misrepresentations, or material omissions during the recruitment process will result in immediate disqualification of your application, or termination of employment if discovered later, in accordance with applicable law. We appreciate your honesty and professionalism.

The potential base pay range for this role, when annualized, is $84,600.00 - $211,600.00. The actual base pay offered may vary based on a number of factors including job-related qualifications such as knowledge, skills, education, and experience; location; and/or schedule (full or part-time). Dependent on the position offered, incentive plans, bonuses, and/or other forms of compensation may be offered, in addition to a range of health and welfare and/or other benefits.