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, HR, payroll, compensation, positions, and benefits data from PeopleSoft HRMS and Oracle EBS HCM.
- Analyze agency configurations and create data-mapping documentation 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.
- Create SQR reports, validation queries, data profiles, and reconciliation processes to verify extraction accuracy, completeness, and zero data loss.
- Maintain PeopleSoft and Oracle EBS legacy extraction environments, including schema refreshes, access, and performance tuning.
- Collaborate with agency administrators on customizations, integrations, dependencies, and extraction sequencing.
- Support final extracts, cutover events, troubleshooting, technical documentation, Agile delivery activities, and knowledge sharing.
Requirements
- U.S. citizenship and the ability to obtain and maintain a Public Trust clearance are required.
- Bachelor’s degree and 5 years of related experience are required, with additional experience permitted in place of the degree.
- At least 7 years of experience in database development, data extraction, or database administration supporting enterprise HR systems is required.
- At least 5 years of hands-on experience with PeopleSoft HRMS and/or Oracle EBS HCM is required, including the listed development tools and modules.
- Strong SQL and PL/SQL skills with experience querying large HR datasets of 100,000 or more records are required.
- Experience with system-migration data mapping, data validation, profiling, quality assessment, and HR data domains is required.
- Familiarity with Agile, SAFe, and iterative migration processes is required.
- Preferred qualifications include 9 or more 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 HR data elements, large-scale migrations, OIC, and OCI.
Benefits
- Primarily remote work, with possible onsite reporting in Reston as business needs arise.
- Full-time regular employment with up to 10% continental U.S. travel.
- Flexible time off, healthcare, wellness, financial and retirement benefits, family support, continuing education, learning and development resources, and other time-off benefits.
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.