Database and Data warehouse Engineer

COURSE DESCRIPTION

Learn the skills required to handle business events, business transactions, partner transactions and market data sets. You will be empowered to understand and work with Oracle, SQL and PL/SQL programming language to process the data. You will be processing the data sets based on the application requirement using PLSQL and INFORMATICA ETL tool. You can mappings to move data from sources to curated / target databases. You learn about Data warehouse, how to build the data warehouse and the stakeholders who gets benefited with the system. You can be proactive and productive in any company you work for as a Database and data warehouse developer. Once the data is available in curated / data warehouse, you will learn how to build visualization reports using PowerBI visualization tool.

PROGRAM PATH

• Business 101

• Communication

• RDBMS (Oracle)

• Oracle SQL

• Oracle PLSQL

• Linux and Shell Scripting to automate procedures

• Data Warehousing Concepts

• Informatica ETL Tool

• Power BI Visualization Tool

• Capstone Project

• Mentors Meeting

Learning Path

• Understand Business and Business Processes with different industries

• Organizing Data in Operational applications/system (OLTP Systems) and its attributes

• Learning Oracle RDBMS, architecture, Learning Complete SQL Language

• Learning PL/SQL Blocks, different control structures, Cursors, Stored Procedures, Functions, Triggers, Packages and populating DW schema using PL/SQL.

• Overview of Linux and Shell Scripting (File Validation and Automation focus)

• Analytical Platforms in enterprises (Data wareHousing, data lakes, Staging area, error handling, and cleansing techniques)

• Informatica ETL Tool

• Projects Capstone projects based on different industry problems (Retail & Healthcare)

Process For Payment