# Page 2 | Matillion Reviews 2026. Verified Reviews, Pros & Cons | Capterra > Page 2 - Is Matillion the right ETL solution for you? Explore 111 verified user reviews from people in industries like yours to make a confident choice. Source: https://www.capterra.com/p/185425/Matillion/reviews --- Matillion 4.3 (111) [View alternatives](https://www.capterra.com/p/185425/Matillion/alternatives/) Provider data verified by our Software Research team, and reviews moderated by our Reviews Verification team. [Learn more](https://www.capterra.com/our-story/) * * * Last updated March 13th, 2026 # Page 2 - Reviews of Matillion ## Showing most helpful reviews Showing 26-50 of 111 Reviews Sort by: Most Helpful Rating Company Size Reviewer's Role Length of Use Frequency of Use DK Daniel K. EVP Operations IT Information Technology and Services Used the software for: 2+ years ### "Not worth the cost compared to other alternatives now" March 20, 2026 3.0 Snowflake has added more native connectors and data ingestion features making it less appealing to go with a third-party tool. Meanwhile Matillion keeps raising their price so it's no longer competitive. Pros It's cloud-based and fairly flexible. It's good that it connects with all the common data warehouses. Cons The cost keeps ratcheting up, outpacing inflation. The environment keeps needing to be updated, and it's no longer competitive with other options. Alternatives considered [Fivetran](https://www.capterra.com/p/170147/Fivetran/) Reason for choosing Matillion Cost is based on how much data you're processing vs. how much time you are using the server. This means fivetran is not cost effective for bulk loading tasks. Switched from [Alteryx Designer](https://www.capterra.com/p/145696/Alteryx-Designer/) We still use Alteryx for detailed ETL tasks, but Matillion is way faster for bulk loading operations into Snowflake. If Matillion could build out more data transformation tools then we may consider switching entirely. Review Source RF Roger F. Software Engineer II Marketing and Advertising Used the software for: 2+ years ### "Responsive to User Needs" June 13, 2019 3.0 Gets better and better with each release. Keep up the good work! Pros I've been using Matillion for about 2 and a half years. I've seen the software improve so much in that time. If I ever found a feature to be lacking, it would be included within the next couple release cycles. The software really seems to adapt as user needs have been evolving. Some of my favorite recent features are the ability to configure some components with just text (really saves me time) and the many Grid orchestration components which allow me to greatly reduce the complexity of the orchestration jobs. Cons UX is sometimes lacking or inconsistent. For example, let's say my goal is to replace an existing job with a new job of the same name. I delete the old job, and import the new one with the same name. All Orchestration components that used that job will understand to use the new job, but for some reason the scheduler doesn't. Also, jobs will have validation errors simply because the components haven't been validated (grey borders). It can be confusing because you may be searching for an error in your work when all you actually have to do is revalidate the job. Review Source MK Melisa K. Head of Business Intelligence and Data Science Computer Software Used the software for: 2+ years ### "If you can write SQL, you don't need Matillion" November 17, 2023 3.0 Pros Early on in the company, our non technical stakeholders could learn how to set up transformations on Matillion and build them up themselves. It is good to see the transformations visually. Cons If you can write SQL and schedule them using DBT, you should do that. Trying to set up the same transformation that you write in SQL in 15 minutes will take you 60 mins with Matillion because you have to think differently when using a click-click software like this. Review Source BL Bruce L. VP, Data Engineering Computer Software Used the software for: 2+ years ### "Matillion - orchestrating complex ELT for analytics" July 8, 2019 5.0 Our business requires us to ingest large amounts of data from customers on a frequent basis. Once typical ELT has been performed, we create customized data stores which are used in a variety of ways including modeling, machine learning and a SaaS front end. Matillion has been instrumental in our ability to move this processing from file systems to Big Query where our performance has moved from days to hours. Pros \- Provides great framework for visualizing complex queries with business users that are not SQL savvy - Logical flow of Transformation builder allowed quick transformation from file based to database based ELT - Just works! We have had very few issues with the tool over the 2 years I have been using it. Cons \- Would like a more robust scheduler - Would like built-in messaging (e.g. for job failures/success) to be able to email out. This is not provided in the version for Big Query that we are running on GCS. - Better source code control (at the transformation/orchestration level, rather than the whole project) - Always could use additional documentation in how to use some of the more complex parts of Matillion. Review Source SK Sandeep K. Project Leader Information Technology and Services Used the software for: 2+ years ### "Need on the fly connectivity to different instance of Redshift" June 14, 2019 4.0 Pros I like the bunch of API integrated in Matillion it helps me to directly grab the data from different sources without manually extra and import in my database. Cons I am using Matillion for Redshift from last more than 2 years. When i setup a project in Matillion with connection to a Redshift cluster, sometimes there is a need to extract the data from other instance of Redshift while running job in Matillion. In that case there is straight forward way of getting the data from other instance of Redshift like you have comments to extract the data from databases like SQL Server, Oracle etc. instead of first i need to run another job by connection second Redshift cluster and extract the records after that run different job to load the extracted records from S3 to main Redshift cluster. Review Source VR Verified Reviewer Senior BI Specialist Media Production Used the software for: 6-12 months ### "Matillion Review" June 14, 2019 4.0 We're using Matillion for all the ETL in our environement: 3000 employees, around 500 BI users, around 30 different systems that we connected to. We were able to switch some existing jobs from Talend and create a whole lot more in just 6 minutes. Pros \+ Fast & easy to use + Completely embedded into AWS environement + Comes light, it's not overloaded with stuff no one uses + Some really innovative features Cons \- Sometimes feels like not "fully under control", e.g. when a component runs into an OutOfMemory, the whole environement crashes. And there are different ways to trigger that... - Scheduling overview could be more sophisticated, it's kind of hard to have a proper overview there - Variable handling seems sometimes to be a bit difficult, e.g. when setting it in one process, it's not always set in sub-jobs - In some cases, one can see that Matillion is still "under development": Same features are available in some components, but are missing in others Review Source UK Ujwal K. Data Programmer Marketing and Advertising Used the software for: 1-2 years ### "A powerful tool to automate complex data processes" September 4, 2023 5.0 Pros I use it on a daily basis when we process incoming client data of different types. It can be used to build extremely complex workflows to handle data. The automation done on the platform rarely broke and was really stable even during peak data transfer intervals. Cons The changes made to the workflows on the platform are saved automatically which can be tricky if you make a change by mistake. So whenever you click a wrong button or value, it will be saved unless you undo the changes made and when working with huge complex workflows it can be really time-consuming to find the source of the issue. Review Source AH Adel H. Tech Lead Engineer Marketing and Advertising Used the software for: 2+ years ### "Extremely easy to use, but hits hard limits when dealing with lots of data" June 17, 2019 2.0 Overall experience isn't so great for the price we pay. Because of our hard limits we have to pay for two instances in order to handle our job loads. That wouldn't be a problem if we were able to scale the EC2 instance the software sits on. It makes no sense why an application has a specific hardware limits. Surely if we can spin up two separate instances to run concurrent jobs that are unrelated to each other, the same principle can be applied when scaling up with more cores/memory etc. Pros The ease of use is definitely the strongest aspect of Matillion. The GUI is exceptionally intuitive and even though the application flow speaks for itself, the documentation is also great for additional support. Cons You can hit a hard limit quite fast with the hardware when working with concurrent jobs running (Java Heap issues etc). You cannot increase the size of the instance (m4.xlarge) which means it becomes increasingly difficult to optimize. We are always trying to find work-arounds with the amount of data we need to load. Review Source LM Luke M. Data Engineer Information Services Used the software for: 2+ years ### "Great data tool!" September 3, 2021 4.0 Great. Good customer service, quality product. Pros Makes for very fast development with lots of built in connectors. Visual layout of complex data pipelines is a big plus. Cons Out of memory errors. We use this for a lot of production applications. After 1 year of trying to fix OOM errors and doubling our instance size, we still get them monthly. I love matillion but I wish it were more reliable. The billing structure contributes to the problem as well. We can't run matillion on a big instance without significantly increasing our licensing fees. I wish they were independant. Review Source SM Steven M. Senior Business Intelligence Consultant Information Services Used the software for: 6-12 months ### "No Technical Customer Support. " September 3, 2021 2.0 Pros It's fast. Pipelines are easy to setup for very basic tasks. Cons Your customer support people are useless. Every time I submitted a ticket, they simply pointed to an article on the Matillion website that is not helpful in solving the problem. There is no community to resolve common issues. Troubleshooting complex tasks is almost impossible for smaller organizations. Review Source SD Susan D. Senior BI Engineer Building Materials Used the software for: 1-2 years ### "Matillion when used with Google BigQuery" June 21, 2019 4.0 We are now using Matillion as our TL tool to load into our Google Data Lake which will be the source of all our BI reporting data (replacing SQL servers). Matillion is easy to install (Google Marketplace, one click build), easy to use initially, sometimes lacks a few specialist bits (usually around new things in the Google estate), but theses can be overcome by using scripts or sql statements and I am sure some will become components in their own right. Matillion support is very good - I usually get a response within the hour Pros From an engineers point of view one of the selling points for Matillion (apart from the absolute simplicity of use - at least to start with) is that it produces its own documentation !! Cons Sometimes the error messages can be confusing , but this is often down to the messages coming from BigQuery. Its also not always obvious that it is producing SQL statement 'under the hood' and that can mean breaking sql statement size limits without realising it Review Source VC Vipul C. Data Engineer Marketing and Advertising Used the software for: 1-2 years ### "Vipul Chona - Matillion Review" September 3, 2021 4.0 Pros ease of use! someone with little code knowledge can come in and understand what's going on, it's very easy to follow along and see the transformation step by step Cons API connectors could be better. Could be more available, and a little more ease of use (especially with the endpoint mapping) Alternatives considered [Databricks](https://www.capterra.com/p/148499/Databricks/)[Fivetran](https://www.capterra.com/p/170147/Fivetran/) Review Source VR Verified Reviewer Cloud Data Engineer Health, Wellness and Fitness Used the software for: 2+ years ### "Best and very much compatible ETL for Redshift" June 25, 2019 5.0 Pros 1.)All the components and transfomrations availability 2.)Specially oriented for data ingestion process using all aws services like rds, s3, sns, redshift 3.)easy admin, ssl setup 4.)very easy diagromatical representation of jobs Cons the latest button change for "switch version" Review Source VR Verified Reviewer Director, IT Operations Computer Software Used the software for: 2+ years ### "Agile Data Engineering" June 13, 2019 5.0 We use Matillion to produce highly curated datasets for customers. Matillion has allowed us to move this workload entirely into the data warehouse where the final work product lives, and cut processing time from days to hours. Pros Matillion allowed us to move a legacy ETL pipeline to BigQuery with speed, precision, and confidence. It is now used exclusively by our team for all of our ELT needs. The user interface is clean, intuitive, and allows members of the team to be immediately productive. Onboarding new users has never been easier. Cons Feature parity between the different flavors (Redshift, Snowflake, BigQuery) is lacking, however, Matillion continues to make progress in narrowing the gap. Review Source VR Verified Reviewer BI Analyst Online Media Used the software for: 2+ years ### "First class ETL for everyone" June 24, 2019 4.0 We've been able to concentrate all data sources in one place and do a proper transformation and normalization of data to feed the Visualization layer. Pros Easy to use for non-tech (engineers) users. Cons Lacks testing stage before production and more flexibility to sample data. Review Source VR Verified Reviewer Data Engineer E-Learning Used the software for: 6-12 months ### "Matillion Review" June 13, 2019 4.0 Pros Matillion is very easy to use. It's simplicity allows you to drag an drop components to easily create orchestrations. It also simple to create shared jobs and use the components. Cons Although there is a decent set of components, they are not very versatile, hence I end up using a SQL script instead. For example, the S3 unload component does not allow one to specify some criteria and some fields are mandatory whereas I would not have to specify such specific criteria when doing this from an SQL script. Review Source VR Verified Reviewer Chief Architect Computer Software Used the software for: 2+ years ### "Is Great" June 19, 2019 4.0 Overall extract and load data strategies is very powerfull Pros Is easy and is real pay as you use, that is very important for latinoamerica business Cons That you can't write in other destinations Reason for choosing Matillion easy Review Source ME Mark E. Principal Consultant Information Technology and Services Used the software for: 6-12 months ### "A Great Cloud-based Tool" July 5, 2019 5.0 I like it overall. It is easy to quickly learn and get up to speed. It is made to work in the environment I'm working in (AWS) and has a nice, clean browser-based interface to build and schedule jobs in EC2. Email-based support is responsive. However, I sometimes feel it is too expensive compared to alternatives for the value it adds and the ELT model, while beneficial in many ways, hamstrings the component feature-set. Pros Well integrated with AWS. Great browser-based interface. Develop in the same place where the code will run, as opposed to other solutions I use that develop in Windows and run in Linux. Easy to schedule. Cons I have mixed feelings on the overall value. The hourly rate really adds up over time. This is probably my biggest misgiving. Otherwise, I sometimes get frustrated with the ELT model because it means if the feature you need isn't supported within Redshift, it's up to you to create Python scripts or Bash scripts to enable it. Review Source VR Verified Reviewer Data Engineer Computer Software Used the software for: 1-2 years ### "A good solution for a one man data shop" June 20, 2019 4.0 In the scope of a sole user, it's a very powerful tool. One can get a production ETL job up and running in hours starting from scratch. After a while, it's pretty hard to figure what is where and if more than one user contributes to the flows it can be painful to understand changes. Pros Easy to learn Visual interface Pretty reliable Cons Version control Search Explaining dependencies Review Source SM Sandeep M. Data Engineer Information Technology and Services Used the software for: 1-2 years ### "SalesLoft Matillion for Data Warehouse" June 13, 2019 5.0 Evaluating an ETL tool is quite a challenge. With a wide variety of options in the market, it is difficult to know where to start. We shortlisted three different ETL tools based on the capabilities to perform full load, incremental load with change data capture (CDC), process chains, job scheduling and monitoring, job success/failure notification to name a few most important criteria. With a very intuitive development interface, Matillion ETL for Redshift came out as a winner. Pros Quick development capabilities to perform full load, incremental load with change data capture (CDC), process chains, job scheduling and monitoring, job success/failure notification, customer support to name a few Cons Wish to see Matillion having Github control Review Source DC Despina C. BI Analyst Construction Used the software for: 1-2 years ### "MELT" June 14, 2019 4.0 Pros Easy to learn and use. The knowledge from other products is transferable. The documentation is amazing (one probably cannot understand how good without the experience). Support is always available and of good quality. Cons There is no restart-from-point-of-failure option for failed loads. Everything has to start from scratch or remaining jobs need to be run manually. Switched from [Domo](https://www.capterra.com/p/119119/Domo/) Inadequate return on investment. Review Source VR Verified Reviewer Senior Data Engineer Computer Software Used the software for: 6-12 months ### "Matiilion - Cloud based, scalable, available ELT for Big data" November 10, 2020 5.0 Overall it is user-friendly, easy to develop & deploy, secure ELT for big data use cases. It supports a lot of already built useful connectors, which helps to reduce marketability cost and time. Pros 1) Easy to use 2) Several ingestion integrations 3) Custom RDBMS ingestion support 4) Robust transformation and Orchestration components Cons No availability of change data capture feature for many databases Review Source BJ Brayden J. Associate Software Developer Transportation/Trucking/Railroad Used the software for: 6-12 months ### "Matillion ETL For Medium to Large Company" June 18, 2019 5.0 Matillion has worked incredibly well answering our business needs. We have integrated it into our core business and use it daily with nearly no issues. We began with Matillion ETL for Redshift but soon switched to Matillion ETL for Snowflake and have had incredible success with it thus far. I recommend this ETL tool to any company of any size as it can be scaled to any business needs and you only pay for what you use. Pros Matillion is easy to integrate into our snowflake system. We use it to build and create materialized tables and views, run scheduled builds, and have used it to create CDC processes. It is slick and intuitive and has a great user interface. Cons The browser and platform crashes occasionally, about once a week. The account will log you out, but it works in real time so it usually does not delete any of your work. Review Source VAC Venkata Aditya C. Data Scientist Computer Software Used the software for: Less than 6 months ### "Good ease of use, should improve customer service" June 25, 2019 5.0 With the tools given most of the business problems can be solved(not in an efficient way though if you consider SnowFlake), but there's a lot of room for improvement on the customer service side. Also, having the same functionalities for both RedShift and SnowFlake would make it a lot better, for now there are more functionalities and components for RedShift. Pros The tool was very easy to use and was intuitive most of the time. The functions and components for RedShift were amazing even though I didn't use them Cons 1\. Initially the customer service was good, calls were being scheduled either on the same day or on the next day. But once you start using it, support calls would take weeks. Sometimes support will say they'll get back to you but they don't. 2. In one particular instance, a support executive said they would get back to me because they couldn't find an immediate solution, but even after 3 weeks there was absolutely no response on their side. I got a reply after I followed up again though. 3. There are good amount of components for RedShift which are not available for SnowFlake, I hope they would incorporate them as soon as possible. Review Source DM Dana M. Director of Technology Operations Apparel & Fashion Used the software for: 6-12 months ### "Matillion is working great!" June 13, 2019 5.0 We are using Matillion to pull API JSON data from various systems and push that data into Snowflake. Matillion is working rock solid. Pros I don't have to babysit the software. Using automation and integration with AWS, I can get messages if there are issues with any orchestration jobs. Cons Getting the API pulls working was a little clunky, but it came together relatively quickly utilizing Matillion's support. Their support team is fantastic! Reason for choosing Matillion Their team really went out of their way to make sure it would meet our business objectives. They have a very good team, from sales to support, I feel confident that I am using one of the best tools out there. Matillion + Snowflake = Modern Infrastructure. Review Source Similar Products Featured