HamburgerMenu
hirist

ODI Developer - Data Warehousing

Angel and Genie
Gurgaon/Gurugram
5 - 7 Years
star-icon
4.8white-divider5+ Reviews

Posted on: 23/07/2025

Job Description

Job Description :


We are looking for a highly skilled ODI Developer with hands-on experience in designing, developing, and maintaining ETL processes using Oracle Data Integrator (ODI) 12c.


The ideal candidate will have a strong background in data warehousing, ETL development, and PL/SQL programming, along with a proven track record of delivering high-performance data integration solutions.

Key Responsibilities :

- Design, develop, and implement robust ETL processes using ODI 12c for data extraction, transformation, and loading.

- Develop and manage ODI components including topology setups, load plans, mappings/interfaces, procedures, and scheduling jobs.

- Customize and manage Knowledge Modules (IKM, LKM, CKM, RKM) based on project-specific requirements.

- Implement complex data warehouse solutions, including SCD Type 2, aggregates, keys, and indexes.

- Collaborate with data architects to develop logical and physical data models.

- Write, optimize, and debug complex PL/SQL scripts and stored procedures.

- Manage Oracle databases, flat files, and XMLs through ODI integration processes.

- Perform performance tuning and optimization of ETL workflows and data pipelines.

- Collaborate with cross-functional teams such as DBAs, business analysts, and QA to deliver integrated data solutions.

- Participate in code reviews, sharing best practices and identifying areas for improvement.

- Design ETL unit test cases, conduct debugging and issue resolution for mappings and workflows.

- Maintain up-to-date documentation of ETL jobs, workflows, and data flows for ongoing reference and auditability.

Qualifications :

- Bachelors degree in Computer Science, Information Technology, or a related field.

- Minimum 5 years of experience in ETL development, data warehousing, and system integration.

- Proven experience with Oracle Data Integrator (ODI) 12c in large-scale projects.

- Strong command over SQL/PLSQL, performance tuning, and database management.

- Deep understanding of data warehouse concepts, dimensional modeling, and data architecture.

- Familiarity with scheduling tools and version control systems.

- Excellent analytical, problem-solving, and communication skills.

- Ability to work both independently and in a team-oriented environment.

Preferred Qualifications :

- Experience with Oracle Cloud, Informatica, or other data integration platforms.

- Exposure to Big Data ecosystems and modern data tools.

- ODI certification or relevant Oracle certifications


info-icon

Did you find something suspicious?