A quick impression on Matillion from a junior data engineer/analyst
June 06, 2019

A quick impression on Matillion from a junior data engineer/analyst

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

Overall Satisfaction with Matillion

Matillion is being used by my department, and we use it as our main ETL tool daily.
  • Makes it easy to design ETL pipelines because of the "drag-and-drop" components.
  • Handles workloads nicely and seamlessly,
  • Has a wide variety of input and output sources
  • Theming or color selections (overall UI, folder and job icons, etc.) would be a nice to have feature.
  • The ability to "inspect" environment variables during the transformation/orchestration building process (similar to debugging in programming).
  • When environment variables are mentioned inside the components' parameters setting, it "invalidates" the job but the jobs would still run on executions. This might be caused by the default values of environment variables being NULL.
  • Enables average analysts to perform DIY ETL processes makes us more efficient at work.
  • Runs relatively well and handles different workloads easily, even with just an average EC2 instance.
  • Provides reliable ETL workloads, and ensures that our daily reports are up to date.
Matilion is easy to use, its documentation is easy to follow through, it has a nice and clean UI, and provides a nice collection of components to address different ETL needs.
I didn't set this up, so I can't say anything about setting Matillion up. Skimming through their documentation, I can see that it's fairly simple. An average SysAdmin would get this tested and running in under two hours (this is quite generous). As for getting started with the transformation process, users can just start designing their ETL right after logging in and selecting projects inside Matillion's environment.
This can be run on either single or clustered instances so scalability wise, this is already a good start.
By supporting a wide range of input and output components, this can be scaled across different departments where different systems are used. This is ideally hosted on AWS, which opens us up to a great world of "scalability."
Matillion is a great tool that can be used by users with technical skills ranging from average to expert (aka, it's pretty simple to build ETL jobs for your average users with basic knowledge regarding databases and data handling).

Matillion Feature Ratings

Connect to traditional data sources
9
Connecto to Big Data and NoSQL
Not Rated
Simple transformations
10
Complex transformations
8
Data model creation
7
Metadata management
7
Business rules and workflow
10
Collaboration
10
Testing and debugging
9
Integration with data quality tools
9
Integration with MDM tools
6