A PeopleSoft-to-Oracle Fusion HCM migration for an Ireland-based enterprise — Core HR, Absence and Payroll — delivered through a Mastek-led program with Excelencia as delivery partner, powered by the Syntra ETL platform. Automated extraction, HDL transformation and full reconciliation, engineered to meet Irish Revenue, PRSI and GDPR requirements.
An Ireland-based enterprise was moving its HR and payroll operation off Oracle PeopleSoft onto Oracle Fusion HCM Cloud. The program ran on a joint governance and execution model, and Syntra ETL provided the automated migration engine that did the heavy lifting — extraction, transformation and load.
Overall program management: planning, reporting, risk and dependency management, executive communications, and the primary interface to the end customer.
Technical architecture and end-to-end delivery execution — data migration, integrations and technical sign-off — aligned to Mastek’s program plan.
The platform behind extraction from PeopleSoft, HDL transformation and load into Oracle Fusion, with reconciliation and delta runs built in.
Three Oracle Fusion HCM domains moved from PeopleSoft. Each has its own detailed write-up:
Employee demographics, personal data, job and position information, and organizational assignments.
Leave balances and accruals, absence events and leave requests, and approval workflows.
Earnings, deductions, taxes and payroll run information — plus terminated-employee and retiree history — built for Irish Revenue and PRSI.
A PeopleSoft Application Engine program (with PeopleCode enhancements) orchestrates extraction from core tables — no manual data pulls, with run-control safety checks to prevent parallel runs.
Full and Change (delta) modes using a last-run timestamp, plus effective-dated logic for current employee records, so re-extracts pick up only what changed.
Extraction and transformation produce Oracle HCM Data Loader (HDL) files (CSV/TXT) that conform to Oracle Fusion Cloud specifications.
Transformation focuses on the fields that matter for Irish Revenue reporting and PRSI (Pay Related Social Insurance), bridging PeopleSoft data to the Fusion model.
Record-count comparison between source and target, data-type and null checks, and an exception log — every cycle.
Automation of extraction and HDL transformation cuts manual effort and error, across iterative migration cycles before production cutover.
A three-phase approach, each phase producing measurable, auditable deliverables:
Define scope and extraction parameters, configure PeopleSoft run controls, extract from core tables into staging, and run initial data verification.
Map PeopleSoft fields to the Oracle Fusion data model, apply HDL transformation rules, generate output files, and load into the staging/target environment.
Validate integrity and statutory compliance, monitor error logs, document validation rules and exceptions, and manage post-migration data governance.
Payroll and HR data for an Irish employer carries specific obligations. The migration was designed around them from extraction onward — not bolted on at the end.
It was delivered on a joint model: Mastek as program-management lead and primary customer interface, Excelencia as technical and delivery partner, with the Syntra ETL platform as the automated migration engine. The end customer — an Ireland-based enterprise — retained business ownership and final acceptance.
Core HR (demographics, job, position, organizational assignments), Absence (leave balances, accruals, events, approvals), and Payroll (earnings, deductions, taxes, plus terminated and retiree history).
Via the Oracle HCM Data Loader (HDL). Syntra extracts from PeopleSoft and transforms the data into HDL-compliant files that conform to Oracle Fusion Cloud specifications.
Irish Revenue reporting fields and PRSI (Pay Related Social Insurance) data are mapped and validated through the pipeline, and validation rules and exceptions are documented for GDPR and audit readiness.
Up to six years of historical payroll records, including terminated-employee and retiree information, to meet statutory and business-continuity needs.
Tell us your PeopleSoft footprint and target Fusion modules — Core HR, Absence, Payroll — and we’ll scope an automated, HDL-based migration on the Syntra ETL platform.