ODI Developer - ETL/Data Warehousing (5-9 yrs)

Experience : 59 Years

Locations : Hyderabad, Pune, Bangalore

Work Mode : Work from Office (WFO)

Engagement : Contract to Hire / Permanent

Shift Timings : UK Shift (2 PM 11 PM IST) & IST Day Shift (Flexibility Required)

Job Summary :

We are looking for a highly skilled ODI (Oracle Data Integrator) Developer with strong expertise in ETL development, PL/SQL, and hands-on experience in ODI repositories, models, mappings, and workflows. The ideal candidate should be passionate about data integration, able to work across different shifts, and ready to take on challenges in a dynamic, collaborative environment.

Key Responsibilities :

- Design, develop, and optimize end-to-end ETL solutions using Oracle Data Integrator (ODI).

- Develop and maintain complex PL/SQL scripts for data transformation and loading.

- Create, configure, and manage ODI repositories, data models, interfaces/mappings, packages, and load plans.

- Ensure robust data quality, integrity, and performance across all data pipelines.

- Collaborate with data architects, business analysts, and QA teams to gather requirements and deliver solutions.

- Monitor, troubleshoot, and resolve issues in ODI jobs and workflows.

- Maintain clear and comprehensive technical documentation.

- Support production environments and ensure timely delivery of data to downstream systems.

- Work across both UK and IST time zones as required.

Required Skills :

- 59 years of hands-on experience with Oracle Data Integrator (ODI).

- Strong understanding of ETL processes, data warehousing, and data integration concepts.

- Proficiency in Oracle PL/SQL and SQL performance tuning.

- Solid experience with ODI repository management, models, mappings, scenarios, and workflows.

- Good knowledge of data migration and transformation strategies.

- Excellent analytical, debugging, and problem-solving skills.

- Strong communication and interpersonal skills.

- Willingness to work in UK shifts and IST hours as per project needs.