* It's very easy to start building scalable production ready ETL pipeline. * GUI is very intuitive. * Has wide variety of integrations available. *

We are trying to automate as many of our recurring tasks as possible -- things like grabbing data from an API endpoint, manipulating it for our purposes, and updating our own databases for clients. Matillion lets us do a lot of that on a regular schedule and once it's set up, our humans are free to focus on things humans are better at. I found it clunky to use at first, non-intuitive. I did not find the online documentation to be very helpful, I never did find a video tutorial that spoke to my needs, and some of the terminology ("orchestration" and "transformation") I still find a bit opaque, and the division of different types of functions into the blue and green widgets doesn't always make sense to me. But I've managed to put together a fairly complex set of components that does most of what I want it to do, no small thanks to the support team, who are fantastically responsive and offer really good, specific advice within unreasonably short time periods. Their personalized attention is very much what enabled me to get going. I went from essentially hating using Matillion to really enjoying it over the course of a month or two. I'm sure I've only scratched the surface of what it can do but it's very clever and clearly quite powerful.

Piping and transformation billions of rows of data from geographically dispersed machines into Snowflake

Matillion offers a powerful feature set within a robust UI. There are other options but none have the ease of onboarding that Matillion offers. The API adds a powerful layer to do advanced integrations.

Our experience with Matillion has been great. We've used to greatly improve and automate our data intake and transformation process.