Item: Matillion
Rating: 10
Author: Chandana M

Use Cases and Deployment Scope

Matillion has been used to clean, integrate and transform data from multiple sources are prepare data for data visualisation to answer key business questions at our organisation. Our business problem was finding an ETL solution as we moved towards Cloud data warehouse. We right away knew Matillion is the best fit for us.

Pros and Cons

The API component is very powerful. At our company we integrated Google Analytics and custom APIs.
Easy of use. Transition from an SQL developer to learning Matillion takes less than a day!
Last but not least is the amazing support team! We tried to integrate Elastic Search using API into our warehouse but had many issues. Finally realised that Matillion has an ES component. But the journey wasn't easy either. We had weeks long conversation with the support team in resolved one issue at a time and they in fact shared their sample server for us to test on! Hands down! They were very keen on resolving our issue rather than just giving out suggestions. And they sure did!

Large complex workflows can exhaust Matillion's memory. If they can work on this, it will save us memory and time to create multiple staging/temporary tables.
It would be great if the SNS component can also include the error message when a job fails. So, as a user I don't have to login to Matillion to check the exact reason for my job failure.

Return on Investment

ROI is quite significant in terms of manual effort that went in before purchasing Matillion.
With Matillion automation, can answer multiple business questions to various stakeholders.

Usability

I can say Matillion can improve on a few things as answered in the previous question. But, I would still rate it 10 because I am completely dependent on it in my day to day activities. One of the reasons I took up a job is to be told in the interview that they were intending to purchase Matillion and they did!
Overall, Matillion is quite easy to use for any one with basic understanding of SQL. Can integrate external data sources with simple setup. For me, helps in answering all the business questions from my stakeholders with Tableau as data visualization tool.

Time to Value

Setup took about 3 or 4 days. And I was able to begin transformation process right away. All in all, less than a week!

Scalability

Likelihood to Recommend

I would 100% recommend Matillion for any business who is looking for an ETL solution for their cloud data warehouse especially Snowflake. What worked for us with Matillion is the ability to integrate our external sources (Elastic Search, Google Analytics), transform, automate and create a single data source for further data visualization.

Fell in love with Matillion in less than a week!

Overall Satisfaction with Matillion