Data Warehousing w/ Matillion ETL For Amazon Redshift

  • Richard Thelwell
  • March 21, 2016

UK-based Big Data consultancy Sirocco Systems recently conducted an independent study on how to quickly and easily build a data warehouse, using Matillion ETL for Amazon Redshift.

Are you evaluating data warehousing using Amazon Redshift? Want to find out how Matillion ETL for Amazon Redshift can help? And how it stacks up against the competition?

Check out this brilliant piece from Sirocco Systems Technical Architect, Peter Carpenter.

This article provides a step-by-step analysis of how to get started with Matillion, how to correctly configure the tool for optimum performance, and how to build orchestration and transformation jobs.


An independent study of Matillion ETL for Amazon Redshift

So how did this product evaluation come about?

Carpenter explains ‘We were recently asked by one of our customers to take a look at Matillion ETL for Amazon Redshift, with a view to potentially replacing their older and significantly more expensive ETL solution’.

‘We performed a ‘thin slice’ PoC to see if we could use it to build and maintain the customer’s product dimension’ he adds.

The resulting article provides a documented evaluation of the PoC they ran.

To view the full article, click here.

Study Conclusion

Carpenter concludes that ‘Matillion ETL for Amazon Redshift comes with the right blend of tools and flexible functionality to make both greenfield DW and existing ETL migration projects fast and painless’.

In regards to setup, he adds that ‘It was very quick to get up and running with little administrative overhead’. Matillion ETL for Amazon Redshift can be launched directly from the AWS Marketplace as an AMI – you can be up and running creating jobs in a matter of minutes.

Our users are always impressed by level of support provided alongside the product. Carpenter backs this up by stating that ‘the support website provides a wealth of useful information and documentation’.

Sirocco Systems

Sirocco Systems are a UK-based IT consultancy business, specialising in ERP, Big Data, Analytics and Data Warehousing.


They are an Amazon Web Services (AWS) consulting partner and have great experience working alongside Redshift users, helping them take the pain out of IT projects.

To find out more about Sirocco Systems, visit their website here.

Or to find more great articles like this one, head over to their Blog.

Learn more about Matillion ETL for Amazon Redshift

If you like the look of what you see and would like to find out more about Matillion ETL for Amazon Redshift, visit the product page here.

Matillion ETl for Redshift

Matillion ETL for Amazon Redshift enables organizations to simplify data loading, transformation and orchestration in Amazon Redshift. It’s a modern ETL/ELT tool built specifically for Amazon Redshift, delivered as an AMI on the AWS Marketplace.

Request a free personalised demo today, to see the product in action.

Alternatively, you can start a free 14 day trial of Matillion ETL for Amazon Redshift, direct from the AWS Marketplace.