ETL made easy for non-programmers
Updated January 05, 2021

ETL made easy for non-programmers

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Matillion

We use Matillion for Redshift to ETL data from various sources into our data warehouse which is used across the organization with the desire to share it with external users in the market too. It allows us to seamlessly integrate within the AWS stack and even outside so we don't have to think twice about whether we will be able to ingest data from any new source.
  • Components available to do work with any source
  • Ability to connect to sources without preconfigured component with extensability
  • Able to kick off jobs from SNS, SQS
  • There are so many options that the learning curve could be long for a newbie
  • Can only parallelize the load in 16 partitions so it can't make use of parallelism of Redshift
  • Menu items for admins may not always work and would have to resort to shell scripting (offered)
  • Allows quick development and deployment
Matillion makes it easy for novices to quickly perform data movement and create transformations.
We have a 24 node Redshift cluster but COPY can utilize only 16 multi-part upload due to Matillion which is annoying.
Matillion is purely cloud solution versus Informatica Cloud still requires PowerCenter to do any serious transformation work.
ETL development can happen without much programming using graphical ETL dev tools and Matillion makes it simple. If data movement is what your organization needs then Matillion is your tool. If you need heavy programming for most performant or reusability then Matillion is not very useful.

Matillion Feature Ratings

Connect to traditional data sources
10
Connecto to Big Data and NoSQL
10
Simple transformations
10
Complex transformations
9
Not Rated
Data model creation
Not Rated
Collaboration
Not Rated
Testing and debugging
Not Rated
feature 1
Not Rated