ETL Design and Implementation

ETL Design and Implementation

  • Course level: Advanced  
There are no active Semester Schedule for this course   Pre-registar

Description

This is a data engineering course in advance level to learn the essential concepts and implementation of an ETL framework in typical Data Warehouse environments.

COURSE OBJECTIVES

•To understand various stages in Data Warehouse  development process
•To create ETL jobs adoptable to almost any data source
•To Filter, Modify and Unite data
•To build standalone jobs that run on a schedule or based on

an event

•To make jobs more user-friendly for non-technical users

COURSE SYLLABUS

•Data Warehousing Concepts
•Data Warehousing Architecture
•Data Warehousing Design: Building Blocks
•Data Sourcing
•Script Requirements for Data Sourcing
•Metadata
•Data Integration
•File Validation
•The Staging Layer
•Business Validation Layer
•Data Warehouse Layer
•Developing ETL with SSIS
•Developing ETL with Talend
•Developing ETL with Tableau
•Testing Techniques in ETL
•Mapping examples
•Audit, Balance and Control
•Configuration Management
Registration fee :
€ 690

Target audience

  • Data Engineers
  • Database Administrators
  • IT staff
  • Computer Science and IT Students

Requirements

  • Basic understanding of SQL commands and RDBMS concepts
  • Basic knowledge on programming
  • Basic understanding of Data Warehouse Concept