Shopify Senior/Staff Data Engineer interview questions

Recruiter screen. Standard intro to the role and process. The recruiter was clear about what each round tested, which I appreciated. SQL pairing (in CoderPad). Live SQL: joins, grouping, aggregations, window functions. Mostly testing how well you read the problem and completeness of the attempted questions. You dont have to finish all questions. System Design and Data modelling, Technical Deep dive. A well rounded process, relevant to the job. I genuinely messed up in the deep dive where i mixed up a few streaming concepts. The entire process did take about 1-1.5 month