ETL Developer - Oracle Data Integrator (5-9 yrs)

Experience : 59 Years

Work Location : Hyderabad, Pune, Bangalore

Work Mode : Work from Office (WFO)

Engagement Type : Contract to Hire

Shift Timings : UK Shift (2 PM 11 PM IST) and IST Day Shift Candidate must be flexible

Job Summary :

We are seeking a seasoned ETL + ODI Developer with strong experience in data integration, PL/SQL development, and a deep understanding of Oracle Data Integrator (ODI). The ideal candidate should be capable of building robust ETL/ELT pipelines and working efficiently with relational databases in a performance-critical environment.

Key Responsibilities :

- Design, develop, and implement robust ETL processes using Oracle Data Integrator (ODI).

- Work on end-to-end data pipelines involving extraction, transformation, and loading across multiple data sources and targets.

- Develop and maintain SQL and PL/SQL scripts for data transformation and validation logic.

- Configure and manage ODI repositories, mappings, models, interfaces, packages, and load plans.

- Optimize data workflows to improve performance, scalability, and reliability.

- Collaborate with business analysts, data architects, and QA teams to deliver high-quality data solutions.

- Monitor and troubleshoot ODI jobs and resolve issues in production environments.

- Maintain detailed documentation and follow development best practices.

Required Skills :

- Strong hands-on experience in ETL development and data integration.

- Proficiency in Oracle Data Integrator (ODI), including knowledge of master/work repositories, load plans, mappings, and knowledge modules.

- Solid command over SQL and PL/SQL development in Oracle databases.

- Good understanding of data warehousing concepts, data modeling, and performance tuning.

- Strong analytical and problem-solving skills.

- Ability to work in a fast-paced environment and manage multiple priorities.

- Flexibility to work in UK and IST shifts as required.