A recruiter reached out on LinkedIn and set up an initial call to discuss my background.

Next were two phone screens:

• SQL
• Any preferred language (I picked Python)

Each phone screen was 45 minutes, and I was asked about 6-7 questions. The questions are relatively straightforward if you are comfortable with the basics.

In the coding interview, they are trying to see if you can approach the same program in two different ways: one using built-in methods and one without using built-in methods.

SQL Questions

A table schema with tables like employee, department, employee_to_projects, projects.

1. Select employees from departments where the maximum salary of the department is 40k.
2. Select employees assigned to projects.
3. Select the employee who has the maximum salary in a given department.
4. Select the employee with the second highest salary.
5. A table has two data entries every day for the number of apples and oranges sold. Write a query to get the difference between the apples and oranges sold on a given day.

Python Questions

1. Print the maximum element of a given list.
2. Print the median of a given list.
3. Print the first non-recurring element in a list.
4. Print the most recurring element in a list.
5. Greatest Common Factor.