Oracle Data Integrator Developer

Job description

**Key Responsibilities** - Design, develop, test, and deploy ETL/ELT solutions using Oracle Data Integrator (ODI). - Create and maintain ODI repositories, interfaces/mappings, packages, procedures, variables, and load plans. - Develop data integration solutions for data warehousing and business intelligence projects. - Perform data analysis, data mapping, and data validation activities. - Optimize ODI jobs and database queries for performance and scalability. - Troubleshoot and resolve production issues related to ETL processes. - Work closely with business analysts, data architects, and application teams to understand requirements and deliver solutions. - Participate in code reviews and ensure adherence to development standards and best practices. - Support deployment activities across development, testing, and production environments. **Required Skills** - 5+ years of experience in **Oracle Data Integrator (ODI)** development. - Strong experience with **ODI 11g/12c**. - Proficient in **Oracle SQL and PL/SQL**. - Strong understanding of **Data Warehouse concepts**, ETL/ELT methodologies, and dimensional modeling. - Experience in developing ODI Packages, Load Plans, Mappings, Procedures, Variables, and Knowledge Modules. - Experience with performance tuning and optimization of ODI jobs. - Good understanding of database design and data modeling. - Experience with Unix/Linux scripting. - Strong analytical, troubleshooting, and problem-solving skills