The Opportunity:
CACI is seeking an experienced Senior Consultant with deep PeopleSoft HRMS and Oracle E‑Business Suite (EBS) HCM expertise to support a large federal HCM modernization initiative. You will play a key role in migrating federal civilian employee records from legacy HR platforms into Oracle Fusion Cloud HCM—supporting multiple agencies and delivering enterprise‑grade data conversion solutions.
This is an opportunity to influence a high‑visibility modernization program, solve complex data challenges, and directly contribute to transforming federal HR operations.
This role is primarily remote with up to 10% travel for agency migration activities.
Responsibilities:
Develop SQL and PL/SQL extraction programs to export employee data from PeopleSoft HRMS and Oracle EBS HCM, including demographics, job history, positions, compensation, and benefits.
Analyze agency‑specific configurations and customizations to produce detailed data mapping documents aligned to Oracle Fusion HCM HDL formats.
Build PeopleSoft Application Designer and Application Engine routines to support repeatable extract processes for mock migrations and production cutover.
Design and implement Oracle EBS HCM concurrent programs and extraction packages ensuring complete HR, payroll, and benefits data export.
Create SQR reports and validation queries to ensure extraction accuracy, completeness, and EHRI compliance.
Conduct data profiling to evaluate data quality, identify gaps, and determine custom handling requirements.
Maintain PeopleSoft and EBS legacy environments used for extraction development (schema refreshes, access, performance tuning).
Collaborate with agency system administrators to understand customizations, integrations, and data dependencies impacting extraction sequencing.
Execute reconciliation processes comparing legacy system data with extraction outputs to ensure zero data loss.
Document extraction processes, agency‑specific mappings, and known data issues following SAFe Agile artifact standards.
Support agency cutover events by running final extracts, validating outputs, and troubleshooting issues under tight deadlines.
Apply established best practices to resolve technical challenges and contribute knowledge to team repositories.
Communicate clearly with project stakeholders, participate in Agile ceremonies, and support coordinated delivery across workstreams.
Qualifications:
Required:
Must be able to obtain and maintain a Public Trust clearance (U.S. Citizenship required).
Bachelor’s degree and 5 years of related experience (additional experience may substitute for degree).
5+ years of experience in database development, data extraction, or database administration supporting enterprise HR systems.
3+ years hands‑on experience with PeopleSoft HRMS (Application Designer, Application Engine, PeopleCode, SQR) and/or Oracle EBS HCM (concurrent programs, PL/SQL packages, HR tables).
Strong SQL/PL‑SQL skills with experience writing complex queries against large HR datasets (100K+ records).
Experience with data mapping for system migrations.
Solid knowledge of HR data domains (employee demographics, job history, positions, compensation, benefits).
Experience in data validation, profiling, and data quality assessment.
Familiarity with Agile/SAFe and iterative migration processes.
Desired:
7+ years of legacy HR data extraction and migration experience within federal government modernization programs.
Expertise with PeopleTools 8.5x, Component Interface, Integration Broker.
Oracle DBA (OCP) certification.
Experience with EHRI data standards and federal personnel data reporting.
Hands‑on experience with Oracle Fusion HDL and HSDL formats.
Knowledge of federal HR data elements (NOA codes, SF‑50 data, position classification).
Experience supporting large‑scale migrations (500K+ records) across multiple legacy systems.
Familiarity with Oracle Integration Cloud (OIC) and 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:
$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.
Skills Required
- Must be able to obtain and maintain a Public Trust clearance
- U.S. Citizenship
- Bachelor's degree and 5 years of related experience; additional experience may substitute for degree
- 5+ years of experience in database development, data extraction, or database administration supporting enterprise HR systems
- 3+ years of hands-on experience with PeopleSoft HRMS and/or Oracle EBS HCM
- Strong SQL and PL/SQL skills with complex queries against large HR datasets
- Experience with data mapping for system migrations
- Knowledge of HR data domains including demographics, job history, positions, compensation, and benefits
- Experience in data validation, profiling, and data quality assessment
- Familiarity with Agile and SAFe iterative migration processes
- 7+ years of legacy HR data extraction and migration experience in federal government modernization programs
- Expertise with PeopleTools 8.5x, Component Interface, and Integration Broker
- Oracle DBA OCP certification
- Experience with EHRI data standards and federal personnel data reporting
- Hands-on experience with Oracle Fusion HDL and HSDL formats
- Knowledge of federal HR data elements, including NOA codes, SF-50 data, and position classification
- Experience supporting large-scale migrations involving 500K+ records across multiple legacy systems
- Familiarity with Oracle Integration Cloud and 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
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.
