Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Matillion ETL

( Duration: 4 Days )

In Matillion ETL training course, you will learn the process to extract, migrate and transform data in the cloud using Matillion Software. In this, Matillion ETL workshop you will learn the concepts such as data export/import, scripting, audit logs, collaboration, job scheduling, version control, task management and much more through real-time scenarios.

COURSE AGENDA

1

Matillion Overview & How-To-Launch

  • Matillion: What, Why& How
  • Different Products & Detailing
  • Matillion Architecture [Single & Clustered]
  • Launch Matillionfor Snowflake [Lab]*
2

Matillion From Developers Eye

  • Matillion UI Access & Default Login
  • Setting up Project in Matillion [Lab]
  • Setting up Execution environments [Lab]
  • Matillion UI Detailing
  • Experience Building Your First Data Pipeline with Matillion [Lab]
  • Experience Building your First Transformation Job [Lab]
3

Explore Matillion for Best Development Experience

  • Development Guidelines & Standards
  • Important Features
  • Built-In Variables in Matillion
  • Scalar Variables in Matillion [Lab]
  • Grid Variables in Matillion [Lab]
  • Set Child Job values dynamically from Parent Job [Lab]
  • Using Iterator Components [Lab]
4

Get to Know Matillion More

  • Set Query Result for Grid Variable [Lab]
  • RDS MySQL with Matillion (External DataLoading) [Lab]*
  • Set Query Result for Scalar Variable [Lab]
  • Reusability with Matillion Shared Job [Lab]
5

Good to Know Features

  • Administration with Matillion UI
  • Administration with EC2 Console*
  • Common Issues & Server Log Debugging
  • Supporting Components in Matillion [Lab]
  • SCD type 2 Implementation with Matillion [Lab]
6

Still More with Matillion?

  • Working with Python Component [Lab]
  • Updating Scalar Variable value with Python
  • Updating Grid Variable value with Python
  • Working with Bash Component
  • Understanding Copied vs Shared Variable Behaviour
  • Working with Struct & Array [Lab]
  • Matillion API Basics
  • Job Scheduling
  • Git Integration

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X