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.
Perguntas de entrevista [1]
Pergunta 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)
Candidatei-me online. O processo levou 3 semanas. Fui entrevistado pela Block (New York, NY) em mai. de 2025
Entrevista
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.
Candidatei-me online. O processo levou 2 semanas. Fui entrevistado pela Block (Los Angeles, CA) em fev. de 2023
Entrevista
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.
Perguntas de entrevista [1]
Pergunta 1
Give me an example of how you utilized SQL to support other teams with ad-hoc quests
