1. HR Pre screening Short introduction interview with HR recruiter (20 min) Why do you want to work at deel? What do you know about deel? What is your salary expectation? What tools are you most familiar with? Are you prepared to work overtime if necessary? 2. Take home test (something around 3 hours) Hiring, contracts and Payments Node.js Express.js Sequilize ORM Transactions and Concurrency SQLite 3. Technical Interview (something around 45 min) Question 1: You need to build a relational data model to store Employees and Departments. One employee belongs to one department. One department can have multiple employees. Which tables and columns would you create? Question 2: Now the requirement changed, one employee might belong to multiple departments, and for each department that employee must have an allocation percentage associated. What do you need to change in your previous model to fit those requirements? How would you move data from the previous data model to this new data model safely in a migration(s)? Question 3: Write a SQL query to list all departments that don’t have associated employees under the many-to-many data model. Question 4: Your monitoring system is alerting that one of your endpoints is timing out. This endpoint queries the database and returns data to be displayed by a dashboard. How would you fix this problem? Question 5: You have been assigned the task of creating a company through an external API and exporting its employees. Each employee can have multiple associated resources, such as addresses and family members. How would you go about implementing this solution while taking into account the common occurrence of failures when connecting to APIs?