OIC Consultant

Ghobash Group; Dubai; On-site; AED 240,000 - 360,000; Full time

Job summary

Ghobash Group in Dubai seeks an experienced Oracle Integration specialist to design, develop and support integrations across Oracle ERP and EBS ecosystems. The role focuses on building scalable interfaces via OIC, REST/SOAP and third-party connectors, while aligning with IT governance.

You will collaborate with business users and technical teams to translate requirements into robust solutions, implement security controls, and ensure quality through testing and documentation.

Qualifications

• Bachelor's degree in computer science or related field.
• Master's degree or relevant professional certification.
• 8 years of experience on Oracle Applications and OIC integrations.

Responsibilities

• Design and implement integration using Oracle Integration Cloud with REST/SOAP and third-party connectors.
• Customize and support Oracle ERP components including forms, reports, workflows, and RICE objects.
• Perform unit testing, debugging and performance optimization for integrations.
• Develop PL/SQL packages, procedures, APIs and scripts for interfaces.
• Ensure security standards and integration protocols across systems.
• Manage technical documentation including designs, test scripts and logs.
• Collaborate with functional teams to gather and translate requirements.
• Lead end-to-end integration projects and coordinate deployments.

Skills

Oracle Integration Cloud

Oracle ERP R12

Oracle EBS support

REST/SOAP services

PL/SQL

RICE objects

Oracle Forms & Reports

Oracle Workflows

Oracle Alerts

SQL

Education

Bachelors in Computer Science

Masters or professional cert

Tools

REST APIs

SOAP Services

SQL/PLSQL

Oracle Forms/Reports

OA Framework

Job description

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.

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.

Qualifications :

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

Additional Information :

Experience:

• 8 years of experience on Oracle Applications and OIC integrations

Skills & Abilities:

• 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