Yajat Services
Location
Mumbai | India
Job description
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
Job tags
Salary