Oracle Integration Cloud (OIC) Consultant

  • -
  • Full-Time
  • On-Site
  • -

Job Description:

Role Objective:

The Senior OIC Consultant will design, develop, and user support for complex integrations using Oracle Integration Cloud to connect Oracle Cloud Applications (ERP, HCM, CX) with third-party systems. You will be responsible for the entire integration lifecycle—from architectural design and mapping to performance tuning and API management—ensuring high availability and data integrity across the enterprise ecosystem.

Key Responsibilities

  • Integration Architecture: Design scalable, reusable, and secure integration patterns (Scheduled, App-driven, and Pub-Sub) tailored to business needs.
  • Development & Configuration:
    • Build complex orchestrations in OIC (Gen 2 or Gen 3) using various adapters (ERP, Salesforce, REST, SOAP, FTP, Database).
    • Implement advanced data mapping and transformations using XSLT and XPath.
    • Develop custom JavaScript functions for complex logic within OIC.
  • Advanced Technical Implementation:
    • Manage FBDI (File-Based Data Import) and HDL (HCM Data Loader) automations through OIC.
    • Utilize Oracle Cloud Infrastructure (OCI) components like Object Storage, Streaming, and Functions where necessary.
  • Security & Governance: Implement best practices for API security (OAuth, SAML, Basic Auth) and manage OIC lookups, libraries, and certificates.
  • Troubleshooting & Monitoring: Set up comprehensive error-handling frameworks, alerts, and dashboards to monitor integration health and performance.

Technical Expertise

  • Core OIC: Expert-level knowledge of OIC components: Integration, VBCS, and Process (PCS).
  • Web Services: Deep understanding of REST, SOAP, JSON, and XML.
  • Database & Logic: Strong proficiency in SQL and PL/SQL for database-level integrations and data staging.
  • Web Technologies: Familiarity with HTML5, CSS, and JavaScript (especially for VBCS development).