For me it was first general introduction which went fine and then they immediately invited me for the next step, which is coding where you are not allowed to take any external help includign Google. This step also went fine, cause I was gridning SQL and python. I got 2 SQL questions, quite easy and an algorithm, which I completed but with not the optimal solution. Still got a callback for the third interview, which is live coding, it requires to have the environment ready, According to my interviewer I'm about to expect data-related problems which I should solve with either Python, SQL or PySpark. That's all that I know so far.

-> Screening (just to know you, ask about your experience, etc.) -> Problem solving (1 SQL problem, 2 Python, first one was to regarding characters in string, second one was to solve a bug in already Python code) -> Live coding (so far in the email he has just mentioned to setup both Python and SQL setup) -> Project (no clue right now)