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).
- Robust experience in ODI Mappings, Packages, Procedures, Variables, Scenarios, and Knowledge Modules.
- Strong knowledge of SQL and PL/SQL.
- Valuable 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.

📌 Oracle Data Integrator (ODI) Developer - Clover Infotech (Delhi)
🏢 Clover Infotech
📍 Delhi