Oracle Consultant - Technical - Senior - OIC BI Publisher and Fast Formula, OTL Absence Payroll

At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all. 

Oracle Consultant - Technical - Senior

(OIC, BIP, Fast Formula, OTL, Absence & Payroll)

Summary:

We are seeking a proactive and experienced Oracle Fusion HCM Technical Consultant – Senior, with strong expertise in Oracle Integration Cloud (OIC), BI Publisher (BIP), and Fast Formula, supported by hands-on experience across Oracle Time and Labor (OTL), Absence Management, and Payroll. The ideal candidate will have a strong Oracle Fusion Cloud HCM technical background and proven experience delivering integrations, reports, extracts, formulas, data conversions, and production support for complex HCM transformation initiatives.

Primary Responsibilities and Accountabilities:

• Design, develop, test, deploy, and support Oracle Fusion HCM integrations using Oracle Integration Cloud (OIC), including HCM adapters, REST and SOAP services, HDL, HCM Extracts, transformations, fault handling, monitoring, and third-party integrations.
• Develop and maintain BI Publisher (BIP) reports, data models, templates, bursting configurations, payroll documents, extracts, and operational reports for HCM processes.
• Design, develop, validate, and troubleshoot Fast Formulas for Oracle Time and Labor, Absence Management, and Payroll, including time-entry rules, overtime and premium calculations, accruals, eligibility, validations, payroll elements, earnings, deductions, and calculation logic.
• Support end-to-end technical solutions for OTL, Absence, and Payroll, working closely with functional consultants to translate business requirements into scalable integrations, reports, extracts, and formulas.
• Develop inbound and outbound interfaces for employee, assignment, time, absence, payroll, costing, and payment-related data using OIC, HCM Extracts, HDL, REST, SOAP, and secure file-transfer mechanisms.
• Deliver high-quality work across the full SDLC, including technical design, code reviews, unit testing, SIT, UAT, release management, production deployment, reconciliation, and Hypercare support.
• Diagnose integration, reporting, formula, time, absence, and payroll issues; identify root causes; optimize performance; and resolve production incidents within agreed service levels.
• Build strong relationships with clients and internal teams while supporting Managers in meeting client commitments and internal KPIs.

Job Requirements:

• Strong hands-on experience in Oracle Integration Cloud (OIC), BI Publisher (BIP), and Oracle Fusion HCM Fast Formula.
• Minimum 5 years of relevant Oracle Fusion Cloud technical experience, including at least 2–3 full life-cycle implementations and one end-to-end HCM implementation or major rollout.
• Extensive OIC experience covering Oracle HCM Cloud adapters, REST, SOAP, FTP/SFTP, scheduled and event-based integrations, mappings, lookups, fault handling, monitoring, and performance troubleshooting.
• Strong BIP expertise covering SQL-based data models, RTF, Excel, eText, and XML templates, bursting, scheduling, security, troubleshooting, and report performance optimization.
• Proven Fast Formula experience across OTL, Absence Management, and Payroll, including database items, contexts, inputs, defaults, formula functions, validation, compilation, testing, debugging, and performance optimization.
• Good functional and technical understanding of OTL configurations and rules, time-entry validation, overtime, shift differentials, premium calculations, approval and transfer processes, and payroll integration.
• Good understanding of Absence Management, including absence plans and types, accruals, eligibility, carryover, proration, entitlement, validations, and payroll impact.
• Good understanding of Oracle Fusion Payroll, including elements, balances, earnings, deductions, calculation cards, costing, payroll flows, prepayments, payments, reconciliation, and legislative considerations.
• Proficiency in HCM Extracts, HDL, HSDL, OTBI, SQL, PL/SQL, REST and SOAP web services, Oracle Cloud security, and related HCM reporting and integration technologies.
• Experience with HCM data migration, conversion, reconciliation, and interface scheduling, including handling effective-dated employee and payroll data.
• Experience preparing technical design documents, formula specifications, interface mappings, report designs, test scripts, deployment plans, and support documentation, with working knowledge of SIT, UAT, SDLC, and change management.
• Strong analytical, communication, stakeholder-management, and problem-solving skills, with a commitment to secure, compliant, and controlled delivery.

Competencies / Skills:

• Strong ability to drive projects along with the team and independently
• Strong communication skills and ability to translate requirements into design documents.
• Able to work under pressure and meet deadlines
• Excellent organizational and time management skills, strong analytical & problem-solving skills
• Ability to acquire, absorb, and apply complex technical knowledge to problems quickly
• Ability to multitask and still stay focused on release priorities
• Must have a valid passport.
• Willing to work in MENA Shift timings (Sunday to Thursday).
• Client site work / Business Traveling involve

Education: Should be a Oracle Certified and a graduate with a BTECH or MBA

EY | Building a better working world 

 
EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.  

 
Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.  

 
Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.