Oracle Financial Services; OFSAA) Tech Specialist

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.

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

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

• 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…