ETL Engineer

Join Amgen’s Mission of Serving Patients

At Amgen, if you feel like you’re part of something bigger, it’s because you are. Our shared mission—to serve patients living with serious illnesses—drives all that we do.

Since 1980, we’ve helped pioneer the world of biotech in our fight against the world’s toughest diseases. With our focus on four therapeutic areas –Oncology, Inflammation, General Medicine, and Rare Disease– we reach millions of patients each year. As a member of the Amgen team, you’ll help make a lasting impact on the lives of patients as we research, manufacture, and deliver innovative medicines to help people live longer, fuller happier lives.

Our award-winning culture is collaborative, innovative, and science based. If you have a passion for challenges and the opportunities that lay within them, you’ll thrive as part of the Amgen team. Join us and transform the lives of patients while transforming your career.

What you will do

Let’s do this. Let’s change the world. In this vital role you will be responsible for working on data extraction, transformation, and loading (ETL) processes, ensuring that data flows smoothly between various systems and databases. This role requires to perform data transformation tasks to ensure data accuracy and integrity. Working closely with product owners, designers, and other engineers to create high-quality, scalable software solutions and automating operations, monitoring system health, and responding to incidents to minimize downtime.

• Design, develop, and implement Extract, Transform, Load (ETL) processes to move and transform data from various sources to cloud systems, data warehouses or data lakes.

• Integrate data from multiple sources (e.g., databases, flat files, cloud services, APIs) into target systems.

• Develop complex transformations to cleanse, enrich, filter, and aggregate data during the ETL process to meet business requirements.

• Tune and optimize ETL jobs for better performance and efficient resource usage, minimizing execution time and errors.

• Identify and resolve technical challenges effectively

• Stay updated with the latest trends and advancements

• Work closely with product team, business team, and other stakeholders

What we expect of you

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

• Bachelor’s degree and 3 to 5 years of Computer Science, IT or related field experience OR

• Diploma and 7 to 9 years of Computer Science, IT or related field experience

Basic Qualifications:

• Strong expertise in ETL development, data integration and managing complex ETL workflows, performance tuning, and debugging.

• Strong proficiency in SQL for querying databases, writing scripts, and troubleshooting ETL processes

• Understanding data modeling concepts, various schemas and normalization

• Strong understanding of software development methodologies, including Agile and Scrum

• Experience working in a DevOps environment, which involves designing, developing and maintaining software applications and solutions that meet business needs.

Preferred Qualifications:

• Extensive experience in Informatica PowerCenter or Informatica Cloud for data integration and ETL development

Professional Certifications:

• SAFe® for Teams certification (preferred)

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

Shift Information:

This position requires you to work a later shift and will be assigned to the second shift. Candidates must be willing and able to work during evening shifts, as required based on business requirements.

Amgen is an Equal Opportunity employer and will consider all qualified applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability status, or any other basis protected by applicable law.