Senior Oracle Technical Consultant

Established more than 40 years ago, the United Al Saqer Group (UASG) is one of the leading multi-sector business groups in the United Arab Emirates. The UASG owns and operates a diverse yet complementary portfolio of six UAE-based companies encompassing several key industry sectors, which includes Abu Dhabi Motors, Performance Plus Motors, Autoplus, Autodrive, Dalma Motors, United Al Saqer Heavy Equipment, Falcon Motors, Al Saqer Property Management, Royal International Construction, Royal Joinery, Royal Wood Factory, SAMA Integrated systems, AG Hotel, Safe Travel, IFM Facilities Management L.L.C. and Global Catering Services.

We are recruiting a Oracle Finance & EPM Consultant who is responsible for designing, developing, and supporting technical solutions across Oracle Cloud applications, with a strong focus on Oracle Integration Cloud (OIC), Oracle Transactional Business Intelligence (OTBI), and BI Publisher. The role delivers end-to-end technical components including integrations, reports, data extracts, and customizations across Finance and HCM modules.

AREA OF RESPONSIBILITY:

Technical Development & RICEW Objects:

• Design and develop technical components including reports, interfaces, conversions, and enhancements (RICEW objects).

• Develop custom reports using BI Publisher, OTBI, Financial Reporting Studio (FRS), Smart View, and HCM extracts.

• Perform page customizations using Sandbox, Redwood, APEX, VCBS, and PCS frameworks.

Integration & Data Management (OIC):

• Design and develop integrations using Oracle Integration Cloud (OIC).

• Build and manage data integrations between Oracle Fusion and third-party systems using REST/SOAP APIs, FBDI, HDL, and HSDL.

• Support data migration, conversion, and automation processes.

• Ensure data accuracy, integrity, and consistency across systems.

Reporting & Analytics (OTBI & BI Publisher):

• Develop advanced OTBI reports, dashboards, and real-time operational insights.

• Create interactive dashboards and optimize performance and usability.

• Design BI Publisher data models, templates, and bursting reports.

• Customize subject areas and reporting data models.

HCM Technical Development:

• Develop and manage HCM Extracts for reporting and integrations.

• Utilize Oracle HCM Data Loader (HDL) for data migration and maintenance.

• Design and implement Fast Formulas to support HR and payroll business rules.

• Support payroll, benefits, and HR reporting requirements.

Testing, Documentation & Deployment:

• Prepare technical design documents, test plans, and user guides.

• Conduct unit testing and system testing; support UAT with business users.

• Ensure smooth deployment and transition of technical solutions into production.

Troubleshooting & Support:

• Provide technical analysis and troubleshooting for Oracle Fusion ERP modules (Finance, SCM, HCM).

• Resolve system performance, integration, security, and data issues.

• Collaborate with IT and business teams to ensure timely issue resolution.

Compliance & Best Practices:

• Ensure all technical solutions adhere to Oracle best practices and IT governance standards.

• Maintain system security, performance, and scalability.

• Support audits and compliance requirements where applicable.

Stakeholder Collaboration:

• Work closely with functional consultants and business users to translate requirements into technical specifications.

• Provide technical guidance and recommendations for system improvements.

• Support cross-functional collaboration across IT, Finance, and HR teams.

Requirements

QUALIFICATIONS & CERTIFICATIONS & EXPERIENCE (MANDATORY & PREFERRED):

• Bachelor’s degree in Computer Science, Information Technology, or related field.

• Minimum of 6-8 years technical experience in Oracle Cloud.

• Strong hands-on experience with Oracle Integration Cloud (OIC), OTBI reporting and dashboards, BI Publisher.

SKILLS & COMPETENCIES (Technical, Behavioral, and Soft):

Technical Skills:

• Oracle Integration Cloud (OIC) development and integration design

• OTBI advanced reporting and dashboard development

• BI Publisher (data models, templates, bursting)

• Financial Reporting Studio (FRS) and Smart View

• HCM technical tools (HCM Extracts, HDL, Fast Formulas)

• SQL, data analysis, XML, and XSLT

• REST & SOAP APIs and file-based integrations (FBDI, HDL)

• Oracle SaaS customization tools (Sandbox, Redwood, APEX, VCBS, PCS)

Behavioural Competencies:

• Customer Focus - Understands customer challenges and takes initiative to resolve them effectively.

• Accountability and Ownership - Manages projects with minimal supervision and ensures quality results.

• Agility and Adaptability - Manages change smoothly and supports others during transitions.

• Collaboration & Influence - Builds networks across functions and resolves conflicts constructively.

• Result Orientation - Sets clear goals and works proactively to achieve high performance.

Location: Abu Dhabi