Oracle Fusion HCM Technical Lead - Reporting & Integrations

We are looking for an Oracle Fusion HCM Technical Lead to work with one of our leading UK clients. Candidates must be NPPV3 eligible ; applicants with a minimum of 3 years' UK residency will also be considered, subject to meeting the clearance eligibility requirements.

Key Responsibilities Workstream Leadership & Solution Ownership Take ownership of Oracle HCM reporting, extracts and integration workstreams, including plans, priorities, dependencies, milestones, testing, cutover and production readiness.

Lead customer workshops and translate business and functional requirements into technical solutions using OTBI, BI Publisher, HCM Extracts, APIs, file interfaces and Oracle Integration Cloud (OIC). Collaborate with HCM, Payroll, Security, Data Migration, Testing and external application teams to manage dependencies, risks and technical decisions through to resolution.

Review technical deliverables produced by other developers while retaining hands-on responsibility for complex design and development activities. BI Publisher, OTBI & SQL Design, develop and support Oracle BI Publisher reports and data models using complex SQL, parameters, List of Values (LOVs), RTF/Excel/eText templates, bursting, scheduling and report delivery.

Develop OTBI analyses and dashboards, including prompts, calculations and scheduled outputs using relevant HCM and Payroll subject areas. Write, debug and optimise SQL for reporting, reconciliation and issue investigation.

Troubleshoot report failures, performance issues, missing data, formatting problems, security restrictions, effective-dating discrepancies and scheduling or delivery defects. HCM Extracts & Outbound Interfaces Design, develop and support Oracle HCM Extracts, including data groups, records, attributes, parameters, output structures, schedules and delivery options.

Work with delivered and user-defined database entities and Fast Formula where appropriate. Implement full and incremental (changes-only) extraction patterns to meet business and downstream application requirements. Develop outbound files in required formats and validate and reconcile extract results against Oracle Fusion source data.

Optimise high-volume extracts and resolve incomplete, failed or long-running processes. Oracle Integration Cloud (OIC) Design, develop and support scheduled, application-driven and orchestration-based integrations using appropriate OIC adapters and connectivity patterns.

Build integration mappings, lookups, transformations, branching, looping, data enrichment, file handling and orchestration logic. Integrate Oracle Fusion with inte...

Report this job