Senior Oracle Integration Cloud (OIC) Consultant

ob Title: Senior Oracle Integration Cloud (OIC) Consultant

Seattle, Washington, United States (On-site)

Note: Need only local candidates. Relocation candidates not considered.

Client: Mastek

Job Description – Senior Oracle Integration Cloud (OIC) Consultant

We are seeking a Senior Oracle Integration Cloud (OIC) Consultant to serve as the subject matter expert for enterprise integrations across Oracle Cloud applications and external systems. This role is responsible for designing, developing, and architecting scalable, secure, and high-performing integration solutions while providing operational and project support in a cloud-first environment, leveraging Oracle Integration Cloud (OIC), Oracle Cloud Infrastructure (OCI), and Oracle Database technologies.

The candidate will collaborate closely with business and technical stakeholders to analyze requirements and design robust integration solutions that support end-to-end business processes, including Order-to-Cash (O2C), Procure-to-Pay (P2P), and Manufacturing flows.

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).
• Develop and manage EDI (X12) integrations to support secure communication and transaction processing with trading partners.
• 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.
• Participate in integration testing, deployment validation, migration activities, and post-production support.
• 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.
• Experience integrating heterogeneous systems (ERP, legacy applications, third-party systems, cloud, and on-premises platforms) using diverse integration patterns.
• Hands-on experience integrating Oracle ERP Cloud, Sales Cloud, CRM/CPQ, Demand Planning Cloud, EDI, and 3PL systems.
• Experience with EDI (X12) integrations.
• 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.
• Knowledge of CI/CD and DevOps deployment methodologies.
• Exposure to Oracle SOA Suite, WebLogic, OSB, and MFT is a plus.
• Exposure to AI-driven automation capabilities such as OIC RPA, Fusion Intelligent Agents, or related automation frameworks is preferred.
• OIC Certification preferred.