OFSAA ALM/FSDF Developer & GL Reconciliation

Huntington Bancshares, Inc.; Detroit (MI); Hybrid; USD 70,000 - 140,000; Full time

Benefits offered by this job

Health insurance

Wellness program

Life insurance

Disability insurance

Retirement plan

Paid leave

PTO

Job summary

Huntington Bancshares, Inc. is seeking an experienced OFSAA Developer to design, develop, and support OFSAA ALM, FSDF, DIH, FTP, PFT, and GL Reconciliation solutions.

The role involves data mappings, validations, and production support, with migrations across Development, QA/UAT, and Production environments. The ideal candidate brings strong Oracle SQL/PLSQL skills, Erwin Data Modeler experience, and a track record in data integration and reconciliation.

Qualifications

• Bachelor's Degree required.
• Minimum of five (5) years hands-on OFSAA development experience.
• Minimum of two (2) years' experience with OFSAA ALM, FSDF, DIH, FTP, PFT, and GL Reconciliation.

Responsibilities

• Design, develop, configure, and support OFSAA ALM, FSDF, DIH, FTP, PFT, and GL Reconciliation solutions.
• Develop and maintain OFSAA data mappings, transformations, processing workflows, business rules, and configurations.
• Work with FSDF staging and processing data models, including source-to-target mapping and data validation.
• Configure and support DIH interfaces to extract data from OFSAA and generate outbound files.
• Configure and support ALM, FTP, and PFT processing and related data processing.
• Develop and support GL Reconciliation, investigate reconciliation breaks and data-quality issues.
• Develop complex Oracle SQL and PL/SQL for data transformation, reconciliation, validation, and tuning.
• Use Erwin Data Modeler to maintain data models and perform impact analysis.
• Export/package OFSAA components for promotion across environments and manage dependencies.
• Perform environment comparisons and resolve differences to keep environments synchronized.
• Support OFSAA batch execution, monitoring, troubleshooting, and performance tuning.
• Troubleshoot production incidents and cross-environment discrepancies.
• Participate in testing, release management, and technical documentation.

Skills

OFSAA development

Data reconciliation

Production support

Batch processing

Education

Bachelor's degree

Tools

Erwin Data Modeler

Oracle SQL

PL/SQL

Job description

Huntington Bancshares, Inc. is seeking an experienced OFSAA Developer to design, develop, and support OFSAA ALM, FSDF, DIH, FTP, PFT, and GL Reconciliation solutions.

The role involves data mappings, validations, and production support, with migrations across Development, QA/UAT, and Production environments. The ideal candidate brings strong Oracle SQL/PLSQL skills, Erwin Data Modeler experience, and a track record in data integration and reconciliation.