Oracle ODI Consultant

Technical Requirements

Education: B.E./B.Tech/M.C.A./M.Sc (CS)

6+ years ETL Lead / developer experience and a minimum of 3-4 Years experience in Oracle Data Integrator (ODI)

Expertise in the Oracle ODI toolset and Oracle PL/SQL, ODI

Minimum 2-3 end to end DWH Implementation experience.

Should have experience in developing ETL processes - ETL control tables, error logging, auditing, data quality, etc. Should be able to implement reusability, parameterization, workflow design, etc.

knowledge of ODI Master and work repository

Knowledge of data modelling and ETL design

Design and develop complex mappings, Process Flows and ETL scripts

Must be well versed and hands-on in using and customizing Knowledge Modules (KM)

Setting up topology, building objects in Designer, Monitoring Operator, different type of KM's, Agents etc.

Packaging components, database operations like Aggregate pivot, union etc.

Using ODI mappings, error handling, automation using ODI, Load plans, Migration of Objects

Design and develop complex mappings, Process Flows and ETL scripts

Must be well versed and hands-on in using and customizing Knowledge Modules (KM)

Experience of performance tuning of mappings

Ability to design ETL unit test cases and debug ETL Mappings

Expertise in developing Load Plans, Scheduling Jobs

Integrate ODI with multiple Source / Target

Experience in Data Migration using SQL loader, import/export

Consulting Requirements

6-10 years of relevant consulting, industry or technology experience

Proven experience assessing client's workloads and technology landscape for Cloud suitability

Experience in defining new architectures and ability to drive project from architecture standpoint

Ability to quickly establish credibility and trustworthiness with key stakeholders in client organization.

Strong problem solving and troubleshooting skills

Strong communicator

Willingness to travel in case of project requirement

Preferred

Experience in Oracle BI Apps

Exposure to one or more of the following: Python, R or UNIX shell scripting.

Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.

Experience in designing and developing Oracle object such as Tables, Views, Indexes, Partitions, Stored Procedures & Functions in PL/SQL, Packages, Materialized Views and Analytical functions

Working knowledge of GIT or similar source code control system

Experience of creating PL/SQL packages, procedures, Functions, Triggers, views, and exception handling for retrieving, manipulating, checking and migrating complex datasets in oracle

Experience in SQL tuning and optimization using explain plan and SQL trace files

Partitioning and Indexing strategy for optimal performance

Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities.

Experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High- and Low-level design documents

Systematic problem-solving approach, coupled with strong communication skills

Ability to debug and optimize code and automate routine tasks.

Experience writing scripts in one or more languages such as Python, UNIX Scripting and/or similar.

Experience working with technical customers