Feedback on Matillion ELT
May 22, 2019

Feedback on Matillion ELT

Srinivas Velamuri | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Overall Satisfaction with Matillion

We're exploring Matillion as an ELT tool when we migrate our workloads to the cloud. This software is not in production yet as we're still exploring. Once accepted, this software will be used in our Information Management department. This business problem that is addressed by this software is ELT.
  • Drag n Drop to build orchestration and transformation jobs
  • Simplicity
  • Pay as you Go
  • Ability to scale up and down
  • Minimal code compared to the competition
  • Cloud based
  • Ability to migrate jobs created for one platform to other easily (for e.g. from Redshift to Snowflake).
  • There is a scope of improving developer productivity by enhancing the user interface. Sometimes the UI is confusing.
  • Some times the orchestration and transformation job diagrams become very complex. Need to come up with design patterns for proper diagram preparation.
  • Pay as you model for ELT processing is appealing.
  • Easy and quick to build simple orchestration and transformation jobs.
  • Need more education material for greater adoption by the user community.
Some times the UI is confusing. Need more documentation and education material.
Simple transformation jobs are easy to build and run. We're able to build and run jobs within a week.
We only tested this product with POC workloads. The product offers vertical scaling (going for a better EC2 instance for larger workloads). However, we're not sure how the product fares when it comes to horizontal scaling.
We've our own home-grown Java based ETL application. This application calls for code changes frequently, which is not the case with Matillion.
For simple business logic, Matillion seems to fit the bill. As the business logic becomes more and more complex, Matillion has to show customers how can they build transformation jobs with complex logic.

Matillion Feature Ratings

Connect to traditional data sources
Connecto to Big Data and NoSQL
Simple transformations
Complex transformations
Metadata management
Business rules and workflow
Testing and debugging
Integration with data quality tools
Integration with MDM tools