The first rounds was a phone interview (~ 1 hour) and it involved questions on SQL and Python. Questions are similar to the ones asked on other reviews here. Just focus on solving it - they are pretty easy and usually require just a simple join or group-by. The next round was on-site. The process will be described by your recruiter and it is exactly the way they explain it to you. They will also give plenty of materials to study and those are usually enough. For the on-site, I would suggest focus on your SQL and get all the parts done. I had a bad experience here with one of the interviewers being really rude. Hopefully, you are lucky enough to not have someone like that. Overall, think of the on-site has a data design question (similar to how you are asked system design questions). Think about scale and daily vs batch solutions