IBM
Description
| ADR Job Number | JOB-29329 |
| Start Date | 3 Nov 2025 |
| End Date | 31 Dec 2026 |
| Type of Project | Contract |
| Target Bill Rate | $16 per hour |
| Industry | Not specified |
| End Client | Confidential (IBM) |
| Travel % | Partial Remote (no expenses) |
| Work Status/Visa | No visa restrictions |
| No. of Positions | 2 |
Key Responsibilities
- Highly skilled ETL Developer to support the development, deployment, and maintenance of data pipelines for the EMDA platform, a GMP-validated solution used across client's global manufacturing sites.
- Build and optimize ETL workflows using Biovia Pipeline Pilot, integrating data from Oracle, SQL Server, and flat files (e.g., Excel), ensuring data quality and compliance for environmental monitoring analytics.
- Design and develop ETL protocols using Biovia Pipeline Pilot v2017R2 to extract, transform, and load data from lab systems (e.g., gLIMS, MODA, LabWare, Thermo Fisher) and flat files.
- Configure and maintain ETL parameters including:
- Target DB environment (Dev, Test, Stage, Prod)
- Data classes and study identifiers
- Folder paths and runtime settings
- Dry run and test mode options
- Integrate data into the Oracle 19c business layer and support schema-level transformations for EMDA modules.
- Troubleshoot ETL failures and protocol errors, including ODBC connection issues and Oracle-specific exceptions.
- Collaborate with DBAs and EMDA support teams to resolve data access and performance issues.
- Support audit trail retrieval and data verification processes using SQL and EMDA audit tables.
- Participate in Agile development cycles and contribute to validation documentation (e.g., ADLC plans, SOPs, design specs).
- Interpret environmental monitoring data and support modules including:
- EMDA Heatmaps
- MODA History & Trend Check
- Utility/Water Trending
- Automated Reports
- ASRAT (Aseptic Site Risk Assessment Tool)
Required Skills
- 7+ years of experience in ETL development, preferably in regulated environments
- Expert hands-on experience with Biovia Pipeline Pilot (protocol design, parameter config, error handling)
- Strong SQL skills with Oracle, SQL Server, and flat file ingestion
- Familiarity with GMP compliance, audit trail management, and validation documentation
- Tools: Visual Studio, VS Code, Postman, JIRA, GitHub/BitBucket, Toad – 3 yrs
- Testing & Security: Unit/Integration Testing, SonarQube, Azure AD SSO – 2 yrs
Solution Overview
Environmental Monitoring Data Analytics (EMDA) is a GMP-validated enterprise solution developed to automate the collection, trending, and reporting of environmental monitoring (EM) data across client's global manufacturing sites.
- Deployed across 25+ sites
- Integrates with MODA, gLIMS, LabWare, SQL Server
- Enables stakeholders to focus on risk mitigation by transforming complex EM datasets into actionable insights
Modules Supported:
- EM Analytics Module
- MODA Trend Check & History Tool
- Heatmap Insights
- Utility/Water Trending
- Automated Reports
- Aseptic Site Risk Assessment Tool (ASRAT)
- Advanced Business Process Trending
Technologies Used:
- Frontend: React JS, Tableau
- Backend: .NET Core, Web API, Windows Services
- ETL & Data Access: Pipeline Pilot (PLP), MODA integrations
- Databases: Oracle 19C, SQL Server 2016
- Document Generation: Aspose, ClosedXML