Matillion has met the needs of our data warehousing and ETL better than we had exptected

I like the way Matillion is set up and in most cases it's very easy to figure out what I need to do and where to find it. Sometimes it takes a little longer to figure out the solution.

We have had no issues with it scaling to do whatever has been needed. However, most of the biggest jobs that we are running only have a few tens of millions of records. As that gets bigger, we'll see how well Matillion handles it.

We also use AWS pipelines to pull data from one environment to another. It works great for a straight data copy. However, it doesn't allow much transforming of the data. Matillion provides a much better way to make transformations on the data prior to loading it into the database.