OIC Consultant

Company Description

Over 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 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

• Bachelor's degree in computer science or related field
• Master’s 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, 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.
• 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