Bright future.
We use Matillion as more than just your run-of-the-mill ETL tool for a newly forming secure Data Lake and Warehouse. With Matillion's sFTP and S3 components and easy to use GUI interface we are able take the "ET" of ETL to new levels by using it to drive file transfers between our many different partners and services through a fully abstracted and secure sFTP/S3 Mediation Zone (MZ). All partner and service interfaces can be programmed into Redshift tables and jobs can be created to run dynamically from these tables through the use of environmental variables. With Matillion's python and bash components we have been able to introduce non-standard - but vital - features to our workflows such as virus scanning, PGP encryption, and proprietary file compression.
Very much looking forward to where this product is heading.