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

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

## Showing most helpful reviews

Showing 76-100 of 111 Reviews

Sort by:

Most Helpful

Rating

Company Size

Reviewer's Role

Length of Use

Frequency of Use

HT

Hrishikesh T.  
Data Engineer  
Financial Services  
Used the software for: 1-2 years

### "Flexible and Easy to use ETL tool"

July 19, 2019

5.0

Pros

I like the use of Variables and Grid Variables that allow me to reuse jobs for different ETL workflows.

Cons

Lack of version control for the ETL code is a problem.

Review Source

Ajay C.  
Senior Software Engineer  
Insurance  
Used the software for: Less than 6 months

### "Most effective Cloud Based Data Integration And Transformation Platform"

July 8, 2022

5.0

Amazing ETL options.

Pros

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. It is the best option since it is based on pay as you go so we can pay as much as we use. This has saved me a lot of money.

Cons

There are no negatives I have noted till now all the services are top-notch and up to the industry mark. This has helped a lot of engineers and businesses transform and automate their data.

Reason for choosing Matillion

The user interface is less complex and the pricing is very cheap.

Review Source

SM

Shivkumar M.  
Solution Architect  
Information Technology and Services  
Used the software for: 1-2 years

### "For AWS one of the best tool to go for"

June 14, 2019

3.0

We are using Matillion to process real-time data

Pros

Ease of deployment Migration Multiple users Pay as you go - cost saving

Cons

Software updates cause sometimes an error

Review Source

CP

Collin P.  
DBA  
Hospital & Health Care  
Used the software for: 6-12 months

### "Great for ETL to Redshift Database"

September 3, 2021

4.0

Good experience but introduced Talend to the company because of the need to ETL to Postgres.

Pros

Does what it claims to do well.

Cons

ETL is rarely ever TO one database type.

Review Source

kH

kal H.  
Data Analyst  
E-Learning  
Used the software for: 1-2 years

### "Matillion ETL"

July 5, 2019

5.0

Pros

Ease of use Configured for AWS Redshift compatible Quick support turnaround

Cons

Not all connectors available - but new releases drop regularly

Review Source

ŁC

Łukasz C.  
BI Database architect  
Health, Wellness and Fitness  
Used the software for: 1-2 years

### "Perfect ELT Tools"

June 13, 2019

5.0

ELT, daily basis extract of data and ad-hoc tasks

Pros

Workflow Layout and clarity of all components

Cons

Environment Management, licensing model

Review Source

MG

Michael G.  
CTO  
Information Technology and Services  
Used the software for: 6-12 months

### "Best ETL tool in the market"

July 19, 2019

5.0

Pros

Matillion was the perfect solution for us. We were using another ETL tool that was great for extract and load, but did not address our transformation needs. That is where Matillion came in and was the perfect fit. The scope and scale of their transformation tools is exactly what we need to fully address our ETL needs.

Cons

There is a learning curve to Matillion. Setting it up the first time can be a bit overwhelming, but once we got it set up we were off to the races. Because of the amount of tools they have, there is a bit of a learning curve, but their documentation and support is there to help get you goin.

Review Source

AB

AnneLaure B.  
data-Scientist  
Telecommunications  
Used the software for: 6-12 months

### "Yes but .."

June 17, 2019

4.0

Data transformation, data prep for python, data analysis

Pros

stable, close to SQL, integrated in AWS, fast

Cons

No data vizualisation (impossible to outpout the data directly in excel... ) Complicated to separate between orchestration in transformation

Review Source

nS

neil S.  
Head of BI  
Aviation & Aerospace  
Used the software for: 6-12 months

### "A good choice for GUI closed based ETL "

June 17, 2019

5.0

We use the tool for creating ETL data piplines.

Pros

Easy learning Curve Simple to work with Cloud based tool Great support Very easy to support shared code due to the GUI element.

Cons

Lack of DevOps style integration Lack of release management support.

Review Source

RP

Raviteja P.  
Data Warehouse Architect  
Leisure, Travel & Tourism  
Used the software for: 6-12 months

### "New Architecture"

June 13, 2019

5.0

Pros

Data doesn't flow through Matillion, it just saves the Jobs created and use them to run jobs on the connected database

Cons

Still a newbie, Matillion is adding more and more options every day but they are not quite there yet.

Review Source

MS

Matthew S.  
Software Developer  
Biotechnology  
Used the software for: 6-12 months

### "Saved a lot of time"

June 23, 2019

4.0

We have been using Matillion for constructing data tables for analytical purposes. It is a very handy tool for doing ETL.

Pros

Matillion provides a graphical representation of any SQL query. It helps with explaining what is going on, even to people that have never used SQL before (such as my CEO). It saves me a whole lot of time from writing SQL queries by hand. What I have achieved with Matillion, I don't think I could have done manually.

Cons

Interactions with external custom APIs can be a bit of a pain, but we've always managed to get there one way or another.

Review Source

DH

Dylan H.  
Senior Developer  
Utilities  
Used the software for: Less than 6 months

### "Great product, highly recommend it"

July 7, 2019

4.0

We needed to easily get data from multiple sources into snowflake. From there we needed to be able to transform it into meaningful information, Matillion quicker, easier and cheaper than all of the other products we reviewed.

Pros

ELT rather than ETL So many data sources Easy to use Fast to learn Very helpful fast support Lovely people to deal with

Cons

Built using java, so memory leaks... I'd like to be able to use different EC2 types, maybe an R rather than an M There could be more/better instructions around some of the components I'd like them to provide a few more patterns.

Review Source

