OFSAA Consultant

n Job Title: OFSAA consultant Location: San Antonio, TX Duration: Contract n n n n Job Description n Knowledge in OFSDF and its Architecture.

Experience in OFSAA DIH and preferably on the Newer Versions.

Experience in Data Model and Ability to perform data model changes/customizations, using CA Erwin tool on key/Custom
– tables/columns for EPM/OFSDF Requirement (Logical/Physical) and Fix DM issues on REV Tables if any.

Understanding in the CSA & FCT Txn tables, Schema (EPM/ERM difference)and how they work, Dimension Management and Enterprise Data Warehouse Knowledge.

Experience in OFSAA GL Reconciliation framework and able to work on Management Ledger table and OFSAA Instrument/transaction tables.

Should have done Performance Tuning on Batches/Rules for Long runners on Data Slice or any advanced method.

OFSAA Data Management Tools Knowledge (F2T/T2T/PLT/SCD’s).

Experience in deploying OFSAA platform (OFSAAI
– OFSAA Infrastructure) and installation of OFSAA application
– preferably OFSAA 8.x onwards.

Closely work with functional consultants/Clients to support all phases of project, including Requirement gathering ,Implementation, user acceptance testing, Migration activities (via OFSAA) and go-live etc.

Provide technical solutions by debugging the failures, and by communicating with Oracle through the SR system.

n Nice To have: n Good to Have
– Experience in any ETL Tool ODI/ Informatica/ OWB or other major ETL/ ELT tools.

Good to Have
– Big Data
– Hive.

PL SQL query handling skills.

Knowledge in Unix Commands.

Should have Worked or ability to Adjust the Working style according to Agile Methodology; Should Adhere to the timelines in Deliverables, Requirement gathering, Testing (Q-test), Demo of the story etc..

nn n n nn
– provided by Dice