OIC Consultant

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 DescriptionTechnical ResponsibilitiesDesign 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 ResponsibilitiesCollaborate 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 ResponsibilitiesLead 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. QualificationsBachelor's degree in computer science or related field8+ years of experience on Oracle Applications and OIC integrationsExpert in Oracle ERP R12.x, Oracle Integration Cloud, and Oracle E-Business supportExperience building integration, unit testing of integration components in OIC using REST/SOAP Services and third party applicationsExpert in customizing and developing Oracle forms and reportsExpert in RICE components, Oracle Interface tables in financial and procurement modulesExpert in Oracle Workflows, Personalization’s, Oracle AlertsStrong 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/SQLHands-On development of packages and functions using SQL/PLSQL and exposing them as RESTStrong knowledge of Oracle development tools, some e-Business application functionality, system administration, database structure and knowledge of multi-Org architecture.