Oracle Data Integrator Lead

As a Senior Integration lead you will:

• Design, develop, and implement ODI ETL and Boomi processes based on new business requirements.
• Enhance and optimize existing ODI integration processes for improved performance and scalability.
• Work directly with customers to capture integration requirements and translate them into technical solutions.
• Document enhancement requirements for existing ODI and Boomi processes.
• Follow industry-standard best practices for integration process design.
• Develop reusable ODI/Boomi components to ensure efficiency and maintainability.
• Conduct unit testing for all developed and modified ODI/Boomi components.
• Ensure data integrity, error handling, and performance optimization in integration processes.
• Troubleshoot and resolve integration-related issues in production and test environments.
• Monitor system performance and ensure seamless data flow across enterprise applications.

Skills Required:

• 7+ years of experience in ETL, data integration, and migration using ODI and Boomi.
• Proven expertise in customer-facing roles for requirement gathering and solution delivery.
• Ability to work independently in a customer-driven environment.
• Expertise in ODI 12c/11g for developing and optimizing ETL pipelines.
• Experience with Knowledge Modules (KM), Data Services, and Load Plans.
• Ability to work with Oracle database, PL/SQL, and performance tuning.
• Strong understanding of Dell Boomi AtomSphere for cloud and on-premise integrations.
• Experience in Boomi Process Design, API Management, and Master Data Hub.
• Hands-on experience in data extraction, transformation, and loading processes.
• Ability to integrate data from heterogeneous sources and optimize ETL performance.
• Experience in end-to-end data migration projects, including mapping, cleansing, and validation.
• Knowledge of data governance, security, and compliance best practices.
• Understanding of Oracle SOA Suite, Web Services, and Enterprise Service Bus (ESB).
• Experience in BPEL, Mediator, and Service Bus for seamless data integration.