OIC Consultant

Company DescriptionOver the many years of its pursuit for investment diversification, the Ghobash Group has capitalized on opportunities in sectors with encouraging growth potential by either buying out established operating companies or founding new businesses to extend value into those markets. As the portfolio of these fully, or majority-owned operating companies grew and became more diversified, the Group established ABAN INVESTMENT in 2008 to administer and facilitate its smooth operation. Each operating company general manager reports into the CEO of Aban Investment and as such it is an actively managed portfolio of companies.ABAN Investment currently has stakes in Technology, Oil & Gas, Pharmaceuticals, Industrial Chemicals and Supplies, Hospitality, Healthcare, and Consumer Services. It is committed to building high-value businesses, from start-ups and early stage ventures to mergers and acquisitions for more mature businesses.Job DescriptionResponsible 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 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 fieldMaster’s degree or relevant professional certificationAdditional InformationExperience:8+ years of experience on Oracle Applications and OIC integrationsSkills & Abilities:Expert 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. Knowledge of Oracle R12 ideal with functional knowledge of core Oracle EBS Modules including Financials and ProcurementAdvantage: Web Adi, OA Framework and customization and Personalization of JSP pages, APEXMust have good experience translating business requirements and design into technical solutionsAbility to research, learn, troubleshoot, and support complex system customizationsThe ability to multi-task and prioritize across concurrent workloads may be requiredExcellent written and verbal communicationAbility to work independently and manage multiple project timelines effectivelyExcellent teamwork and collaboration capabilitiesGather 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