Overall Satisfaction with Matillion
Matillion is used by the Data Engineering team to load data into Amazon Redshift and to implement data transformations that produce the reporting layer of the data warehouse. The reporting layer is used across the organisation from everything from customer analytics to financial reporting.
- Loading data into Redshift using bulk load utilities.
- ELT makes use of Redshift's MPP architecture.
- Very good UI, and intuitive to use.
- Choice of Python for custom code is good as it's an easy language.
- Connectors to streaming solutions like Kafka would be a good addition.
- Some legacy component connectors are not available.
- Reduced setup, and software update costs.
- Reduced training costs due to intuitive UI and lots of good documentation and how to videos.
Set up was done in less than an hour. This is a huge saving. We ingested about 130 data sets and about developed about 60 transformation steps in 5 months with a team of 4.
Matillion is easier to set up and use. Works well for cloud data warehouses. Falls short when legacy application connectors are required, this is where Talend and Informatica have the upper hand.