Matillion Review

iQuanti is a Digital Marketing organization, which drives strategic decisions based on a data-driven approach and for this we use Matillion as our ETL solution tool for our organization, which is consumed by our Data Management team. We have large numbers of the digital platform from which we report and analyze the performance. Matillion helps us to automate most of our reporting needs by providing connectors to digital platforms like Google Analytics, Google Adwords, Facebook, Bing, JIRA, Google BigQuery, and various Data source connectors like Postgres, SQL, MongoDB along with AWS support as SNS, S3 etc, which provides lots of flexibility in today's world.

Matillion being ELT cloud tool offers easy to implement which requires an AWS EC2 instance and licensing.
Training on Matillion and getting the development team on-board was quite a challenge. Would require immense experience to explore the core functionality of Matillion. Matillion was running with-in a week time after acquiring a license but for the development team to work efficiently it took a couple of weeks.

Yes, there were absoultely increased in reporting speed that our team was able to delivery. Intially we had our own scripting tool to generate result which took 2 weeks (around 80 hours of development time + testing time) whereas using matillion we were able to complete the development in 32-40 hours including one round of testing. I could say we were able to bring down 50% of development time. Please note this is after the team had grasp of matillion enviroment. Initial time taken was different. Also the quality of reporting improved.

While moving away from legacy system towards matillion it offered some significant cost on matillion hosting and licensing part but we were able to save some on legacy system hosting but majority of saving where on people resource which was huge cost saver for our organization. along with that team was able to deliver at much higher pace which was very important in service based organization to retain the client.

Our organization work in digital marketing industry and matillion do provides lots of connector related to digital marketers. Matillion was able to solve 90% of our data sources connection problem but there were few of the rarer sources which matillion din't provide the connection to. Hopefully thats part of their roadmap for near future. With being able to connect to most of the data source through matillion we were able to better estimate the development time vs older time, which required to study the connector before commiting any deadlines. And once the connector is available with Maitllion, most of the scaling problem was taken care by matillion.

Our team member had already the knowledge of other ETL tool in market which made us easier to transform to Matillion as ETL tool. Initally when there were more rigrous update on tool, it took us few months to understand all the different features of the product and use them. We used to reach out to support team regularly for clarity purpose and they were very helfpul. So that helped us to make most the maitllion tool. Once the team adapted to various naunces of the tool, we had internally developed a process/framework which made our onboarding process smoother.

Evaluation criteria based on cloud services supported and various out-of-box support availability.

Not Sure

There are a couple of times when Matillion support team provided its extraordinary brilliance.
I would like to point out an instance when we were trying to implement tracking & monitoring in place for scheduled jobs and Kalyan (from the Support team) helped us to implement tracking which is still very helpful for our team without manually going to individual job to check the success.
Team provided the idea of "Task History Export" and another instance of using automated variable "Matillion ID" for tracking needs.