OIC Consultant

Responsible for designing developing and supporting integration solutions across the Oracle ecosystem using Oracle Integration Cloud. This role ensures seamless data flow between Oracle Applications and third-party systems through efficient integrations customization and technical development. The consultant will work closely with business stakeholders functional teams and technical resources to translate business requirements into reliable scalable and secure technical solutions while ensuring adherence to best practices and organizational standards.

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

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

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

• Bachelors degree in computer science or related field
• Masters degree or relevant professional certification

• 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 Personalizations 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.
• Knowledge of Oracle R12 ideal with functional knowledge of core Oracle EBS Modules including Financials and Procurement
• Advantage:
  Web Adi OA Framework and customization and Personalization of JSP pages APEX
• Must have good experience translating business requirements and design into technical solutions
• Ability to research learn troubleshoot and support complex system customizations
• The ability to multi-task and prioritize across concurrent workloads may be required
• Excellent written and verbal communication
• Ability to work independently and manage multiple project timelines effectively
• Excellent teamwork and collaboration capabilities
• Gather and document business requirements on IT incidents and change work.
• Troubleshoot process issues and provide remedial actions whether functional or technical in nature liaising with Oracle where required

Remote Work:

No

Employment Type:

Full-time