This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description CACI is seeking a Legacy System Export Developer with expertise in PeopleSoft 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 PeopleSoft HRMS and Oracle EBS HCM systems. - Mapping legacy data schemas to Oracle Fusion HCM Data Loader (HDL) formats. - Ensuring extracted data meets EHRI standards and data quality thresholds required for successful migration. - Working directly with agency legacy system databases, developing SQL/PL-SQL extraction programs, SQR reports, PeopleSoft Application Engine processes, and EBS concurrent programs. 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. Qualifications - 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 with PeopleSoft HRMS (Application Designer, Application Engine, PeopleCode, SQR) and/or Oracle E-Business Suite HCM (concurrent programs, PL/SQL packages, HR module tables). - Strong SQL and PL/SQL development skills with experience writing complex extraction queries against large (100,000+ record) HR databases. - Experience with data mapping between legacy HR system schemas and target system data formats for system migration projects. - Knowledge of HR data domains including employee demographics, job history, position management, compensation, and benefits data structures. - Experience with data validation, data profiling, and data quality assessment methodologies. - Familiarity with Agile/SAFe development methodologies and iterative migration approaches with mock conversion cycles. - Must be able to obtain and maintain a Public Trust clearance (US Citizenship required). - Additional experience may substitute for degree. Requirements - Develop SQL and PL/SQL extraction programs to export employee data from PeopleSoft 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 PeopleSoft 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 (PeopleSoft 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 issues. Benefits - Healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits. - Competitive compensation and learning and development opportunities. - Flexible time off benefit. Company Description CACI values the unique contributions that every employee brings to our company and our customers - every day. 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. At CACI, we place character and innovation at the center of everything we do.