Legacy System Export Developer (PeopleSoft/EBS)
CACI International2 days ago
Base Salary
$90k - $190k/yr
Responsibilities
- Develop SQL and PL/SQL extraction programs for employee demographics, job history, positions, compensation, and benefits from PeopleSoft HRMS and Oracle EBS HCM.
- Analyze agency configurations and customizations and create data mapping documents aligned with Oracle Fusion HCM HDL formats.
- Build PeopleSoft Application Designer and Application Engine routines for repeatable mock-migration and production-cutover extracts.
- Design Oracle EBS HCM concurrent programs and extraction packages for HR, payroll, and benefits data.
- Create SQR reports and validation queries and perform data profiling, quality assessment, and reconciliation to ensure complete and accurate exports.
- Maintain legacy PeopleSoft and EBS extraction environments, including schema refreshes, access, and performance tuning.
- Collaborate with agency administrators on customizations, integrations, data dependencies, extraction sequencing, and known data issues.
- Support final cutover extracts, output validation, troubleshooting, documentation, stakeholder communication, and coordinated Agile delivery.
Requirements
- Bachelor’s degree and 5 years of related experience; additional experience may substitute for the degree.
- 7+ years of experience in database development, data extraction, or database administration supporting enterprise HR systems.
- 5+ years of hands-on experience with PeopleSoft HRMS and/or Oracle EBS HCM, including the listed development and extraction tools.
- Strong SQL and PL/SQL skills, including complex queries against large HR datasets of 100,000 or more records.
- Experience with data mapping for system migrations and with data validation, profiling, and quality assessment.
- Knowledge of HR data domains including demographics, job history, positions, compensation, and benefits.
- Familiarity with Agile/SAFe and iterative migration processes.
- Ability to obtain and maintain a Public Trust clearance and U.S. citizenship.
- Preferred qualifications include 9+ years of federal legacy HR data extraction and migration experience, PeopleTools 8.5x, Component Interface, Integration Broker, Oracle DBA/OCP certification, EHRI standards, Oracle Fusion HDL/HSDL, federal personnel data, large-scale migrations, Oracle Integration Cloud, and Oracle Cloud Infrastructure.
Benefits
- Primarily remote work, with possible onsite reporting in Reston based on business needs.
- Up to 10% travel within the continental United States.
- Regular full-time employment with flexible time off, healthcare, wellness, financial and retirement benefits, family support, continuing education, and learning and development resources.
Tech Stack
Categories
Data Engineering
About CACI International
CACI International is a public government contractor that delivers enterprise IT, cybersecurity, electronic warfare, space, and intelligence solutions to U.S. defense, intelligence, and federal civilian customers. It provides systems engineering, software and data services, and mission support across C4ISR and business systems, primarily through long-term government contracts. Founded in 1962 and headquartered in Reston, Virginia, CACI trades on the NYSE under the ticker CACI.