Legacy Modernization Software Developer Ashburn, VA,

Position: Legacy Modernization Software Developer Ashburn, VA, US
Remote## Legacy Modernization Software Developer
405 ASHBURN VA (ASHBURN CACI/CLIENT REIMB SITE)

Job Title:

Legacy Modernization Software Developer Job Category:
Information Technology Time Type:
Full time Minimum Clearance Required to Start:
None Employee Type:
Regular Percentage of

Travel Required:

Up to 25%
Type of Travel:
Continental US     
*
* The Opportunity:

** CACI is seeking a Legacy System Export Developer with expertise in People Soft HRMS and Oracle E-Business Suite (EBS) HCM to support a large-scale federal HCM modernization program. This enterprise-scale initiative will migrate federal civilian employee records from legacy HR systems to Oracle Fusion Cloud HCM across multiple federal agencies. In this role, you will be responsible for extracting, validating, and transforming HR data from agency legacy People Soft HRMS and Oracle EBS HCM systems, mapping legacy data schemas to Oracle Fusion HCM Data Loader (HDL) formats, and ensuring extracted data meets EHRI standards and data quality thresholds required for successful migration.

You will work directly with agency legacy system databases, developing SQL/PL-SQL extraction programs, SQR reports, People Soft Application Engine processes, and EBS concurrent programs that reliably extract complete employee records for conversion. This is a primarily remote position with up to 10% travel supporting agency-by-agency data migrations throughout the contract period. 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:*
* • Develop SQL and PL/SQL extraction programs to export employee data from People Soft HRMS and Oracle EBS HCM databases including personal data, job history, compensation, benefits, position management, and organizational structures
• Analyze agency-specific legacy system configurations, custom fields, and data structures to create comprehensive data mapping documents from legacy schemas to Oracle Fusion HCM HDL file formats
• Build People Soft Application Designer and Application Engine processes for automated, repeatable data extraction routines that support iterative mock migration cycles and final cutover extracts
• Develop EBS concurrent programs and data extraction packages for agencies running Oracle E-Business Suite HRMS, ensuring complete extraction of HR, payroll, and benefits data
• Create SQR reports and data validation queries to verify extraction completeness, data integrity, and compliance with EHRI data standards before handoff to the middleware/ETL team
• Design and execute data profiling analyses on legacy databases to identify data quality issues, orphaned records, incomplete fields, and agency-specific customizations requiring special handling
• Maintain legacy database environments (People Soft and EBS) used for extraction development and testing, including schema refreshes, access management, and performance tuning for large-volume exports
• Collaborate with agency legacy system administrators to understand custom configurations, interfaces, and data dependencies that affect extraction scope and sequencing
• Develop data reconciliation procedures that compare legacy system record counts and key data elements against extraction outputs to ensure zero data loss during migration
• Document extraction procedures, data mapping specifications, and known data quality issues for each agency migration in accordance with SAFe Agile artifact standards
• Support cutover activities during agency go-live events, executing final extraction runs, validating outputs, and resolving extraction-related issues within tight cutover windows
• Apply established methods, standards, and practices to independently resolve    
*
* Qualifications:

*
*
* Required:

* • Bachelor's degree in Computer Science, Information Technology, Database Administration, or related field
• 5+ years of experience in database development, data extraction, or database administration for enterprise HR systems
• 3+ years of hands-on experience…