Oracle Financial Services (OFSAA) Tech Specialist

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

Description Summary:

We are seeking an experienced OFSAA Developer with hands‑on expertise in ALM, FSDF, DIH, FTP, PFT, and GL Reconciliation. The ideal candidate will have strong experience with OFSAA 8.1.x, Oracle SQL/PLSQL, Erwin Data Modeler, data integration, reconciliation, and production support. The role is responsible for developing and supporting OFSAA solutions, managing data processing and outbound interfaces, migrating components across environments, and ensuring Development, QA/UAT, and Production environments remain synchronized.

Key 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.

Basic Qualifications

• Bachelor's Degree
• Minimum of five (5) years of hands‑on development experience with OFSAA 8. or an additional 4 years of related work experience may be considered in lieu of a bachelor's degree
• Minimum of two (2) years of experience with ALM, FSDF, DIH, FTP, PFT, and GL Reconciliation, Oracle SQL and PL/SQL development and troubleshooting skills.

Preferred Qualifications

• Experience with FSDF data structures, staging tables, processing tables, and source‑to‑target mappings, DIH outbound interfaces and extracting OFSAA data to files for downstream consumption.
• Experience developing and troubleshooting GL reconciliation and financial‑data validation processes, ALM, FSDF, DIH, FTP, and PFT.
• Experience with FSDF data structures, staging tables, processing tables, and source‑to‑target mappings.
• Experience with DIH outbound interfaces and extracting OFSAA data to files for downstream consumption.
• Experience developing and troubleshooting GL reconciliation and financial‑data validation processes.
• Hands‑on experience with Erwin Data Modeler and logical/physical data modeling.
• Experience exporting, packaging, and migrating OFSAA components across Development, QA/UAT, and Production environments.
• Experience managing component dependencies and maintaining environment synchronization and configuration consistency.
• Strong experience with batch processing, performance tuning, production support, and root‑cause analysis.
• Strong understanding of SDLC, testing, release management, and change‑management processes.
• Strong analytical, troubleshooting, communication, and collaboration skills.
• Banking or financial‑services industry experience.
• Knowledge of loans, deposits, securities, and other financial instruments.
• Experience tracing data from source systems through FSDF/OFSAA to downstream interfaces and the General Ledger.
• Experience with OFSAA upgrades, patches, environment refreshes, and production deployments.
• Experience with Unix/Linux and shell scripting.
• Experience supporting high‑volume financial‑data and batch‑processing environments.

Technical Skills

• OFSAA: OFSAA 8.1.x | ALM | FSDF | DIH | FTP | PFT | GL Reconciliation
• Database/Data Modeling: Oracle | SQL | PL/SQL | Erwin | Data Modeling | Data Mapping | Data Reconciliation
• Deployment: OFSAA Component Export/Import | File-Based Migration | Environment Synchronization | Deployment Validation | Change/Release Management
• Operations: Unix/Linux | Shell Scripting | Batch Processing | Performance Tuning | Production Support | Root‑Cause Analysis

Exempt Status

Exempt Status: (Yes = not eligible for overtime pay) (No = eligible for overtime pay) Yes

Workplace Type

Office

Certain positions outside our branch network may be eligible for a flexible work arrangement. We’re combining the best of both worlds: in‑office and work from home. Our approach enables our teams to deepen connections, maintain a strong community, and do their best work. Remote roles will also have the opportunity to come together in our offices for moments that matter. Specific work arrangements will be provided by the hiring team.

Compensation Range

Compensation Range: $70,000-$140,000 Annual Salary The compensation range represents the anticipated low and high end of the base compensation range for this position. Actual compensation will vary based on various factors including but not limited to location, experience, and education.Colleagues in this position are also eligible to participate in an applicable incentive compensation plan.In addition, Huntington provides a variety of benefits to colleagues, including health insurance coverage, wellness program, life and disability insurance, retirement savings plan, paid leave programs, paid holidays and paid time off (PTO).

Huntington is an Equal Opportunity Employer.

Tobacco-Free Hiring Practice: Visit Huntington's Career Web Site for more details.

Note to Agency Recruiters: Huntington will not pay a fee for any placement resulting from the receipt of an unsolicited resume. All unsolicited resumes sent to any Huntington colleagues, directly or indirectly, will be considered Huntington property. Recruiting agencies must have a valid, written and fully executed Master Service Agreement and Statement of Work for consideration.

Welcome to Huntington! At Huntington, we look out for people. From reinventing banking with game-changing innovations to building an internal culture that creates lifelong bonds, together, we can make people’s lives better. And amazing things happen when we look out for each other. We prove it every day. Whether it’s helping a colleague or collaborating on a new tool that will revolutionize the way people save money, our actions can have a huge impact. Our colleagues look out for people with a Can-Do Attitude, Service Heart and Forward Thinking. Those are our values—simple but powerful. Each of them pushes us do the right thing, to do right by people. Because people are what matter. If that sounds like you, we hope you’ll apply to join our team. If you’d like to learn more about how Huntington looks out for people, visit https://www.huntington.com/lookingout

We endeavor to make this site accessible to any and all users. If you would like to contact us regarding the accessibility of this site or if you require a reasonable accommodation to apply for a job or to perform the essential functions of the job, please send an email to [e-mail] Reasonable Accommodations Various methods will be used throughout the recruitment process to verify candidate authenticity. Any interviews conducted virtually must be joined from a distraction-free environment, with the candidate on camera and without the use of virtual backgrounds.

EEOC Disclaimer Know Your Rights CA Data Privacy CA Data Privacy Rights Tobacco Disclaimer