Oracle OFSAA Consultant

Pipe Recruit; United States; Remote; USD 90,000 - 130,000; Part time

Job summary

A consulting firm is seeking an experienced Oracle OFSAA Consultant to implement 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 and PL/SQL programming. The position is remote in the USA and is a contract for 6 months.

Qualifications

• 5+ years of hands-on experience with OFSAA implementation and development.
• Strong expertise in Oracle PL/SQL programming and SQL query optimization.
• Familiarity with financial regulations like Basel III, IFRS 9, Dodd-Frank.

Responsibilities

• Configure and optimize OFSAA solutions to meet compliance and business requirements.
• Develop and enhance PL/SQL scripts for efficient data processing.
• Collaborate with stakeholders to translate business needs into technical solutions.

Skills

Oracle PL/SQL programming

Data modeling

ETL processes

Analysis and problem-solving

Communication and collaboration

Education

Bachelor's degree in Computer Science or related field

Tools

Oracle Exadata

OBIEE

Oracle Analytics Cloud

Git

Subversion

Job description

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