Data Migration & Conversion Specialist

The Opportunity

CACI is seeking a Data Migration and Conversion Specialist to lead and execute the migration of federal HR data from legacy systems into Oracle Fusion Cloud HCM as part of a large-scale federal HCM modernization program. This initiative will transition federal civilian employee records from legacy platforms — including People Soft HCM, Oracle EBS, and agency-custom HRIS solutions — into a unified Oracle Fusion Cloud HCM environment across multiple federal agencies.

You will design and execute data extraction, transformation, cleansing, and loading strategies using Oracle HCM Data Loader (HDL) and HCM Spreadsheet Data Loader (HSDL), ensuring data integrity at every step. Each agency migration wave — from Small to X-Large complexity — requires meticulous data quality analysis, transformation rule development, and parallel validation to guarantee zero-disruption transitions. This role is ideal for a data professional who thrives on solving complex data quality challenges at massive scale in a mission-critical federal environment.

This position is at the T4 (senior) level, suited for an experienced technical professional who operates with significant independence, resolves complex technical challenges using advanced techniques, and provides guidance and mentorship to less experienced team members.

• Design and execute end-to-end data migration strategies for extracting federal HR data from legacy systems including People Soft HCM, Oracle E-Business Suite, and agency-custom HRIS platforms into Oracle Fusion Cloud HCM
• Develop and maintain ETL/ELT pipelines, data transformation rules, and data mapping specifications that convert legacy HR data structures into Oracle Fusion Cloud HCM data model formats using HDL and HSDL templates
• Perform comprehensive data profiling and quality analysis on legacy source systems, identifying data anomalies, missing values, orphaned records, and non-conforming data that require cleansing prior to migration
• Build and execute data cleansing routines that remediate data quality issues, standardize code values, resolve duplicate records, and align legacy data with government EHRI data standards and eOPF document classification requirements
• Plan and execute iterative migration cycles (mock migrations, dress rehearsals, and production cutover) for each agency transition wave, adapting strategies for Small, Medium, Large, and X-Large agency complexity tiers as defined in agency transition
• Design and execute parallel payroll validation testing that compares migrated Oracle Fusion Cloud HCM payroll outputs against legacy system payroll runs, ensuring zero-dollar-variance for all employee pay calculations before agency go-live
• Create and maintain data migration runbooks, conversion specifications, data dictionaries, and reconciliation reports that document every transformation rule and validation checkpoint
• Develop automated data validation and reconciliation scripts that verify record counts, data integrity, referential integrity, and business rule compliance across all migration objects (employees, positions, jobs, benefits, compensation, assignments)
• Collaborate with federal HR policy advisors to validate that migrated data accurately reflects current employee status, service computation dates, benefits eligibility, and personnel action history
• Coordinate with integration engineers to ensure migrated data aligns with downstream interface requirements for EHRI, eOPF, payroll providers, and benefits carriers
• Support data governance activities including data ownership identification, data quality metrics reporting, and migration issue triage and resolution with agency data stewards
• Operate with significant independence to analyze and resolve complex functional and technical issues, applying advanced techniques and serving as a go-to technical resource and mentor for less experienced team members across the program
• Lead small work efforts and technical initiatives within the assigned functional area, contributing to team strategy, conducting technical reviews of deliverables, and guiding junior consultants on Oracle Fusion Cloud HCM best practices and…