Matillion Masterclass

#Matillion #ETL #CloudDatewarehouse #MatillionDataLoader

What you'll learn

Matillion and various product offering

How Matillion fits in cloud ETL landscape

Matillion component practicals in-depth

Cloud DWH Project using Matillion as ETL Tool and example of SCD2

Helpful in Matillion Associate Certification Journey

Requirements

Basic understanding of ETL

Basic understanding of DWH

Description

Matillion is a cloud-native data integration platform that enables organizations to extract, load and transform (ELT) data from various sources into their data warehouses, such as Amazon Redshift, Google BigQuery, and Snowflake. It is designed to help businesses accelerate their data integration processes and achieve faster time-to-insight. Matillion provides a visual, drag-and-drop interface that allows users to easily create ETL pipelines without writing any code. It also offers a range of pre-built connectors for popular data sources, including Salesforce, Google Analytics, and Facebook Ads. Matillion is a popular choice among data engineers, data analysts, and other data professionals looking to streamline their data integration workflows and increase their data agility. Its performance and integration options makes it a very popular amongst enterprises. This course is intended for Data Engineers, ETL Engineers, Data Analyst and anyone with willingness to learn Matillion and though we tried to keep it simple as possible, you might require some basic knowledge of ETL, AWS, Snowflake.In this course, Matillion Masterclass, you will learn the architecture of Matillion with in-depth hands-on exercise. When you have finished the course, you will have the skills and knowledge to work on Matillion and will assist you in your journey towards Matillion Associate Certification.

Overview

Section 1: Section 1 : Introduction

Lecture 1 Course Introduction

Lecture 2 Know your Instructor

Lecture 3 Course Download

Section 2: Section 2 : Matillion Overview and Architecture

Lecture 4 Matillion Overview

Lecture 5 What is ETL & ETL ?

Lecture 6 Matillion Product Offerings

Lecture 7 Matillion Competitors

Lecture 8 Matillion Architecture

Section 3: Initial Setup - Labs

Lecture 9 Create Free AWS Account

Lecture 10 Create Snowflake Account

Lecture 11 Create MS Azure Account

Lecture 12 MS Azure - Source SQL DB Setup

Lecture 13 Matillion Hub Account Creation

Lecture 14 Matillion Instance Setup

Lecture 15 Matillion Project Config

Lecture 16 Datwarehouse Setup

Section 4: Matillion Data Loader

Lecture 17 What is Matillion Data Loader or MDL ?

Lecture 18 Navigate to MDL

Lecture 19 Initial Load with Matillion Data Loader

Section 5: Matillion UI

Lecture 20 Matillion UI Overview

Lecture 21 Project Menu

Lecture 22 Admin Menu

Lecture 23 Certification Centric Summary - Matillion UI

Section 6: Variable

Lecture 24 What are Variables and Type of Variable in Matillion?

Lecture 25 Job Variable

Lecture 26 Environment Variable

Lecture 27 Grid Variable

Lecture 28 Automatic Variable

Section 7: Matillion Job

Lecture 29 Matillion Job and Job Types

Lecture 30 Orchestration Job and Components

Lecture 31 Transformation Job

Lecture 32 Transformation Job - Set operation

Lecture 33 Shared Job

Lecture 34 Load S3 Flat Files

Lecture 35 DDL Component Lab

Lecture 36 AWS Component Lab

Lecture 37 Load via API Component

Lecture 38 Flow Component Lab

Lecture 39 Load from Gmail

Lecture 40 Fixed Iterator

Lecture 41 Table Iterator

Lecture 42 Loop Iterator

Lecture 43 File Iterator

Lecture 44 Trasaction Component

Lecture 45 Snowflake Component

Lecture 46 Notification

Lecture 47 Error Log

Lecture 48 Data Transfer Component

Lecture 49 Certification Centric Summary - Orchestration and Transformation Job

Section 8: Dimension SCD Type 2 in Matillion

Lecture 50 SCD Type 2 Dimension using Matillion

Section 9: Building a Datawarehouse in Matillion and Snowflake

Lecture 51 Setup Source DB on Azure and create warehouse framework

Section 10: Matillion for Amazon Redshift

Lecture 52 What is Amazon Redshift

Lecture 53 Redshift as Matillion Destination warehouse

Section 11: Best Practises Matillion – What’s News ?

Lecture 54 What are Matillion Best Practise ?

Data Engineer and Analyst who wish to understand Matillion in-depth and progress toward Matillion Certification