Item: Matillion
Rating: 7
Author: Verified User

Use Cases and Deployment Scope

Matillion is used by the data engineering team in order to build most of our data warehouse.

Pros and Cons

Development speed
Number of connectors
Load/unload speed

GIT integration
CI/CD integrations
Failure messaging

Return on Investment

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.

Usability

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.

Scalability

It's not horizontally scalable, not distributed, offers few EC2 choices.

Alternatives Considered

SQL Server Integration Services, Stitch and a Talend company

It's browser-based and well suited for snowflake and redshift DWH. Matillion is Python-scripting friendly.

Likelihood to Recommend

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.

Good stepping stone for data infrastructure

Overall Satisfaction with Matillion