Hands on development experience in ETL using ODI 12C

Hands on development experience in ETL using ODI 12C

Strong knowledge of ELT/ETL concepts, design and coding

Experience in integrating ODI with multiple Source / Target.

Should have experience of Extracting and loading the files using ODI.

Proficiency in SQL, PL/SQL and other relevant technologies.

Good querying skills on Oracle database with ability to understand and debug PL/SQL procedures .

Experience in performance tuning, debugging, and troubleshooting ODI mappings.

Must have done the Development of topology setup, Load Plans, Packages, Mappings/Interfaces, Procedures, and Scheduling Jobs.

Customize and work with various Knowledge Modules (IKM, LKM, CKM, RKM) as per project requirements.

Monitor and troubleshoot ETL processes to resolve issues and ensure timely delivery.

Setting up topology, building objects in Designer, Monitoring Operator, different type of KMs, Agents etc

Ability to work with minimal guidance or supervision