Sr BI Platform Engineer

Join Amgen's Mission to Serve Patients

If you feel like you’re part of something bigger, it’s because you are. At Amgen, our shared mission—to serve patients—drives all that we do. It is key to our becoming one of the world’s leading biotechnology companies. We are global collaborators who achieve together—researching, manufacturing, and delivering ever-better products that reach over 10 million patients worldwide. It’s time for a career you can be proud of.

BI Platform Administrator – Informatica with Teradata

Job Summary

Amgen is seeking a BI Platform Administrator – Informatica with Teradata with 5–8 years of experience to join our Enterprise Data & Analytics (EDA) organization within Global Information Systems (GIS).
In this role, you will be responsible for administering and optimizing Amgen’s Informatica and Teradata ecosystems, ensuring they deliver secure, high-performance, and compliant data integration and analytics capabilities that support Amgen’s mission of serving patients.

You will partner with data engineers, architects, and platform teams to manage enterprise data pipelines, optimize Teradata workloads, and maintain seamless integration between Informatica ETL processes and Teradata data warehouses.

What You Can Do (Key Responsibilities)

Informatica Administration

• Administer, configure, and maintain Informatica environments (PowerCenter, IICS, IDQ, EDC, Axon).

• Manage repositories, domains, node configurations, and integration services.

• Perform installation, upgrades, patches, and system migrations across DEV/QA/PROD environments.

• Monitor ETL jobs, session logs, and workflow performance; tune for optimal throughput.

• Implement Informatica security, user provisioning, and audit policies aligned with Amgen’s governance standards.

• Automate recurring administrative and operational tasks using shell scripts, Python, or Jenkins pipelines.

Teradata Administration

• Administer and manage Teradata databases, ensuring performance, scalability, and availability across enterprise workloads.

• Manage database objects, space allocation, partitions, and user/session configurations.

• Perform Teradata version upgrades, patches, and maintenance in collaboration with infrastructure teams.

• Monitor system performance using Viewpoint, Teradata Manager, PMON, and DBQL; identify and resolve query bottlenecks.

• Optimize ETL and SQL performance through workload management (TASM), statistics collection, and index tuning.

• Develop, deploy, and maintain Teradata utilities such as BTEQ, FastLoad, MultiLoad, TPump, and TPT for efficient data movement.

• Ensure backup/recovery and disaster recovery readiness using BAR (Backup Archive Restore) processes.

• Implement role-based security and data access control in line with Amgen’s data compliance requirements (GxP, SOX, 21 CFR Part 11).

• Collaborate with Informatica developers to improve ETL–Teradata integration performance and throughput.

• Support capacity planning and workload balancing across multi-node environments.

Integration & Collaboration

• Collaborate with data engineering, BI, and infrastructure teams to support Amgen’s enterprise data warehouse, Snowflake, and cloud platforms.

• Work closely with the DevOps team to automate deployment, monitoring, and CI/CD pipelines for Informatica and Teradata jobs.

• Support analytical and visualization tools (Power BI, Tableau) by maintaining reliable backend data pipelines.

• Participate in on-call rotation and provide L2/L3 production support for critical BI workloads.

• Maintain detailed operational documentation, SOPs, and change management records per Amgen’s validation processes.

What We Expect of You

• Deliver stable and compliant Informatica and Teradata platforms that meet Amgen’s uptime, performance, and audit standards.

• Proactively identify and mitigate performance issues, resource contention, and system vulnerabilities.

• Champion automation, standardization, and proactive monitoring within the BI ecosystem.

• Support modernization initiatives such as Teradata-to-cloud integration, Informatica Cloud (IICS) adoption, and Snowflake migration.

• Collaborate across GIS, Data Governance, and Enterprise Architecture teams to drive best practices.

Basic Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or related field.

• 5–8 years of experience in BI/ETL platform administration with significant exposure to Informatica and Teradata.

• Proven experience administering Informatica PowerCenter and/or IICS (installation, configuration, repository, tuning).

• Hands-on experience managing Teradata systems, including performance tuning, workload management (TASM), and query optimization.

• Strong understanding of ETL design principles, data warehousing, and relational database concepts.

• Experience with Teradata utilities (BTEQ, FastLoad, MultiLoad, TPT) and SQL performance troubleshooting.

• Familiarity with Unix/Linux, scripting (Shell, Python), and automation frameworks.

• Exposure to enterprise change control, ITSM, and incident management processes.

Preferred Qualifications

• Experience in biotech, pharmaceutical, or other regulated industries with GxP and SOX compliance.

• Experience integrating Informatica with Teradata, Snowflake, or Data Lake platforms.

• Knowledge of Teradata Viewpoint, performance monitoring, and system resource tuning.

• Familiarity with data governance frameworks (Informatica Axon, Collibra) and metadata management (EDC).

• Working knowledge of Informatica Cloud (IICS) and hybrid data integration architectures (on-prem/cloud).

• Experience with automation tools such as Jenkins, Ansible, and GitHub.

• Certifications in Informatica Administration and/or Teradata Certified Professional.

Soft Skills

• Strong analytical and troubleshooting skills across complex data ecosystems.

• Excellent communication and documentation abilities.

• Ability to prioritize tasks and manage competing demands in a fast-paced environment.

• Collaborative mindset, working effectively with cross-functional and global teams.

• Detail-oriented, process-driven, and proactive in driving improvements.

• Adaptable and eager to learn emerging data and analytics technologies.

Shift Information: 

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

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. 

Ready to Apply for the Job? 

We highly recommend utilizing Workday's robust Career Profile feature to complete the application process. A link to update your profile is available when you click Apply. You can then complete your Workday profile in minutes with the “Upload My Experience” functionality to upload an updated copy of your resume or you can simply edit the individual sections of your Career Profile. 

Please note that you should be in your current position for at least 18 months before applying to internal positions. Staff must notify their current manager if invited for an interview. In addition, Staff are ineligible to apply for open positions if (a) their performance is currently being managed on a performance improvement plan (PIP) or other locally utilized formal coaching document or (b) their most recent performance rating was not a “Partially Meets Expectations” or higher. Please visit our Internal Transfer Guidelines for more detailed information