Sr BI Platform Engineer

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

1. Administer, configure, and maintain Informatica environments (PowerCenter, IICS, IDQ, EDC, Axon).
2. Manage repositories, domains, node configurations, and integration services.
3. Perform installation, upgrades, patches, and system migrations across DEV/QA/PROD environments.
4. Monitor ETL jobs, session logs, and workflow performance; tune for optimal throughput.
5. Implement Informatica security, user provisioning, and audit policies aligned with Amgen’s governance standards.
6. Automate recurring administrative and operational tasks using shell scripts, Python, or Jenkins pipelines.

Teradata Administration

1. Administer and manage Teradata databases, ensuring performance, scalability, and availability across enterprise workloads.
2. Manage database objects, space allocation, partitions, and user/session configurations.
3. Perform Teradata version upgrades, patches, and maintenance in collaboration with infrastructure teams.
4. Monitor system performance using Viewpoint, Teradata Manager, PMON, and DBQL; identify and resolve query bottlenecks.
5. Optimize ETL and SQL performance through workload management (TASM), statistics collection, and index tuning.
6. Develop, deploy, and maintain Teradata utilities such as BTEQ, FastLoad, MultiLoad, TPump, and TPT for efficient data movement.
7. Ensure backup/recovery and disaster recovery readiness using BAR (Backup Archive Restore) processes.
8. Implement role-based security and data access control in line with Amgen’s data compliance requirements (GxP, SOX, 21 CFR Part 11).
9. Collaborate with Informatica developers to improve ETL–Teradata integration performance and throughput.
10. Support capacity planning and workload balancing across multi-node environments.

Integration & Collaboration

1. Collaborate with data engineering, BI, and infrastructure teams to support Amgen’s enterprise data warehouse, Snowflake, and cloud platforms.
2. Work closely with the DevOps team to automate deployment, monitoring, and CI/CD pipelines for Informatica and Teradata jobs.
3. Support analytical and visualization tools (Power BI, Tableau) by maintaining reliable backend data pipelines.
4. Participate in on-call rotation and provide L2/L3 production support for critical BI workloads.
5. Maintain detailed operational documentation, SOPs, and change management records per Amgen’s validation processes.

What We Expect of You

1. Deliver stable and compliant Informatica and Teradata platforms that meet Amgen’s uptime, performance, and audit standards.
2. Proactively identify and mitigate performance issues, resource contention, and system vulnerabilities.
3. Champion automation, standardization, and proactive monitoring within the BI ecosystem.
4. Support modernization initiatives such as Teradata-to-cloud integration, Informatica Cloud (IICS) adoption, and Snowflake migration.
5. Collaborate across GIS, Data Governance, and Enterprise Architecture teams to drive best practices.

Basic Qualifications

1. Bachelor’s degree in Computer Science, Information Systems, or related field.
2. 5–8 years of experience in BI/ETL platform administration with significant exposure to Informatica and Teradata.
3. Proven experience administering Informatica PowerCenter and/or IICS (installation, configuration, repository, tuning).
4. Hands-on experience managing Teradata systems, including performance tuning, workload management (TASM), and query optimization.
5. Strong understanding of ETL design principles, data warehousing, and relational database concepts.
6. Experience with Teradata utilities (BTEQ, FastLoad, MultiLoad, TPT) and SQL performance troubleshooting.
7. Familiarity with Unix/Linux, scripting (Shell, Python), and automation frameworks.
8. Exposure to enterprise change control, ITSM, and incident management processes.

Preferred Qualifications

1. Experience in biotech, pharmaceutical, or other regulated industries with GxP and SOX compliance.
2. Experience integrating Informatica with Teradata, Snowflake, or Data Lake platforms.
3. Knowledge of Teradata Viewpoint, performance monitoring, and system resource tuning.
4. Familiarity with data governance frameworks (Informatica Axon, Collibra) and metadata management (EDC).
5. Working knowledge of Informatica Cloud (IICS) and hybrid data integration architectures (on-prem/cloud).
6. Experience with automation tools such as Jenkins, Ansible, and GitHub.
7. Certifications in Informatica Administration and/or Teradata Certified Professional.

Soft Skills

1. Strong analytical and troubleshooting skills across complex data ecosystems.
2. Excellent communication and documentation abilities.
3. Ability to prioritize tasks and manage competing demands in a fast-paced environment.
4. Collaborative mindset, working effectively with cross-functional and global teams.
5. Detail-oriented, process-driven, and proactive in driving improvements.
6. 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.