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.
- 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.
- Follow industry-standard best practices for integration process design
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.
