ODI Developer / ETL Developer

Position: ODI Developer / ETL Developer

Location: Ahmedabad

Shift Time: 2pm to 11pm

Experience: 3+ Years

Job Overview:

The ODI Developer will be responsible for designing, developing, and implementing data integration solutions using Oracle Data Integrator. The role requires strong hands-on ETL development skills, knowledge of data warehousing concepts, and experience in working with Oracle databases and enterprise data sources.

Key Responsibilities:

·      Design, develop, and maintain ETL workflows using Oracle Data Integrator (ODI 12c/11g).

·      Build ODI interfaces, packages, procedures, scenarios, and load plans.

·      Optimize and troubleshoot ETL processes, including debugging ODI sessions and analyzing logs.

·      Work with Oracle Database to write and tune SQL/PL-SQL queries.

·      Collaborate with business and technical teams to understand data requirements and map source-to-target transformations.

·      Configure and manage ODI Agents and scheduling for automated data loads.

·      Support data integration between Oracle EBS, Oracle Fusion, and external systems (preferred).

·      Ensure data quality, performance, and reliability across integration pipelines.

Required Skills & Qualifications:

·      3–4 years of hands-on experience with Oracle Data Integrator (ODI 12c/11g).

·      Strong proficiency in SQL; PL/SQL experience preferred.

·      Good understanding of ETL concepts, data warehousing, and data modeling.

·      Experience with:

ü ODI Load Plans & Scenarios

ü ODI Variables & User Functions

ü ODI Agent configuration, scheduling & deployment

·      Ability to debug ODI sessions, logs, and resolve integration issues.

·      Experience integrating with Oracle E-Business Suite, Oracle Fusion, or other enterprise systems (optional but a strong plus).

Preferred Qualifications:

·      Knowledge of performance tuning for ETL jobs.

·      Familiarity with CI/CD processes for ODI deployments.

·      Exposure to cloud platforms (OCI/AWS/Azure) is an advantage.