LCJG-Data-Engineer-Test

Data engineer interview test for LCJG and you need to finish it within 24 hours.

Question 1 : Design database schema for the data.json

• Submit the ERD

Question 2 : Write a program by using python to get the data from data.json

• Use networok request
• Store data in sqlite3 by using the database designed in Question 1
• Submit the sqlite3 database and all the source code

Question 3: Using this data set(+) to complete the following question.

• How you work with the data set?

  • You can restore it in MySQL database by using mysqlsampledatabase.sql or
  • You can read the csv data directly

• Create analysis table for customer

  • customerNumber
  • customerName
  • phone
  • addressLine1
  • addressLine2
  • city
  • country
  • first purchase date
  • total amount of spend
  • total qty of all purchases
  • sales person id
  • sales person office code
  • avg order value

• Submit the SQL and the result data in csv format

After you finsih the test please zip them all to a single file and email to [email protected]

(+) Orginal from https://sp.mysqltutorial.org/