Data synchronization scheduled task between several cloud business applications

Overview Our company has several business applications running in the cloud: Sharepoint lists and libraries (Office365) together with Mailchimp and Freshdesk, functioning as CRM repository. These applications all store customer details (companies and contacts) separately which results in data duplication and inconsistency. Therefore, we need some background task that can keep that data synchronized and up-to-date. All the company applications are hosted in the cloud and have public (accessible from the internet) Web APIs which can be used to programmatically snychronize data: Freshdesk: [login to view URL] Mailchimp: [login to view URL] Sharepoint: [login to view URL] Desired outcomes • The company employee should update a customer record in one application, and that change should be reflected in other applications (say, every 60 minutes or less). • The company IT admin should be able to define sync rules between various applications. This admin interface can be a Sharepoint list app or even a text config file with documented syntax. Implementation remarks and details When syncing data between 2 sources, the admin can define: • The data sources: o Sharepoint list url o Mailchimp list id o Freshdesk contacts or companies • Replication type: o master-slave, defining what data source is master and what is slave o peer-to-peer, defining what data source is master in case of replication conflict i.e. same record has been changed in both apps. • What fields need to be synced (based on the data sources selected) • What fields are to be considered keys that identify the mapping between data sources • If there are no fields that can be used as keys, there should be a way to make a first time data reconciliation where a field from one data source is copied another and serves as key for future replications Preferred Technology C# .Net sync task application, scheduling realized via Azure WebJobs or Scheduler (no on-premise server). All testing should be done on developer accounts, not on the company data. We can supply test data, but the developer should signup for free trial accounts of applications listed above. Deliverables all source code and functional sync application with admin interface (either Sharepoint list or text config file, see above).