Birlasoft
Location
Pune | India
Job description
ODI ETL Developer/Lead
IT Experience 4 to 8 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
Job tags
Salary