Experience in design, build ,customize OFSAA Data model ,Validation of data model
· Excellent knowledge in Data model guidelines for Staging. processing and Reporting tables.
· Knowledge on Data model Support on configuring the UDPs, subtype and supertype relationship enhancements
· Experience on OFSAA platform (OFSAAI) with one or more of following OFSAA modules:
o OFSAA Financial Solution Data Foundation - (Preferred)
o OFSA Data Integrated Hub - Optional
· Good in SQL and PL/SQL.
· Strong in Data Warehouse Principles, ETL/Data Flow tools.
· Should have excellent Analytical and Communication skills.
OFSAA Integration SME - DIH/Batch run framework
· Experience in ETL process, familiar with OFSAA.
·DIH setup in EDS, EDD, T2T, etc.
· Familiar with different seeded tables, SCD, DIM, hierarchy, look ups, etc…
· Worked with FSDF in knowing the STG, CSA, FACT table structures
· Have working with different APIs and out of box connectors, etc.
· Familiar with Oracle patching and SR