Oracle OFSAA Consultant

Job Title: Oracle OFSAA Consultant

Location: Remote (USA)
Employment Type: Contract
Duration: 6 Months

Job Summary:

We are 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. This role requires deep expertise in OFSAA modules, PL/SQL, data modeling, and financial industry regulations.

Key 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.

Required Skills & Qualifications:

• 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.

Soft Skills & Competencies:

• Strong analytical and problem-solving abilities.
• Excellent communication and collaboration skills.
• Ability to multitask and work in a fast-paced environment.

Preferred Qualifications:

• Experience with Agile/Scrum/Kanban methodologies.
• Familiarity with version control (Git, Subversion).
• Knowledge of cloud computing (OCI, AWS).