> Markdown version of [/jobs/ext/3419449-senior-hcm-data-migration-middleware-developer](https://www.wearedevelopers.com/jobs/ext/3419449-senior-hcm-data-migration-middleware-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior HCM Data Migration Middleware Developer - **Company:** Caci Inc - **Location:** Reston, VA, United States (Remote available) - **Experience:** Expert - **Salary:** $90,300.0 - $189,600.0 - **Contract:** Permanent contract - **Skills:** Agile Methodology, Batch Processing, Spreadsheets, Cloud Computing, Data Validation, Data Cleansing, Data Governance, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Transformation, Data Migration, Data Profiling, Data Structures, Data Visualization, Software Design Patterns, Middleware, Hardware Description Language, JSON, Performance Tuning, Reference Data, Power BI, Standard Sql, Oracle Fusion Middleware, Talend, Extensible Markup Language (XML), Enterprise Data Management, Data Processing, Enterprise Software Applications, Informatica Powercenter, Sap Business Objects, HR Software, Data Loader, Oracle Service Cloud, People Soft, Restful APIs, Oracle Integration, Oracle Cloud Infrastructure - **Published:** September 7, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=02300064a542f023 ## About the Role * Bachelor's degree and 7 years of relevant experience. Additional experience may be substituted for degree. * 7+ years of experience in ETL development, middleware development, or data integration for enterprise system implementations. * 5+ years of hands-on experience with ETL/middleware tools such as Oracle Integration Cloud (OIC), Informatica PowerCenter/Cloud, Talend, or equivalent data integration platforms. * Strong SQL proficiency with experience writing complex transformation queries, data validation scripts, and reconciliation procedures. * Experience with batch data processing for large-volume datasets (100,000+ records) including performance optimization, error handling, and restart/recovery design patterns. * Knowledge of data quality management principles including data profiling, cleansing, standardization, and validation. * Experience with file-based data integration formats (CSV, XML, JSON) and enterprise data loader specifications. * Familiarity with Agile/SAFe development methodologies and iterative delivery practices. * Must be able to obtain and maintain a Public Trust clearance (US Citizenship required). Desired: * 8+ years of ETL/middleware development experience with specific experience on HCM or ERP data migration projects. * Oracle Integration Cloud (OIC) certification or demonstrated proficiency with OIC adapters, orchestrations, and monitoring. * Direct experience with Oracle Fusion HCM Data Loader (HDL) file specifications and HCM Spreadsheet Data Loader (HSDL) templates. * Informatica PowerCenter/Cloud certification or Talend Open Studio/Cloud certification. * Experience with federal government HR data migrations including EHRI data standards and federal personnel data formats. * Knowledge of Oracle Fusion HCM business object structures and REST API data models for programmatic data loading. * Experience building data quality dashboards using Oracle Analytics Cloud, Power BI, or equivalent visualization tools. * Experience with Oracle Cloud technologies including Oracle Integration Cloud (OIC) and/or Oracle Cloud Infrastructure (OCI) in enterprise HCM or ERP environments. ## Description * Design and develop ETL pipelines using Oracle Integration Cloud (OIC), Informatica, Talend, or equivalent middleware tools to transform extracted legacy HR data into Oracle Fusion HCM HDL and HSDL load file formats. * Build data transformation rules that map legacy data values (codes, descriptions, hierarchies) to Oracle Fusion HCM reference data, value sets, and lookup values for each agency migration. * Develop data cleansing pipelines that identify and remediate data quality issues including missing required fields, invalid date formats, duplicate records, and referential integrity violations before target system loading. * Design and implement batch processing frameworks capable of handling large-volume agency migrations ranging from small to very large agency employee populations with configurable parallelism and restart/recovery capabilities. * Build comprehensive error handling and exception management within ETL pipelines including error categorization, automated retry logic, and error reporting dashboards for migration teams. * Develop data reconciliation processes that compare source record counts, key data element values, and business rule validations between legacy extracts, transformation outputs, and target system loaded records. * Create and maintain data quality dashboards providing real-time visibility into migration pipeline status, error rates, data completeness metrics, and reconciliation results for each agency migration wave. * Design reusable transformation templates and parameterized mapping configurations that accelerate successive agency migrations by leveraging patterns from completed migrations. * Collaborate with legacy system export developers (PeopleSoft/EBS team) to define extraction file formats, handoff procedures, and data interface specifications. * Support iterative mock migration cycles (typically 3-4 per agency) and final cutover data loads, optimizing pipeline performance and resolving data quality issues identified in each cycle. * Document ETL design specifications, transformation rules, data flow diagrams, and operational runbooks for each agency migration in accordance with SAFe Agile artifact standards. * Operate with significant independence to analyze and resolve complex functional and technical issues, applying advanced techniques and serving as a go-to technical resource and mentor for less experienced team members across the program. * Lead small work efforts and technical initiatives within the assigned functional area, contributing to team strategy, conducting technical reviews of deliverables, and guiding junior consultants on Oracle Fusion Cloud HCM best practices and solution approaches. ## Related Videos - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [What if your HR software adapted to you, not the other way around?](https://www.wearedevelopers.com/videos/100259-what-if-your-hr-software-adapted-to-you-not-the-other-way-around) - [Introducing JSON Structure](https://www.wearedevelopers.com/videos/100219-introducing-json-structure) - [Delete the roles, deploy the skills](https://www.wearedevelopers.com/videos/2104-delete-the-roles-deploy-the-skills) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [System change: restart as developer?](https://www.wearedevelopers.com/magazine/39-system-change-restart-as-developer) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Long-Term Employment vs Job Hopping](https://www.wearedevelopers.com/magazine/419-long-term-employment-vs-job-hopping)