Employer Active
- India
Not Disclosed
Salary Not Disclosed
1 Vacancy
Technical experience with the development of ETL processes in the Data Warehouse Oracle environment
Experience with Oracle ODI Informatica Power Center or Power Exchange.
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 starschema physical models and logical modeling concepts
Works on APIs and frameworks to expose data for visualization and study
Full Time