Interview Format: 30-minute coding session on CoderPad, involving pair programming. I had to explain my solutions as I coded.
Faced 7 SQL questions, ranging from leetcode easy to medium difficulty.
Questions d'entretien [1]
Question 1
a quick rundown of all the questions-
1. count distinct
2. group by having count
3. select * from...where not in (select distinct...) using left join
6. calculate 'rate' using multiple left joins
5. dense rank (had to explain why)
6. rank + CTE + (need to ask clarifying questions)
7. CTE + (need to ask clarifying questions)
J'ai postulé en ligne. Le processus a pris 3 semaines. J'ai passé un entretien chez Block (New York, NY) en mai 2025
Entretien
Quick and to the point. Didn’t leave me guessing and I left the interview feeling like I had a fair shot at the job. There are a mix of technical and behavioral questions you should expect to answer.
J'ai postulé en ligne. Le processus a pris 2 semaines. J'ai passé un entretien chez Block (Los Angeles, CA) en févr. 2023
Entretien
SQL Test on joining datasets, window functions, stored procedures, using CTEs. Database management skills, questions on tableau, looker. Asked about previous experience working in data engineering, asked about ETL methods. Asked about experience working with snowflake.
Questions d'entretien [1]
Question 1
Give me an example of how you utilized SQL to support other teams with ad-hoc quests