# Matillion Reviews 2026. Verified Reviews, Pros & Cons | Capterra > 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 # Reviews of Matillion Ease of use 4.4 Customer Service 4.5 ## Pros and Cons in Reviews MK Melisa K Head of Business Intelligence and Data ScienceComputer Software, 51 - 200 employeesUsed the software for: More than 2 years. “It is good to see the transformations visually.“ November 17, 2023 DH Dan H IT ManagerRenewables & Environment, 51 - 200 employeesUsed the software for: 6-12 months. “When communicating with the support and billing teams, they are never around to answer.“ May 30, 2024 James M Senior AnalystConsumer Services, 51 - 200 employeesUsed the software for: More than 2 years. “Its' ability to blend a ton of out-of-the-box functionality with the ability to script custom components in Python to author our own integrations is invaluable.“ August 31, 2021 Madhankkumar S Senior Data EngineerTelecommunications, 5,001 - 10,000 employeesUsed the software for: 6-12 months. “The job monitoring functionality is limited , the scheduling and job log features could have been improved.“ February 21, 2023 James M Senior AnalystConsumer Services, 51 - 200 employeesUsed the software for: More than 2 years. “It has enabled us to build transformed data within our warehouse, use pre-authored integrations to pull data from vendors, write our own integrations to pull from vendors, and is the single tool we use along with Redshift to provide visibility to all of the data within our business. “ August 31, 2021 JD John D Sr. Data AnalystHealth, Wellness and Fitness, 11 - 50 employeesUsed the software for: Less than 6 months. “We haven't used it enough to encounter negative aspects yet but having to pay for the full amount of time the VM is up is going to be cost prohibitive for our small team.“ August 31, 2021 Ajay c Senior Software EngineerInsurance, 1,001 - 5,000 employeesUsed the software for: Less than 6 months. “The platform is very user-friendly since it is based on drag and drop functions it makes the whole process easy and can be done by anyone.“ July 8, 2022 SM Steven M Senior Business Intelligence ConsultantInformation Services, 11 - 50 employeesUsed the software for: 6-12 months. “Every time I submitted a ticket, they simply pointed to an article on the Matillion website that is not helpful in solving the problem.“ September 3, 2021 ## Showing most helpful reviews Showing 1-25 of 111 Reviews Sort by: Most Helpful Rating Company Size Reviewer's Role Length of Use Frequency of Use James M. Senior Analyst Consumer Services Used the software for: 2+ years ### "The best ELT tool on the market" August 31, 2021 5.0 Matillion is the single most important piece of software I use on a day-to-day basis. Its' ability to blend a ton of out-of-the-box functionality with the ability to script custom components in Python to author our own integrations is invaluable. It has enabled us to build transformed data within our warehouse, use pre-authored integrations to pull data from vendors, write our own integrations to pull from vendors, and is the single tool we use along with Redshift to provide visibility to all of the data within our business. I am a huge fan of Matillion and have used it in 2 different orgs. It is one of the only software tools I will champion across any org I move to. Pros \-Extremely easy deployment with cloud formation template. -Excellent pre-authored integrations that are easily extensible/customizable. -Easy to use UI to build complex transformations. -Extremely flexible logic with static and grid variables to intelligently execute jobs and branch as needed. Cons \-No automated scheduling based on dependent table updates. (This is possible to set up, but not out of the box.) -Support SLAs have gotten worse over time. Alternatives considered [Pentaho](https://www.capterra.com/p/78014/Pentaho-Business-Analytics/)[AWS Glue](https://www.capterra.com/p/234164/AWS-Glue/)[Fivetran](https://www.capterra.com/p/170147/Fivetran/) Review Source DH Dan H. IT Manager Renewables & Environment Used the software for: 6-12 months ### "As an ETL it is robust" May 30, 2024 4.0 It's not a bad product, but our team decided to portion the ETL function to an Azure-based service as they couldn't tie Matillion to our business continuity plan due to a lack of skills with this product. Pros There is a vast number of options and data connectors on offer. Cons When communicating with the support and billing teams, they are never around to answer. Phone support is useless as no one answers, and it takes a few days to get an answer via email. Took for ever to switch billing from credit card to invoicing. Reason for choosing Matillion We were sold Matillion as part of a package for a specific project; I had no say in the matter. Switched from [Data Warehouse](https://www.capterra.com/p/191919/servdata/) We needed a better, more modern, and cloud-based product. Review Source Marcus Vinícius S. Back End Developer Financial Services Used the software for: 1-2 years ### "Matillion Usability" July 5, 2019 3.0 I really like Matillion ETL but I was a bit disappointed with some of its limitations and quirks, like when Twitter updated his API all my jobs stopped working and the only thing I could do was develop everything again without using the Matillion component. When I was trying to make upsert procedures on RDS Databases, I was thrilled that the Matillion component has that option, bit it simply didn't work. It seems like these functionalities haven't got the same attention of the others, I contacted the Matillion support which is simply great and these things are still going to be fixed. When I wanted specific libraries of Python, I couldn't get it working on my instance because pip was out of date and it couldn't be updated. I tried to update and I messed up with my instance. Overall, Matillion is great, when you're creating a flow of data migration and you need to parse the data before and do some automations, but there are some cases when you need something a little more specific, that's when it becomes a pain. Pros The ease to use, Matillion has a great set of tools that make complex and difficult process more simple and fast to develop. Cons There are many tools in Matillion that doesn't have enough attention and because of that these tools are fragile, while some of them do not work. Review Source VR Verified Reviewer Senior Data Engineer Telecommunications Used the software for: 6-12 months ### "Matillion - ELT process made easy , perfect integration tool for snowflake users !" February 21, 2023 4.0 The overall experience with Matillion is good , if they compared the product with other products feature may be they could become even more better . Pros Matillion is a cloud based ELT tool and it is very easy to use . The data transfer rates are incredibly good since the product locates in cloud infrastructure and the infrastructure can be scaled up when required. Cons The connectors to other data sources are limited when compare to what other rival product are offering . The job monitoring functionality is limited , the scheduling and job log features could have been improved. The GitHub integration could have been straight forward. Alternatives considered [Talend Open Studio](https://www.capterra.com/p/246747/Talend-Open-Studio/) Reason for choosing Matillion We wanted to try out Matillion before going with Talend . Worked and built a project with Matillion after the usage of 6-7 month realized it will not suit for our future requirement and went with Talend. Review Source GL Graham L. Solution Architect Marketing and Advertising Used the software for: 2+ years ### "Easy to use solution, allowing rapid delivery of ELT processes" June 14, 2019 5.0 We came to Matillion while looking for a tool that would allow us to orchestrate our load processes for Amazon Redshift. We'd used other ETL tools previously, were blown away by how easy it was to pick up and understand Matillion. We liked the simplicity, and the fact that we could always dig into the SQL that was generated. New features are added frequently, and we usually find one or two improvements that directly impact us with each release. Their support team are also very responsive, and Matillion are always keen to help you get the most out of their software, so there's a lot of support if you want it. 2+ years later, and we're using Matillion to run all our ELT jobs across various data warehouse projects, and very happy with it. Pros \- Very intuitive design environment - super quick to learn. - Components map closely to SQL capabilities in Redshift. - Easy to view the SQL generated. - Sample, row count, and data lineage make it easy to unit test as you build. - Powerful management options via REST API (orchestration, Github integration, etc.). - Native AWS integration. - Aggressive release cycle, constantly adding new features. - Easy to document in-workflow. - Lots of third party integrations. Cons \- User concurrency/licencing model (simple, but can't be customised to fit your need). - Exception handling could be improved. - A single Task View would be helpful for multi-environment/project support. Alternatives considered [Alteryx Designer](https://www.capterra.com/p/145696/Alteryx-Designer/) Reason for choosing Matillion Simplicity, and the fact that Matillion was built specifically for Redshift, meant it was ideal for our needs. Review Source MS Michael S. Director, Business Intelligence and Web Services Higher Education Used the software for: 6-12 months ### "Great for pipelining data to warehouse/lake, not getting it back" June 13, 2019 4.0 It was easy to get set up, and it worked great for pushing data into Snowflake as a data warehouse. However, we quickly realized that we would need yet another tool to get the data back out to the source systems to synchronize/integrate it. We could sort of do it with Matillion, but it required a lot of custom programming and was not very intuitive. We ended up using a different iPaaS tool that could handle traffic/integration in both directions. Pros It is extremely fast and easy to pull data from various sources and pipe it into Snowflake. The graphic interface lets this happen without programming. Cons There is almost no ability to get data back from your warehouse into the other systems to synchronize the data. It's great to have it all in the warehouse, but it seems pretty critical to have that data flowing back to other systems that are part of your environment. The pricing model is frustrating. You are billed for when the machine instance is ON, not when it is actively doing something. So, if you have a couple hours of job that run in a day, you have to shut down the machine to save money the rest of the day. With it shut down, development can't happen. So, we had to turn it on and off all the time. It would be much better if they billed as it is used, not as it is on. Alternatives considered [SSIS Data Flow Components](https://www.capterra.com/p/196326/SSIS-Data-Flow-Components/) Reason for choosing Matillion Matillion was written for Snowflake, which is our preferred solution over MS SQL Server. Review Source JD John D. Sr. Data Analyst Health, Wellness and Fitness Used the software for: Less than 6 months ### "Just started using Matillion this week" August 31, 2021 5.0 Overall experience with Matillion has been great. The first call with \[SENSITIVE CONTENT\] set the tone of who and what Matillion can offer our company. \[SENSITIVE CONTENT\] was kind, not pushy, relatable, and truly tried to understand our use case. \[SENSITIVE CONTENT\] really sold us on proceeding with a demo after sharing some of the functionality of the MDL tool available for free in AWS marketplace. While we very much could simply use the free tool, \[SENSITIVE CONTENT\] helped us understand why we should consider the full product. Finally, \[SENSITIVE CONTENT\] was a great account rep to work with. Before our first call he had looked up our company and understood our business (which is not easy to do). We are in a sensitive are of health care and \[SENSITIVE CONTENT\] opened up and shared a personal story relating to the line of work we are in. Other companies/products we looked into and has calls with did not take the time to understand our business or empathize with our customers. The personal touch from the above folks was a nice addition to the great product Matillion offers. Pros Matillion is incredibly easy to deploy in AWS. In addition, the security and compliance aspects are all handled on the customer side due to the deployment method. The UI is easy to use and the price point was the most competitive. Cons We haven't used it enough to encounter negative aspects yet but having to pay for the full amount of time the VM is up is going to be cost prohibitive for our small team. Alternatives considered [Adverity](https://www.capterra.com/p/162524/DataTap/)[Segment](https://www.capterra.com/p/150621/Segment/)[Fivetran](https://www.capterra.com/p/170147/Fivetran/)[Stitch Labs](https://www.capterra.com/p/139349/Stitch-Labs/)[Integrate.io](https://www.capterra.com/p/153780/Xplenty/) Reason for choosing Matillion We chose Matillion over these other providers for the following reasons: - Cost (pay as you go is helpful for us to grow into the product) - Scalability - Compliance/Security - Integrations and the ability to connect to an API if the integration doesn't exist - The personal touch from the Matillion reps who we worked with Review Source AH Alexander H. Data Engineer Computer Hardware Used the software for: 1-2 years ### "Efficiency!" June 14, 2019 5.0 Satisfied! Pros The collection of components; especially the integration components that hook into a very popular CRM and another quite popular ERP. Cons The python component. Depending on the box where your instance is hosted, this component will drag along like a broken train or move at the speed of shooting star. Switched from [Informatica MDM & 360](https://www.capterra.com/p/168312/Informatica-MDM/) Less budget and client wanted a cloud based solution Review Source EB Erick B. Business System Analyst Automotive Used the software for: Less than 6 months ### "Matillion Review" June 14, 2019 4.0 Matillion is a great out of the box product with minimal requirements. You spin the machine up, allow your database's firewall to communicate with Matillion. Start creating jobs, schedule them, and sit back. It helps you focus on visualizing your data. Pros It is a pay for what you use type of software. Most other ETL platforms are a flat monthly fee, sometimes at crazy prices. The pay for what you use model makes it easy to justify cost to leadership. You can schedule jobs to make sure you maximize your time. Cons The user experience feels a little dated. Some things could be better displayed/ explained. Alternatives considered [Informatica MDM & 360](https://www.capterra.com/p/168312/Informatica-MDM/)[Alooma](https://www.capterra.com/p/161022/Alooma/)[Treasure Data Suite](https://www.capterra.com/p/173775/Treasure-Data/)[Striim](https://www.capterra.com/p/173369/Striim/)[Fivetran](https://www.capterra.com/p/170147/Fivetran/) Reason for choosing Matillion The simple price model, out of the box features, and direct load to Big Query made the decision for our ETL. Others offered similar feature but at extremely steep prices. Although they might have looked better visually the functionalities were there, but the pricing was not. Review Source Ravi V. CTO Information Technology and Services Used the software for: 6-12 months ### "Very productive toolset" August 31, 2021 5.0 We are using it to do the extract load and transfer for our data warehouse Pros \- Quick to start - Consumption based model - Works well with Snowflake Cons \- Harder to find resources with skills - Cost relatively higher Reason for choosing Matillion Feature set, cloud first approach and consumption based model Review Source KRK KOTESWAR RAO K. Senior Data Engineer Information Technology and Services Used the software for: 6-12 months ### "Matillion\_Koti\_Feedback" June 24, 2019 4.0 I like working on matillion , but this tool can be made more flexible by providing some of the additional features. Pros 1) Most of the components are user friendly. 2) Development of ETL orchestrations and transformation consumes less time. 3) Advanced features are available in some of the components makes the complex scenarios achievable. Cons 1) OAuth document does not provide the details of proper permissions and access levels on account\_id or client\_id which are required for a connector. 2) Differentiation of naming convention of metrics between the console and matillion data model , mapping document of these naming conventions is not available. 3) Connector for Outbrain is not available. 4) Indirect file loading concept is not available , for example if we have five files with same structure , reg ex can not be used to load all files in a single component(s3 load,s3 put or excel) and need to use the file iterator. 5) Loss of properties when the component configuration is changed from Basic to Advanced features , ideally the component should include all the properties of basic and then additional setting should be provided. Review Source FT Francis T. Head of BI Automotive Used the software for: 1-2 years ### "Matillion is an Easy To Leverage (ETL) solution!" June 13, 2019 4.0 Pros \- Easy to orchestrate an ETL pipeline - Integration with Redshift and other AWS services provides convenience - Support team is easy to reach and have relatively quick response times - They also support the other 2 popular cloud data warehouses, Snowflake and BigQuery - Some components are available out to the box for easy integration - Task history is useful for debugging and monitoring current state of ETL pipelines - A GUI is provided for implementing complicated workflows, that can be easily followed Cons \- Since it's mainly GUI based, it becomes difficult for data engineers to compare changes between old and new versions of an ETL. - There are hard limitations for the number of concurrent users. This is part of the pricing model which is the reason. - Integration with GIT is not yet available but we heard that it would be coming in the near future. Review Source DW David W. Data Analyst Airlines/Aviation Used the software for: 2+ years ### "Great ETL product" June 13, 2019 5.0 Pros Matillion is very intuitive. The GUI is easy to use and fairly easy to learn. The support team is great and they respond to your questions quickly. I like how the Matillion team is frequently looking to add new functionality and features. The new keyword search functionality is very helpful. Cons Matillion works great extracting data from a variety of databases and is very efficient unloading onto S3 or Amazon Redshift. However, when we attempted to use it to unload large datasets to Microsoft SQL Server it was very slow and we experienced performance issues. Review Source JE Joe E. Data Engineer Publishing Used the software for: Less than 6 months ### "Matillion for Data Engineers" June 28, 2019 4.0 An easy to use tool that has allowed me to build a fully automated data warehouse to report to the business, it was easy to learn and implement, and as difficult as SQL to master. I think the real complexity comes from optimising complex workflows, the more T you need in the ETL/ELT process, the more Matillion falls down. This being said it is a very good tool for 90% of your work. Pros It is easy to use and quick to get started, there are many inbuilt APIs and transformations that integrate it across a broad suite of systems, and enable you to transform data for the business without having to spend too much time thinking about scripts or bespoke batch files. Cons The filter transformer is pretty minimal considering the power of the SQL it is utilising, it cannot use compound logic or reference other columns/objects in the query. There is also optimisation issues in very complex workspaces. Both of these have easy to use workarounds but it is unfortunate it is not supported more at surface level. Switched from [FME](https://www.capterra.com/p/126404/FME/) I changed company Review Source MM Maksymilian M. Data Engineer Hospital & Health Care Used the software for: 1-2 years ### "Scaling with Matillion" June 13, 2019 3.0 The experience is very positive at the beginning but as the project grows and there are more and more workloads and data being processed Matillion starts to become a bottleneck. Pros It is very easy to implement features and changes to existing workload. It is very good for creating POCs Cons It is not scalable and has numerous limitations. Concurrency setting for Matillion limits the possibility of using it for multiple warehouses. It is highly insufficient when executing commands parallel and does not utilise the resources to it's full potential. The environment limitation is also very problematic when trying to scale. Review Source PC Paul C. IT Systems Administrator Sports Used the software for: 6-12 months ### "Have been using Matillion for past 9 months" June 28, 2019 4.0 We have developed Data Warehouse for our business using Matillion. We employ 6k+ people, and Matillion was a perfect match for our needs. Storing data in Google Big query allows seamless access to it from other Cloud Products I.E. Google Data Studio. I love the product, and limitless possibilities it gives us. Pulling the data from anything you may think of, transforming it and then outputting into Big Query is very easy and straight forward. Pros My background is development and I love the simplicity of the Matillion, you can very easy transform your thought process into blocks in Matillion, and debug any issues at a very granular level. Cons Matillion crashes from time to time, meaning you need to log back on to the system, but its benefits definitely outweigh this small issue. Review Source RAA Ryan Allen A. Data Engineer Insurance Used the software for: 1-2 years ### "Matillion for BigQuery - United HealthGroup Data Engineer Review" July 12, 2019 4.0 Very useful tool. If you're looking for a tool for your analytics data warehouse which is fast, convenient and easy to learn, then this is the tool for you Pros Its very easy to learn. The UI is great and easy to navigate. It utilized the ELT approach which makes the data integration fast. Security and access control is well implemented and there are a lot of components to use. Cons Its a one way ETL, I'm using the BigQuery product and all the destination are in BigQuery, it would also be nice if we can load data to the sources. Review Source BR Brian R. Enterprise Data Architect Security and Investigations Used the software for: 6-12 months ### "Making my life easier!" July 19, 2019 4.0 It's been great. The support team has been very responsive in resolving some Azure-related issues, tuning our instance, and helping to understand the nuances of how it works. It's been a significant reduction in development time since we migrated to Matillion. Pros Simple, intuitive interface. I replaced a complicated series of scripts, "ETL" products, and Python code with a simple-to-understand Matillion instance. Cons We use it on Snowflake for Azure, so there are several features that have not been migrated from the AWS version, yet. An option for a larger server by default in the Azure Marketplace. Reason for choosing Matillion Simplicity, greater feature set. Review Source RE Roger E. Solution Architect Utilities Used the software for: 1-2 years ### "Initial Feedback" June 13, 2019 3.0 Its helping us build a data warehouse for visualizing debt and customer segmentation in our business. It means we are getting real insight into our business. Thank you! Pros User interface and range of connections. Powerful capabilities. Compatibility with AWS Cons Licensing is not flexible, Why cant you specify the number of concurrent users for a given instance? It comes with a fixed amount, if you don't like it, update to a much large and expensive instance that we do not need. Review Source CL Christoph L. BI Manager Retail Used the software for: 1-2 years ### "Solution that works fine for almost all applications" July 1, 2019 4.0 If you really use your data and work on a daily basis with your data warehouse you should consider using Matillion. We had no downtimes and the service is brilliant. We connected all of our data sources and it works really well. But it got its price. Compared to other solutions the pricing is good for growing businesses. Pros Connectivity Really good customer service Individual solutions if necessary No downtimes Hosted on Amazon Cons Pretty expensive A bit hard to set up initially Review Source LS Levan S. Data Engineer Financial Services Used the software for: 1-2 years ### "Great for starting" June 17, 2019 3.0 Pros \* It's very easy to start building scalable production ready ETL pipeline. \* GUI is very intuitive. \* Has wide variety of integrations available. \* Cons \* Error handling/debugging is on a poor level. \* No good way to version queries/scripts or jobs. \* Not really suitable if you need to build something very complex, as it's not very customizable. Review Source EC Ellis C. Marketing Intelligence Analyst E-Learning Used the software for: 6-12 months ### "Very useful product" June 13, 2019 4.0 Pros The features and ease of use are good. The transformations act as a documentation for the self because of the readability. Cons The customer service is very poor. When they eventually respond to messages it is with an unhelpful response. Generally they will blame us for issues on their end, or they misunderstand the problem completely. It's not what we need from a tool The paid training we took was also pretty basic Review Source SB Spencer B. Analytics Director Marketing and Advertising Used the software for: 1-2 years ### "Excellent Product" June 13, 2019 5.0 We are able to quickly execute on ongoing ETL projects and ad hoc needs. Pros Ease of use and breadth of functionality. Cons We had a billing issue at one point when trying to renew but that was mostly due to AWS Marketplace and not Matillion as a product. Review Source CD Christopher D. Head of Business Intelligence & Analytics Wholesale Used the software for: 1-2 years ### "Great ETL Tool" June 13, 2019 4.0 Class leading, can turn a new file around in hours and days. Pros Pretty straightforward compared to other ETL tools, traditional engineers pick up in no time at all. Cons The google version is not as rich as the AWS one Review Source DL David L. Senior Software Engineer Education Management Used the software for: 6-12 months ### "A Great ELT and warehousing toolset in a clean GUI" June 16, 2019 4.0 We're pulling multiple datasets together and integrating them in star schemas with Matillion, as well as doing sophisticated data analysis. Pros The GUI and design makes it easy to not only functionalize your ELTs, but also show a graphical DAG to stakeholders. Cons I wish it had an out-of-the-box API gateway to receive webhook requests from third-party data sources. Review Source Similar Products Featured