Legacy System Export Developer, PeopleSoft/EBS

CACI International Inc

. Develop SQL and PL/SQL extraction programs to export employee data from PeopleSoft HRMS and Oracle EBS HCM .

Posted 11/9/2026full-timeReston • United StatesMid-LevelSenior💰 $90,300 - $189,600 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in SQL and PL/SQL for data extraction and validation within HR systems, with a strong focus on PeopleSoft HRMS and Oracle EBS HCM. Proficient in data mapping, profiling, and ensuring compliance with federal HR data standards.

Highest-signal resume keywords

SQL/PL-SQL DevelopmentPeopleSoft HRMS ExperienceOracle EBS HCM ExpertiseData Mapping for System MigrationsOracle DBA (OCP) Certification

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLPL/SQLPeopleSoft Application DesignerPeopleSoft Application EngineSQRData ValidationData ProfilingData Quality AssessmentOracle Fusion HDLEHRI Data Standards

Soft Skills

CollaborationCommunicationProblem-SolvingAgile Methodologies

Tools & Technologies

Oracle EBS HCMPeopleTools 8.5xOracle Integration Cloud (OIC)Oracle Cloud Infrastructure (OCI)

Certifications & Qualifications

Oracle DBA (OCP)

Industry Keywords

Federal HR Data ElementsLegacy HR Data ExtractionData MigrationHR Data DomainsPublic Trust Clearance

Tech Stack

Tools & technologies

CloudOracleSQL

About the role

Key responsibilities & impact

Develop SQL and PL/SQL extraction programs to export employee data from PeopleSoft HRMS and Oracle EBS HCM
Analyze agency-specific configurations and customizations to produce data mapping documents aligned to Oracle Fusion HCM HDL formats
Build PeopleSoft Application Designer and Application Engine routines for repeatable extract processes supporting mock migrations and production cutover
Design and implement Oracle EBS HCM concurrent programs and extraction packages for 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, including schema refreshes, access, and 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 with project stakeholders, participate in Agile ceremonies, and support coordinated delivery across workstreams

Requirements

What you’ll need

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: 9+ 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)
Up to 10% travel required

Benefits

Comp & perks

Flexible time off benefit
Robust learning resources
Healthcare benefits
Wellness benefits
Financial benefits
Retirement benefits
Family support benefits
Continuing education benefits
Time off benefits
Competitive compensation
Learning and development opportunities