NR

Nikhil R.  
BI Consulant  
Hospital & Health Care  
Used the software for: 2+ years

### "Best UI made Redshift and Snowflake compatible Ingestion automated tool"

June 28, 2019

4.0

It is good. Used for many easy to complex jobs in our Business Intelligence and analytic platform

Pros

compatibility with AWS services. Ease of use

Cons

user accounts being hashed out and not able to login in that case

Review Source

OC

Oliver C.  
Database Developer  
Wireless  
Used the software for: 6-12 months

### "Matillion ETL Review"

June 21, 2019

4.0

Pros

Easy to use, demo, and documentation resources

Cons

There is only web app to access the software, no client tool.

Review Source

fS

felice S.  
CIO  
Financial Services  
Used the software for: Less than 6 months

### "So Far so Good"

August 31, 2021

5.0

We are loading customer data to provide reporting and analytics.

Pros

We just started using Matillion within the last six months. We have been able to get it set up and are starting to load data for our customers.

Cons

Too soon to tell, as we just started using the product. We are not yet formally in production as yet.

Review Source

AC

Arnaud C.  
Data Practice Lead  
Computer Software  
Used the software for: 6-12 months

### "Best visual ELT on the market"

July 1, 2019

4.0

Matillion helped us develop various business use cases: Ambient temperature monitoring, ERP data centralization, data quality management. Components such as change detection were really helpful.

Pros

With Matillion, you can harness the power of major cloud data warehouses in no time. What I love most is that you can give it to data engineers as well as ETL engineers with no prior experience with big data.

Cons

Error management and replay can be tricky to develop.

Review Source

DN

Daniel N.  
Data Analyst  
Education Management  
Used the software for: 1-2 years

### "Matillion ETL for Redshift"

July 7, 2019

4.0

Matillion makes building ETL pipelines easy for almost everyone in the team without extensive knowledge.

Pros

Easy to build ETL pipelines visually with flexible choice of components

Cons

In some cases, using environment variables can invalidate your ETL but it would still run.

Review Source

IR

Indy R.  
IT Manager  
Aviation & Aerospace  
Used the software for: 6-12 months

### "Matillion product review"

July 2, 2019

5.0

Pros

Target based ETL application. Cloud Native.

Cons

I would prefer it to support multiple target DBs like SQL Server, Oracle, MySQL, Redshift, Snowflake.

Reason for choosing Matillion

It was suggested by consultants.

Switched from

[PowerCenter](https://www.capterra.com/p/117/PowerCenter/)

Initial Cost

Review Source

ŁC

Łukasz C.  
Data analist  
Internet  
Used the software for: Less than 6 months

### "Great piece of software"

June 13, 2019

4.0

Importing data from different sources.

Pros

Easy to use. Easy to move a lot of different processes into one place.

Cons

Problematic API support. ESC closing windows without any warning and I lose everything I prepared in that window! More support for operations not exactly about read like elasticsearch index creation or ability to do PUT, POST and DELETE with API.

Review Source

GN

Gary N.  
Data Engineer  
Mining & Metals  
Used the software for: Less than 6 months

### "Intuitive ETL"

June 13, 2019

5.0

Speed of ETL development and templated approaches.

Pros

I could build a complete ETL process with absolutely no training at all in just a few hours. All of the components I expected to see where there, and heaps more. When I needed help - there it was!

Cons

Versioning and branching is difficult when developing, there is a total reliance on a unique component name.

Review Source

AH

Alejandro H.  
Data Analysts  
Apparel & Fashion  
Used the software for: 1-2 years

### "Fantastic Product"

June 21, 2019

5.0

Pros

The easy of use is great. Being able to easily migrate data from multiple sources into AWS is a dream.

Cons

Sometimes the error logs are not very descriptive so it can be hard to debug at times.

Review Source

BO

Brian O.  
Sr Director of Development  
Information Services  
Used the software for: Less than 6 months

### "Matillion for AWS"

June 13, 2019

4.0

Pros

Once configured, it is easy to setup a workflow in minutes. The tool has lots of easy to use features.

Cons

Search capabilities could be better. Let's say I want to search for the use of a particular object (ex: a datbase table). There does not seem to be an easy way to do that.

Review Source

LJ

Lars J.  
BI architect  
Computer Software  
Used the software for: Less than 6 months

### "Matillion and Snowflake ELT"

June 13, 2019

4.0

Building a data warehouse with AWS and Snowflake. Easy and quite fast to build ELT.

Pros

easy to get into. Orchestrations and Transformations makes it easy to build flows. Push down to Snowflake

Cons

No standalone client, no easy way to automate/generate (somegow possible with grid variables though)

Review Source

HM

Hans M.  
enterprise architect  
Utilities  
Used the software for: Less than 6 months

### "enexis case"

June 14, 2019

4.0

Pros

cloud product, GUI for ETL, responsiveness supplier, scripting & parameters, performance, ETL features, mature product knowledgeable and responsive help desk

Cons

Struggle with load balancing -> product seems not mature enough Costing Snowflake icw Redshift

Review Source

AR

Abhinav R.  
Senior Data warehouse Engineer  
Retail  
Used the software for: Less than 6 months

### "Best ETL(ELT) tool in the market for AWS Redshift"

June 21, 2019

5.0

In love with the tool, I highly recommend it. It’s perfect for the data warehouse we are building.

Pros

Easy to use. Quicker ETL. Comprehensive documentation

Cons

Nothing comes to mind. Perhaps round the clock support would be helpful, especially for customers located in Australia.

Review Source

Similar Products

Featured