Test Automation Engineer II

Career Category

Job Description

ABOUT AMGEN

Amgen harnesses the best of biology and technology to fight the world’s toughest diseases, and make people’s lives easier, fuller and longer. We discover, develop, manufacture and deliver innovative medicines to help millions of patients. Amgen helped establish the biotechnology industry more than 45 years ago and remains on the cutting-edge of innovation, using technology and human genetic data to push beyond what’s known today.

ABOUT THE ROLE

Role Description

We are seeking a detail-oriented and highly skilled Data Engineering Test Automation Engineer to ensure  the quality, reliability, and performance of our data pipelines and platforms. The ideal candidate will have a strong background in data testing, ETL validation, and test automation frameworks. You will work closely with data engineers, analysts, and DevOps teams to build robust test suites for large-scale data solutions. This role combines deep technical execution with a solid foundation in QA best practices including test planning, defect tracking, and test lifecycle management.

You will be responsible for designing and executing manual and automated test strategies for complex real-time and batch data pipelines, contributing to the design of automation frameworks, and ensuring high-quality data delivery across our AWS and Databricks-based analytics platforms.

The role is highly technical and hands-on, with a strong focus on automation, data accuracy, completeness, consistency, and ensuring data governance practices are seamlessly integrated into development pipelines.

Roles & Responsibilities

• Design, develop, and maintain automated test scripts for data pipelines, ETL jobs, and data integrations.
• Validate data accuracy, completeness, transformations, and integrity across multiple systems.
• Collaborate with data engineers to define test cases and establish data quality metrics.
• Develop reusable test automation frameworks and CI/CD integrations (e.g., Jenkins, GitHub Actions).
• Perform performance and load testing for data systems.
• Maintain test data management and data mocking strategies.
• Identify and track data quality issues, ensuring timely resolution.
• Perform root cause analysis and drive corrective actions.
• Contribute to QA ceremonies (standups, planning, retrospectives) and drive continuous improvement in QA processes and culture.

Must-Have Skills

• Experience in QA roles, with strong exposure to data pipeline validation and ETL Testing.
• Domain Knowledge of R&D domain of life science.  
• Validate data accuracy, transformations, schema compliance, and completeness across systems using PySpark and SQL.
• Strong hands-on experience with Python, and optionally PySpark, for developing automated data validation scripts.
• Proven experience in validating ETL workflows, with a solid understanding of data transformation logic, schema comparison, and source-to-target mapping.
• Experience working with data integration and processing platforms like Databricks/Snowflake, AWS EMR, Redshift etc…
• Experience in manual and automated testing of data pipelines executions for both batch and real-time data pipelines.
• Perform performance testing of large-scale complex data engineering pipelines.
• Ability to troubleshoot data issues independently and collaborate with engineering teams for root cause analysis
• Strong understanding of QA methodologies, test planning, test case design, and defect lifecycle management.
• Hands-on experience with API testing using Postman, pytest, or custom automation scripts
• Experience integrating automated tests into CI/CD pipelines using tools like Jenkins, GitHub Actions, or similar.
• Knowledge of cloud platforms such as AWS, Azure, GCP.

Good-to-Have Skills

• Certifications in Databricks, AWS, Azure, or data QA (e.g., ISTQB).
• Understanding of data privacy, compliance, and governance frameworks.
• Knowledge of UI automated testing frameworks like Selenium, JUnit, TestNG
• Familiarity with monitoring/observability tools such as Datadog, Prometheus, or  Cloud Watch

Education and Professional Certifications

• Master’s degree and 3 to 7 years of Computer Science, IT or related field experience

OR

• Bachelor’s degree and 4 to 9 years of Computer Science, IT or related field experience

Soft Skills

• Excellent analytical and troubleshooting skills.
• Strong verbal and written communication skills
• Ability to work effectively with global, virtual teams
• High degree of initiative and self-motivation.
• Ability to manage multiple priorities successfully.
• Team-oriented, with a focus on achieving team goals
• Strong presentation and public speaking skills.

EQUAL OPPORTUNITY STATEMENT

Amgen is an Equal Opportunity employer and will consider you without regard to your race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability status.

We will ensure that individuals with disabilities are provided with reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request an accommodation.