Job Title : Oracle OFSAA Developer / Consultant

Experience Required : 6- 8 Years

Primary Skills : Oracle Financial Services Analytical Applications (OFSAA), PL/SQL

Job Description :

We are seeking an experienced Oracle OFSAA professional with strong expertise in implementation, installation, upgrades, and support of the OFSAA platform. The ideal candidate should have hands-on experience delivering end-to-end OFSAA implementations and be capable of troubleshooting production issues.

Key Responsibilities :

- Install, configure, upgrade, and maintain Oracle OFSAA environments.

- Demonstrate a solid understanding of the Oracle OFSAA architecture and its core components.

- Participate in at least one or two complete OFSAA module implementations from design through deployment.

- Deploy OFSAA applications on application servers such as Oracle WebLogic, IBM WebSphere, or Apache Tomcat.

- Analyze application and server logs to diagnose and resolve deployment and runtime issues.

- Modify and maintain OFSAA data models using ERwin Data Modeler based on business requirements.

- Perform product upgrades, apply patches, and validate successful implementation.

- Support OFSAA version 8.0 or higher, including implementation and ongoing maintenance.

- Monitor, troubleshoot, and resolve batch processing failures to ensure smooth execution.

- Develop and optimize PL/SQL queries and procedures, and create Unix shell scripts whenever required.

- Configure and manage OFSAA security settings and application parameters.

- Work with OFSAA data management components, including Data Model Upload, Staging Tables, Data Quality Checks, and data loading/extraction using T2T and F2T processes.

- Investigate and resolve application issues by interpreting OFSAA and server log files.

Technical Skills :

- Hands-on experience with Oracle OFSAA installation, configuration, upgrades, and patching.

- Strong understanding of Oracle OFSAA architecture and application framework.

- Experience implementing OFSAA Suite (version 8.x or above).

- Knowledge of WebLogic, WebSphere, or Tomcat application servers.

- Experience with ERwin Data Modeler and OFSAA data model customization.

- Strong Unix/Linux administration and shell scripting skills.

- Advanced PL/SQL development and SQL query tuning experience.

- Experience troubleshooting batch jobs, deployment issues, and application logs.

- Familiarity with OFSAA security configuration, data quality framework, staging concepts, and T2T/F2T data processing.

Preferred Qualifications :

- Experience supporting production OFSAA environments.

- Strong analytical and troubleshooting skills.

- Ability to independently identify, diagnose, and resolve technical issues during implementation and support.