CACI is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, age, national origin, disability, status as a protected veteran, or any other protected characteristic.
Legacy System Export Developer
Location
United States
Posted
5 days ago
Salary
Not specified
Job Description
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.
Job Requirements
- 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.
- 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.
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
Lead Manager of Data Engineering
JobgetherWe use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team. We appreciate your interest and wish you the best! Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time. #LI-CL1 We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.
This role involves leading a dynamic data engineering team dedicated to developing innovative solutions grounded in AI technologies. Lead the data engineering team and manage all associated activities. Drive the development of data architecture leveraging AI innovations. Implemen...
Senior Data Engineer
OpalaConnecting data flow across healthcare so that every patient's experience is optimized.
The Senior Data Engineer will be responsible for designing, developing, deploying, and maintaining the data-hub and its integrations, focusing on building and optimizing scalable end-to-end data pipelines for ingestion, transformation, and delivery. Key tasks include designing data models, operationalizing data-driven solutions, implementing data quality best practices, and integrating diverse data sources, including clinical and real-time streams.
Senior Data Engineering Manager
JobgetherWe use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team. We appreciate your interest and wish you the best! Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time. #LI-CL1 We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.
This role involves leading a dynamic data engineering team dedicated to developing innovative solutions grounded in AI technologies. Your leadership will be instrumental in shaping IT architecture that aligns with business needs while enhancing analytics capabilities. Lead the da...
EDI/Data Senior Specialist
JobgetherWe use an AI-powered matching process to ensure your application is reviewed quickly, objectively, and fairly against the role's core requirements. Our system identifies the top-fitting candidates, and this shortlist is then shared directly with the hiring company. The final decision and next steps (interviews, assessments) are managed by their internal team. We appreciate your interest and wish you the best! Data Privacy Notice: By submitting your application, you acknowledge that Jobgether will process your personal data to evaluate your candidacy and share relevant information with the hiring employer. This processing is based on legitimate interest and pre-contractual measures under applicable data protection laws (including GDPR). You may exercise your rights (access, rectification, erasure, objection) at any time. #LI-CL1 We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.
This role involves contributing to the implementation of software tools essential for health care reform compliance and automated benefits enrollment. Audit and upload data for customer website implementations. Create and configure EDI files for customer websites following best p...
