I applied online. I interviewed at Northern Trust (New York, NY) in May 2025
Interview
The interview process consisted of three rounds. The first was an initial screening with HR discussing my experience and motivation. The second round focused on technical skills, including SQL queries, data modeling, and ETL pipeline design. The final round involved a case study and system design discussion with the engineering team, followed by some behavioral questions.
Interview questions [1]
Question 1
How would you design a scalable data pipeline to process and transform real-time streaming data from multiple sources?
I applied online. I interviewed at Northern Trust in Aug 2021
Interview
I applied for the job via linked in and HR contacted me. There was 4 rounds of virtual interview 3 hour long (45 mins each) with no break. Round 1 with the hiring manager, round 2 with a peer which was technical, round 3 was behavioural and round 4 was with a senior manager. All the rounds was pretty simple and no much technical was asked. I did not receive a offer as they said i dont have managerial capabilities which was not even mentioned in the JD and this was meant to be a technical role.
Interview questions [1]
Question 1
1)What is recursive function in python?
2)Difference JSON and parquet.
3)Dictionaries in python.
