MySQL data staging transforms

We are currently looking for some help to develop a data staging process to replace our existing hard coded system. There are four main source tables that are used to produce 3 tables for each of 5 clients and one main table. Additional clients may be added in the future. There are currently about 1000 testers that send data to the source tables. The utility is to take the raw data and produce the output tables that are used for various reports. In the future, we may want to connect with other data sources like Zoho and Zendesk.

More details to be provided later.