Data Migration & Conversion Specialist

Posted Yesterday
Be an Early Applicant
Hiring Remotely in Reston, VA, USA
In-Office or Remote
75K-158K Annually
Senior level
Information Technology • Consulting • Defense
The Role
Leads end-to-end migration of federal HR data from legacy systems into Oracle Fusion Cloud HCM. Develops ETL pipelines, transformation rules, cleansing routines, validation scripts, reconciliation reports, and migration runbooks. Performs profiling, anomaly detection, mock conversions, payroll validation, and production cutovers. Partners with HR policy, integration, and data governance teams to ensure accurate, compliant data supporting payroll, benefits, and downstream interfaces. Works independently within Agile and SAFe delivery environments.
Summary Generated by Built In
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

* * *

CACI is seeking a Senior Consultant specializing in data migration and conversion to support a large-scale federal HR modernization effort. This role leads the transformation and migration of HR data from legacy federal systems—including PeopleSoft HCM, Oracle EBS, and agency‑specific HRIS platforms—into Oracle Fusion Cloud HCM. The position focuses on delivering high‑quality, repeatable data migration processes that ensure data accuracy, integrity, and continuity for multiple federal agencies of varying complexity.

The ideal candidate thrives in mission‑critical environments, excels at solving complex data quality challenges, and brings hands‑on experience migrating large datasets into Oracle Fusion Cloud HCM using HDL and HSDL.

This position is primarily remote; however, candidates may be required to report onsite in Reston as business needs arise.

Responsibilities:

  • Design and execute end‑to‑end data migration strategies from legacy federal HR systems into Oracle Fusion Cloud HCM.

  • Develop ETL/ELT pipelines, mapping documentation, and transformation rules using HDL and HSDL templates.

  • Perform detailed data profiling, anomaly detection, and cleansing of large‑volume HR datasets.

  • Build and implement data cleansing routines to standardize values, remove duplicates, and align with EHRI and eOPF requirements.

  • Lead iterative migration cycles including mock conversions, dress rehearsals, and production cutover for agencies ranging from small to extra‑large complexity.

  • Conduct parallel payroll validation ensuring zero‑variance between legacy and Oracle payroll outputs.

  • Create and maintain runbooks, data dictionaries, reconciliation reports, and conversion specifications.

  • Develop automated validation and reconciliation scripts to ensure record accuracy, referential integrity, and compliance with business rules.

  • Partner with federal HR policy teams to confirm accurate representation of employee status, SCDs, eligibility markers, and personnel action history.

  • Coordinate with integration teams to ensure migrated data supports downstream HR interfaces (EHRI, eOPF, payroll providers, benefits carriers).

  • Support data governance activities, issue resolution, and quality metric reporting.

  • Apply established methods to independently resolve moderate technical and functional issues.

  • Communicate effectively within Agile and SAFe project structures, providing progress updates and supporting collaborative problem‑solving.

Qualifications — Required:

  • Ability to obtain and maintain a Public Trust clearance (U.S. Citizenship required).

  • Bachelor’s degree and 5 years of relevant experience (additional experience may substitute for degree).

  • 5+ years of data migration, data conversion, or ETL development experience.

  • 3+ years of hands‑on migration experience into Oracle Fusion Cloud HCM, Oracle ERP Cloud, or similar enterprise cloud platforms using HDL, HSDL, or FBDI.

  • Proficiency in SQL for transformation, validation, and reconciliation.

  • Proven experience profiling and cleansing large datasets (100K+ records).

  • Experience with ETL technologies such as ODI, Informatica, Talend, or Python-based pipelines.

  • Strong understanding of HR data domains (employee, positions, jobs, compensation, benefits, personnel actions).

  • Experience working within Agile or SAFe delivery teams.

Desired:

  • 6+ years of data migration experience, including large-scale Oracle Fusion Cloud HCM implementations (5,000+ employees).

  • Hands‑on experience with HDL/HSDL templates and BI Publisher for reporting.

  • Experience migrating from federal HR systems (PeopleSoft, Oracle EBS HR, custom HRIS).

  • Knowledge of federal HR data standards (EHRI, eOPF, SF‑50, federal reporting requirements).

  • Experience with parallel payroll validation methodologies.

  • Proficiency in Python or R for scripting and automated data quality processes.

  • Oracle 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 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:

