OFSAA Solutions Engineer: ALM, FSDF & GL Reconciliation

Huntington Bancshares, Inc.; Columbus (OH); On-site; USD 70,000 - 140,000; Full time

Benefits offered by this job

Health insurance

Retirement plan

Paid time off

Job summary

Huntington Bancshares, Inc. seeks an experienced OFSAA Developer to design, implement, and support OFSAA solutions across Development, QA/UAT, and Production environments. You will work on ALM, FSDF, DIH, FTP, PFT, and GL Reconciliation, with Oracle SQL/PLSQL and Erwin Data Modeler for data modeling and migrations.

The role focuses on data mappings, reconciliation, data validation, and production support while ensuring environment synchronization and smooth deployments in a banking context.

Qualifications

• Minimum 5 years OFSAA development experience or 4 additional years in lieu of a bachelor’s degree
• Minimum 2+ years with ALM, FSDF, DIH, FTP, PFT, and GL Reconciliation; Oracle SQL/PL/SQL development and troubleshooting

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, data validation, reconciliation, and troubleshooting.
• Configure and support DIH interfaces to extract data from OFSAA and generate outbound files for downstream systems.
• Configure and support ALM, FTP, and PFT processing, methodologies, rules, allocations, and related data processing.
• Develop and support GL Reconciliation, including investigation and resolution of reconciliation breaks, mapping discrepancies, data-quality issues, and out-of-balance conditions.
• Develop complex Oracle SQL and PL/SQL for data transformation, reconciliation, validation, troubleshooting, and performance tuning.
• Use Erwin Data Modeler to maintain logical and physical data models and perform impact analysis for data-model changes.
• Export and package multiple interdependent OFSAA components to files for promotion across Development, QA/UAT, and Production environments.
• Manage component dependencies, migration sequencing, and pre/post-deployment validation to ensure successful implementation.
• Perform environment comparisons and resolve configuration, metadata, database-object, code, and component differences to keep OFSAA environments synchronized.
• Support OFSAA batch execution, monitoring, troubleshooting, restart/recovery, and performance tuning.
• Troubleshoot production incidents, data discrepancies, batch failures, reconciliation issues, and cross-environment differences.
• Participate in testing, release management, change management, deployments, production validation, and technical documentation.

Skills

OFSAA development

ALM

FSDF

DIH

FTP

PFT

GL Reconciliation

Oracle SQL

PL/SQL

Data Modeling

Education

Bachelor's Degree

Tools

Erwin Data Modeler

Job description

Huntington Bancshares, Inc. seeks an experienced OFSAA Developer to design, implement, and support OFSAA solutions across Development, QA/UAT, and Production environments. You will work on ALM, FSDF, DIH, FTP, PFT, and GL Reconciliation, with Oracle SQL/PLSQL and Erwin Data Modeler for data modeling and migrations.

The role focuses on data mappings, reconciliation, data validation, and production support while ensuring environment synchronization and smooth deployments in a banking context.