ODI Developer

3 weeks ago

Gurugram, India Angel and Genie Full time

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
(ref:hirist.tech)

  • Odi Developer

    3 weeks ago

    Gurugram, Chennai, Bengaluru, India Erm Placement Services Full time

    Job Description Responsibilities: - Design, develop, and maintain data integration processes using Oracle Data Integrator (ODI). - Create and manage ODI mappings, packages, and scenarios to meet business requirements. - Perform data extraction, transformation, and loading (ETL) processes to ensure data accuracy and consistency. - Collaborate with...

  • Odi Developer

    1 week ago

    Bengaluru, Chennai, Gurugram, India ERM Placement Services Full time ₹ 15,00,000 - ₹ 20,00,000 per year

    Exp: 4 - 7 yrsLocation: PAN INDIAResponsibilities:Design, develop, and maintain data integration processes using Oracle Data Integrator (ODI).Create and manage ODI mappings, packages, and scenarios to meet business requirements.Perform data extraction, transformation, and loading (ETL) processes to ensure data accuracy and consistency.Collaborate with...

  • Odi - PLSQL Developer

    1 week ago

    Bengaluru, Gurugram, Pune, India Randstad Full time ₹ 15,00,000 - ₹ 20,00,000 per year

    Your key responsibilities:Overall having 3-15 years of ETL Lead / developer experience and a minimum of 2-3 Years experience in Oracle Data Integrator (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...

  • Assistant Manager, Legal Services, Entity Management

    2 weeks ago

    Gurugram, Gurugram, India Marriott International Full time

    Job Description Additional Information Job Number25141396 Job CategoryLegal LocationGurgaon Area Office, Vatika Towers 5/F Block B, Gurugram, Haryana, India, 122003VIEW ON MAP ScheduleFull Time Located RemotelyN Position Type Management Job Summary: We are seeking a qualified Company Secretary (CS) to oversee the secretarial, legal, and compliance...

  • Postulez maintenant

    7 days ago

    Gurugram, India Gurgaon Area Office Full time

    Job Summary: We are seeking a qualified Company Secretary (CS) to oversee the secretarial, legal, and compliance functions of our APEC operations in alignment with both local Indian laws and the global governance standards of our multinational group. The role requires a skilled professional who can manage statutory filings, ensure corporate compliance,...

  • Assistant Manager, Legal Services, Entity Management

    3 weeks ago

    Gurugram, India Marriott International Full time

    Additional InformationJob Number Job CategoryLegalLocationGurgaon Area Office, Vatika Towers 5/F Block B, Gurugram, Haryana, India, ScheduleFull TimeLocated Remotely?NPosition Type Management Job Summary: We are seeking a qualified Company Secretary (CS) to oversee the secretarial, legal, and compliance functions of our APEC operations in alignment with...

  • Oracle Retail Fusion Applications Dba

    2 days ago

    Gurugram, Haryana, India ShyftLabs Full time

    **Position Overview**: ShyftLabs is seeking a talented Oracle Retail FUSION Applications DBA for our Gurgaon/Noida location, where you'll collaborate with cross-functional teams to implement efficient solutions. ShyftLabs is a growing data product company that was founded in early 2020 and works primarily with Fortune 500 companies. We deliver digital...

  • Intech Organics

    1 week ago

    Gurugram, India Intech organics Full time

    Company: Intech Organics Chemical Manufacturing Corporate Office HO (Gurgaon CA Qualified / MBA 10-20 Years Exp with Relevant roleJob Purpose:- Reviewing funding needs, monthly reporting of all treasury activities to senior management.- Analyzing and performing appropriate hedging and funding activities (Forex, swaps, loans, deposits, etc.).- Cash and...