# Page 3 | Matillion Reviews 2026. Verified Reviews, Pros & Cons | Capterra

> Page 3 - 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 3 - Reviews of Matillion

## Showing most helpful reviews

Showing 51-75 of 111 Reviews

Sort by:

Most Helpful

Rating

Company Size

Reviewer's Role

Length of Use

Frequency of Use

Raul G.  
CTO  
Information Technology and Services  
Used the software for: 1-2 years

### "Great tool and experience"

June 28, 2019

4.0

Great tool

Pros

Easy to use, graphical way to do data flows on Google Cloud

Cons

The most missing functionality, is to be able to setup data destinations additionally to BigQuery

Review Source

AS

Amit S.  
Data Engineer  
Computer Software  
Used the software for: 6-12 months

### "Does the job very well"

June 13, 2019

4.0

I have been using Matillion since September 2018 and at the beginning i didn't like it very much as i dont had hands on experience using Matillion. But later my work has increased a lot using Matillion. So far i have had integrated bunch of sources using Matillion to data warehouse. I am liking it at this moment and no complains.

Pros

Matillion ETL is web based ETL tool and very easy to use from anywhere. It has most of the connectors for all data sources which makes my job to complete end to end development.

Cons

One thing I did not like about Matillion is, there is no need of Transformation job. Everything should be done at one place(Should be in Orchestration job). Also, the list of components are different in Orchestration and transformation jobs.

Review Source

VR

Verified Reviewer  
Account Executive  
Information Technology and Services  
Used the software for: 1-2 years

### "Matillion is the lead in ETL space."

July 5, 2019

4.0

Matillion's cloud model is leading the trend in this industry. It's cost effective and manageable.

Pros

Matillion is the most reliable ETL/ELT tool currently. I've worked with a larger number of clients that have uses Matillion as well as other tools and Matillion is definitely the most reliable. The UI is easy to follow and understand and the learning curve is small.

Cons

The technology isn't as intuitive as others in the space. It does require some training or knowledge of workflow development though it's the most reliable.

Review Source

NY

Nels Y.  
Associate, Data & Analytics  
Hospital & Health Care  
Used the software for: 6-12 months

### "Matillion Review"

June 21, 2019

5.0

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

Pros

I appreciate the ease of use of the tool. It is very simple and intuitive to build data pipelines using Matillion.

Cons

It's necessary to perform out own server maintenance to support the tool, which isn't too difficult, but can be a pain at times. If this were a hosted solution that would be easier.

Alternatives considered

