• 5 10 years of Hands on experience in OFSAA modules.
• Experience writing and debugging complex SQL queries and Stored Procedures in Oracle database.
• Experience on Erwin Data Model.
• Excellent understanding of BFSI Banking and Insurance domain
• Develop procedure using PL/SQL.
• Troubleshoot technical issues by analyzing OFSAA log files and fixing the issues.
• Production support of OFSAA, this includes batch runs and minor development requests to fix defects as required.
• Troubleshoot technical issues by analyzing OFSAA log files and fixing the issues. Analyze data related issues and identify root cause of issues / defects.
• Working knowledge of OFSAA Run Rule framework
• In depth understanding of Data Warehousing concepts and dimensional modeling
• Configuration of the OFSAA solution.
• Research and solve the data related issues within the environment.
• Advising other assets engaged in the project on OFSAA configuration details.
• Hands on experience in Implementation/ Dev