Senior Developer - EMDA Analytics (ETL, Biovia Pipeline Pilot)

About the Role :

We are seeking a highly skilled ETL Developer to join our EMDA (Environmental Monitoring Data Analytics) team. The role focuses on developing, deploying, and maintaining ETL workflows for a GMP-validated platform used across Pfizer’s global manufacturing sites. The candidate will work with Biovia Pipeline Pilot, integrating data from multiple sources, ensuring high-quality data analytics, and supporting environmental monitoring initiatives.

Key Responsibilities :

• Design, develop, and optimize ETL protocols using Biovia Pipeline Pilot v2017R2 to extract, transform, and load data from lab systems (gLIMS, MODA, LabWare, Thermo Fisher) and flat files (Excel, CSV).
• Configure and maintain ETL parameters including target DB environments (Dev, Test, Stage, Prod), data classes, study identifiers, folder paths, and runtime settings.
• Integrate and transform data into the Oracle 19c business layer , ensuring data quality and compliance with GMP standards.
• Troubleshoot ETL failures, protocol errors, ODBC connectivity issues, and Oracle-specific exceptions.
• Collaborate with DBAs and EMDA support teams to resolve data access, performance, and integration issues.
• Support audit trail retrieval , data verification processes, and validation documentation (ADLC plans, SOPs, design specifications).
• Participate in Agile development cycles and contribute to continuous improvement initiatives.
• Interpret environmental monitoring data and support EMDA modules including :
• Heatmaps
• MODA History & Trend Check
• Utility / Water Trending
• Automated Reports
• ASRAT (Aseptic Site Risk Assessment Tool)

Skills & Qualifications :

Preferred Experience :