ETL QA Automation Engineer
Share
Job Location:
Rosemont, IL - USA
Monthly Salary:
$ 84600 - 211600
Posted on:
Yesterday
Vacancies:
1 Vacancy
Job Summary
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 thirdparty 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 highquality 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 thirdparty 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 retesting
- 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
- Bachelors 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 handson 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 rootcause analysis
- Excellent organizational and time management skills with the ability to synthesize business and technical requirements
- Proficiency with flowcharting and processmapping tools such as Lucidchart or Visio
- Strong written and verbal communication skills with attention to detail
- Ability to work independently and collaboratively in crossfunctional 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
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. 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 $84600.00 - $211600.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.Required Experience:
IC
About Company
IQVIA is the Human Data Science Company™. We are inspired by the industry we serve and provide solutions that enable life sciences companies to innovate with confidence, maximize opportunities and ultimately drive human health outcomes forward. Our approach is Human Data Science – a d ... View more
