Job Title

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.