Matillion ETL Other Advice

AntonHaupt - PeerSpot reviewer
Data Architect at Capitec

Overall, I would rate it nine out of ten.

View full review »
MG
Director of IT Operations at a financial services firm with 10,001+ employees

Before switching to cloud databases, you need to understand the cost of Snowflake and AWS. You need to understand the costs of porting the data over and replicating it. If you are going for Snowflake, I would 100% advise you to go for it. It helps you get where you need to be. I would rate the product ten out of ten.

View full review »
Chris Hastie - PeerSpot reviewer
Data Lead at InterWorks

The main thing to consider before using Matillion is the specific reason you want to use a tool like it. If you need a combination of data ingestion and transformation, then Matillion can be a great option. 

Additionally, if you expect to load large volumes of data that will be used across multiple avenues, Matillion is a good choice. On the other hand, if you only need data ingestion and with more manageable volumes or ingesting streams, it might be better to look at a tool like Fivetran. However, they charge you based on the volume of rows or records you ingest. So, if you ingest large volumes, your costs can rapidly increase and overtake your maintenance costs.

Overall, I would rate Matillion ETL an eight out of ten. 

View full review »
Buyer's Guide
Matillion ETL
April 2024
Learn what your peers think about Matillion ETL. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,578 professionals have used our research since 2012.
Tomáš Hronek - PeerSpot reviewer
Data Engineer at Merck

I am using the latest version of the solution. The solution's connectors saved us the most time during data transformations.

Overall, I rate the solution a nine out of ten.

View full review »
Shehab Saad - PeerSpot reviewer
Business Intelligence Manager & Data Analytics (Retail Business) at B.TECH

If the product enhances the CDC functionality, I would rate it a ten out of ten. I would recommend people to use the solution. Overall, I rate the solution a nine out of ten.

View full review »
it_user628059 - PeerSpot reviewer
Senior Engineer, Big Data/Data-Warehousing at a manufacturing company with 501-1,000 employees
  • Experiment and test it ASAP
  • Watch all the videos from Matillion
  • Join their webinar series
  • Talk with existing users

Remember, what Matillion does is simply orchestrate the required jobs. It stands back and lets Redshift do what it is good at.

View full review »
Sunny Kumar - PeerSpot reviewer
Specialist Programmer at Infosys

The decision to use Matillion ETL depends on the specific requirements. If the requirements can be met without Matillion ETL in a short amount of time, then using it would be unnecessary. However, if dealing with large data sets and frequent data migrations to and from the cloud, then Matillion ETL would be a suitable choice.

I have a lot of experience in this field of data and I was able to achieve results with Matillion ETL that I was not able to with the traditional approach. The solution is helpful for large amounts of data.

I rate Matillion ETL an eight out of ten.

View full review »
AS
Principal Consultant at Eviden France

Matillion ETL and DBT help our company by making it easy for us to build data pipelines, particularly when Snowflake was used as a data platform.

Matillion ETL helps my company automate the data pipeline and allows us to optimize data workflows.

In the context of the cloud-based data platforms, the good aspect of Matillion ETL stems from the fact that it actually runs code in the platform, which is basically like a push-down approach wherein, though our company builds the pipeline using the tool, the actual execution of those pipelines happens within Snowflake.

The product supports our company's growing data needs.

The product is integrated with Snowflake. Through a straightforward process, Matillion ETL can be degraded with Snowflake.

The integration capabilities of the tool improved our company's overall data analytics pipeline.

I am satisfied with the product interface.

The product has had an impact on my company's team productivity. It is an easy-to-use tool with a simple UI and serves as a no-code ETL solution.

I recommend the tool to those who specifically use Snowflake in their companies.

I rate the tool an eight out of ten.

View full review »
Jacques Du Preez - PeerSpot reviewer
Chief Executive Officer at Intellinexus

Overall, I would rate the solution a nine out of ten. 

View full review »
David Carbery - PeerSpot reviewer
Data Analytics Consultant at Snap Analytics

My advice to new users would be to start by going through the tutorials and working with example data. These tutorials are quite helpful in getting you familiar with the tool. Additionally, try working with data that you understand well, such as data from your previous work or a familiar dataset. This way, you can focus on learning how to use the tool without having to figure out complex data problems simultaneously. Overall, I would rate Matillion ETL a nine out of ten. It works very well.

View full review »
PH
Senior Data Engineer Consultant at a tech company with 201-500 employees

I give the solution a nine out of ten. This is one of the best solutions. Matillion ETL is closely integrated with the cloud environment, which is quite common, and thanks to that, we can take advantage of services available in AWS, GCP, and Azure. I have used a few solutions so far and this is one of the best. Everything works as expected, the tool is very intuitive, the monitoring is very well-developed, and the Git integration is great. From a developer or architect's point of view, it is quite intuitive and nice to use. Matillion ETL is one of the best.

