OFSAA Developer

Position Description:

Your future duties and responsibilities:

• Designing, implementing, and maintaining OFSAA solutions for financial institutions
• Work closely with business and IT teams, developing and documenting SQL queries, executing data sanity checks, and managing data movement and server administration.
• Data Movement and Server Management
• Understand complex SQL queries, analyze data related issues and identify root cause of issues / defects. Develop and implement performance optimal system.
• Troubleshoot technical issues by analyzing OFSAA log files and fixing the issues. Analyze data related issues and identify root cause of issues / defects.

Required qualifications to be successful in this role:

• A Design, develop, and configure components within the OFSAA suite, including Data Foundation, DIH (Data Integration Hub), FSDF, and Metadata Manager.
• Implement business rules, data models, and mapping logic using OFSAA tools like Rule Framework, ERWIN, or T2T (Table to Table).
• Design and develop ETL workflows to extract, transform, and load financial and risk data from source systems into OFSAA staging and atomic layers.
• Work with ODI, Informatica, or PL/SQL scripts to ingest and transform large datasets.
• Build and maintain validation rules to ensure data accuracy, completeness, and consistency across ingestion and reporting layers.
• Optimize OFSAA components and SQL queries for performance and scalability.
• Collaborate with Business Analysts, Data Architects, and Reporting Teams to gather requirements and translate them into OFSAA configuration and code.

• Good to have knowledge on finance and accounting principles.

Skills:

• Data flow analysis
• Data Modeling
• Data Warehousing
• DataStage
• ETL
• Oracle SQL Developer
• Python

What you can expect from us:

Together, as owners, let’s turn meaningful insights into action.
Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because… You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction. Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise. You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons. Come join our team—one of the largest IT and business consulting services firms in the world.