ODI Lead - ETL/Data Warehousing

Mandatory Skill combination: ODI Lead, Source Systems(flat files (csv and json), Oracle DB, etc.),Snowflake, Large Data IT Experience: 6 to 7 Years - Technical experience with the development of ETL processes in the Data Warehouse Oracle environment - Experience with Informatica Power Center, Power Exchange or 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 (ref:hirist.tech)

Location: Pune, IN

Posted Date: 4/24/2024