Tech Specialist, Oracle Financial Services Analytical Applications

Huntington National Bank

. Design, develop, configure, and support OFSAA ALM, FSDF, DIH, FTP, PFT, and GL Reconciliation solutions .

Posted 10/23/2026full-timeUnited StatesMid-LevelSenior💰 $70,000 - $140,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in OFSAA solutions, including ALM, FSDF, DIH, FTP, PFT, and GL Reconciliation, with strong capabilities in Oracle SQL and PL/SQL development. Proficient in data modeling using Erwin Data Modeler and experienced in managing complex data processing workflows and environments.

Highest-signal resume keywords

OFSAA DevelopmentOracle SQL DevelopmentGL ReconciliationData Modeling with ErwinBatch Processing and Performance Tuning

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

OFSAA ALMOFSAA FSDFOFSAA DIHOFSAA FTPOFSAA PFTOFSAA GL ReconciliationOracle SQLPL/SQLData MappingData Validation

Soft Skills

TroubleshootingProblem SolvingCollaborationAttention to DetailCommunication

Tools & Technologies

Erwin Data ModelerUnix/LinuxShell ScriptingDevelopment EnvironmentsQA/UAT Environments

Industry Keywords

Financial ServicesBankingLoansDepositsSecurities

Tech Stack

Tools & technologies

LinuxOracleSDLCShell ScriptingSQLUnix

About the role

Key responsibilities & impact

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 for promotion across Development, QA/UAT, and Production environments
Manage component dependencies, migration sequencing, and pre/post-deployment validation
Perform environment comparisons and resolve configuration, metadata, database-object, code, and component differences
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

Requirements

What you’ll need

Bachelor's Degree
Minimum of five (5) years of hands-on development experience with OFSAA 8.1.x, 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
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
Experience with banking or financial-services industry
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

Benefits

Comp & perks

Incentive compensation plan eligibility
Health insurance coverage
Wellness program
Life and disability insurance
Retirement savings plan
Paid leave programs
Paid holidays
Paid time off (PTO)
Flexible work arrangement may be available for certain positions
Opportunities to work from home and come together in offices for moments that matter