Lead Oracle Fusion Cloud Integration Consultant

Job Description

We are seeking a hands‑on Lead Oracle Fusion Cloud Integration Consultant with strong Oracle Integration Cloud (OIC) expertise and proven experience delivering integrations across Oracle Fusion Cloud and wider enterprise systems. This client‑facing technical leadership role centres on Oracle Integration Cloud delivery, leading integration design and delivery, defining reusable interface patterns, supporting technical governance, and remaining hands‑on throughout build, testing, deployment, and defect resolution activities.

The role also includes exposure to Oracle Fusion extensions and workflow tooling such as VBCS, Oracle Process Automation (OPA)/Process Cloud Service (PCS). The successful candidate should be willing and able to quickly learn these areas.

• Designing and delivering Oracle Integration Cloud integrations across Fusion ERP, HCM and EPM.
• Building app‑driven, scheduled, event‑based, REST/SOAP and file‑based integrations.
• Working with Fusion interface patterns including FBDI, HDL, BICC, BI Publisher outputs and public APIs.
• Establishing reusable OIC templates, error‑handling patterns, monitoring standards and deployment controls.
• Leading integration work streams and engaging functional, technical and client stakeholders.

OIC Integration Architecture & Delivery

• Lead the end‑to‑end design, build and delivery of integrations between Oracle Fusion Cloud and internal or external enterprise systems using Oracle Integration Cloud.
• Define practical and reusable integration patterns covering synchronous APIs, asynchronous orchestration, scheduled processing, event‑based flows and file‑based interfaces.
• Produce and maintain integration design artefacts, including interface catalogues, mapping specifications, transformation rules, error‑handling designs, deployment notes and operational support documentation.
• Build and optimise OIC integrations using:
  • App‑driven orchestrations
  • Scheduled integrations and bulk processing patterns
  • REST and SOAP services
  • SFTP/file‑based interfaces
  • Oracle Fusion adapters and enterprise application adapters where applicable
  • JSON, XML, XSLT, XPath and schema‑based transformations
• Implement robust error handling, replay, recovery and operational support patterns covering technical failures, business validation failures, rejected records and downstream availability issues.
• Support performance tuning for high‑volume integrations, including batching, pagination, payload optimisation, parallel processing and appropriate use of asynchronous patterns.
• Implement secure integration patterns using OAuth2, certificates, keys, PGP encryption, secure FTP, allow‑listed connectivity and OIC connectivity agents where required.
• Support environment configuration, migration between environments, deployment sequencing and release readiness for OIC artefacts.

Fusion Interface & Data Alignment

• Work closely with Fusion functional and data migration teams to confirm source and target objects, interface ownership, business rules, error handling and reconciliation requirements.
• Design integrations that align with Fusion ERP/HCM/EPM interface options, including REST/SOAP APIs, FBDI, HDL, BICC extracts, BI Publisher outputs and scheduled ESS jobs.
• Ensure integration outputs support reconciliation, auditability, traceability and operational reporting requirements.
• Support defect triage across Fusion, OIC and external system boundaries, including analysis of payloads, logs, transformations and downstream responses.

VBCS and OPA/PCS Support

• Support VBCS‑based extension activities such as minor page updates, service connection configuration, UI changes and integration with existing OIC services.
• Develop working familiarity with Oracle Process Automation (OPA)/Process Cloud Service (PCS) with expectation of learning and supporting workflow/process automation use cases under guidance.
• Work with senior extension or process automation specialists where complex UI, workflow or business process design is required.
• Apply agreed standards for role‑based access, usability, configuration management and handover when contributing to VBCS, OPA/PCS artefacts.

Framewor…