Data Migration & Conversion Specialist

CACI; United States; On-site; USD 120,000 - 160,000; Full time

Job summary

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.

Qualifications

• 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.

Responsibilities

• 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.

Skills

SQL

Data migration

ETL development

HDL

HSDL

Agile/SAFe

Education

Bachelor's degree

Tools

HDL

HSDL

FBDI

Oracle Fusion Cloud HCM

ODI

Informatica

Job description

Job Title: Data Migration & Conversion Specialist

Job Category: Information Technology

Time Type: Full time

Minimum Clearance Required to Start: None

Employee Type: Regular

Percentage of Travel Required: Up to 10%

Type of Travel: Continental US

* * *

The Opportunity:

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-including PeopleSoft HCM, Oracle EBS, and agency‑specific HRIS platforms-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. This role provides significant independence, the chance to solve complex data quality challenges at scale, and the opportunity to directly influence the modernization of federal HR systems.

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 (mock migrations, dress rehearsals, production cutover) across multiple agency complexity tiers
• Perform parallel payroll validation testing to ensure zero‑dollar 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

Qualifications:

Required:

• Ability to obtain/maintain a Public Trust clearance (U.S. Citizenship required)
• Bachelor's degree and 7 years of relevant experience (or equivalent experience)
• 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

Desired:

• 8+ years of data migration experience, including one large Oracle Fusion Cloud HCM implementation (5,000+ employees)
• Direct experience with HDL templates, HSDL spreadsheets, and BI Publisher validation reporting
• Experience migrating federal HR data from PeopleSoft, Oracle EBS, or custom HRIS platforms
• Knowledge of federal HR data standards (EHRI elements, eOPF document types, SF‑50 fields, federal reporting requirements)
• Experience with parallel payroll validation and automated variance analysis
• Proficiency with Python or R for scripting and data quality reporting
• OCI Data Integration or Oracle Data Integrator certification
• Experience with Oracle Integration Cloud (OIC) or Oracle Cloud Infrastructure (OCI)

This position is contingent on funding and may not be filled immediately. However, this position is representative of positions within CACI that are consistently available. Individuals who apply may also be considered for other positions at CACI.

What You Can Expect:

• A culture of integrity.
• At CACI, we place character and innovation at the center of everything we do. As a valued team member, you'll be part of a high-performing group dedicated to our customer's missions and driven by a higher purpose - to ensure the safety of our nation.
• An environment of trust.
• CACI values the unique contributions that every employee brings to our company and our customers - every day. You'll have the autonomy to take the time you need through a unique flexible time off benefit and have access to robust learning resources to make your ambitions a reality.
• A focus on continuous growth.
• Together, we will advance our nation's most critical missions, build on our lengthy track record of business success, and find opportunities to break new ground - in your career and in our legacy.

Pay Range : There are a host of factors that can influence final sal