OIC Consultant

Technical Responsibilities

• Design and build integration using Oracle Integration Cloud, REST/SOAP services, and third-party application connectors.

• Customize, develop, and support Oracle ERP components including forms, reports, workflows, and RICE objects.

• Perform unit testing, troubleshooting, defect resolution, and performance optimization for integration components.

• Develop PL/SQL packages, procedures, APIs, and scripts required for interfaces and data processing.

• Implement and maintain security standards and integration protocols across systems.

• Manage technical documentation including integration designs, test scripts, and support logs.

Functional & Operational Responsibilities

• Collaborate with functional consultants and business users to gather, validate, and translate requirements.

• Support Oracle Financials and Procurement modules from an integration and technical perspective.

• Provide root cause analysis and incident resolution for issues involving Oracle EBS and OIC.

• Assist in change requests, enhancements, and new integration initiatives.

• Liaise with Oracle Support for complex issues requiring vendor intervention.

Project & Collaboration Responsibilities

• Lead end-to-end integration projects, ensuring timelines, quality, and deliverables are met.

• Support cross-functional teams during testing cycles, deployments, and go-live activities.

• Provide knowledge transfer and technical guidance to internal teams.

• Ensure documentation accuracy and compliance with IT governance standards.

• Bachelor's degree in computer science or related field

• 8+ years of experience on Oracle Applications and OIC integrations

• Expert in Oracle ERP R12.x, Oracle Integration Cloud, and Oracle E-Business support

• Experience building integration, unit testing of integration components in OIC using REST/SOAP Services and third party applications

• Expert in customizing and developing Oracle forms and reports

• Expert in RICE components, Oracle Interface tables in financial and procurement modules

• Expert in Oracle Workflows, Personalization’s, Oracle Alerts

• Strong programming experience in creating Procedures, APIs, Packages, Functions, Triggers, views, collections nested tables and arrays, records, sequences, views, Constraints and other database objects using SQL and PL/SQL

• Hands-On development of packages and functions using SQL/PLSQL and exposing them as REST

• Strong knowledge of Oracle development tools, some e-Business application functionality, system administration, database structure and knowledge of multi-Org architecture.