[Fivetran](https://www.capterra.com/p/170147/Fivetran/)[Stitch Labs](https://www.capterra.com/p/139349/Stitch-Labs/)

Reason for choosing Matillion

Price and ease of configuration and use

Review Source

RK

Ravi K.  
Sr. Cloud Data Engineer  
Pharmaceuticals  
Used the software for: 6-12 months

### "Review of Matillion as ETL cloud Engineer"

July 8, 2019

4.0

It was great working as well learning experience , hope Matillion will come up as industry leader.

Pros

Matillion integration with AWS services is flawless and has real time impact in batch jobs pulling data from on-premises to cloud platform.

Cons

Restricting the number of user can access Matillion, Lot's of time huge data set get stuck and fail with many other issues lastly better full log specifically for Developer to debug the issues.

Switched from

[Talend Data Fabric](https://www.capterra.com/p/118978/Data-Integration/)

It was more leadership decision.

Review Source

JB

Jesse B.  
AVP, Technology  
Marketing and Advertising  
Used the software for: 2+ years

### "Great turnkey solution to ETL and data migrations"

June 13, 2019

5.0

Pros

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.

Cons

Some threads have become unresponsive while running. This has been rare and was easy enough to resolve by resetting the service.

Review Source

VR

Verified Reviewer  
Director, Business Intelligence  
Financial Services  
Used the software for: 6-12 months

### "Starting out with Matillion"

June 13, 2019

4.0

We were trying to quickly set up multiple ETL pipeline into our Analytic Data-warehouse and Matillion did just that.

Pros

Matillion was very easy to set up, it allow us to quickly build out our ETL/ELT pipeline on AWS. GUI was easy to navigate, most default functions works well, it has the ability to connect to all of our required cloud data sources, and any custom function can be scripted using Python.

Cons

Python scripting is very limited, it is used mostly to assigned variables or run simple boto3 script. We tried using the python module to run heavy CPU data cleansing process and the software timed out.

Review Source

Amber H.  
VP Partnerships  
Computer Software  
Used the software for: 6-12 months

### "Great Company"

June 13, 2019

5.0

They have been a great company to work with. They are very transparent, quick to response, have awesome support and great training.

Pros

It's very easy to use, great training and support.

Cons

I don't have any cons. From start to end they have been great to work with.

Review Source

Jose Mari T.  
Data Architect  
Oil & Energy  
Used the software for: 6-12 months

### "Good"

July 29, 2019

5.0

Overall Matillion is good and I'm sure it could be better.

Pros

I like the stability of the product. We haven't updated our version since we started.

Cons

Can't use simple SQL Functions like CURRENT\_DATE in FIlter Component. And no Automatic Update.

Review Source

CM

Chaitanya M.  
BI Engineer  
Building Materials  
Used the software for: 1-2 years

### "Simple and easy ELT"

June 14, 2019

5.0

Very nice. Easy and simple tool. Yet a lot possible with python scripting feature.

Pros

Integration with GCP API calls and cloud storage. Easy of access from anywhere. Self documentation. Customer service. Automatic updates.

Cons

Failure capture process. Any changes made not needing to be saved. Accidental changes are considered saved at click of the button. No front end customisation available to distinguish between different environments. Having to use 3rd party add ons.

Review Source

ES

Edward S.  
Senior Software Architect  
Computer Software  
Used the software for: 6-12 months

### "Geographically disparate data to the cloud in 3 days flat"

June 13, 2019

5.0

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

Pros

\* If you've done any type of ETL work before, this will be a breeze. If you haven't it might take a few hours as opposed to minutes to get up and running \* The trial is full featured, get started today without waiting \* The software is on a EC2 instance in your own VPC in AWS. If you have company policies for how/where data can be processed -- you have complete control \* You can pay by the hour or the year, no hassle no fuss! If you do encounter an issue the support organization is amazing. All questions were answered the same day, many within the hour.

Cons

More examples to work through on the transformation components would be helpful, but again... it's pretty easy

Alternatives considered

[Fivetran](https://www.capterra.com/p/170147/Fivetran/)

Review Source

PS

PRANAVKUMAR S.  
Project Lead  
Information Technology and Services  
Used the software for: 2+ years

### "Good tool for workflow management"

July 5, 2019

5.0

I am happy with this tool and it has good UI.

Pros

\- It has very good UI to design the workflow. - It is easy to design the workflow. - It has very good support with persistence storage. Like snowflake, redshift, etc.

Cons

\- It should also support Azure data warehouse.

Reason for choosing Matillion

It is easy to learn tool.

Review Source

JS

John S.  
ICT Consultant  
Information Technology and Services  
Used the software for: Less than 6 months

### "Powerful, useful, not the easiest thing I've ever learned"

July 23, 2019

4.0

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.

Pros

Its ability to automate repetitive tasks. Also, it has some quite useful built-in database functions that I wish MySQL had -- for example a search/replace function that can use regular expressions.

Cons

It's not very intuitive and not very easy to learn (although the support team is amazingly responsive and helpful).

Review Source

OS

Oliver S.  
Data Analyst  
Leisure, Travel & Tourism  
Used the software for: 6-12 months

### "Fast track to results"

June 14, 2019

4.0

Very helpful support which takes care of all our problems, especially with "stupid" beginner questions.

Pros

Very easy to use and very easy to get results. Fast implementation cycles compared to other tools. Best is to loop over variables which enables simple but powerful solutions.

Cons

Sometimes more flexibilty on specific tasks, e.g. Excel import or csv.

Review Source

VR

Verified Reviewer  
Director of BI  
Internet  
Used the software for: 6-12 months

### "Great ETL Tool for Business Users"

June 28, 2019

5.0

Pros

Logic drag & drop of ETL steps makes the design and documentation of each ETL processes much simpler.

Cons

Getting it setup and connected to our data warehouse seemed to be unnecessarily complicated. Luckily tech support is great and helped my DevOps team throughout the process.

Alternatives considered

[Informetica LCMS](https://www.capterra.com/p/71502/Informetica-LCMS/)[Talend Data Fabric](https://www.capterra.com/p/118978/Data-Integration/)[Stitch Labs](https://www.capterra.com/p/139349/Stitch-Labs/)

Review Source

TO

Tobias O.  
Senior Enterprise Architect  
Marketing and Advertising  
Used the software for: 1-2 years

### "very good ETL Tool with some growing pains"

June 13, 2019

4.0

it helped us a lot to build our Redshift Data Lake from the Scratch

Pros

very easy to use, fast and good Customer Support, many API Connectors out of the box, well integrated in AWS Infrastructure

Cons

some Problems regarding Out of Memory lags, sometimes it's better to write custom Code instead of using the Out of the Box API Connectors (faster and more stable)

Review Source

MH

Martin H.  
Business Analyst  
Media Production  
Used the software for: 1-2 years

### "Intuitive & Flexible"

July 4, 2019

4.0

Pros

I love the GUI that Matillion employs - it makes creating and adjusting tasks very simple and transparent.

Cons

The scheduling of tasks is a little tricky, as we have to separately have to schedule the virtual machine to fire up and down. Once this is done though, it works faultlessly.

Review Source

DSS

Deepaank Satyam S.  
Sr. Associate  
Information Technology and Services  
Used the software for: 2+ years

### "Great product for handling big data flow automation"

June 13, 2019

5.0

Pros

This tool helps in automating etl process.

Cons

Integration with python is limited. Need this feature

Review Source

PS

Prashanta S.  
Senior Business Intelligence Enginner  
Hospital & Health Care  
Used the software for: 1-2 years

### "Simple easy-to-use Interface but looks like a development in progress software"

June 13, 2019

3.0

Pros

Simple with not a lot of unnecessary components. Very easy to use with Amazon Redshift.

Cons

Licensing mechanism not good. We had problem when trying to increase license to 6 person from 5. Integrating with Git or other source control tool not easy.

Review Source

SS

Sudheer S.  
Dat Architect  
Computer Software  
Used the software for: 1-2 years

### "Great ELT tool "

July 9, 2019

5.0

We use Matillion ELT to manage Data Warehouse. Support team provides consistent work around for issues.

Pros

Connectivity to Saas sources. Reliability and Customer Support team

Cons

RSD creation for Saas sources that do not have built in connector.

Review Source

JW

Jagdish W.  
Senior software engineer  
Computer Software  
Used the software for: 1-2 years

### "User friendly and Advance connectors "

June 13, 2019

4.0

I was developed around 20 to 50 mapping using Matillion and I don't see any difficulties right know.

Pros

User interface is very easy and any one can mange development things without too much of knowledge. Matillion have very content on official site and It help's a lot to make hands on on this tool. In few click we can connect any database weather it is on premises or cloud. I have extracted data from different source system and loaded in to redshift in very easy and fast manner.

Cons

I don't see straight forward job Audit framework. Please try to build nice job monitoring and audit framework.

Reason for choosing Matillion

We have redshift database and we gone through the Matillion ETL features. It is easily available on AWS market place and It won't need too much effort to installed. Any one can manage admin part easily. It has lot of functionality and we can easily build critical business things.

Review Source

VM

Vishant M.  
Sr Developer  
Marketing and Advertising  
Used the software for: 1-2 years

### "Easy to use features"

July 2, 2019

4.0

Pros

Inbuild features to integrate with AWS s3, send SNS messages.

Cons

Readability should be more, ease to retain changes or navigate to environment variables should improve.

Reason for choosing Matillion

Good features , Good price

Review Source

LP

Lee P.  
SQL BI Developer  
Information Technology and Services  
Used the software for: 1-2 years

### "Using Matillion with AWS Redshift"

June 14, 2019

5.0

Pros

Easy to understand and follow processes. Easy to pass variable values between jobs. Works well with Redshift and S3.

Cons

Use of API's can be a little confusing to setup/configure.

Review Source

KS

Karan S.  
Data Scientist  
Hospital & Health Care  
Used the software for: 1-2 years

### "Matillion Review - Excellent overall"

July 16, 2019

5.0

Pros

Ease of Use and excellent support which makes this software likely to use in comparison to other ELT tools.

Cons

Does not compatibility with Genetics connector like VCF or BAM

Review Source

pJ

payal J.  
ETL developer  
Information Technology and Services  
Used the software for: Less than 6 months

### "Reviews\_ByPayal"

September 1, 2021

5.0

Overall Good

Pros

Easy to Use , Easy to Understand , Drag and drop features , Help with all components really helpful

Cons

Less Features as compared to TOS , All features not there as per documentation

Review Source

Similar Products

Featured