Good stepping stone for data infrastructure
September 17, 2020

Good stepping stone for data infrastructure

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

Overall Satisfaction with Matillion

Matillion is used by the data engineering team in order to build most of our data warehouse.
  • Development speed
  • Number of connectors
  • Load/unload speed
  • GIT integration
  • CI/CD integrations
  • Failure messaging
  • Not a high ROI, as it is a high-priced service--more even for start-ups
  • Jobs can get done fast. Delivering is a plus. Reports are made faster.
  • It requires infrastructure monitoring, another "hidden" cost.
Matillion is not as robust as SSIS, but it has nice features.
It has to be taken into account that the learning curve is high. It is a new tool that requires some understanding about its myriad of functionalities. However, jobs and ETLs can be done fast after getting a grasp on its components.
It's not horizontally scalable, not distributed, offers few EC2 choices.
It's browser-based and well suited for snowflake and redshift DWH. Matillion is Python-scripting friendly.
Matillion is well suited for small teams that require fast and graphic development of dataflow jobs. Not so great with its support (it might take several days to get any response and that is not good when pipelines are business critical). When it comes to orchestration of big teams working with GIT, it can become a nightmare: single-lined big jsons not specifying what work was done.

Matillion Feature Ratings

Connect to traditional data sources
Connecto to Big Data and NoSQL
Simple transformations
Complex transformations
Business rules and workflow
Testing and debugging