Etl Lead

Cloudxtreme; Hyderabad, Chennai District, Bengaluru; Hybrid; INR 1,500,000 - 2,800,000; Full time

Job summary

Cloudxtreme seeks an experienced ODI ETL Lead to design and implement complex ETL solutions using Oracle ODI. The role emphasizes knowledge modules customization, mapping design, and end-to-end data warehouse engagements in a Hyderabad setting.

The ideal candidate will drive performance tuning, build reusable workflows, and ensure robust error handling, logging, and data quality across large-scale data integration projects.

Qualifications

• 6+ years of ETL lead/developer experience with ODI.
• Expertise in Oracle ODI toolset and Oracle PL/SQL.
• 2–3 end-to-end DWH implementations.
• Experience in building reusable, parameterized ETL workflows with proper error handling and auditing.

Responsibilities

• Lead and develop ETL processes using ODI, including KM customization.
• Design mappings, process flows, and ETL scripts for complex workloads.
• Set up topology, designers, monitoring, agents, and load plans.
• Integrate ODI with multiple source/target systems and perform data migrations.
• Perform mappings performance tuning and design ETL unit tests.

Skills

ODI experience

PL/SQL

ETL development

Data warehousing

Performance tuning

ETL testing

Load plans

Data migration

Process flows

KM customization

Scheduling jobs

Tools

ODI Studio

ODI Designer

ODI Console

Knowledge Modules (KM)

Job description

Role & responsibilities

• 6+ years ETL Lead / developer experience and a minimum of 3-4 Years experience in Oracle Data Integrator (ODI)
• Expertise in the Oracle ODI toolset and Oracle PL/SQL, ODI
• Minimum 2-3 end to end DWH Implementation experience.
• Should have experience in developing ETL processes - ETL control tables, error logging, auditing, data quality, etc. Should be able to implement reusability, parameterization, workflow design, etc.
• knowledge of ODI Master and work repository
• Knowledge of data modelling and ETL design
• Design and develop complex mappings, Process Flows and ETL scripts
• Must be well versed and hands-on in using and customizing Knowledge Modules (KM)
• Setting up topology, building objects in Designer, Monitoring Operator, different type of KM’s, Agents etc.
• Packaging components, database operations like Aggregate pivot, union etc.
• Using ODI mappings, error handling, automation using ODI, Load plans, Migration of Objects
• Design and develop complex mappings, Process Flows and ETL scripts
• Must be well versed and hands-on in using and customizing Knowledge Modules (KM)
• Experience of performance tuning of mappings
• Ability to design ETL unit test cases and debug ETL Mappings
• Expertise in developing Load Plans, Scheduling Jobs
• Integrate ODI with multiple Source / Target
• Experience in Data Migration using SQL loader, import/export

Consulting Requirements