Job Title: Oracle Integration (OIC) & ATP Specialist LIMS to Oracle Conversion

Location: Remote

Experience Required: 5+ years (independent, hands-on development)

Job Summary

Our direct client is seeking an experienced Oracle Integration Cloud (OIC) Developer with strong expertise in ATP (Available-to-Promise) to support a LIMS to Oracle Cloud conversion project. The ideal consultant will have hands-on, independent development experience designing and implementing integrations between LIMS platforms and Oracle Cloud applications.

Key Responsibilities

Integration Development (OIC)

• Design, develop, and deploy integrations between LIMS systems and Oracle Cloud using OIC.

• Build complex integrations, orchestrations, data mappings, REST/SOAP APIs, and scheduled jobs.

• Develop end-to-end integrations independently without heavy guidance.

• Implement error handling, logging, monitoring, and performance tuning within OIC.

• Create reusable components and integration templates when required.

LIMS to Oracle Migration

• Work with business and technical teams to understand LIMS data structures and processes.

• Map LIMS data to Oracle Cloud modules (ATP, Inventory, OM, SCM).

• Support conversion activities, validations, and troubleshooting during migration.

• Ensure data integrity and process continuity through integration flows.

Oracle ATP Expertise

• Configure and support Available-to-Promise (ATP) rules within Oracle Cloud Supply Chain.

• Collaborate with Order Management/Inventory teams to align ATP logic with business processes.

• Ensure integrations correctly sync supply, demand, inventory, and fulfillment details.

• Optimize ATP data flow from LIMS to Oracle to maintain accuracy.

Project Coordination

• Work independently to deliver assigned development tasks.

• Collaborate with cross-functional teams including SCM, Manufacturing, and LIMS SMEs.

• Provide status updates, documentation, design specs, and technical artifacts.

• Support testing cycles (SIT, UAT) and resolve integration defects quickly.

Required Skills & Experience

• 5+ years of hands-on OIC development (must be independent, not only under guidance).

• Strong experience building integrations using REST, SOAP, FTP, DB adapters, orchestration flows.

• Experience in LIMS integration or working in laboratory/manufacturing environments.

• Strong knowledge of Oracle Cloud SCM, especially ATP (Available-to-Promise).

• Good understanding of Oracle Order Management, Inventory, Supply Chain, and Manufacturing modules.

• Ability to troubleshoot issues across Oracle Cloud, OIC, and source systems.

• Experience with data migration, conversion, validations, and reconciliation.

Nice-to-Have

• Experience integrating with specific LIMS tools (LabWare, LabVantage, SampleManager, etc.).

• Knowledge of Oracle PaaS development (SQL, PL/SQL, Visual Builder).

• Experience working in regulated environments (pharma, biotech, manufacturing).