Senior Oracle Integration Cloud (OIC) Consultant

Veriipro; Seattle (WA); On-site; USD 135,000 - 195,000; Full time

Job summary

Veriipro is seeking a Senior Oracle Integration Cloud Consultant to lead enterprise integration efforts across Oracle cloud and external systems. You will design and architect scalable, secure integrations leveraging OIC, OCI, and Oracle DB technologies.

You will collaborate with business and technical stakeholders to deliver end-to-end processes such as O2C, P2P, and Manufacturing, while ensuring high performance and compliance with CI/CD practices.

Qualifications

• Experience designing and implementing enterprise integration solutions using OIC.
• Experience integrating ERP, legacy, and cloud/on-prem systems with diverse integration patterns.
• Strong SQL/PLSQL development skills.
• Experience with EDI X12 and B2B/EDI integrations.
• OIC certification preferred.
• Exposure to OCI and OCI services and DevOps practices.

Responsibilities

• Design, develop, and architect integration solutions using OIC (App-Driven, Scheduled, Orchestrated, File-Based, REST, SOAP).
• Apply integration patterns: synchronous/asynchronous messaging, event-driven architecture, API-led integrations, file-based batch processing, B2B/EDI.
• Integrate Oracle ERP Cloud and external/legacy systems using OIC adapters (REST, SOAP, Database, FTP/File, JMS, B2B/EDI).
• Develop and manage EDI (X12) integrations with trading partners; support O2C, P2P, and Manufacturing processes.
• Work with OCI services (Object Storage, IAM, Networking, Compute) for secure deployments.
• Develop BI Publisher reports, ESS jobs, and BICC extractions; implement FBDI and bulk data processing.
• Troubleshoot issues, perform RCA, and support CI/CD deployments.

Skills

OIC (Oracle Integration Cloud)

Enterprise integration architecture

SQL/PLSQL

EDI (X12) integrations

OCI & Cloud services

SaaS/ERP integrations

BIP/ESS/BICC

APEX knowledge

Tools

BI Publisher

BI Cloud Connector (BICC)

FBDI

ESS Jobs

WebLogic

OSB (Oracle Service Bus)

MFT (Managed File Transfer)

Oracle APEX

Job description

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-premise 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.