Solutions

Training Let’s Build Long‑lasting Data Solutions Together

Training

Matillion

Module 1:

  • Matillion: What, Why, and How
    • Overview & quick introduction
  • Matillion Offerings & Product Overview
    • Different products & Detailing
  • Architectural Components
    • Enterprise Architecture Walkthrough [Single/Clustered Instance]
  • Set up: Ways to Launch Matillion Instance
    • Through AWS Marketplace, Cloud Formation Templates
  • Matillion From Developers Eye
    • UI Detailing
  • Let’s Setup the Project & Workspace
    • Project Setup& Options

Module 2:

  • Experience Building your First Pipeline with Matillion
    • Create sample Transformation Job
  • Orchestrating your ETL Pipeline
    • Orchestrating your Transformation Job
  • Explore Basic Features
    • Must-know features & development practices
  • Using the Grid Variables
    • Grid variables with Examples
  • Reusability with Shared Jobs
    • Example of shared job
  • Parameterization

Passing local/global variables and values during run time

Module 3:

  • Administration with Matillion
    • Basic Administration in Matillion
  • Cloud-native Query Components & Example
    • Sample example to pull documents from Couchbase or any other cloud service
  • Do more in Matillion with SNS, Cloud Watch and SQS
    • SNS & Cloud Watch example
  • CRM-native Components & Example
    • Using any one of CRM components to fetch data
  • Using Internet Family Components
    • Using any Internet components
  • Explore Social Network Components
    • Pulling data from Social media

Module 4:

  • Advance Features
    • Working with Struct & Array
    • Change Data Capture (CDC)
    • APIs Integration
    • GIT Integration
    • Job Scheduling
    • Snowflake Orchestration: Data Insert/Data Extraction/DWH management.

N.B: This module can be also offered along with Matillion for Redshift / Matillion for Big Query/ Matillion for Azure Synapse

Get in Touch

Let’s talk. We will get in touch within 1 business day. No obligation and we don’t share your data with anyone