Oracle ODI OAC Consultant

Talpro; Chennai District; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Talpro INDIA PRIVATE LIMITED invites an Oracle Data Integrator (ODI) and Oracle Analytics Cloud (OAC) consultant to join our Chennai-based team. You will deliver data integration and analytics solutions using ODI and OAC for our clients.

The role requires 2+ years of hands-on ODI and OAC experience, strong SQL/PLSQL, ETL/ELT design, and client-facing communication. Immediate joiners preferred; CTC offered up to 20 LPA based on experience.

Qualifications

• Strong hands-on experience with ODI: Topology, Designer, Operator, and Agent modules.
• Proficiency in OAC: Developing dashboards, KPIs, and reports.
• Advanced SQL and PL/SQL capabilities.
• Proven experience in ETL/ELT workflow design and data transformation.
• Sound knowledge of data modelling and data warehouse design principles.
• Familiarity with Oracle databases and OCI.
• Excellent communication skills and client interaction ability

Responsibilities

• Design and implement scalable data integration solutions using ODI.
• Build and optimize ETL/ELT pipelines for seamless data transformation.
• Develop insightful dashboards and analytical reports on OAC.
• Work closely with business users to understand and gather requirements.
• Translate business needs into technical specifications and solutions.
• Ensure data accuracy, consistency, and integrity across systems.
• Identify and troubleshoot issues in ODI/OAC pipelines and reports; monitor data flow and implement improvements as needed.
• Train end-users to effectively utilize OAC dashboards and features.

Skills

Oracle Data Integrator (ODI)

Oracle Analytics Cloud (OAC)

SQL/PLSQL

ETL/ELT design

Data modelling

Data warehouse design

Oracle DB / OCI

Client communication

Tools

Tableau

Power BI

Python

Shell scripting

Job description

TALPRO INDIA PRIVATE LIMITED | Full time

• Assigned Recruiter(s) BHASKAR ANAND,Ankita Raj
• Date Opened 04/22/2025
• Job Type Full time
• State/Province Tamil Nadu
• Country India

About Us

Talpro is leading the way in transforming the talent acquisition landscape. We deliver innovative, sustainable, and cost-effective recruitment solutions tailored to today’s business needs. Our mission is to offer comprehensive hiring strategies that address immediate recruitment demands while laying the groundwork for long-term success.

Job Description

Position Overview

• Years of Experience : Minimum 2+ years in Oracle Data Integrator (ODI) and Oracle Analytics Cloud (OAC)
• Role Type : Full-Time, Permanent with Client
• CTC Offered : Up to 20 LPA (Based on experience)
• Notice Period : Immediate Joiners only

Mandatory Skills

• Strong hands-on experience with Oracle Data Integrator (ODI) : Topology, Designer, Operator, and Agent modules
• Proficiency in Oracle Analytics Cloud (OAC) : Developing dashboards, KPIs, and reports
• Advanced SQL and PL/SQL capabilities
• Proven experience in ETL/ELT workflow design and data transformation
• Sound knowledge of data modelling and data warehouse design principles
• Familiarity with Oracle databases and Oracle Cloud Infrastructure (OCI)
• Excellent communication skills and the ability to interact effectively with clients

Good to Have Skills

• Experience with Oracle Autonomous Data Warehouse (ADW)
• Familiarity with BI tools like Tableau or Power BI
• Knowledge of Python or Shell scripting for automation
• Understanding of data governance and security best practices

Role Summary

We are seeking a results-driven Oracle Data Integrator (ODI) and Oracle Analytics Cloud (OAC) Consultant to join our dynamic team. In this role, you will be responsible for delivering high-quality data integration and analytics solutions using Oracle's advanced cloud technologies. Your work will empower stakeholders to make data-driven decisions by translating complex data into clear, actionable insights.

Key Responsibilities

• Design and implement scalable data integration solutions using ODI
• Build and optimize ETL/ELT pipelines for seamless data transformation
• Develop insightful dashboards and analytical reports on OAC
• Work closely with business users to understand and gather requirements
• Translate business needs into technical specifications and solutions
• Ensure data accuracy, consistency, and integrity across systems
• Identify and troubleshoot issues in ODI/OAC pipelines and reportsMonitor data flow performance and implement improvements as needed
• Train end-users to effectively utilize OAC dashboards and features

Additional Notes

• Immediate Joiners Preferred (within 30 days)
• Oracle Cloud platform expertise is strongly preferred
• All responsibilities should be carried out with a focus on reliability, performance, and user satisfaction
• Use clear and structured approaches in development and documentation