After an initial hr screening I was invisted to an hour and a half on-site interview where I was asked four or five computer science and data base theoretical questions. The on-site interview was followed by a coding home assignment.
I applied online. The process took 2 months. I interviewed at KayHut (Tel Aviv-Yafo)
Interview
First interview over the phone. Second in the company, technical interview about sql, spark and databases. There was a home assignment in python, took me about 2 hours to complete.
Interview questions [1]
Question 1
What are the ways to speed up queries in database.