Data Integration Developer Oracle ODI & OIC

Job Function

The Data Integration Developer is a role for a BioPharma client building a data warehouse. The Data Integration Developer will be responsible for designing and writing ETL solutions using Oracle's Data Integrator (ODI) and Oracle Integration Cloud (OIC) software tools for a Process Development group within the Chemical, Manufacturing and Controls (CMC) department.

with pharma/biotech that comes from Accenture, Gapgemini etc

Primary Responsibilities

Partner with client Process Development group and other stakeholders to implement Data Integration jobs using ODI for batch jobs and OIC for application-to-application integration.
Create source to target mappings for simple to complex data integration tasks.
Integrate enterprise applications such as MasterControl and LabVantage with other enterprise applications and data feeds.
Document Technical Requirements based on Data Requirements
Provide estimates and timelines to deliver functionality based on Data Requirements
Provide updates and status reports to the Project Manager around progress and any issues or blockers
Create extracts and data for statistical analysis (SAS/JMP) and Machine Learning (Client) research

Qualifications

Strong knowledge of Oracle Data Integrator for batch application development within a Data Warehouse environment.
Experience with Oracle Integration Cloud for building data connections between various applications in the client's environment.
ODI and OIC configuration and setup experience
Good functional knowledge of Life Sciences CMC Process Development processes.
Strong understanding of data warehousing and source to target mapping concepts
Minimum of 3 years' experience working with ODI, OIC and Data Warehouses
Experience working with a Pharmaceutical, Biotech or Medical Device organization.
Experience working in an agile delivery environment.
Ability to handle multiple priorities and work under pressure.
Familiarity with the following is a plus:
Experience with Process Development Data (Stability data, Building and Equipment Monitoring data, Electronic Batch Records, LIMS data and systems).
Experience with Machine Learning data set preparation including sampling, binning, bias and testing.