OIC Consultant

Company Description

Ghobash Group capitalizes on opportunities within promising industry sectors by either acquiring existing companies or establishing new businesses. Aligned with the needs of a growing portfolio, the Group established Aban Investment to administer a host of centralized business functions (finance, legal, HR, marketing, etc.) all aimed at delivering greater cost efficiencies, value and best practices to each of its business units.

Job Description

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

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