#Matillion #ETL #CloudDatewarehouse #MatillionDataLoader
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.
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.
Course Content
- Section 1 : Introduction –> 3 lectures • 3min.
- Section 2 : Matillion Overview and Architecture –> 5 lectures • 15min.
- Initial Setup – Labs –> 8 lectures • 36min.
- Matillion Data Loader –> 3 lectures • 10min.
- Matillion UI –> 4 lectures • 21min.
- Variable –> 5 lectures • 25min.
- Matillion Job –> 21 lectures • 2hr 9min.
- Dimension SCD Type 2 in Matillion –> 1 lecture • 25min.
- Building a Datawarehouse in Matillion and Snowflake –> 1 lecture • 34min.
- Matillion for Amazon Redshift –> 2 lectures • 5min.
- Best Practises Matillion – What’s News ? –> 1 lecture • 5min.
Requirements
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.