Technical Screen

SQL and a Business Case in One Technical Screen

ChimeData Scientist · Technical Screen · Oct 2025

This round is split into two parts: one hour of SQL and one hour of a case study. SQL: They give you a transaction table and a user table. If you're fast you'll probably get through 5-6 questions. The time field is a timestamp, so you need to use date_trunc to handle it. The first few questions are pretty basic and you can knock them out with a few CTEs. It involves several window functions like…

Shared by a candidate · reported Oct 2025. Interview formats change; use it as a guide, not a script.