Remote Data Migration & Cloud HCM Specialist

CACI International Inc.; Reston (VA); On-site; USD 90,000 - 190,000; Full time

Job summary

CACI International Inc. seeks a Data Migration & Conversion Specialist to lead end-to-end migration of federal HR data into Oracle Fusion Cloud HCM. You will architect ETL/ELT pipelines using HDL and HSDL, perform data profiling and cleansing, and ensure compliance across agencies.

The role is primarily remote with occasional on-site reporting in Reston as needed, offering visibility into large-scale modernization efforts and opportunities to influence federal HR systems.

Qualifications

• Ability to obtain/maintain a Public Trust clearance (U.S. Citizenship required).
• Bachelor’s degree and 7 years of relevant experience (or equivalent).
• 7+ years of experience in data migration, data conversion, or ETL development.
• 5+ years of hands-on experience with Oracle Fusion Cloud HCM, Oracle ERP Cloud, or similar platforms using HDL, HSDL, or FBDI.
• Strong SQL skills for data analysis, validation, and reconciliation.
• Experience with large-scale data profiling and cleansing (100K+ records).
• Familiarity with ETL tools such as ODI, Informatica, Talend, or Python-based pipelines.
• Understanding of key HR data domains (employee master data, jobs, positions, compensation, benefits, personnel action history).
• Experience working in Agile or SAFe environments.

Responsibilities

• Lead end-to-end data migration from legacy federal HR systems into Oracle Fusion Cloud HCM.
• Build and maintain ETL/ELT pipelines, data mapping, and transformation logic using HDL and HSDL.
• Conduct comprehensive data profiling, anomaly detection, and data quality analysis.
• Execute data cleansing routines to standardize values, remove duplicates, and align with EHRI and eOPF standards.
• Plan and perform iterative migration cycles across multiple agency complexity tiers.
• Perform parallel payroll validation testing to ensure zero-doll ar variance between legacy and Oracle Cloud payroll runs.
• Create/document migration runbooks, data dictionaries, conversion specifications, and reconciliation reports.
• Develop automated validation scripts to ensure record consistency, referential integrity, and compliance.
• Collaborate with federal HR policy experts to validate employee status, benefits eligibility, and personnel action accuracy.
• Partner with integration teams to ensure compatibility with EHRI, eOPF, payroll providers, and benefits carriers.
• Support data governance, issue triage, and data quality metric reporting.
• Serve as a technical expert and mentor; lead small workstreams and review technical deliverables.

Skills

SQL

HDL

HSDL

FBDI

ETL

Oracle Fusion Cloud HCM

Oracle ERP Cloud

Data migration

Data conversion

Agile

SAFe

Python

Data profiling

Education

Bachelor's degree

Tools

ODI

Informatica

Talend

Python

Job description

CACI International Inc. seeks a Data Migration & Conversion Specialist to lead end-to-end migration of federal HR data into Oracle Fusion Cloud HCM. You will architect ETL/ELT pipelines using HDL and HSDL, perform data profiling and cleansing, and ensure compliance across agencies.

The role is primarily remote with occasional on-site reporting in Reston as needed, offering visibility into large-scale modernization efforts and opportunities to influence federal HR systems.