Matillion ETL Valuable Features
The most valuable feature is the ability to put together pipelines that push down all of the logic into Snowflake. So none of the actual execution or none of the data you need to travel through. But we can do it in a GUI-based system, which is a lot easier to hand over to end-users. Most end-users, in my opinion, have an easier understanding of GUI-based tools than code-based tools. And Matillion just has a whole load of features that assist with that, they get integration allowing you to have the exact same as slow but apply it to different environments or push code changes through two different environments is really useful. And their ability to leverage different forms of iterators over variables control tables, etcetera, so that you can orchestrate a whole variety of things in one go instead of having to kind of train them up.
PH
Paul Hoc
Senior Data Engineer Consultant at a tech company with 201-500 employees
The positive aspect of this solution is that it provides a graphical interface for jobs. Another advantage of Matillion is its extensibility; if something is missing, it can be easily adjusted or custom components can be written. What I really appreciate about Matillion is that it allows us to schedule jobs, so we can track and monitor their execution on a daily basis. I also like how the solution is organized in Matillion; everything is clear and visible, and we can easily access any details we are interested in. Additionally, there is a useful feature for reporting errors, so we don't have to worry about error handling within the jobs themselves. This feature is very convenient as it saves a lot of time and effort.
Matillion ETL has great Git integration that is perfect and convenient to use.
View full review »It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth. Its simplicity is such that one only needs a basic understanding of ETL processes to become proficient. With a plethora of connectors available, it seamlessly integrates with various data sources. Moreover, its native integration with AWS enhances its efficiency, utilizing lightweight instances and pushing processing tasks to registered instances, resulting in swift performance.
Buyer's Guide
Matillion ETL
March 2024
Learn what your peers think about Matillion ETL. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
763,778 professionals have used our research since 2012.
MG
Michael Grayson
Director of IT Operations at a financial services firm with 10,001+ employees
We have a lot of user-created excel spreadsheets. Matillion works very dynamically when it comes to fetching out data changes. It uses the metadata in the Excel document to map everything to your Snowflake which no other ETL can do. It cuts down the redundancy of remapping everything whenever somebody makes a change, especially while dealing with client-created files.
It's been able to do everything we require. It could fetch Excel files, SLS files, etc. It's pretty dynamic. I would say I am happy with their features.
View full review »
The most valuable feature of Matillion ETL is the ETL. The solution is open-source which provides advantages, such as good performance and high efficiency. Additionally, it supports three data types which eliminates predefining the data, and we can write script models in Python.
View full review »The product has a good user interface. I don’t have to write too many codes. I can design or create general data transfer and technical jobs through simple texts. If I want to repeat a job, I can do it without creating multiple pipelines. I can create multiple jobs with a single pipeline. It is a fantastic feature of the product.
View full review »SK
reviewer2132352
Data Engineer
The most valuable feature of Matillion ETL is its ease of use. If you have had some experience with other solutions, such as Snowflake, the use of this solution will be simple.
View full review »The most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation.
View full review »The most valuable feature of Matillion ETL is its user-friendly graphical interface.
View full review »PT
business811623
Data analyst at a tech services company with 51-200 employees
The tool's middle-dimensional structure significantly simplifies obtaining the right data at the appropriate level. This feature makes deploying our applications easier since we utilize a single source without publishing data from various sources. Consequently, presenting data becomes more straightforward, and customer interactions involve no copying or pasting, streamlining the exchange process.
With Matillion ETL, we read data from different warehouse source systems. We create a unified version of the data in the data warehouse using the ETL functionality. Mapping tables address the challenges of different source systems, ensuring the data is at the correct level of detail. It is very strong and comes with much functionality, including monitoring.
View full review »AH
Anton Haupt
Data Architect at Old Mutual Life Assurance Company (South Africa) Limited
The interface is very intuitive.
Buyer's Guide
Matillion ETL
March 2024
Learn what your peers think about Matillion ETL. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
763,778 professionals have used our research since 2012.