Candidate must be a freelancer, available to start working in the next 2 to 3 weeks on full time basis (8 hrs a day).
The project duration is 3 months with good chances of becoming a permanent position depending on the project results.
The project is a database migration. The existing infrastructure has been developed with real-time application databases in mind, not data analysis. Queries were initially run on a ‘production follower’ and later, as the need for data analysis grew, first on a separate database and more recently on a dedicated Redshift data warehouse that contains a subset of the application data, stored in a different schema. As a result, data consumers have to query up to three different databases for analysis, with a different syntax for each.