Note: The job is a remote job and is open to candidates in USA. Pipe Recruit is seeking an experienced Oracle OFSAA Consultant to implement, customize, and optimize Oracle Financial Services Analytical Applications (OFSAA) solutions. The ideal candidate will ensure compliance with banking regulations, enhance risk management capabilities, and support profitability objectives.
Responsibilities
- Configure and optimize OFSAA solutions to meet regulatory compliance (Basel III, IFRS 9, Dodd-Frank) and business requirements
- Develop and enhance PL/SQL scripts, optimize SQL queries, and ensure efficient data processing
- Work with OFSAA modules such as FTP, ALM, LRM, PFT, and RRM
- Design and implement ETL processes, data models, and integration solutions
- Collaborate with stakeholders to translate business needs into technical solutions
- Support regulatory reporting frameworks (CCAR, DFAST) and ensure adherence to financial standards
- Follow Agile (Scrum/Kanban) methodologies for project delivery
- Utilize Oracle Exadata, OBIEE, Oracle Analytics Cloud (OAC), and BI tools for reporting
- Maintain version control using Git/Subversion and adhere to SDLC best practices
Skills
- Bachelors degree in Computer Science, Information Technology, or related field
- 5+ years of hands-on experience with OFSAA implementation and development
- Strong expertise in Oracle PL/SQL programming and SQL query optimization
- Experience with OFSAA modules (FTP, ALM, LRM, PFT, RRM)
- Knowledge of financial regulations (Basel III, IFRS 9, Dodd-Frank)
- Proficiency in data modeling, ETL, and data integration
- Familiarity with Oracle Exadata, OBIEE, and Oracle Analytics Cloud (OAC)
- Experience with regulatory reporting (CCAR, DFAST)
- Knowledge of Java, web services, and cloud platforms (OCI, AWS) is a plus
- Certification in OFSAA is preferred
- Strong analytical and problem-solving abilities
- Excellent communication and collaboration skills
- Ability to multitask and work in a fast-paced environment
- Experience with Agile/Scrum/Kanban methodologies
- Familiarity with version control (Git, Subversion)
- Knowledge of cloud computing (OCI, AWS)
Company Overview