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 field3+ years of experience in developing ETL solutions with Oracle Data Integrator (ODI)Strong understanding of ETL concepts, data integration, and data warehousingProficient in SQL, PL / SQL, and working with Oracle databasesExperience in performance tuning and error handling in ODIStrong analytical, debugging, and communication skillsPreferred Qualifications :
Experience with Oracle BI, OBIEE, or Oracle Cloud Data IntegrationsFamiliarity with ODI 12c features such as reusable mappings and load plansExposure to other ETL tools like Informatica, Talend, or SSISExperience in Agile development environmentsKnowledge of data quality and data governance frameworksSkills Required
Etl Development, Data Integration, Sql, Pl / sql, Oracle Database