Matillion Reviews & Insights

Score7.7 out of 10

219 Reviews and Ratings

Community insights

TrustRadius Insights for Matillion are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

Graphical User Interface: Users have praised the unique and helpful graphical user interface, which has greatly assisted in easy debugging and navigation of widgets. The visually appealing design has been noted to enhance the overall user experience, allowing for intuitive data manipulation.

Hierarchical Structure: Reviewers have found the hierarchical structure beneficial for efficiently organizing projects and pipelines on the platform. This feature helps users maintain a clear overview of their data workflows, leading to better project management and organization.

Access Control & Collaboration: The ease of access control and sharing necessary access has been highlighted by users as facilitating quick collaboration within projects. Secure sharing functionalities ensure smooth teamwork among users, promoting seamless communication and productivity.

Reviews

145 Reviews

Matillion experience

Rating: 9 out of 10

Incentivized

October 22, 2025

Use Cases and Deployment Scope

We use Matillion for data warehousing solution and building scalable and optimized pipelines to transfrom data. Also we use it to schedule the data pipelines to ensure the data refresh will happen on time.

Pros

Transform data
Inbuild toggles to use python and related libraries
Git integration

Cons

Task optimization
Memory optimization

Likelihood to Recommend

It is easy to understand and use. By simply drag and drop components we can build optimized and scalable pipelines for data warhousing solutions.

Verified User

Engineer in Engineering (201-500 employees)

Vetted Review

5 years of experience

My Matillion Review

Rating: 10 out of 10

Incentivized

October 20, 2025

Use Cases and Deployment Scope

Use Matillion to fetch data from third-party apps to our own app

Pros

Its AI is very smart and helpful
UI is pretty good, easy to use
Support is fast and useful

Cons

Support more external apps
Support more features, for example file&image download
Support more extensions, for example let end user can add some code to handle data

Likelihood to Recommend

It's is well suited to fetch data from external apps and transform it.

Verified User

Professional in Engineering (5001-10,000 employees)

Vetted Review

1 year of experience

Streamlined ETL with Powerful No-Code Capabilities

Rating: 8 out of 10

October 14, 2025

Use Cases and Deployment Scope

We use Matillion to build, manage and control our data pipelines for our various data warehouses in Snowflake data cloud platform.

Pros

Data connectivity between Source and Target Database
Manage different ETL environments
Job components for data transformation

Cons

Handle automatic saving of Jobs differently. User should have the option to ssave or discard any changes made.
External access to the execution log history in addition to see the logs from the UI.

Likelihood to Recommend

Building data pipelines in a data cloud environment using Snowflake as target database.

Souvendra Apiah

Business Intelligence Solution Architect in Information Technology at Optimum Group (201-500 employees)

Vetted Review

5 years of experience

Matillion - A great tool for building data pipelines

Rating: 9 out of 10

Incentivized

October 14, 2025

Use Cases and Deployment Scope

Matillion is used as the preferred ETL / ELT tool in our organization and has everything that we need for managing and maintaining our data warehouse in Snowflake. The built in connectors and integration with DevOps git makes pipeline creation very easy resulting in high productivity of Data Engineers. There is very detailed documentation available and Matillion support is very responsive. We have moved from a traditional on premise data warehouse to a cloud data warehouse and Matillion has made this transformation easy and sustainable.

Pros

Hundreds of connectors for easy integration with data sources
Integration with git repositories for version control and recovery of pipelines
Really good customer support

Cons

Major upgrades are frequent and require change freezes
Post upgrades, certain things require reconfiguration and fixing
Pay per hour is not the best billing mechanism as sometimes only a few minutes are needed to do some tasks

Likelihood to Recommend

Matillion is well suited to maintain and manage our layered architecture based on medallion architecture principles. It caters to most of the data sources we have in our organization and also it has version controlling and documentation capabilities built in. It also integrates nicely with cloud platforms, Azure in our case for secure connections with key vaults.
The only drawback it has is when we need real time data update as we cannot keep the VMs on all the time for cost control. But again it is not built for that purpose.

Verified User

Consultant in Information Technology (1001-5000 employees)

Vetted Review

3 years of experience

Matillion powers our BI stack

Rating: 10 out of 10

Incentivized

October 10, 2025

Use Cases and Deployment Scope

As a digital company we do have several different B2B and B2C systems. Mostly their data is about the same but as anywhere else, nothing is unified. We use Matillion in order to load all of the different source systems and transform and unify the data. It fully empowers our DWH based on AWS redshift.

Pros

Using different type of sources
Simplify SQL statements by providing an nice UI
Team collaboration between the data engineers

Cons

Template system
Data inspection playground

Likelihood to Recommend

An overwhelming system landscape with different types of databases and APIs to deal with. For generating complex SQL statements and having them nicely displayed to a full overview.

Verified User

