OFSAA Tech Specialist — Remote ALM & GL Reconciliation

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

Benefits offered by this job

Restaurant

Job summary

Huntington Bancshares, Inc. is seeking an experienced OFSAA Developer with hands-on expertise in ALM, FSDF, DIH, FTP, PFT, and GL Reconciliation to design, implement, and support OFSAA solutions.

You will develop complex Oracle SQL/PLSQL, use Erwin Data Modeler for data modelling, manage data processing and outbound interfaces, and ensure Development, QA/UAT, and Production environments stay synchronized.

Qualifications

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

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

ALM

FSDF

DIH

FTP

PFT

GL Reconciliation

Oracle SQL

PL/SQL

Erwin Data Modeler

Education

Bachelor's Degree

Tools

Erwin Data Modeler

Job description

Huntington Bancshares, Inc. is seeking an experienced OFSAA Developer with hands-on expertise in ALM, FSDF, DIH, FTP, PFT, and GL Reconciliation to design, implement, and support OFSAA solutions.

You will develop complex Oracle SQL/PLSQL, use Erwin Data Modeler for data modelling, manage data processing and outbound interfaces, and ensure Development, QA/UAT, and Production environments stay synchronized.