PostgreSQL, Node.js, Javascript

JOB DESCRIPTION: You are assigned to write the javascript code that will run on [login to view URL], which is a cloud scraping service based on [login to view URL] and store the result in a PostgreSQL database hosted on Amazon Web Services. A script has alredy been developed that is 95% finished, which outputs the data as JSON, and can be accessed through [login to view URL]’s API. Your only job in terms of working with the code is to structure it and write comments in the code according to the tables that you will create in the database (For example: /***This block of code is inserted in the name_of_table***/) and also change the column names according to the Excel-document that will be provided to you. The way you should populate the database is by writing a piece of Node.js code, utilizing the Lambda service on AWS ([login to view URL]) in order to fetch the data from Apifier's REST API, perform validation and cleansing of the data (e.g. remove duplicates with respect to your database) and store it into the database. All the info about Apifier's REST API, how to call it etc., is available on the Apifier website under the documentation page ([login to view URL]). For the database design we want you to design our database schema according to the best practices and we will send you a paper on how this has been done for another very similar service and bBefore you implement the database schema we would like to review it and understand your reasoning behind it. Information about the database needs to be well documented in terms of identification of the database, configuration files, database management system used, and schema design. I will message the applicants I find interesting and you may ask me any questions you have about the project. Once you have feel that you have the information you need I would like you to provide me with an estimate of number of hours needed to complete the project. Your estimate will need to be within +- 10% of the final invoice. I will then create a new project with the requirements and specifications of the project that we both have agreed on. You will then bid on the new project according to the price and estimate number of hours and I will award it to you. All communication should take place through [login to view URL] messaging system. SKILLS NEEDED: -PostgreSQL [login to view URL] -Webscraping -Javascript (no Jquery) WHEN TO START: Right away, the sooner the better.