Need help with my workflow

Here is my use case.

  1. I have a source table in mongo that defines each customer I have. I need to be able for each customer, select data from a set of DB tables in the same cluster, transform the data and send to redshift. The key to this process is each customer data is in its own location on mongodb

Any ideas