This solution does only focus on the "E" part. But is does open up the possibilities of how you can handle transformations. Loading into a Data Warehouse is optional.