Job Description
The Opportunity
Our Technology Centers focus on creating a space where teams can come together to deliver business solutions that save and improve lives. An integral part of our companys’ IT operating model, Tech Centers are globally distributed locations where each IT division has employees to enable our digital transformation journey and drive business outcomes. These locations, in addition to the other sites, are essential to supporting our business and strategy.
A focused group of leaders in each Tech Center helps to ensure we can manage and improve each location, from investing in growth, success, and well-being of our people, to making sure colleagues from each IT division feel a sense of belonging to managing critical emergencies. And together, we must leverage the strength of our team to collaborate globally to optimize connections and share best practices across the Tech Centers.
Role Overview
We are looking for a skilled QA automation Engineer to join the Data Ingestion Framework team. This tool is an enterprise-grade, cloud-native data ingestion platform built on Apache Airflow, AWS Glue, and Databricks, used to ingest data from 20+ source systems into a centralised data lake. You will own and evolve an automated test suite covering 150+ end-to-end integration scenarios and be a key contributor to quality gates across every release.
What will you do in this role
What should you have
Primary Skill: ETL testing, Python, Robot Framework, AWS
4+ years of QA/test automation experience in a data or backend engineering environment.
· Robot Framework — confident writing test cases, resource files, and custom Python libraries.
· Python 3.x — ability to write clean, maintainable helper code
· AWS — practical experience with S3, Glue, IAM roles/assume-role, and CloudWatch logs.
· Data pipeline concepts — incremental vs. full-load strategies, CDC, schema evolution, data quality.
· CI/CD — GitHub Actions.
· Jira – maintaining project tasks
· Xray – populating tests execution and results to Jira
· Git — disciplined branching, PR workflow, and commit hygiene.
· AI — Practical experience applying AI/ML to test generation, prioritization, or maintenance. AI-assisted test case generation using LLMs
Nice to Have
· Experience with Databricks (Unity Catalog, Delta Lake, all-purpose clusters).
· Apache Airflow — understanding of DAGs, operators, connections, and variable configuration.
· Familiarity with Jira/Xray for test management and traceability.
· Knowledge of SharePoint, Veeva Vault, LDAP, or SFTP integration testing.
· Experience testing GxP-regulated systems and maintaining audit-trail documentation.
· Docker — building and debugging containerised test environments.
· PaBot or similar parallel Robot Framework execution tooling.
· VERA – approval tool.
Who we are
We are known as Merck & Co., Inc., Rahway, New Jersey, USA in the United States and Canada and MSD everywhere else. For more than a century, we have been bringing forward medicines and vaccines for many of the world's most challenging diseases. Today, our company continues to be at the forefront of research to deliver innovative health solutions and advance the prevention and treatment of diseases that threaten people and animals around the world.
What we look for
Imagine getting up in the morning for a job as important as helping to save and improve lives around the world. Here, you have that opportunity. You can put your empathy, creativity, digital mastery, or scientific genius to work in collaboration with a diverse group of colleagues who pursue and bring hope to countless people who are battling some of the most challenging diseases of our time. Our team is constantly evolving, so if you are among the intellectually curious, join us—and start making your impact today.
#HYDIT2025
Required Skills:
Apache Airflow, Automation Testing, AWS Glue, Business Intelligence (BI), Database Administration, Databricks Platform, Data Engineering, Data Management, Data Modeling, Data Pipelines, Data Quality, Data Visualization, Debugging, Design Applications, Git Version Control System, Information Management, Prioritization, Project Tasks, Requirements Traceability Matrix (RTM), Robot Framework, Software Development, Software Development Life Cycle (SDLC), System DesignsPreferred Skills:
Current Employees apply HERE
Current Contingent Workers apply HERE
Search Firm Representatives Please Read Carefully
Merck & Co., Inc., Rahway, NJ, USA, also known as Merck Sharp & Dohme LLC, Rahway, NJ, USA, does not accept unsolicited assistance from search firms for employment opportunities. All CVs / resumes submitted by search firms to any employee at our company without a valid written search agreement in place for this position will be deemed the sole property of our company. No fee will be paid in the event a candidate is hired by our company as a result of an agency referral where no pre-existing agreement is in place. Where agency agreements are in place, introductions are position specific. Please, no phone calls or emails.
Employee Status:
RegularRelocation:
VISA Sponsorship:
Travel Requirements:
Flexible Work Arrangements:
HybridShift:
Valid Driving License:
Hazardous Material(s):
Job Posting End Date:
06/11/2026*A job posting is effective until 11:59:59PM on the day BEFORE the listed job posting end date. Please ensure you apply to a job posting no later than the day BEFORE the job posting end date.