Birlasoft - ODI Developer - ETL/Python (6-8 yrs)

Educational Background : Bachelor's degree in Computer Science, Information Technology, or a related field.

Role & Responsibilities :

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

- Experience with Oracle ODI.

- 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 star-schema physical models and logical modeling concepts

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

- Experience of working with ODI SNP Tables and setting up alerts for data load job failures

- Experience of working on Production Support project is an added advantage