01Overview
Role & responsibilities
OBIEE - ODI Admin & Developer
Position : OBIEE -ODI Admin & Developer
Years of exp: 6-8 YEARS
Location : Chennai
NP: Immediate -15 Days
Timings : 11:30 am -8:30 pm/12:30 pm -9:30 pm
Skills required :
Strong expertise in Web Logic server and enterprise manager (EM) administration and monitoring
Proven experience in designing and managing Scenarios and load plans ,ensuring complex job sequencing ,dependency management and restart ability
Hands on experience in RPD Modelling ,including physical, business model & mapping (BMM) and presentation layers along with RPD development process
Solid foundation in data modelling , with strong understanding of fact and dimension
Skilled in developing interactive dashboards analytical reports and scorecards
Experience in building packages ,load plans, and scenarios for efficient ETL Workflows
Strong SQL and PL /SQL expertise ,with in depth knowledge of indexing strategies, Query optimization, and oracle performance tuning.
Proficient in exporting and importing data ,managing large datasets and maintain data accuracy and integrity
Job Description:
Monitor and support ODI jobs and BI Reports to ensure smooth daily operations .
Troubleshoot job failures ,investigate root cause, and resolve performance related issues.
Manage application roles and handle user access provisioning and security administration.
Schedule ,monitor, and maintain load plans to ensure timely data processing .
Proactively identify ,analyse and resolve system and performance bottlenecks .
Perform patch management activities and support system upgrades
Maintain and enhance standardized PL/SQL Code to ensure consistency ,performance and reliability
Certifications if any :
OBIEE (Oracle Business Intelligence) Certification
Oracle Analytics Server (OAS) Certification (Preferrable)
ODI (Oracle Data Integrator) Certification (Preferable)
Preferred candidate profile
Perks and benefits .
