Overall Satisfaction with Matillion
Matillion is primarily used by our Data Engineering team to produce highly curated datasets for use by our clients. We transform extensive volumes of client and vendor data into a highly clean and valuable artifact. Matillion is our primary ELT tool and has displaced a number of other tools previously used by our organization.
- Clean interface.
- Features.
- Diversity of supported data warehouse platforms.
- Ability to rapidly onboard new users.
- Support can be slow to respond.
- Minor UI irritations.
- Upgrade process is onerous, often requiring manual intervention to successfully complete.
- Git integration needs improvement.
- Matillion allowed us to increase the productivity of our data engineering team by an order of magnitude.
- Matillion created a culture of standardization within our organization: the team uses a consistent approach to working with client data that is repeatable, testable, and easily automated.
- The ability to rapidly iterate, and receive meaningful feedback from the tools, allows our teams to experiment with new approaches to working with client data.
Our initial POC demonstrated that migrating to Matillion was the logical next step for our organization. Our expectation had been six months to migrate our production loads from legacy tooling to Matillion. We were able to migrate complex production workflows, validate the result, and promote the Matillion generated artifacts in less than two months. Processing time for each workflow was cut from three days to a few hours. The productivity gains were stunning. Team members have been freed to focus on deeper and more valuable work as a direct result of our implementation.
We have direct experience with a number of ELT tools: SAS, Informatica, Pentaho, and others.
Matillion's ability to interface directly with Google BigQuery, the quality of its design, and the ability to be immediately productive made it the only product in the marketplace that we evaluated for this effort.