Loc : Pune, Mumbai, Noida, Chennai, Hyderabad, Bangalore
Exp : 7 Yrs to 10 Yrs
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.
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.
Job Classification
Industry: IT Services & Consulting Functional Area: IT Services & Consulting Role Category: Software Development Role: Technical Lead Employement Type: Full time