Sr BI Platform Engineer

.

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 Amgens governance standards.
• Automate recurring administrative and operational tasks using shell scripts, Python, or Jenkins pipelines.

• 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 Amgens data compliance requirements (GxP, SOX, 21 CFR Part 11).
• Collaborate with Informatica developers to improve ETLTeradata integration performance and throughput.
• Support capacity planning and workload balancing across multi-node environments.

• Collaborate with data engineering, BI, and infrastructure teams to support Amgens 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 Amgens validation processes.

• Deliver stable and compliant Informatica and Teradata platforms that meet Amgens 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.

• Bachelors 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.

• 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.

• 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.