Oracle OFSAA Developer/Consultant
First seen by Alion on Aug 7, 2026.
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.
Skills
OFSAA, PL-SQL, Oracle Apps, Oracle Support, Oracle Implementation, WebLogic, WebSphere, Shell Scripting, Unix, Linux