The first step is an hour home test built with two sections.
the first is a 40 minutes SQL test with 4 different questions. joins, aggregations, window functions, indexing. Later a 20 min business test with two assignments, in the first you need to record a video of yourself answering how can you predict a purchase of an iPhone based on the data you are given. And in the second you need to do a sanity check to a data table you are given, for example, the categories were not consistent during all months.
The second stage is a Zoom interview where you are given a problem in python to solve, mine was transforming keys and values of a dictionary and avoid duplications during this transformation. later a question regarding how to solve it in SQL.
The last stage is a 3 hour home test in SQL with research and business thinking.