Oracle-Technical-OIC-BI Publisher and Fast Formula - OTL-Absence

EMBARK SERVICES PRIVATE LIMITED; Ernakulam; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Embark Services Private Limited seeks a proactive Oracle Fusion HCM Technical Consultant – Senior with deep expertise in OIC, BI Publisher, and Fast Formula. You will deliver complex integrations, reports, and formulas, supporting OTL, Absence, and Payroll functions for client projects.

You will collaborate with functional teams to translate requirements into scalable technical solutions, ensuring security, performance, and reliability across the HCM landscape.

Qualifications

• Minimum 5 years of relevant Oracle Fusion Cloud technical experience.
• Experience across OIC integrations, BI Publisher reports, and Fast Formula implementations.
• Exposure to end-to-end HCM transformations including data conversions and production support.

Responsibilities

• Design, develop, test, deploy, and support Oracle Fusion HCM integrations using OIC.
• Develop and maintain BI Publisher reports, data models, and payroll documents.
• Design, validate, and troubleshoot Fast Formulas for OTL, Absence, and Payroll.

Skills

OIC (Oracle Integration Cloud)

BI Publisher (BIP)

Fast Formula

OTL (Oracle Time and Labor)

Absence Management

Payroll

HCM Reporting

Education

Oracle Certification

BTech or MBA

Tools

HCM Extracts

HDL

HSDL

OTBI

SQL

PL/SQL

REST

SOAP

Job description

Embark Services Private Limited | Full time

Oracle-Technical-OIC-BI Publisher and Fast Formula - OTL-Absence

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.

Requirements

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.
• 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