Hiring: ODI Developer
Location: Gurgaon (Hybrid/Onsite)
Experience Required: 7–10 Years
Notice Period: Immediate to 15 Days Preferred
We are looking for an experienced ODI Developer with strong expertise in Oracle Data Integrator (ODI) and Oracle database technologies. The ideal candidate should have hands-on experience in designing, developing, optimizing, and supporting enterprise ETL solutions.
Key Responsibilities:
- Design, develop, modify, and maintain ODI 11g/12c mappings, packages, procedures, and load plans.
- Develop and optimize ETL processes to ensure high performance and scalability.
- Write complex SQL and PL/SQL code, including stored procedures, functions, indexes, and partitions.
- Perform full and incremental data loads while ensuring data integrity and quality.
- Conduct data profiling, validation, and reconciliation activities.
- Troubleshoot and resolve data integration and ETL-related issues.
- Collaborate with business and technical teams to understand data requirements.
- Maintain technical documentation for ETL workflows, mappings, and data processes.
- Support production deployments and ongoing maintenance activities.
Required Skills:
- Strong experience with Oracle Data Integrator (ODI) 11g/12c.
- Expertise in Oracle SQL and PL/SQL development.
- Hands-on experience in ETL design, development, and performance tuning.
- Strong understanding of Oracle database concepts, including indexing and partitioning.
- Experience with data warehousing and data integration projects.
- Ability to analyze and resolve complex data and ETL issues.
- Experience working in Agile/Scrum environments.
Preferred Skills:
- Exposure to large-scale data migration or data warehouse projects.
- Experience with Oracle performance tuning and optimization techniques.
