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.
This position is primarily remote; however, candidates may be required to report onsite in Reston as business needs arise.
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)
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 salary including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications. Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives. We offer competitive compensation, benefits and learning and development opportunities. Our broad and competitive mix of benefits options is designed to support and protect employees and their families. At CACI, you will receive comprehensive benefits such as; healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits.
Since this position can be worked in more than one location, the range shown is the national average for the position.
The proposed salary range for this position is:
$90,300-$189,600CACI is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, age, national origin, disability, status as a protected veteran, or any other protected characteristic.
Similar Jobs
What you need to know about the San Francisco Tech Scene
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
