OFSAA Developer

OFSAA Developer
Location : Vancouver, Toronto, Halifax - 4 days onsite :

MarketRole OverviewWe 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 ResponsibilitiesData 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 RequirementsOFSAA 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.