Lead Oracle Data Integrator Developer

Title: Lead ODI DeveloperLocation: RemoteDuration: 6 Months (6 Months extension )

Requirements: 1. Proven experience as an ODI Developer, with a minimum of 8+ years of hands-on experience in Oracle Data Integrator 11g/12c.2. In-depth knowledge of ODI 11g and 12c Cloud Edition, including installation, configuration, and administration.3. Proficiency in Oracle Business Intelligence Applications (OBIA) and familiarity with Out-of-the-Box (OOTB) solutions.4. Strong SQL and PL/SQL programming skills, with the ability to write complex queries and stored procedures.5. Extensive experience with Oracle databases and data warehousing concepts. Responsibilities: 1. Lead the upgrade process from ODI 11g to 12c Cloud Edition, ensuring all components, workflows, and integrations are migrated successfully.2. Collaborate with cross-functional teams including database administrators, business analysts, and developers to understand requirements and identify upgrade dependencies.3. Develop and implement upgrade strategies, ensuring minimal downtime and data integrity during the migration process.4. Must have experience in Moving ETL customizations from 11g to 12c.5. Customize and extend OBIA Out-of-the-Box solutions to meet specific business requirements, leveraging ODI's capabilities for data transformation and integration.6. Design, develop, and maintain ODI interfaces, packages, and workflows to support data extraction, transformation, and loading (ETL) processes.7. Perform troubleshooting and debugging of ODI workflows, identifying and resolving performance bottlenecks, errors, and issues.8. Develop expertise in the Oracle ODI tool set (12c) and Oracle PL/SQL, ODI. Should be able to create ODI Mapping, Packages, Scenarios, and load plans.9. Set up topology, build objects in Designer, Monitoring Operator, different types of KMs, Agents, etc.10. Package components, perform database operations like Aggregate, union, etc.11. Optimize ODI 12c Cloud Edition environments for enhanced performance and scalability.12. Develop topology setup, Load Plans, Packages, Mappings/Interfaces, Procedures, and Scheduling Jobs.13. Collaborate with stakeholders to gather requirements, define data integration workflows, and provide technical guidance and expertise.14. Document technical specifications, upgrade processes, and best practices for knowledge sharing and future reference.15. Stay up-to-date with the latest trends and advancements in ODI, OBIA, and Oracle technologies, recommending and implementing improvements to enhance system performance and efficiency.

Key Skills

• Python
• Data Science
• Kafka