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.