Oracle Data Integrator Lead - ETL Pipeline

Oracle Data Integrator (ODI) ETL Lead :

Key Responsibilities :

- Lead the design, development, and deployment of ETL workflows using Oracle Data Integrator (ODI).

- Build and optimize complex ODI mappings, load plans, and custom Knowledge Modules (KMs).

- Contribute to multiple full-cycle data warehouse implementations, ensuring timely and quality delivery.

- Implement advanced ETL solutions including delta extracts, parameterization, data auditing, and error handling.

- Manage ODI repositories, agents, and topologies; monitor and optimize ETL performance.

- Perform data migrations leveraging SQL Loader and ODI export/import utilities.

- Ensure ETL pipelines are automated, scalable, and reliable to support enterprise data needs.

- Collaborate with cross-functional teams to integrate ODI with diverse source and target systems.

Required Qualifications & Skills :

- Strong expertise in Oracle PL/SQL, ETL design principles, and ODI component management.

- Hands-on experience with ODI Master and Work repositories, custom Knowledge Module

development, and performance tuning.

- Proven ability to integrate ODI across various data sources and target systems.

- Excellent problem-solving skills and ability to troubleshoot complex ETL workflows.

- Strong communication and collaboration skills.

Preferred/Bonus Skills :

- Familiarity with DevOps practices applied to ETL development.

- Experience with real-time data processing and streaming architectures.