Description

You will design and implement ETL solutions and application-to-application integrations to support data warehouse construction.

Responsibilities

• Design and write ETL solutions using Oracle Data Integrator (ODI) for batch jobs and Oracle Integration Cloud (OIc) for application integration.
• Create source-to-target mappings for simple and complex data integration tasks.
• Integrate enterprise applications, including MasterControl and LabVantage, with other data feeds.
• Document technical requirements and provide delivery estimates and timelines based on data requirements.
• Generate data extracts for statistical analysis (SAS/JMP) and machine learning research.

Required Skills

• 5+ years of experience working with Oracle Data Integrator (ODI), Oracle Integration Cloud (OIC), and Data Warehousing.
• Strong knowledge of ODI for batch application development within a Data Warehouse environment.
• Hands-on experience with OIC for building data connections between enterprise applications.
• Proven experience with ODI and OIC configuration and setup.
• Deep understanding of source-to-target mapping and data warehousing concepts.
• Experience working within a Pharmaceutical, Biotech, or Medical Device organization.
• Functional knowledge of Life Sciences CMC Process Development processes.
• Experience working in an agile delivery environment.

Preferred Skills

• Experience with Process Development data, including Stability data, Electronic Batch Records, and LIMS.
• Experience with machine learning dataset preparation, including sampling, binning, and bias testing.

Key Skills

Education

Any Graduate