I applied through referral link. Had applied before without it but I was rejected. The first interview is three prerecorded questions and you must record yourself. Then they sent me a technical test, a test where you could download it and do it in your local env or use the online tools they provided. The technical test was composed by two parts one coding section (python and spark) other a query. I did the test online there were some python functions you needed to complete to read some files through spark, then other functions to build a hardcoded data frame, then other functions to join that data, and other function to apply some transformations or calculations over some date fields. The functions had some test cases, you needed to do the function correctly so the test cases passed. I couldn't make all the test cases to success by some reason, so jumped to the query section, you cannot go back. The query was easy, it took me for about 15 mins finishes it, needed to use left joins instead of inner to make the test case pass for that query. I got 7.8 out of 10 points, That allowed me to get an interview with a recruter which explained me the company culture and position. Be preare because they ask you a lot of technical questions in this interview. The process continues until the technical interview, which actually I consider less heavy than the one with the recruter. The guy asked me some questions about slowly changing dimensions, my background. Asked me about a letter soup, how would I find a word in a letter soup using spark.