Matillion ETL Valuable Features

Anton Haupt
Solutions Architect at a financial services firm with 501-1,000 employees
It's very intuitive and it's super fast once the data's in the cloud. It's simple and visual, as well. I was self-taught. It's so intuitive and easy to use you can actually just teach yourself how to use it. They also have very good support with their YouTube tutorials. Those show you how to do various things if you need help figuring out aspects of the solution. View full review »
it_user628059
Senior Engineer, Big Data/Data-Warehousing at a manufacturing company with 501-1,000 employees
* It works well with AWS Redshift: I have used Informatica, SnapLogic, and Talend and they do not work well with Redshift. * Mid-pipeline data sampling: Without changes to pipelines, one can quickly and easily track down errors. * Automatic database-object verification: A fundamental part of how Matillion works is ensuring objects, tables, columns, views, and other metadata are ready and available for use if, and when, a pipeline is started. * Run-time parameters: These enable pipelines to be organized and modularized with minimum effort. * An array of source-data components: Pulling data from wide tables, such as SFDC, can be setup in seconds. Using Sqoop to pull data to S3, for example, can take hours or even weeks to get right. It is worth noting that Matillion does not cost more if you need more source-data components (SFDC, Marketo, Google AdWords, RDS, MongoDB, etc.). * A wide array of in-database DDLs and UDFs accessible from ETL are able to process unstructured data easily, without having to resort to EMR/Hadoop solutions. * Integration with other AWS services: It can use Amazon SQS or SNS very easily to extend capabilities, such as doing micro-batch imports (near real-time updates) from source-systems. * Python components using Boto and other libraries running on Matillion’s EC2: Matillion can push data from a data warehouse, via REST APIs, to target systems like DynamoDB and Marketo. View full review »
Harpreet Singh
Director of Data Architecture at a healthcare company with 51-200 employees
* It is pretty easy to learn. * No scripting is required. * Being cloud native. View full review »
Find out what your peers are saying about Matillion, Informatica, SnapLogic and others in Cloud Data Integration. Updated: November 2019.
382,196 professionals have used our research since 2012.
SeniorIn7f6d
Senior Infrastructure Engineer at a tech services company with 51-200 employees
* It is pretty user-friendly, even for people who aren't super technical. * It has good integrations with Amazon Redshift and other AWS services. View full review »
Neel Vora
Application Developer at John Deere & Company
It is cost-effective. Based on our use case, it's efficient and cheap. It saves a lot of money and our upfront costs are less. View full review »
Luis Henriquez
Hewlett Packard Enterprise Solution Architect at a tech services company with 11-50 employees
* Analytics * Integration with SAP and AWS. View full review »
Engineer2076
Lead Software Engineer at a tech vendor with 10,001+ employees
Its ease of use. View full review »
Find out what your peers are saying about Matillion, Informatica, SnapLogic and others in Cloud Data Integration. Updated: November 2019.
382,196 professionals have used our research since 2012.
Sign Up with Email