ODI

8 to 10 Years of experience 

5 years of relevant experience ODI

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

Experience in Customer Experience

Hands-on experience in ODI scripting using Python.

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

Expertise in the ETL/ELT process

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)

Experience in Ingesting data from Oracle, MSSQL, and Salesforce

Experience in ingesting Data from CSV and JSON files

Experience in handling a Large Volume of Data Ingestion and Transformation

Experience in Ingesting Data to Snowflake

Airflow (nice to have)

Python (nice to have)

Understand normalized and star-schema physical models and logical modeling concepts

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