Matillion ETL Previous Solutions

Anton Haupt
Solutions Architect at a financial services firm with 501-1,000 employees
We had previously used a homegrown ETL system and used a combination of IBM Cognos and ClickView as the presentation layout. They both had their own ETL steps inside them. What we're doing now is we're taking all of the data and moving it into one central data lake warehouse, which is sitting in Redshift, and controlling all the ETL in one place, as well. We're looking to switch off the legacy products now. Essentially, I want all my data sitting in AWS and I wanted one product that could handle everything, that also needed to be lightweight. I didn't want to go with one of these big Informatica's or other similar tools that are out there, which are all licensed based and very expensive. I wanted something lightweight that was easy to use and relatively cheap. View full review »
Senior Engineer, Big Data/Data-Warehousing at a manufacturing company with 501-1,000 employees
We used Informatica, SnapLogic, and Talend. They do not work well with Redshift and they cost more. They do not understand MPP and much of what they do is outside of Redshift, i.e., not in-database. You need to put them on a bigger EC2 or buy multiple licenses and have multiple EC2s to manage, in order to get scalability. View full review »
Harpreet Singh
Director of Data Architecture at a healthcare company with 51-200 employees
We haven't used any of the on-premise solutions. What we used before was SQL Server Integration Service (SSIS), and when we were moving to the cloud, we wanted to use something that was cloud native (AWS). View full review »
Learn what your peers think about Matillion ETL. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
426,617 professionals have used our research since 2012.