OFSAA Technical Lead

OFSAA Technical Lead

3 TO 5 YEARS - Should be relevant to the JD

Hybrid Mandatory at 66 Wellington Street West, Toronto, Ontario, M5K1A2

What are the top 3 skills required for this role?
BASEL/Large Exposure experience with OFSAA

Regulatory Functional knowledge of both US and Canadian OSFI experience

OFSAA stack full end to end from data ingestion to regulatory reporting

Additional Information

OFSAA, SQL / PLSQL, Oracle database 12c / 19c , Unix shell scripting, Erwin data modeling, ETL , ODI , SQL Developer

Jd

Lead OFSAA development team

Plan, execute, and deliver proposed Solutions within scope, budget, and timeline

Assign tasks to team members and monitor progress to ensure project milestones are achieved on time

Ensure high code quality by guiding team members, conduct code reviews, and promote best practices

Identify and address technical challenges during project execution

Communicate project plan with team members, product owners, and engineering managers

Collaborate among team members to ensure smooth development cycles

Must have an implementation Experience on below OFSAA modules OFSAA Financial Solution Data Foundation

OFSAA Capital Adequacy Pack OFSAA Data Integration Hub OFSAA Data Governance Pack and OFSAA GL Recon

Advanced OFSAA platform knowledge (FSDF) with coding experience; especially in OFSAAI 8.0.6 .x or similar (at least 3 years in OFSAAI)

Experience in OFSAA architecture and metadata management framework (Hierarchies, datasets)

Experience in OFSAAI performance enhancement work. Scalability/performance tuning experience with large databases. Parallel execution of queries and optimization

Experience developing or reviewing credit risk (including Counterparty credit risk) risk rating and measurements systems, economic capital, stress testing with commercial banks or financial institutions in the context of broader regulatory reforms such as Basel IIl

Knowledge of credit risk reporting and economic capital, regulatory reporting related to credit risk portfolios and supporting the proces

Experience with Oracle 19c, SQL, PL/SQL, OFSAA metadata management framework, data modeling, and managing OFSAA data model using Erwin

Experience with OFSAA data management tools - T2T, file extracts, data quality framework, run-rule, and process modeling framework

Experience with building data entry forms, Excel uploads, run-Rule framework, Data Quality, and FSDF architectur

Knowledge of Data Modelling using Erwin tool, Data Migration Activities and Slowly Changing Dimension (SCD) Component

Experience in managing requirements gathering, business/gap analysis, solution design and documentation for OFSAA projects

Strong in Data Warehouse Principles, ETL/Data Flow tools