Oneqsoft

Menu
Job Portal
Start Course

Matillion - Mastering Cloud Data Integration

One-Q Soft offers you complete practical and Real-time Matillion training with basic to advanced cloud concepts along with Snowflake & AWS S3 services.

Here in One-Q Soft– Our credentialed Matillion instructor teaches you how to use Matillion Software to retrieve, move, and convert data in the cloud. Through real – world scenarios, users would then learn concepts such as data export/import, script writing, audit logs, collaborative effort, job scheduling, versioning, multitasking, and more in this Matillion ETL training.

Why only One-Q Soft

  • 3200+ professionals trained on different technologies.
  • Splendid Certified and Experienced Trainers.
  • Highly Interactive & Classroom training
  • Customised complete course notes
  • Job guidance
  • Guidance on official certification

Python course overview Highlights

  • Free Demo class
  • 30 days class room training
  • Successfully trained 100+ learners
  • Customised course notes
  • Live instructor-LED Online and Classroom training
  • Real-time practical guidance
  • Doubt clarification schedules
  • Basic to advanced training
  • Interview Guidance

Matillion Course Overview

Matillion is a cloud-based ETL (Extract, Transform, Load) tool that helps businesses to extract data from a variety of sources, transform it into a consistent format, and load it into a data warehouse or data lake. Matillion is a popular choice for businesses of all sizes, as it is easy to use, scalable, and affordable.

Matillion software includes more than 20 elements for undertaking multiple services such as data read, write, and join. By using sophisticated Matillion ETL tool, users could indeed create simple and powerful ETL systems as well as schedule ETL jobs.

If you are looking for a way to improve your data quality, increase your data agility, and reduce your IT costs, Matillion is a great option.

Matillion Course Curriculum

1, Data warehouse overview

    • a. Data Warehouse Product introduction

    • b. Launching a Data Warehouse Instance

    • c. Typical Data Warehouse Architecture

  • 2, Technical concepts related to data warehousing

    • a. Data Warehouse Basics

    • b. Time Zones

    • c. File Formats

    • d. Stages

    • e. Functions/Procedures/  Sequences, etc,.

  • 3, Overview to Matillion

    • a. Matillion ETL Product Overview

    • b. Matillion architecture

    • c. Launching a Matillion ETL Instance

  • 4, Exploring the core concepts of matillion

    • a. Matillion project creation

    • b. Folder creation

  • 5, Orchestration

    • a. Adding Data Sources

    • b. Connectors

    • c. Connector Authentication

    • d. Cloud Storage

    • e. DDL

    • f. Flow Components

    • g. Generators

    • h. Messaging

    • i. Scripting

    • j. Variables

  • 6, Transformation

    • a. Transform

    • b. Join

    • c. Read

    • d. Write

  • 7, Components

    • a. Loading Data

    • b. Expression Editors

    • c. URL Safe Characters

    • d. Incremental Load Tools

  • 8, Scheduling Job

    • a. Jobs

    • b. Job Concurrency

    • c. Shared Jobs

    • d. Task Management

    • e. Generate Job Documentation

    • f. Data Lineage

  • 9, Environment

    • a. UI And Basic Functions

    • b. Enterprise Mode

    • c. Admin Menu

  • 10, Administration

    • a. Understanding about the Managing of Backups

    • b. Backups (GCP)

    • c. Backups (Azure)

  • 11, Migration

    • a. Explore on how to Import and export the Projects

    • b. Learn to perform the Import Job and Export Job