I have over 2 years of experience in Oracle Data Integrator.
I have extensive experience in developing load plans, packages, and scheduling jobs.
I possess a strong understanding of ODI12C architecture and its new features.
I am skilled in installing ODI12c and creating Master and Work repositories in various ORDBMS products, including Oracle 12c.
I have a solid understanding of ODI Navigators such as Designer, Topology, Operator, and Security Navigator.
My knowledge includes proficiency in Knowledge modules like LKM, CKM, IKM, and JKM.
I am well-versed in different loading strategies such as Control Append, SCD1, SCD2, and SCD3.
I have expertise in loading data from and to various file formats like FLAT FILE, CSV, and XML files.
I am familiar with Package Utilities and other related tools.
I have experience in creating and configuring Standalone agents.
I possess knowledge of ODI Administration tasks, including setting up master and work repositories during the initial environment setup.
I am proficient in using ODI procedures to create and populate target systems.
I have strong debugging skills for code-related issues.
I am knowledgeable about load plans, scenarios, and scheduling in ODI.
I am familiar with the ODI marketplace and have exposure to other cloud versions.
I have a basic understanding of creating and debugging PL/SQL packages, procedures, cursors, functions, and triggers.
I have a good grasp of data warehousing concepts, including Dimensions and Facts