Oracle HCM Data Migration Middleware Engineer

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

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.