Senior Oracle Integration Cloud (OIC) Technical Consultant

Job Summary

We are seeking a highly experienced Senior Oracle Integration Cloud (OIC) Technical Consultant to lead the design, development, implementation, support, and optimization of integration solutions across Oracle Cloud and third-party enterprise systems. The role requires strong expertise in Oracle Integration Cloud, integration architecture, API development, middleware concepts, data transformation, and enterprise application connectivity .

The consultant will work closely with business stakeholders, functional teams, solution architects, infrastructure teams, and implementation partners to deliver secure, scalable, reusable, and high-performing integration solutions aligned with business objectives, enterprise architecture standards, and digital transformation initiatives.

Key Responsibilities

Technical Leadership

• Lead end-to-end design, development, deployment, and support of Oracle Integration Cloud solutions across enterprise programs.
• Develop integrations between Oracle Fusion applications and external systems including:
• ERP
• HCM
• SCM
• EPM
• Legacy applications
• Third-party SaaS and on-premise systems
• Analyze business and technical requirements and translate them into robust integration designs.
• Participate in architecture discussions and recommend best-practice integration patterns, tools, and approaches.
• Prepare and review technical design documents, interface specifications, mapping documents, test scenarios, and deployment plans.

Integration Design & Development

• Design and build integrations using Oracle Integration Cloud components including:
• App-driven integrations
• Scheduled integrations
• File-based integrations
• REST and SOAP web services
• Orchestration flows
• Adapters
• Lookups
• Mappings
• Assignments
• Switches
• Loops
• Fault handling
• Develop reusable integration frameworks, templates, and utilities to improve delivery efficiency and maintainability.
• Configure and manage connectivity using Oracle adapters, REST APIs, SOAP services, FTP/SFTP, and database connections.
• Implement data transformation, validation, enrichment, and routing logic within OIC integrations.
• Support integration with Oracle ERP/HCM/SCM modules, Oracle ERP Cloud web services, and external middleware platforms.

API, Security & Middleware Management

• Design and consume REST/SOAP APIs for inbound and outbound integrations.
• Implement authentication and authorization mechanisms including OAuth, basic authentication, certificates, and secure credential management.
• Ensure secure transmission of data across systems using encryption, certificates, and enterprise security standards.
• Collaborate with infrastructure and security teams on network connectivity, firewall rules, certificates, and endpoint access.
• Support API lifecycle management, versioning, and governance practices.

Testing & Deployment

• Lead unit testing, SIT, UAT support, regression testing, and production deployment activities for integrations.
• Validate payloads, mappings, error handling, and end-to-end transaction flows.
• Support cutover planning, migration of integration artifacts, and production readiness checks.
• Troubleshoot integration failures, analyze logs, identify root causes, and implement corrective actions.
• Provide hypercare and post-go-live support to ensure stable operations.

Monitoring, Support & Continuous Improvement

• Monitor integration jobs, schedules, alerts, and error queues in Oracle Integration Cloud.
• Provide L2/L3 technical support for production incidents and service requests.
• Analyze recurring issues and implement automation, optimization, and preventive controls.
• Maintain integration documentation, support runbooks, and operational procedures.
• Drive continuous improvement in integration performance, reliability, and reusability.

Stakeholder & Governance Management

• Engage with business users, functional consultants, solution architects, PMOs, and technical teams to gather requirements and resolve issues.
• Participate in design reviews, governance meetings, and project status updates.
• Ensure compliance with enterprise integration standards, audit requirements, data governance policies, and change management processes.
• Coordinate with Oracle Support and third-party vendors for issue resolution and service requests.

Requirements

Required Qualifications

• Bachelor’s degree in related discipline.
• Oracle Integration Cloud certification or equivalent professional qualification is preferred.
• 8–12+ years of Technical experience with 5+ years in Oracle Integration Cloud or middleware/integration development .
• Proven experience in at least 2–3 full lifecycle Oracle Cloud integration implementations .
• Strong understanding of enterprise integration patterns, API management, data transformation, and cloud-to-cloud/cloud-to-on-premise connectivity.

Mandatory Technical Expertise

• Oracle Integration Cloud (OIC) development and administration
• REST and SOAP web services
• Oracle Cloud ERP/HCM/SCM integration knowledge
• App-driven and scheduled integrations
• File-based integrations and file handling
• Oracle adapters and connectivity setup
• Data mapping, transformation, and orchestration
• Fault handling, exception management, and retry logic
• Integration monitoring, logging, and troubleshooting
• OTBI/BI Publisher awareness for reporting-related integrations
• Secure credential management and authentication mechanisms
• Integration testing, deployment, and migration activities
• API consumption and exposure
• Knowledge of Oracle Fusion web services and business events
• Strong skills of SQL, PL SQL is mandatory
• Working knowledge on XML, JSON, XSLT, and web service standards.

Preferred Skills

• Experience in Government, Public Sector, Utilities, Oil & Gas, or Large Enterprise environments .
• Knowledge of Oracle ERP Cloud, Oracle HCM Cloud, Oracle SCM Cloud, and Oracle EPM Cloud integration scenarios.
• Exposure to Oracle SOA Suite, Oracle Service Bus, MuleSoft, Informatica, Boomi, or other middleware platforms.
• Understanding of B2B integrations, EDI, SFTP-based file exchanges, and batch processing.
• Experience with Oracle Cloud release management and quarterly update impact assessment.
• Knowledge of data migration tools and methods such as FBDI, HDL, HSDL, and custom file interfaces.
• Understanding of enterprise architecture, integration governance, and API lifecycle management.