OBIEE - ODI Admin & Developer- Chennai - Locals ONLY

Innova Solutions; Chennai District; On-site; INR 1,500,000 - 2,500,000; Full time

Job summary

Innova Solutions seeks an experienced OBIEE/ODI Admin & Developer in Chennai to oversee ODI jobs and BI reports, ensuring reliable daily operations. The role requires hands-on RPD modelling, SQL/PLSQL expertise and strong administration of WebLogic and Oracle EM.

You will design load plans, manage data integration workflows, and address performance bottlenecks while supporting system upgrades and security administration. Immediate joiner preferable but flexible.

Qualifications

• Strong expertise in WebLogic server and EM administration and monitoring.
• Designing and managing Scenarios and load plans with complex job sequencing and restart ability.
• Hands on experience in RPD Modelling including physical, business model & mapping (BMM) and presentation layers.

Responsibilities

• Monitor and support ODI jobs and BI Reports to ensure smooth daily operations.
• Troubleshoot job failures, investigate root cause, and resolve performance issues.
• Manage application roles and user access provisioning and security administration.
• Schedule, monitor, and maintain load plans to ensure timely data processing.
• Identify, analyse and resolve system and performance bottlenecks.
• Perform patch management activities and support system upgrades.
• Maintain standardized PL/SQL code for consistency and performance.

Skills

WebLogic Admin

Load plan design

RPD Modelling

Data modelling

Dashboards & reports

ETL workflows

SQL & PL/SQL

Data export/import

Tools

ODI

RPD Studio

Oracle EM

Job description

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