Volvo Cars Interview Question

Tech interview consisted of two blocks. The first one was about reviewing some code written in Python; pointing out potential flaws in the design and reasoning about how to fix them. The code snippet looked like a module that a Data Scientist that lacks understanding of software engineering would write. Second part was about writing a sql query that would filter and join a couple of tables to compute a metric with multiple levels of aggregation.