I applied online. The process took 2 weeks. I interviewed at Block (Los Angeles, CA) in Feb 2023
Interview
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.
Interview questions [1]
Question 1
Give me an example of how you utilized SQL to support other teams with ad-hoc quests
I applied online. The process took 3 weeks. I interviewed at Block (New York, NY) in May 2025
Interview
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.
Interview questions [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)