Manager in Finance and Accounting (201-500 employees)

Vetted Review

8 years of experience

Matillion review

Rating: 8 out of 10

Incentivized

September 27, 2025

Use Cases and Deployment Scope

We use Matillion ETL as an orchestrator, source ingestor and partially as a transformation tool. We utilize its connectors to query multiple sources, organize these pulls into neat interconnected flows and run initial transformations. Additionally, we use the native Git integration to have a proper development pipeline with the CI/CD flow.

Pros

Easy to use orchestration and transformation components
A good amount of connectors for any occasion
Flexibility to create custom flows

Cons

Niche limitations on some connectors
Poorly documented connectors
Lack of features in connection to the native Git integration
No cache clearing options

Likelihood to Recommend

Great: Need to query simpler APIs, or utilize well known services such as GSheets etc.? Matillion has got some of the best and easiest to use connectors out there.

Not so great: Do you need have a competent CI/CD flow that you will be able to update / compare from Matillion as well as other sources at the same time? Good luck, you will need to be extra careful, as you might have to have a deeper dive into your servers Terminal each time you have a git conflict.

Verified User

Engineer in Engineering (201-500 employees)

Vetted Review

4 years of experience

Matillion ETL

Rating: 9 out of 10

Incentivized

September 26, 2025

Use Cases and Deployment Scope

We have a snowflake cloud data platform setup which host data from wide variety of sources and we rely on Matillion ETL to bring data from source into snowflake. Matillion gives us flexibility to connect to wide variety of sources and we built automation using Matillion and bring data into snowflake to further give business insights.

Pros

Wide variety of connectors
Easy to build Orchestration Jobs
Minimul maintenance

Cons

More target connectors to load data into other applications
Improve on Memory optimization
Improve API Connectivity configurations

Likelihood to Recommend

Matillion is a good orchestration tool to build automated ETL Pipelines and has wide variety of connectors. They offer connections to different cloud platforms. It has various connectors available which can be used to fetch data from multiple sources into different cloud data warehouse. Its a modern cloud ELT platform. Its not that great for large data loads.

Verified User

Engineer in Information Technology (1001-5000 employees)

Vetted Review

5 years of experience

ETL made easy

Rating: 9 out of 10

Incentivized

July 14, 2025

Use Cases and Deployment Scope

I use Matillion to ingest data from API sources for our POS, Inventory management system, audits and Reviews platform. The business problems that I solve are relating to sales, finance, inventory count and audit scores. All the transformation for our raw data also occur inside Matillion before loading data into the data marts

Pros

Custom API integration
Transformation
Orchestration
Pipeline logs

Cons

Change data capture
Incremental data loading
Custom API data types

Likelihood to Recommend

It is very well suited for custom API integrations and orchestrating pipelines. More built in connectors could also help. For data transformation, dbt type format which is very suitable for sql users is missing. Overall, i think Matillion is great for quick and easy pipeline orchestration and complex data transformation

Muneeb Khan

Business Intelligence Developer in Information Technology at Pur and Simple (51-200 employees)

Vetted Review

1 year of experience

Matillion a crazy tool catering to all your ETL needs

Rating: 8 out of 10

Incentivized

July 1, 2025

Use Cases and Deployment Scope

Matillion ETL is used by us to create the data pipelines to extract the data from the clients source systems and ingest it into snowflake and perform some transformations within the pipeline. Even after inserting the data to the raw layer in snowflake we create some pipelines to read the data from the raw layer and transform it for some reporting purposes and insert it into consumption layer for bi tool to read the data from there.

Pros

data ingestion from various sources
tansforming the data
easy to use
saves time and efforts

Cons

git integration needs to be improved as it stores JSON file
credit cost should be based on processing time

Likelihood to Recommend

wherever there is a need of extracting the data from multiple sources and loading the data in any data warehousing tool while performing certain transformation during the pipeline run and you don't have much coding expertise and need to save the time and efforts then Matillion is the best suited tool to do that.

Verified User

Engineer in Information Technology (501-1000 employees)

Vetted Review

1 year of experience

Matillion review

Rating: 7 out of 10

Incentivized

May 13, 2025

Use Cases and Deployment Scope

Matillion ETL is being used by our datamanagement team for the ingestion of data from our organisation into the datawarehouse in Snowflake and for transforming this data through the datawarehouse to the acces layers for our end users

Pros

Ingest data from different sources
Transforming data with easy to use modules
Easy to use webgui

Cons

Git integration now stores one big json file which is hard to added when needed
Credit cost is based on uptime of Matillion ETL, instead of processing time
Egress can be improved to more targets

Likelihood to Recommend

It is depending on the usecase. For a combination of ingestion and transformations it can be a good choice

Verified User

Team Lead (501-1000 employees)

Vetted Review

3 years of experience

Loading Reviews List....