Good Hands-on experience on ODI 12c.
Proficient in analyzing and debugging the Data issues and providing bug fixes in ETL.
Able to Design and develop ELT solutions for enhancement/change requests in ODI.
Good hands on at SQL queries to debug any data issues and Performance tuning.
Exposure on ETL Architecture/Star model etc.
Experience in writing complex queries, Stored Procedures in Oracle SQL and Oracle PL/SQL
Primary focus on developing solutions using Oracle's analytics products: Oracle Analytics Cloud, Oracle Data Visualization, OBIEE, (Optional Machine Learning and Autonomous Data warehouse ADW).
Must possess solid knowledge on OBIEE RPD design, development & deployment.
Must have experience in designing customized interactive dashboards and reports in OBIEE using drill down, prompts, filters, and variables.
Experience in working with session and repository variable and initialization blocks.
Experience on working with report performance optimization.
Good understanding of dimensional data modelling techniques.
Career Level - N/A