Oracle Technical Lead with Ofsaa

2 weeks ago

Toronto, Canada Compest Solutions Inc Full time

What are the top 3 skills required for this role?
1. BASEL/Large Exposure experience with OFSAA
2. Regulatory Functional knowledge of both US and Canadian OSFI experience
3. OFSAA stack full end to end from data ingestion to regulatory reporting

Job Description/ Responsibilities:
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 III
- Knowledge of credit risk reporting and economic capital, regulatory reporting related to credit risk portfolios and supporting the process
- 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 architecture
- 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.

Years of Experience: 8.00 Years of Experience

**Job Type**: Fixed term contract
Contract length: 12 months

Pay: $50.00-$55.00 per hour

Expected hours: 40 per week

Schedule:

- Monday to Friday

**Education**:

- Bachelor's Degree (preferred)

**Experience**:

- OFSAA: 10 years (required)
- OSFI: 10 years (required)
- Erwin data modeling: 9 years (preferred)
- SQL / PLSQL: 9 years (preferred)

**Language**:

- English (preferred)

Work Location: In person

  • Ofsaa Technical Lead

    1 week ago

    Toronto, Canada Compest Solutions Inc Full time

    What are the top 3 skills required for this role? 1. BASEL/Large Exposure experience with OFSAA 2. Regulatory Functional knowledge of both US and Canadian OSFI experience 3. OFSAA stack full end to end from data ingestion to regulatory reporting Job Description/ Responsibilities: Additional Information: OFSAA, SQL / PLSQL, Oracle database 12c / 19c, Unix...

  • Ofsaa - Oracle Financial Crime and Compliance

    2 weeks ago

    Toronto, Canada Atlantis IT group Full time

    Role: OFSAA Location: Toronto Job Requirements- Undergraduate Degree or Technical Certificate. - Demonstrated strong experience delivering or supporting OFSAA suite of solutions (Good to Have - Oracle Financial Crime and Compliance Management suite experience). - 10+ yrs. of development and support experience having implemented OFSAA suite of solutions...

  • Oracle Mantas/ofsaa Consultant

    1 month ago

    Toronto, Canada Genpact Full time

    With a startup spirit and 115,000+ curious and courageous minds, we have the expertise to go deep with the world’s biggest brands—and we have fun doing it. We dream in digital, dare in reality, and reinvent the ways companies work to make an impact far bigger than just our bottom line. We’re harnessing the power of technology and humanity to create...

  • Oracle Ofsaa Functional Consultant

    2 weeks ago

    Toronto, Canada AstraNorth Full time

    Knowledge on how to identify the Assets and Liabilities - Knowledge on the mapping the products for the assets and liabilities - In depth knowledge on the Products and deriving the required attributes for the Products - In depth knowledge on mapping the Products and the their attributes to the FSDF - In depth knowledge on products for CASA, Money Markets,...

  • Ofsaa Functional Lead

    1 month ago

    Toronto, Canada Cognizant Technology Solutions Full time

    **OFSAA Functional Lead**: At Cognizant, our global community sets us apart—an energetic, collaborative and inclusive workplace where everyone can thrive. And with projects at the forefront of innovation, you can build a varied, rewarding career and draw inspiration from dedicated colleagues and leaders. Cognizant is right where you belong. **Role...

  • Oracle Ofsaa Functional Consultant

    2 weeks ago

    Toronto, Ontario, Canada AstraNorth Full time

    Knowledge on how to identify the Assets and Liabilities Knowledge on the mapping the products for the assets and liabilities In depth knowledge on the Products and deriving the required attributes for the Products In depth knowledge on mapping the Products and the their attributes to the FSDF In depth knowledge on products for CASA, Money Markets,...

  • Ofsaa Consultant

    2 weeks ago

    Toronto, Canada Cloudious Full time

    Roles & Responsibilities: - Support Current OFSAA Application - Perform RCA, Error Handling, and improvements - Write business data requirements and translate them to system data requirements. - Manage reference/master data and transactional data Must have Experience on one or more of below OFSAA modules: - OFSAA Financial Solution Data Foundation -...

  • Ofsaa Architecture

    6 days ago

    Toronto, Canada Atlantis IT group Full time

    **Title : OFSAA Architecture** **Location : Toronto, ON - Hybrid** 1. Understand OFSAA architecture and have extensive experience with OFSAA Infra components like T2T,DQ,SCD,Batch operations. 3. Ability to understand/write/optimize SQL queries in Oracle. Understanding of advance SQL operations would be a PLUS. 4. Work with Erwin, on modelling and...

  • Ofsaa Consultant

    2 weeks ago

    Toronto, Ontario, Canada Cloudious Full time

    Roles & Responsibilities: Support Current OFSAA Application Perform RCA, Error Handling, and improvements Write business data requirements and translate them to system data requirements. Manage reference/master data and transactional dataMust have Experience on one or more of below OFSAA modules:OFSAA Financial Solution Data Foundation (preferred) OFS...

  • Ofsaa Consultant

    3 weeks ago

    Toronto, Canada Compest Solutions Inc Full time

    Job Title : OFSAA Consultant Location: Halifax, NS / Toronto, ON (Hybrid) Experience : 10 to 12 yrs. 6+ months long term contract position Roles & Responsibilities: - Support Current OFSAA Application - Perform RCA, Error Handling, and improvements - Write business data requirements and translate them to system data requirements. - Manage reference/master...

  • Sr. OFSAA Analyst

    2 weeks ago

    Greater Toronto Area, Canada Innova Solutions Full time

    Innova Solutions Sr. Business Analyst with OFSAA Implementation ExperiencePosition Type: Full-time OR Contract to HireDuration: 12+ MonthsLocation: Toronto, Ontario, Canada (Remote/Hybrid)As a Sr. Business Analyst with OFSAA Implementation experience you will have:Experience in integrating source data into Oracle OFSAA with an in-depth understanding of CSA...

  • Ofsaa Application Specialist

    3 weeks ago

    Toronto, Canada Scotiabank Full time

    Requisition ID: 189292 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. **The Team** Our team is responsible for the systems that support Global Finance. We support over 1000 users across the Finance teams in the bank. **The Role** **Some of the key accountabilities include**: - Gather requirements,...

  • Sr. OFSAA Analyst

    2 weeks ago

    Greater Toronto Area, Canada Innova Solutions Full time

    Innova Solutions is looking to hire a Sr. Business Analyst with OFSAA Implementation experience.Position type: Full-time OR Contract to HireDuration: 12+ MonthsLocation: Toronto, Ontario, Canada (Remote/Hybrid)As a Sr. Business Analyst with OFSAA Implementation experience you will have:Experience in integrating source data into Oracle OFSAA with a deep...

  • Ofsaa Consultant Hybrid

    2 weeks ago

    Toronto, Ontario, Canada Mewar Info Tech Limited Full time

    Support Current OFSAA Application Perform RCA, Error Handling, and improvements Write business data requirements and translate them to system data requirements. Manage reference/master data and transactional dataMust have Experience on one or more of below OFSAA modules:- OFSAA Financial Solution Data Foundation - (preferred) OFS Financial Accounting...

  • Oracle Financial Functional Consultant

    2 weeks ago

    Toronto, Canada Vivatech solutions Full time

    **Role: Oracle Financial Services Analytical Applications (OFSAA)** **Location: Toronto, ON** **Duration: Long Term Contract** - **Understand OFSAA architecture and have extensive experience with OFSAA Infra components like T2T, DQ, SCD, Batch operations.** - **Well versed with OFSAA - FSDF data model.** - **Ability to understand/write/optimize SQL queries...

  • Ofsaa Data Modeler

    2 weeks ago

    Toronto, Canada Cognizant Technology Solutions Full time

    **OFSAA Data Modeler**: At Cognizant, our global community sets us apart—an energetic, collaborative and inclusive workplace where everyone can thrive. And with projects at the forefront of innovation, you can build a varied, rewarding career and draw inspiration from dedicated colleagues and leaders. Cognizant is right where you belong. **What you will...

  • Ofsaa Business Analyst

    2 weeks ago

    Toronto, Canada Cognizant Technology Solutions Full time

    **OFSAA Business Analyst** At Cognizant, our global community sets us apart—an energetic, collaborative and inclusive workplace where everyone can thrive. And with projects at the forefront of innovation, you can build a varied, rewarding career and draw inspiration from dedicated colleagues and leaders. Cognizant is right where you belong. **What you...

  • Ofsaa Consultant Hybrid

    3 weeks ago

    Toronto, Canada Mewar Info Tech Limited Full time

    Support Current OFSAA Application - Perform RCA, Error Handling, and improvements - Write business data requirements and translate them to system data requirements. - Manage reference/master data and transactional data Must have Experience on one or more of below OFSAA modules: **- OFSAA Financial Solution Data Foundation - (preferred)** **- OFS Financial...

  • Oracle Financial Functional Consultant

    2 weeks ago

    Toronto, Ontario, Canada Vivatech solutions Full time

    Role: Oracle Financial Services Analytical Applications (OFSAA)Location: Toronto, ONDuration: Long Term Contract- Understand OFSAA architecture and have extensive experience with OFSAA Infra components like T2T, DQ, SCD, Batch operations.- Well versed with OFSAA FSDF data model.- Ability to understand/write/optimize SQL queries in Oracle. Understanding of...

  • Ofsaa Data Modeler

    2 weeks ago

    Toronto, Ontario, Canada Cognizant Technology Solutions Full time

    OFSAA Data Modeler:At Cognizant, our global community sets us apart—an energetic, collaborative and inclusive workplace where everyone can thrive. And with projects at the forefront of innovation, you can build a varied, rewarding career and draw inspiration from dedicated colleagues and leaders. Cognizant is right where you belong.What you will do:...