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.
Data Migration & Conversion Specialist
Location
United States
Posted
6 days ago
Salary
$75.2K - $158K / year
No structured requirement data.
Job Description
The Opportunity:
CACI is seeking a Data Migration and Conversion Specialist to lead and execute the migration of federal HR data from legacy systems into Oracle Fusion Cloud HCM as part of a large-scale federal HCM modernization program. This landmark initiative will transition federal civilian employee records from legacy platforms — including PeopleSoft HCM, Oracle EBS, and agency-custom HRIS solutions — into a unified Oracle Fusion Cloud HCM environment across multiple federal agencies. You will design and execute data extraction, transformation, cleansing, and loading strategies using Oracle HCM Data Loader (HDL) and HCM Spreadsheet Data Loader (HSDL), ensuring data integrity at every step. Each agency migration wave — from Small to X-Large complexity — requires meticulous data quality analysis, transformation rule development, and parallel validation to guarantee zero-disruption transitions. This role is ideal for a data professional who thrives on solving complex data quality challenges at massive scale in a mission-critical federal environment. This position is at the T3 level, suited for a mid-career technical professional who applies solid working knowledge and established methods to independently perform a range of technical and functional tasks, resolving problems of moderate scope and complexity.
Responsibilities:
• Design and execute end-to-end data migration strategies for extracting federal HR data from legacy systems including PeopleSoft HCM, Oracle E-Business Suite, and agency-custom HRIS platforms into Oracle Fusion Cloud HCM
• Develop and maintain ETL/ELT pipelines, data transformation rules, and data mapping specifications that convert legacy HR data structures into Oracle Fusion Cloud HCM data model formats using HDL and HSDL templates
• Perform comprehensive data profiling and quality analysis on legacy source systems, identifying data anomalies, missing values, orphaned records, and non-conforming data that require cleansing prior to migration
• Build and execute data cleansing routines that remediate data quality issues, standardize code values, resolve duplicate records, and align legacy data with government EHRI data standards and eOPF document classification requirements
• Plan and execute iterative migration cycles (mock migrations, dress rehearsals, and production cutover) for each agency transition wave, adapting strategies for Small, Medium, Large, and X-Large agency complexity tiers as defined in agency transition
• Design and execute parallel payroll validation testing that compares migrated Oracle Fusion Cloud HCM payroll outputs against legacy system payroll runs, ensuring zero-dollar-variance for all employee pay calculations before agency go-live
• Create and maintain data migration runbooks, conversion specifications, data dictionaries, and reconciliation reports that document every transformation rule and validation checkpoint
• Develop automated data validation and reconciliation scripts that verify record counts, data integrity, referential integrity, and business rule compliance across all migration objects (employees, positions, jobs, benefits, compensation, assignments)
• Collaborate with federal HR policy advisors to validate that migrated data accurately reflects current employee status, service computation dates, benefits eligibility, and personnel action history
• Coordinate with integration engineers to ensure migrated data aligns with downstream interface requirements for EHRI, eOPF, payroll providers, and benefits carriers
• Support data governance activities including data ownership identification, data quality metrics reporting, and migration issue triage and resolution with agency data stewards
• Apply established methods, standards, and practices to independently resolve functional and technical issues of moderate scope, contributing to team knowledge bases and consulting with senior staff on complex or unfamiliar problems as they arise
• Communicate effectively with project team members and direct stakeholders to report progress, explain technical approaches, and support collaborative problem-solving within assigned workstreams and Agile Release Train ceremonies
Qualifications:
Required:
• Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field
• 4+ years of professional experience in data migration, data conversion, or ETL development for enterprise applications
• 3+ years of hands-on experience with data migration into Oracle Fusion Cloud HCM, Oracle ERP Cloud, or comparable enterprise cloud platforms using HDL, HSDL, or FBDI
• Strong proficiency in SQL for data analysis, transformation, validation, and reconciliation across relational database systems
• Experience with data profiling and data quality tools, with demonstrated ability to identify and remediate data anomalies in large datasets (100K+ records)
• Familiarity with ETL tools such as Oracle Data Integrator (ODI), Informatica, Talend, or Python-based data pipeline frameworks
• Understanding of HR data domains including employee master data, positions, jobs, compensation, benefits, and personnel action history
• Experience working within Agile or SAFe delivery teams, including iterative migration cycle planning and sprint-based delivery
• Must be able to obtain and maintain a Public Trust clearance (US Citizenship required)
• Additional experience may substitute for degree
Desired:
• 6+ years of data migration experience with at least one large-scale Oracle Fusion Cloud HCM implementation (5,000+ employees)
• Direct experience with Oracle HCM Data Loader (HDL) templates, HCM Spreadsheet Data Loader (HSDL), and Oracle BI Publisher for migration validation reporting
• Experience migrating data from federal HR systems including legacy PeopleSoft HCM, Oracle EBS HR, or agency-specific HRIS platforms
• Knowledge of federal HR data standards including EHRI data elements, eOPF document types, federal data reporting requirements, and Standard Form 50 data fields
• Experience with parallel payroll validation methodologies, including automated comparison and variance analysis
• Proficiency in Python or R for data analysis, transformation scripting, and automated data quality reporting
• Oracle Cloud Infrastructure Data Integration or Oracle Data Integrator certification
• Experience with Oracle Cloud technologies including Oracle Integration Cloud (OIC) and/or Oracle Cloud Infrastructure (OCI) in enterprise HCM or ERP environments
-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,100CACI 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.
Related Guides
Related Job Pages
More Software Engineer Jobs
The role involves designing and maintaining ETL pipelines for unstructured data processing for Retrieval-Augmented Generation (RAG) systems and supporting the development of agent-based architectures using reasoning and acting patterns like ReAct. Responsibilities also include building agent workflows using node-based orchestration frameworks and implementing various agent memory strategies.
Software Engineer I, .NET
HagertyHagerty is an automotive enthusiast brand and the world’s largest membership organization. Along with being a best-in-class provider of specialty insurance for enthusiasts, Hagerty is also home to the Hagerty Drivers Foundation, Garage + Social, Hagerty Drivers Club, Marketplace and so much more. Committed to saving driving for future generations, each and every thing Hagerty does is dedicated to the love of the automobile. Hagerty is a rapidly growing company that values a winning culture. We provide meaningful work for and invest in every single team member. At Hagerty, we share the road. We are an inclusive automotive community where all are welcomed, valued and belong regardless of race, gender, age, or car preference. We are united by our shared passion for driving, our commitment to preserve car culture for future generations and our desire to make a positive impact in the world. If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!
The engineer will develop, maintain, and support scalable, secure, and resilient software for the Payment Services team, focusing on expanding APIs for back-office needs like reconciliation and check processing. Responsibilities include writing clean code, developing comprehensive automated tests, reviewing telemetry, and actively participating in troubleshooting and on-call support rotations.
The role involves developing and validating SAS programs for the statistical analysis and reporting of clinical trial data, while collaborating with biostatisticians to define analysis plans and statistical methods. Responsibilities also include performing quality control checks on outputs and assisting in the preparation of reports for regulatory submissions.
Staff Software Engineer- Risk Platform
AledadeAledade, a public benefit corporation, exists to empower the most transformational part of our health care landscape - independent primary care. We were founded in 2014, and since then, we've become the largest network of independent primary care in the country - helping practices, health centers and clinics deliver better care to their patients and thrive in value-based care. Additionally, by creating value-based contracts across a wide variety of health plans, we aim to flip the script on the traditional fee-for-service model. Our work strengthens continuity of care, aligns incentives and ensures primary care physicians are paid for what they do best - keeping patients healthy. If you want to help create a health care system that is good for patients, good for practices and good for society - and if you're eager to join a collaborative, inclusive and remote-first culture - you've come to the right place.
The engineer will be responsible for building the next generation of distributed data storage and processing systems designed to scale indefinitely and surpass traditional query performance. Duties include identifying and developing scalable solutions, shaping product strategy, developing code architecture foundations, and mentoring other engineers.
