Job description
Role Overview
OIC Consultant at Ghobash Group. The role supports the Group's centralized business functions and portfolio of business units, focusing on Oracle integration and ERP technical delivery.
Company Overview
Ghobash Group capitalizes on opportunities within promising industry sectors by acquiring existing companies or establishing new businesses. Aban Investment was established to administer centralized business functions (finance, legal, HR, marketing, etc.) across the Group's business units, delivering cost efficiencies, value, and best practices.
Role Purpose
Design, build, customize, and maintain Oracle Integration Cloud (OIC) and Oracle ERP solutions. Provide technical and functional support for integration projects, Oracle Financials and Procurement modules, and cross-system data processing while ensuring security standards and governance compliance.
Key Responsibilities
Design & Development
- 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.
- Develop PL/SQL packages, procedures, APIs, and scripts required for interfaces and data processing.
- Implement hands-on development of packages and functions using SQL/PL/SQL and expose them as REST services.
Testing & Optimization
- Perform unit testing, troubleshooting, defect resolution, and performance optimization for integration components.
- Lead unit testing of integration components in OIC using REST/SOAP services and third-party applications.
Security & Compliance
- Implement and maintain security standards and integration protocols across systems.
- Ensure documentation accuracy and compliance with IT governance standards.
Documentation & Knowledge Management
- Manage technical documentation including integration designs, test scripts, and support logs.
- Provide knowledge transfer and technical guidance to internal teams.
Requirements & Collaboration
- 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.
- Liaise with Oracle Support for complex issues requiring vendor intervention.
Incident & Root Cause Analysis
- Provide root cause analysis and incident resolution for issues involving Oracle EBS and OIC.
- Assist in change requests, enhancements, and new integration initiatives.
Project Leadership
- 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.
Qualifications & Experience
- 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.
- Expert in customizing and developing Oracle forms and reports.
- Expert in RICE components and Oracle Interface tables in financial and procurement modules.
- Expert in Oracle Workflows, Personalizations, and Oracle Alerts.
- Strong knowledge of Oracle development tools, e-Business application functionality, system administration, database structure, and multi-Org architecture.
Skills & Competencies
- Oracle Integration Cloud (OIC).
- REST/SOAP services and third-party application connectors.
- Oracle ERP R12.x and Oracle E-Business Suite (EBS).
- PL/SQL: procedures, packages, functions, triggers, views, collections, nested tables, arrays, records, sequences, and constraints.
- Oracle forms, reports, and workflows.
- SQL and PL/SQL programming.
- Database objects and database structure.
- Oracle Financials and Procurement modules.