10+ years Oracle PL/SQL Developer with the following skillset
Experience with hands-on SQL, PL/SQL (Basic and Advanced).
Good analytical, logic building and problem solving skills.
Hands on with performance tuning and trouble shooting.
Exposure to DB Design and Modeling.
Flexible to work under pressure and multitasking
Good understanding in ELT design development on ODI 11g and 12c
Sound knowledge on operator, topology, designer and security modules.
Should be able to define and understand odi interfaces, packages, variables, sequences.
Should be able to create interface using procedures and define, debug existing interfaces.
Good knowledge on use of variables.
Knowledge on ODI architecture and installation.
Should have experience with data and dimensional modeling for a Data Warehouse
Should have experience in setting up OBIEE security (Creating Application roles, updating OBIEE config files)
Should have experience in installing and configuring OBIEE Servers
Should have OBIEE 12c and 11g experience in creating OBIEE repository (Physical, Business Model and Presentation Layer), Time series objects,
Interactive dashboards , web catalog objects and reports
Administration experience on OBIEE, ODI - Should have thorough knowledge on trouble shooting migration issues like LDAP authentication and SSL configuration on the servers.