OFSAA Developer (ECM)

OFSAA Developer

Vancouver, Toronto, Halifax - 4 days Onsite

Role Overview

We are seeking a seasoned OFSAA Developer to act as the technical backbone of our analytical platform. You'll be responsible for the end-to-end technical implementation of OFSAA modules, ensuring that our data moves from the staging area to the processing engines with surgical precision.

Key Responsibilities

Data Integration : Design and develop ETL / ELT processes using ODI (Oracle Data Integrator) or DIH (Data Integration Hub) to load data into the OFSAA Unified Metadata Analyzer (UMM).

Engine Configuration : Configure and execute OFSAA modules (e.g., FTP, PFT, ALM, or IFRS 9) and troubleshoot complex batch execution issues.

Performance Engineering : Optimize heavy SQL and PL / SQL scripts to handle large-scale financial datasets without melting the server.

T2T & Metadata : Create and maintain Table-to-Table (T2T) definitions, Data Mapping, and Metadata definitions.

Environment Management : Support patches, upgrades, and migrations across Development, UAT, and Production environments.

Technical Requirements

OFSAA Core : Extensive experience with the OFSAA Infrastructure (OFSAAI) and the Financial Services Data Model (FSDM).

Database Mastery : Advanced Oracle PL / SQL (Stored Procedures, Packages, Tuning).

Middleware / OS : Proficiency in Unix / Linux Shell Scripting and batch scheduling tools (e.g., Autosys, Control-M).

ETL Tools : Strong experience with ODI or Informatica within an OFSAA context.