Oracle Data Integrator (ODI) Developer - Clover Infotech

Clover Infotech; Mumbai, Navi Mumbai, Delhi; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Clover Infotech requires an experienced ODI Developer with 6–8 years of hands-on ODI, SQL, and PL/SQL expertise to design, develop, and maintain data integration and ETL/ELT solutions. The role involves ODI mappings, packages, variables, and knowledge modules across Oracle databases within data warehouse environments.

The candidate will collaborate with Business Analysts, DBAs, and Data Engineers to ensure scalable data flows, perform performance tuning, and support production interfaces across

Qualifications

• 6–8 years of hands-on ODI experience and strong ODI knowledge.
• Proficient in ODI Mappings, Packages, Procedures, Variables, Scenarios, and KMs.
• Strong SQL and PL/SQL skills.
• Good experience with Oracle Database and ETL/ELT concepts.
• Experience in data migration and data warehouse environments.
• Understanding of data modelling and data transformation concepts.
• Experience in troubleshooting and performance tuning.

Responsibilities

• Design, develop, and maintain ODI ETL/ELT workflows.
• Develop and maintain ODI Mappings, Packages, Procedures, Variables, KMs, and Scenarios.
• Perform data extraction, transformation, validation, and loading from multiple sources.
• Create complex SQL queries and PL/SQL procedures and packages.
• Work with Oracle DBs and data warehouse environments.
• Collaborate with analysts, DBAs, and engineers; provide documentation.
• Provide production support and root-cause analysis for issues.

Skills

ODI Developer

ODI Mappings

SQL

PL/SQL

Oracle Database

ETL/ELT

Data Warehousing

Education

Bachelor's degree in CS/IT/Engineering

Tools

ODI

Linux/Unix shell scripting

Python

Informatica

Talend

Azure Data Factory

Job description

Experience: 68 Years
Role: ODI Developer
Employment Type: Full-Time
Location: Mumbai / Delhi
Work Mode: WFO

Job Summary:

We are looking for an experienced Oracle Data Integrator (ODI) Developer with 6–8 years of experience in designing, developing, and maintaining data integration and ETL/ELT solutions. The candidate should have strong hands‑on experience with Oracle Data Integrator, SQL, PL/SQL, data warehousing, mappings, packages, procedures, and data migration/integration processes.

Key Responsibilities:

• Design, develop, and maintain ETL/ELT workflows using Oracle Data Integrator (ODI).
• Develop and maintain ODI Mappings, Packages, Procedures, Variables, Knowledge Modules (KMs), and Scenarios.
• Perform data extraction, transformation, validation, and loading from multiple source systems.
• Develop complex SQL queries and PL/SQL procedures, functions, and packages.
• Work with Oracle databases and data warehouse environments.
• Analyze business and technical requirements and translate them into scalable data integration solutions.
• Monitor and troubleshoot ODI interfaces, workflows, and production jobs.
• Identify and resolve data quality, performance, and integration issues.
• Perform performance tuning of SQL queries and ODI processes.
• Participate in data migration and data warehouse development activities.
• Collaborate with Business Analysts, Data Engineers, DBAs, and other technical teams.
• Prepare technical documentation and support deployment activities across environments.
• Provide production support and participate in root‑cause analysis of recurring issues.

Mandatory Skills:

• 6–8 years of hands‑on experience in Oracle Data Integrator (ODI).
• Strong experience in ODI Mappings, Packages, Procedures, Variables, Scenarios, and Knowledge Modules.
• Strong knowledge of SQL and PL/SQL.
• Good experience with Oracle Database.
• Strong understanding of ETL/ELT concepts and data integration processes.
• Experience in data migration and data warehouse environments.
• Good understanding of data modeling and data transformation concepts.
• Experience in troubleshooting and performance tuning.

Good to Have:

• Experience with ODI 12c.
• Knowledge of Oracle Data Warehouse concepts.
• Exposure to Oracle Cloud / OCI and cloud‑based data integration.
• Experience with Linux/Unix shell scripting.
• Exposure to Python or other scripting languages.
• Knowledge of scheduling tools and production job monitoring.
• Experience working in Agile/Scrum environments.
• Exposure to other ETL/data integration tools such as Informatica, Talend, or Azure Data Factory.

Education:

Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline.