Ace your Data Engineer technical interview

Going through the process of interviews is quite painful.
Take a quick look at the list of questions that will make your life easier before going to a Data Engineer technical interview.
Go to the link below to check the theory part:

https://wetrustindata.com/ace_your_technical_interview_theory/

For the practical part, ensure that you will not get blocked when they will ask you some easy practical puzzle.

Try your best and have on mind that some interviewers will ask you to open a notepad or directly to make the exercise in the chat and think the solution there without any compiler(that will be the case for easy puzzles).

SQL

• BEGINNER

1. Review leetcode exercises from 175-185 to warm up.
   https://leetcode.com/problemset/?page=4

Some extra puzzles:

2. You have employee table with id and dept_id columns & department table with dept_id and dept_name columns.

List all the departments in employee table that does not exist in departments table. Make it with a JOIN condition

Python

1. Review leetcode exercises from 145-167 to warm up.
   https://leetcode.com/problemset/?page=3

https://leetcode.com/problemset/?page=4

• OBJECT ORIENTED PROGRAMMING

1. Create a class, a function and a method.
2. What is faster and why:

  max(list_1)

or

  list_1 = [1,2,3,4,5]
  for i in list_1:
    if i > count:
      count = i
    max_number = i

3. Which statement will give True?

0=None
None=null
None=False