Matillion Snowflake 

Training Outcome In One Line: Purpose-built for Google BigQuery, Matillion provides ability to quickly load and transform data within BigQuery. Matillion visually orchestrates sophisticated data workflows with transactions, decisions, and loops.  
  • Total hours and mode: 40 hours & VILT
  • Hands-on available? – Yes
  • Technologies taught: NA
  •  Assessments or certification available? – Assessment available
  Get Enterprise Training on Matillion Snowflake for Your Teams 

12 hours

Hours of Live Training

12 Hrs

Mentoring

28 hours

Hours of Practice

23 Hrs

Batches Conducted

Request a Quote

Your Learning Advisor will get back to you within 24 hours

Organizational Benefits of Training on Matillion Snowflake

f0f695dd2bf2bc786bb42c96890217823222e2e6.png

Master Snowflake data integration

Reduce operational costs

Optimize data performance

Boost productivity

Benefit 2

Benefit 4

Request a Quote

Your Learning Advisor will get back to you within 24 hours

Course Contents:

Duration – 5 days (40 hours)

Module 1: Understanding Redshift (Designing Snowflake Tables):

  1. Data Distribution Concept
  2. Micro-partition, Time-travel and Cloning
  3. Types of tables
  4. Data Sharing and replication
  1. Query Planning and Execution Workflow
  2. Generating the Query Plan
  3. Factors Affecting the Query Performance
  4. Query Profile and system tables
  1. Brief Intro and comparison with other ETL tools/ Benefits and Cons.
  2. Difference between orchestration jobs and transformation jobs and use cases for both
  3. Data loading from various sources, Various methods of Data ingestion. Setting up
  1. Vacuum Tables Component
  2. Analyze Tables Component
  3. SQL Script Component
  4. Python Script Component
  5. SNS / SQS Message Component
  6. CloudWatch Publish Component
  7. Fixed Iterator Component
  8. Retry Component
  1. Implement SCD Type 1
  2. Implement SCD Type 2
  3. Create a Static Date Dimension
  4. Implement Sample Jobs for some Orchestration Component Use Cases
  1. Error Handling Mechanism
  2. Parameterization of variables and their usage.
  3. Other important concepts that help in optimization and smooth functioning.
  4. DDL – Create Table, Create External Table, Create Stream, Delete Table
  5. Flow –Success, Failure, Retry, If,Or
  6. Load/Unload – S3 Load/Unload, API and CRM (with Use case)
  7. Snowflake and AWS specific components.
  8. Variables – Grid Variables, Job Variables, Table Result to Grid, Query Result to Grip
  9. Read – Fixed Flow, Generate Sequence, Stream Input, Table Input
  10. Join – Unite, Join, Intersect
  11. Write – Create View, Table output, Table Update
  12. Security features
  13. The use case should cover the above
  14. Matillion Scheduling and Deployment approach (Manual and GitHub)

Request this curriculum for your organization or explore customizations.

Trainer Details 

X years experience
X batches trained
Conducted trainings at A, B, C

Why Train With Techademy? 

On-demand mentoring

1-on-1 sessions with 10,000+ industry experts 

Practical application

Hands-on labs and role-based assessments

Detailed analytics

Fine-grained insights with OneProfile 

Multiple modes

In-person, online, or blended learning 

What our learners have to say about this training 

Arun KK is a seasoned professional with over two decades of experience in the IT industry. Throughout his illustrious career, Arun has adeptly navigated diverse roles, showcasing his versatility and expertise. With a rich background in customer-facing responsibilities, as well as in delivery and operations, Arun has consistently demonstrated

-Philip Samuel

Creative copy writer

We're trusted by the best