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.
Domande di colloquio [1]
Domanda 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)
Ho presentato la mia candidatura online. La procedura ha richiesto 3 settimane. Ho sostenuto un colloquio presso Block (New York, NY) nel mese di mag 2025
Colloquio
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.
Ho presentato la mia candidatura online. La procedura ha richiesto 2 settimane. Ho sostenuto un colloquio presso Block (Los Angeles, CA) nel mese di feb 2023
Colloquio
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.
Domande di colloquio [1]
Domanda 1
Give me an example of how you utilized SQL to support other teams with ad-hoc quests