Envié una solicitud electrónica. El proceso duró 2 semanas. Acudí a una entrevista en Block (Los Angeles, CA) en feb 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.
Preguntas de entrevista [1]
Pregunta 1
Give me an example of how you utilized SQL to support other teams with ad-hoc quests
Envié una solicitud electrónica. El proceso duró 3 semanas. Acudí a una entrevista en Block (New York, NY) en may 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.
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.
Preguntas de entrevista [1]
Pregunta 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)
