Senior Oracle Integration Cloud (OIC) Consultant

Key Responsibilities

• Design, develop, and architect integration solutions using Oracle Integration Cloud (OIC), including App-Driven, Scheduled, Orchestrated, File-Based, REST, and SOAP integrations.
• Apply industry-standard integration patterns such as synchronous and asynchronous messaging, event-driven architecture, file-based batch processing, API-led integrations, and B2B/EDI integrations.
• Integrate Oracle ERP Cloud and external/legacy systems using OIC adapters, including REST, SOAP, Database, FTP/File, JMS, and B2B/EDI (X12).
• Support integrations aligned to Order-to-Cash (O2C), Procure-to-Pay (P2P), and Manufacturing business processes.
• Integrate Oracle ERP Cloud, Sales Cloud, CRM/CPQ, Demand Planning (DDC), 3PL systems, and multiple in-house applications.
• Work with Oracle Cloud Infrastructure (OCI) services, including Object Storage, IAM, Networking, and Compute, to support secure and scalable integration deployments.
• Develop BI Publisher (BIP) reports, including Data Models, SQL datasets, RTF templates, bursting configurations, and scheduled delivery.
• Configure and manage Enterprise Scheduler Service (ESS) jobs for automation and batch processing.
• Utilize BI Cloud Connector (BICC) for high-volume data extraction and downstream integrations.
• Design and implement File-Based Data Import (FBDI) integrations and bulk data processing solutions.
• Develop and optimize SQL and PL/SQL database objects, including Stored Procedures, Packages, Functions, Triggers, Sequences, and Views.
• Prepare System Design Documents (SDD), Technical Design Documents (TDD), and detailed test cases.
• Troubleshoot production issues, perform root cause analysis (RCA), and implement corrective actions.
• Follow CI/CD best practices for version control, automated deployments, environment promotion, and release management.
• Design AI-driven automation capabilities such as OIC RPA, Fusion Intelligent Agents, or related automation frameworks (preferred).
• Work across the full Software Development Lifecycle (SDLC) within Agile delivery models.

Required Experience

• Strong hands-on experience with Oracle Integration Cloud (OIC).
• Proven experience designing and architecting enterprise integration solutions.
• Hands-on experience integrating heterogeneous systems (ERP, legacy applications, third-party systems, cloud, and on-premises platforms) using diverse integration patterns.
• Experience integrating Oracle ERP Cloud, Sales Cloud, CRM/CPQ, Demand Planning Cloud, EDI, and 3PL systems.
• Exposure to Order-to-Cash (O2C), Procure-to-Pay (P2P), and Manufacturing business processes.
• Strong SQL and PL/SQL development expertise.
• Experience developing BI Publisher reports, ESS jobs, and BICC extracts.
• Working knowledge of Oracle Cloud Infrastructure (OCI) and Oracle APEX development.
• Exposure to CI/CD and DevOps deployment methodologies.
• Exposure to AI-driven automation capabilities such as OIC RPA, Fusion Intelligent Agents, or related automation frameworks (preferred).
• OIC Certification preferred.