Oracle Data Integrator (ODI) Developer - Clover Infotech

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.