Job Title:  Senior Consultant | OIC ( Integration) | Gurugram | Oracle

Position

Senior Consultant – Oracle Integration Cloud (OIC)

Experience

5–8 Years

Location

Gurgaon (client office)

Role Overview

We are seeking an experienced Oracle Integration Cloud (OIC) Senior Consultant to design, develop, and implement enterprise integrations across Oracle Fusion Cloud Applications, Oracle Primavera Unifier, Oracle Primavera Cloud (OPC), and third-party systems. The consultant will be responsible for delivering scalable, secure, and high-performance integration solutions while working closely with functional consultants, business stakeholders, and technical teams.

The ideal candidate should have strong expertise in Oracle Integration Cloud, API-led integrations, data migration, and enterprise application integration within ERP and project management ecosystems.

Key Responsibilities

Integration Solution Design

• Lead integration requirement gathering workshops with business and technical stakeholders.
• Design end-to-end integration architecture and technical solutions.
• Develop integration strategy, interface specifications, and data mapping documents.
• Recommend best practices for cloud-to-cloud, cloud-to-on-premise, and hybrid integrations.

OIC Development & Implementation

• Design, develop, test, and deploy integrations using Oracle Integration Cloud (OIC).
• Build and maintain:
• App-Driven Integrations
• Scheduled Integrations
• File-Based Integrations
• Event-Based Integrations
• REST and SOAP Service Integrations
• Configure and manage OIC adapters and connectivity agents.
• Develop reusable integration frameworks and templates.

API & Middleware Development

• Design and develop REST and SOAP APIs.
• Implement API security using OAuth, JWT, and authentication protocols.
• Manage data transformations using XML, JSON, XSLT, and XPath.
• Support event-driven and real-time integration requirements.

Oracle Applications Integration

• Integrate Oracle Fusion ERP modules including:
• Financials
• Procurement
• Project Portfolio Management (PPM)
• Supply Chain Management (SCM)
• Human Capital Management (HCM)
• Implement integrations with:
• Oracle Primavera Unifier
• Oracle Primavera Cloud (OPC)
• Oracle E-Business Suite
• Oracle APEX applications
• Third-party applications and legacy systems

Data Migration & Conversion

• Support data migration and bulk data synchronization activities.
• Develop integration processes for master data and transactional data migration.
• Validate and reconcile migrated data across systems.

Monitoring & Support

• Monitor integration performance and troubleshoot issues.
• Manage error handling, exception management, and recovery processes.
• Support production deployments and post-go-live stabilization.
• Participate in Oracle quarterly update testing and impact assessments.

Required Skills

Oracle Integration Cloud

• 5–8 years of integration and middleware experience.
• Minimum 3 years of hands-on Oracle Integration Cloud (OIC) experience.
• At least 2–3 end-to-end Oracle Cloud integration implementations.
• Strong experience with:
• OIC Generation 3 (preferred)
• Integration Patterns
• Connectivity Agents
• Lookup Frameworks
• Fault Handling
• Integration Monitoring

Technical Skills

• REST APIs and SOAP Web Services.
• XML, JSON, XSLT, XPath.
• Oracle SQL and PL/SQL.
• File-based integrations (CSV, XML, Excel).
• SFTP, FTP, Web Services, and API Gateway concepts.
• Understanding of Oracle Cloud Infrastructure (OCI).

Integration Technologies

• Oracle Integration Cloud (OIC)
• Oracle Fusion ERP Cloud
• Primavera Unifier
• Primavera Cloud (OPC)
• Oracle APEX
• Oracle E-Business Suite
• Oracle Visual Builder (desirable)

Preferred Skills

• Experience with Oracle Primavera Unifier and Primavera Cloud integrations.
• Experience integrating Oracle Fusion ERP with capital project management systems.
• Knowledge of Oracle Fusion business processes including Finance, Procurement, SCM, and PPM.
• Experience with Oracle Integration Cloud migration and upgrade projects.
• Exposure to Oracle Data Integrator (ODI) and Oracle SOA Suite.
• Understanding of event-driven architecture and microservices.

Qualifications

• Bachelor's Degree in Engineering, Computer Science, Information Technology, or related discipline.
• Oracle Integration Cloud Certification preferred.
• Oracle Cloud Infrastructure (OCI) certification is an added advantage.

Key Competencies

• Strong problem-solving and troubleshooting skills.
• Excellent client-facing and stakeholder management abilities.
• Strong communication and documentation skills.
• Ability to lead technical integration workstreams independently.
• Experience mentoring junior consultants and developers.
• Ability to work in global delivery and multi-vendor environments.