Data Migration Architect for Federal HCM Modernization

CACI; United States; Presencial; USD 120.000 - 160.000; Jornada completa

Descripción de la vacante

CACI is seeking a Principal Consultant specializing in Data Migration & Conversion to support a major federal HCM modernization initiative. In this role, you will lead the migration of HR data from legacy systems into Oracle Fusion Cloud HCM across multiple federal agencies.

You will architect and deliver high‑quality extraction, transformation, cleansing, and loading strategies using HDL and HSDL while ensuring data accuracy, federal compliance, and zero‑disruption cutovers.

Formación

• Bachelor's degree and 7+ years in data migration or ETL.
• 7+ years experience with Oracle Fusion Cloud HCM or similar.
• Strong SQL for data analysis and reconciliation.
• Experience with HDL/HSDL templates or BI Publisher.
• Knowledge of federal HR data standards.

Responsabilidades

• Lead end-to-end data migration from legacy HR systems to Oracle Fusion Cloud HCM.
• Build ETL/ELT pipelines and data mappings using HDL and HSDL.
• Perform data profiling, anomaly detection, and quality analysis.
• Plan iterative migration cycles and validate payroll alignment.
• Create runbooks, data dictionaries, and reconciliation reports.
• Develop automated validation scripts for data integrity.
• Mentor junior staff and lead small workstreams.

Conocimientos

SQL

Data migration

ETL development

HDL

HSDL

Agile/SAFe

Educación

Bachelor's degree

Herramientas

HDL

HSDL

FBDI

Oracle Fusion Cloud HCM

ODI

Informatica

Descripción del empleo

CACI is seeking a Principal Consultant specializing in Data Migration & Conversion to support a major federal HCM modernization initiative. In this role, you will lead the migration of HR data from legacy systems into Oracle Fusion Cloud HCM across multiple federal agencies.

You will architect and deliver high‑quality extraction, transformation, cleansing, and loading strategies using HDL and HSDL while ensuring data accuracy, federal compliance, and zero‑disruption cutovers.