We currently have 15 developers using the solution in our organization.

Depending on the specific case and requirements; when deciding, I would take into consideration what other options are available. From an end-user perspective, I really like Matillion ETL; it is comfortable to work with and easy to set up and maintain. The solution is not perfect, but there are no other similar solutions. The support is also very good and the integration with Git is quite nice, so it is quite flexible. Even if something is not supported out of the box, we can customize components or include Python code. It also depends on the amount of data to be processed, what kind of data it is, and the underlying database engine. There are cases where Matillion ETL makes sense, but there may be cases where it is not recommended. The solution is quite flexible, with the Snowflake dedicated version or Databricks, so we can decide which underlying data warehouse to use. If the company is GCP-related, they may not want to use Redshift, but there is an option for Bitquery. If developers prefer to use Spark, the Databricks version of Matillion ETL would be a nice option. I have been using the solution for a while and I feel comfortable with it. Compared to other tools like DataStage and Informatica, I can say a lot of good things about Matillion ETL, so it is quite convenient for us.

View full review »
HS
Director of Data Architecture at a healthcare company with 201-500 employees

Give it a shot. See how easy it is to get started with the product, because the scripting which is required is minimal. Anybody who is familiar with the SQL Server platform and with SQL scripting can easily pick it up and run with it,

Overall, it is a really good product.

View full review »
NV
Application Developer at John Deere & Company

Anybody can help to configure and train on it, learning how to use it. This will help speed up the process.

We use the AWS version only.

View full review »
it_user149223 - PeerSpot reviewer
Senior Engineer, Big-Data/Data-Warehousing at a manufacturing company with 501-1,000 employees

The mindset of the traditional ETL tools is to off-load transformation to another server/DB. This totally misses the point of MPP and especially of Redshift. Load the data into Redshift early and then transform it inside Redshift ("ELT" not "ETL"). Matillion orchestrates the loading and transformation "pipelines", then gets out of the way whilst Redshift does what it is good at (i.e. the "grunt work").

View full review »
AH
Data Architect at Old Mutual Life Assurance Company (South Africa) Limited

I would rate Matillion ETL a nine out of ten it is a very good product.

View full review »
SK
Data Engineer

For those who want a cloud-based analytics platform, I would recommend this solution.

I rate Matillion ETL an eight out of ten.

View full review »
it_user987312 - PeerSpot reviewer
Solutions Architect at a financial services firm with 501-1,000 employees

We're using the latest enterprise version of the solution with the public cloud deployment model.

They're constantly improving themselves. I'm quite pleased with the pace of the number of changes that are coming out all the time.

It's a great product and I think it's very competitive. I would recommend the solution.

I would rate the solution nine out of ten.

View full review »
PT
Data analyst at a tech services company with 51-200 employees

The tool seems to reduce complexity rather than boost performance. The overall process remains somewhat intricate. I don't think we've observed any performance improvements using my team. I rate the overall product a seven out of ten. 

View full review »
it_user635448 - PeerSpot reviewer
BI Team Lead (Warehouse) at a tech services company with 1,001-5,000 employees

Just go ahead and take advantage of the initial free period for evaluation. The on-demand price is also very competitive.

View full review »
ID
Senior Infrastructure Engineer at a tech vendor with 501-1,000 employees

It does the things that it does fairly well, but it would be nice to have some more features, like custom jobs.

Try different tools as much as you can. Make sure the different data that you are trying to sync fits in with the integration the tool provides (or at least most of them). Otherwise, you are going to be paying a lot for not using most of its features.

View full review »
MH
Data & Analytics Practitioner (BIDW, Big Data) at a computer software company with 10,001+ employees

I would recommend Matillion ETL for any cloud-based operations. 

I rate Matillion ETL an eight out of ten.

View full review »
AG
Managing Director at a tech services company with 51-200 employees

I would recommend this solution. We plan to keep providing it.

I would rate Matillion ETL an eight out of ten.

View full review »
MA
Lead Software Engineer at a tech vendor with 10,001+ employees

Ask about pricing details.

View full review »
it_user848262 - PeerSpot reviewer
Hewlett Packard Enterprise Solution Architect at a tech services company with 11-50 employees

It is perfect for when you need your data to never leave your environment using a robust tool. It also ensures the best security practices are deployed within your AWS account.

I have also integrated this solution with Microsoft Azure, but the best performance is with AWS.

View full review »
Buyer's Guide
Matillion ETL
April 2024
Learn what your peers think about Matillion ETL. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,578 professionals have used our research since 2012.