ETL QA Automation Engineer
IQVIA, Rosemont, IL, United States
Job Title:
ETL QA Automation Engineer
The 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 Functions
Write complex SQL queries to validate ETL workflows, transformations, and output datasets
Discover, troubleshoot, and resolve data quality issues and discrepancies across ETL processes
Build, maintain, and continuously enhance an automated QA framework for ETL testing
Define and maintain ETL test strategies, test plans, test cases, and validation documentation
Monitor ingestion and transfer of data from internal and third-party sources, ensuring accuracy and timeliness
Validate complex ETL mappings, transformations, and data logic across environments
Partner with engineering, product, and data teams to resolve ETL defects and support re-testing
Log, track, and manage ETL defects and enhancements using JIRA
Document QA processes and recommend improvements to enhance testing efficiency and effectiveness
Facilitate ETL deployments to QA environments and support release readiness activities
Act as an ETL QA subject matter expert and mentor team members on data quality best practices
Ensure data quality risks and deviations from specifications are escalated to management in a timely manner
Qualifications
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 & Experience
Bachelor's degree in Computer Science, Information Systems, or equivalent practical experience
Advanced expertise in SQL with strong understanding of relational data models and database structures
4+ years of experience defining, executing, and automating QA test cases with an ETL focus
4+ years of hands-on testing experience with Talend or similar ETL / integration platforms
Strong experience testing complex ETL transformations, mappings, and data pipelines
Experience with AWS technologies including S3, Athena, Glue, and Redshift
Proven ability to translate manual ETL validation efforts into scalable automated test solutions
Strong analytical and troubleshooting skills with a focus on data integrity and root-cause analysis
Excellent organizational and time management skills with the ability to synthesize business and technical requirements
Proficiency with flowcharting and process-mapping tools such as Lucidchart or Visio
Strong written and verbal communication skills with attention to detail
Ability to work independently and collaboratively in cross-functional Agile teams
Experience working with Agile tools such as JIRA
Preferred Qualifications
Experience using Confluence for documentation
Experience 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.
IQVIA is a leading global provider of clinical research services, commercial insights and healthcare intelligence to the life sciences and healthcare industries. We create connections that accelerate the development and commercialization of innovative medical treatments. Everything we do is part of a journey to improve patient outcomes and population health worldwide.
To get there, we seek out diverse talent with curious minds and a relentless commitment to innovation and impact. No matter your role, everyone at IQVIA contributes to our shared goal of helping customers improve the lives of patients everywhere. Thank you for your interest in growing your career with us.
EEO Minorities/Females/Protected Veterans/Disabled
ETL QA Automation Engineer
The 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 Functions
Write complex SQL queries to validate ETL workflows, transformations, and output datasets
Discover, troubleshoot, and resolve data quality issues and discrepancies across ETL processes
Build, maintain, and continuously enhance an automated QA framework for ETL testing
Define and maintain ETL test strategies, test plans, test cases, and validation documentation
Monitor ingestion and transfer of data from internal and third-party sources, ensuring accuracy and timeliness
Validate complex ETL mappings, transformations, and data logic across environments
Partner with engineering, product, and data teams to resolve ETL defects and support re-testing
Log, track, and manage ETL defects and enhancements using JIRA
Document QA processes and recommend improvements to enhance testing efficiency and effectiveness
Facilitate ETL deployments to QA environments and support release readiness activities
Act as an ETL QA subject matter expert and mentor team members on data quality best practices
Ensure data quality risks and deviations from specifications are escalated to management in a timely manner
Qualifications
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 & Experience
Bachelor's degree in Computer Science, Information Systems, or equivalent practical experience
Advanced expertise in SQL with strong understanding of relational data models and database structures
4+ years of experience defining, executing, and automating QA test cases with an ETL focus
4+ years of hands-on testing experience with Talend or similar ETL / integration platforms
Strong experience testing complex ETL transformations, mappings, and data pipelines
Experience with AWS technologies including S3, Athena, Glue, and Redshift
Proven ability to translate manual ETL validation efforts into scalable automated test solutions
Strong analytical and troubleshooting skills with a focus on data integrity and root-cause analysis
Excellent organizational and time management skills with the ability to synthesize business and technical requirements
Proficiency with flowcharting and process-mapping tools such as Lucidchart or Visio
Strong written and verbal communication skills with attention to detail
Ability to work independently and collaboratively in cross-functional Agile teams
Experience working with Agile tools such as JIRA
Preferred Qualifications
Experience using Confluence for documentation
Experience 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.
IQVIA is a leading global provider of clinical research services, commercial insights and healthcare intelligence to the life sciences and healthcare industries. We create connections that accelerate the development and commercialization of innovative medical treatments. Everything we do is part of a journey to improve patient outcomes and population health worldwide.
To get there, we seek out diverse talent with curious minds and a relentless commitment to innovation and impact. No matter your role, everyone at IQVIA contributes to our shared goal of helping customers improve the lives of patients everywhere. Thank you for your interest in growing your career with us.
EEO Minorities/Females/Protected Veterans/Disabled