Amazon MWS developer – Automate order reporting via APIs to SQL database

OBJECTIVES: We want to set up a program running on an Amazon EC2 instance that calls MWS APIs to Extract, Transforms and Loads (ETL) new and updated order, seller & product (Amazon seller) data into a new (AWS) SQLdatabase on a near real time basis. In addition, we want to perform a similar function with Facebook’s Ad Insight API to update to the another table (within the same database) on a daily basis. And finally perform a simple SQL (count) query, sending the result out via an automated email (daily). Further API integration projects with other platforms possible upon successful completion of initial objective. SUMMARY We’re looking for a developer familiar with amazon MWS, to work with our business analyst to set up the required AWS cloud infrastructure, scripts and associated databases needed for this project. Writing and implementing a program/script to call on APIs (as well as setting up the needed E2C compute & RDS instances), which will allow us to use MWS’s RESTful API to update seller order data and stored on an updated record on an SQL AWS database. As an organization we lack technical knowledge and experience of working with API and associated data architecture – We looking for a developer who has gone through this process before & work with us to achieve our objective.