9+ yrs of proven experience in design and development of Data Warehouse solutions, ETL, Software Development and system integration projects
Minimum 6 yrs of strong exp in Oracle Data Integrator(ODI) with knowledge of data modeling and ETL design
Minimum 3-4 yrs of strong exp in OBI-APPS(Financials analytics modules)
Must have 1-2 yrs of exp in OBIEE
Good querying skills on Oracle database with ability to understand and debug PL/SQL procedure
Good knowledge of Enterprise application data structure(Oracle PeopleSoft)
Experience of performance tuning of mappings and able to tune mappings at ETL level and provide suggestion of tuning at database level
Ability to design ETL unit test cases and debug ETL mappings
Strong knowledge and expand implementation of Oracle Data warehouse concepts SCD, Aggregates, Hierarchy tables, Snapshot fact tables etc.,
Ability to work with functional groups an different level of employees to achieve results effectively and professionally
Strong follow-up skills: ability to organize applicable department timelines and follow up with internal and external customer needs
Strong organization skills, ability to accomplish multiple tasks within the agreed upon timeframes through effective prioritization of duties d functions in a fast paced environment.