Main focus should be on Product sense, SQL and python basics like List and Dictionaries.
SQL - You should be well aware of aggregations, how to do one table scan and provide aggregated values.
Product sense is something which will be covered in all your rounds.
Data Modeling - Focus how you design your Dimension and Fact tables. Make sure to have denormalized fact tables. Go through Data models of Uber, Doordash, LinkedIn (not like graph database) but at higher level.
Because SQL questions would be based on how you design.
Python - Basic questions like calculating average, traversing and sorting lists and dictionaries would be enough.

Question

Main focus should be on Product sense, SQL and python basics like List and Dictionaries.
SQL - You should be well aware of aggregations, how to do one table scan and provide aggregated values.
Product sense is something which will be covered in all your rounds.
Data Modeling - Focus how you design your Dimension and Fact tables. Make sure to have denormalized fact tables.  Go through Data models of Uber, Doordash, LinkedIn (not like graph database) but at higher level.
Because SQL questions would be based on how you design.
Python - Basic questions like calculating average, traversing and sorting lists and dictionaries would be enough.

Meta

Meta Interview Question

Want the inside scoop on your own company?

Bowls

Followed companies

Job searches