Data Migration Middleware Developer

The Squires Group, Inc.; Reston (VA); On-site; USD 110,000 - 150,000; Full time

Job summary

The Squires Group, Inc. seeks an experienced Oracle HCM Data Migration Middleware Developer to support a large-scale Oracle Fusion Cloud HCM modernization initiative.

The role involves designing, developing, and maintaining data migration pipelines and middleware solutions that transform legacy HR data into Oracle Fusion HCM HDL and HSDL formats. This role requires 4+ years in ETL or data integration, strong SQL skills, and experience with OIC, Informatica, or Talend.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field; equivalent experience considered.
• 4+ years of ETL, middleware, or enterprise data integration experience.
• 3+ years of experience with Oracle Integration Cloud (OIC), Informatica, Talend, or similar integration tools.
• Strong SQL skills and experience developing data transformation and reconciliation processes.
• Experience supporting large-scale data migrations and high-volume batch processing.
• Knowledge of data quality management, validation, cleansing, and profiling techniques.
• Experience working with CSV, XML, JSON, and other file-based integration formats.
• Familiarity with Agile and SAFe methodologies.
• Ability to obtain and maintain a Public Trust clearance.
• US Citizenship required.

Responsibilities

• Develop ETL and middleware solutions that transform legacy HR data into Oracle Fusion HCM HDL and HSDL load formats.
• Build data mappings, transformation rules, and validation processes to support agency migrations.
• Create data cleansing, reconciliation, and quality assurance processes to ensure migration accuracy.
• Design scalable batch processing frameworks with error handling, monitoring, and recovery capabilities.
• Develop dashboards and reporting tools to track migration status, data quality, and reconciliation results.
• Create reusable migration templates and frameworks to accelerate future implementation efforts.
• Collaborate with technical and functional teams to define data interfaces, migration requirements, and integration specifications.
• Support mock conversions, production cutovers, troubleshooting, and performance optimization activities.
• Document ETL designs, transformation logic, operational procedures, and migration processes.
• Participate in Agile ceremonies and support continuous improvement initiatives.

Skills

ETL development

Middleware

SQL

Data integration

OIC

Informatica

Talend

Data quality

Agile/SAFe

Public Trust

US Citizenship

Education

Bachelor's degree in Computer Science/IT or related field

Tools

Oracle Integration Cloud (OIC)

Informatica

Talend

Job description

Oracle HCM Data Migration Middleware Developer

The Squires Group is seeking an experienced Oracle HCM Data Migration Middleware Developer to support a large‑scale Oracle Fusion Cloud HCM modernization initiative. The role involves designing, developing, and maintaining data migration pipelines and middleware solutions that transform legacy HR data into Oracle Fusion HCM HDLs and HSDLs. This position is based in Ashburn, VA, with occasional travel (up to 25%). Candidates must be US citizens and able to obtain and maintain a Public Trust clearance.

Responsibilities

• Develop ETL and middleware solutions that transform legacy HR data into Oracle Fusion HCM HDL and HSDL load formats.
• Build data mappings, transformation rules, and validation processes to support agency migrations.
• Create data cleansing, reconciliation, and quality assurance processes to ensure migration accuracy.
• Design scalable batch processing frameworks with error handling, monitoring, and recovery capabilities.
• Develop dashboards and reporting tools to track migration status, data quality, and reconciliation results.
• Create reusable migration templates and frameworks to accelerate future implementation efforts.
• Collaborate with technical and functional teams to define data interfaces, migration requirements, and integration specifications.
• Support mock conversions, production cutovers, troubleshooting, and performance optimization activities.
• Document ETL designs, transformation logic, operational procedures, and migration processes.
• Participate in Agile ceremonies and support continuous improvement initiatives.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field; equivalent experience considered.
• 4+ years of ETL, middleware, or enterprise data integration experience.
• 3+ years of experience with Oracle Integration Cloud (OIC), Informatica, Talend, or similar integration tools.
• Strong SQL skills and experience developing data transformation and reconciliation processes.
• Experience supporting large‑scale data migrations and high‑volume batch processing.
• Knowledge of data quality management, validation, cleansing, and profiling techniques.
• Experience working with CSV, XML, JSON, and other file‑based integration formats.
• Familiarity with Agile and SAFe methodologies.
• Ability to obtain and maintain a Public Trust clearance.
• US Citizenship required.

Preferred Qualifications

• Experience supporting Oracle Fusion HCM or ERP migrations.
• Hands‑on experience with Oracle Fusion HDL and HSDL.
• Oracle Integration Cloud (OIC), Informatica, or Talend certifications.
• Knowledge of federal HR data standards and government migration projects.
• Experience with Oracle Fusion HCM business objects, APIs, and Oracle Cloud technologies.
• Experience developing migration reporting and data quality dashboards using Power BI or similar tools.
• Prior experience supporting enterprise Oracle Cloud HCM implementations.

The Squires Group, Inc. is an Equal Opportunity/Affirmative Action Employer.