Oracle Data Integrator (ODI) Developer

Job Summary:

The Oracle Data Integrator (ODI) Developer is responsible for designing, developing, and maintaining ETL solutions using Oracle Data Integrator. This role ensures the efficient extraction, transformation, and loading of data across various systems and supports data integration and warehousing initiatives.

Key Responsibilities:

• Design and develop ETL processes using Oracle Data Integrator (ODI)
• Create and manage interfaces, packages, and scenarios for data loading and transformation
• Integrate data from various sources including databases, flat files, and cloud platforms
• Optimize performance of ETL jobs and ensure data accuracy and consistency
• Collaborate with business analysts and data architects to gather requirements
• Troubleshoot data load failures, investigate issues, and implement fixes
• Document ETL processes, mappings, and integration logic
• Perform unit testing and support system and user acceptance testing
• Ensure adherence to data governance and security policies
• Support ODI upgrades, patches, and production deployments

Required Skills and Qualifications:

• Bachelor's degree in Computer Science, Information Systems, or related field
• 3+ years of experience in developing ETL solutions with Oracle Data Integrator (ODI)
• Strong understanding of ETL concepts, data integration, and data warehousing
• Proficient in SQL, PL/SQL, and working with Oracle databases
• Experience in performance tuning and error handling in ODI
• Strong analytical, debugging, and communication skills

Preferred Qualifications:

• Experience with Oracle BI, OBIEE, or Oracle Cloud Data Integrations
• Familiarity with ODI 12c features such as reusable mappings and load plans
• Exposure to other ETL tools like Informatica, Talend, or SSIS
• Experience in Agile development environments
• Knowledge of data quality and data governance frameworks