Job Description :
Greeting!!

Please go through the requirement and let me know if you are interested.


Role: Oracle OFSAA Consultant
Location: Pittsburgh, PA
Duration: 11+ Months
Interview Mode: Telephonic/Skype


Job description:

Perform and lead workload and risk analysis related to OFSAA reporting solutions.
Lead the design of OFSAA financial data warehouse solutions based on the key business change requirements and deliverables.
Be involved in discussions with users, management, and other technical personnel to clarify requirements, identify problems, and suggest changes and/or best practices.
Design and develop software component within OFSAA platform including but not limited to: SCD, T2T, T2F, Batch, PLT, DQ.
Document technical specs of each OFSAA software component implementation.
Work side by side with other developers and database administrators to improve software performance of OFSAA.
Support, maintain and enhance existing financial software, and participate in user trainings
Develop and lead team developing data warehousing applications/ Costing applications in financial and banking domain.
Oracle SQL and PL/SQL Development
Recommend enhancements in Oracle DB and tool based on implementation experience.
Translate gathered business needs into technical requirements
Import Model
Data Management Tools
Data Ingestion

Required Skill:
Configuration of the OFSAA solution, 5+years of experience on OFSAA.
Research and solve the data related issues within the environment.
Advising other assets engaged in the project on OFSAA configuration details.
Experience in leading and developing data warehousing applications/ profitability applications in financial and banking domain.
Act as business analyst for gathering requirements
Recommend enhancements in Oracle DB and tool based on implementation experience.
Experienced in all phases of Software Development Life Cycle
Experienced in OFSAA Data Foundation Must have (Operational)
Designs technology solutions by modeling requirements and applying standard application methodology best practices

Technical Skill:
5+ years Solution Architect-Solution Architecture or experience in implementing OFSAA v8.0 or higher
Strong Oracle database development experience
Configuration of the OFSAA solution, 3+years of experience on OFSAA.
Research and solve the data related issues within the environment.
Advising other assets engaged in the project on OFSAA configuration details.
Sound understanding of key processing dimensions, hierarchies and attributes within OFSAA solution.
Good knowledge of the end-to-end data flow and calculations within OFSAA solution.
Working knowledge of writing SQL queries and troubleshoot data related issues.
Flexible in managing competing priorities and objectives.