ODI Technical lead

Technical experience with the development of ETL processes in the Data Warehouse Oracle environment

Experience with Oracle ODI Informatica Power Center or Power Exchange.

Expert in SQL and PL/SQL.

Performs SQL queries design code test and aggregate the results to create useful information

Responsible for building online analytical processes (OLAP) using relational and multidimensional databases

Knowledge of Business Intelligence

Design and develop Extract Load Transform (ELT) process and load data from source tables into staging tables and then into target fact and dimension tables utilizing Oracle Data Integrator (ODI)

Validate data loaded into various tables utilizing Structured Query Language (SQL) and other analysis

Advanced SQL statements to interact with a database

Experience in profiling source and raw data

Define transformation logic of data from business requirements

Experience in Python

Knowledge of logical and physical database modeling concepts and techniques

Understand normalized and starschema physical models and logical modeling concepts

Works on APIs and frameworks to expose data for visualization and study