$75,200-$158,100

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

Skills Required

  • Ability to obtain and maintain a Public Trust clearance
  • U.S. Citizenship
  • Bachelor's degree and 5 years of relevant experience, or equivalent additional experience
  • 5+ years of data migration, data conversion, or ETL development experience
  • 3+ years of hands-on migration experience into Oracle Fusion Cloud HCM, Oracle ERP Cloud, or similar enterprise cloud platforms using HDL, HSDL, or FBDI
  • Proficiency in SQL for transformation, validation, and reconciliation
  • Experience profiling and cleansing large datasets of 100,000 or more records
  • Experience with ETL technologies such as ODI, Informatica, Talend, or Python-based pipelines
  • Strong understanding of HR data domains, including employees, positions, jobs, compensation, benefits, and personnel actions
  • Experience working within Agile or SAFe delivery teams
  • 6+ years of data migration experience, including large-scale Oracle Fusion Cloud HCM implementations
  • Hands-on experience with HDL or HSDL templates and BI Publisher
  • Experience migrating from federal HR systems such as PeopleSoft, Oracle EBS HR, or custom HRIS platforms
  • Knowledge of federal HR data standards including EHRI, eOPF, SF-50, and federal reporting requirements
  • Experience with parallel payroll validation methodologies
  • Proficiency in Python or R for scripting and automated data quality processes
  • Oracle OCI Data Integration or Oracle Data Integrator certification
  • Experience with Oracle Integration Cloud or Oracle Cloud Infrastructure

CACI International Inc Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about CACI International Inc and has not been reviewed or approved by CACI International Inc.

  • Healthcare Strength Pay is supported by a broad set of health-plan options across multiple national carriers, with telemedicine and tax-advantaged accounts included. Dental and vision choices are also described as multi-option, which strengthens overall coverage breadth.
  • Leave & Time Off Breadth Flexible Time Off is available for many salaried-exempt roles, while hourly roles accrue PTO, creating multiple time-off pathways by employment class. Paid disability coverage, fixed holidays, and paid leave programs (including parental leave and other leave types) further round out time-off and leave coverage.
  • Retirement Support Retirement support includes a 401(k) match structure described as 50% up to 8% of pay (effective 4%) and an Employee Stock Purchase Plan with a discount. Tuition reimbursement and certification support also add to the overall rewards package that complements core retirement benefits.

CACI International Inc Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Reston, VA
17,673 Employees
Year Founded: 1962

What We Do

CACI’s approximately 23,000 talented employees are vigilant in providing the unique expertise and distinctive technology that address our customers’ greatest enterprise and mission challenges. Our culture of good character, innovation, and excellence drives our success and earns us recognition as a Fortune World's Most Admired Company. As a member of the Fortune 1000 Largest Companies, the Russell 1000 Index, and the S&P MidCap 400 Index, we consistently deliver strong shareholder value. Visit us at www.caci.com.

Similar Jobs

CACI International Inc Logo CACI International Inc

Data Migration & Conversion Specialist

Information Technology • Consulting • Defense
In-Office or Remote
Reston, VA, USA
17673 Employees
90K-190K Annually

GoodRx Logo GoodRx

GTM Manager, Media Strategy & Execution

Consumer Web • Coupons • Healthtech • Social Impact • Pharmaceutical
Remote or Hybrid
USA
800 Employees
102K-216K Annually

Empathy Logo Empathy

Social Media Manager

Fintech • Healthtech • HR Tech • Information Technology • Financial Services • Telehealth
Remote or Hybrid
USA
200 Employees

Pie Insurance Logo Pie Insurance

Medical Only Claims Adjuster

Fintech • Insurance • Machine Learning • Analytics • Financial Services • Automation
Easy Apply
Remote
United States
350 Employees
60K-75K Annually

Similar Companies Hiring

NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity
Sydney, AU
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Outpost Space Thumbnail
Aerospace • Defense
US
24 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account