An external recruiter reached out about the opportunity 1st stage was with an internal recruiter - Talking about my experience/projects. 2nd stage was with the hiring manager - Similar to previous stage but more in-depth with follow up questions on my answers. There were also a few behavioural questions at this stage. 3rd stage was the technical round. It was a 2 hour interview split into 3 parts: - Experience and projects from a technical PoV - after explaining the project, I was asked about specific tech used, why that tech, etc. There were detailed questions about volume of data, type of data, architecture of the pipeline, challenges with that architecture, etc. - Pair Programming in Python - You were given 2 files with data, you had to join this data in a pandas df, clean it (filtering a records based on specific conditions) and write it to another file. Nothing challenging, but you need to know your pandas. The other thing is that there is a little trap. They don't give you much info about the data e.g. what are the joining keys, edge cases, primary keys. You have to explore it yourself + ask the interviewer for confirmation (it is a pairing exercise after all). - System Design - You had to design a system for trading stocks on a whiteboard (draw.io).