I applied online. The process took 1 week. I interviewed at bp (Houston, TX) in Nov 2023
Interview
I participated in an online assessment on the HireVue platform, where I successfully completed two coding challenges. The first task involved writing a complex SQL query, while the second required me to demonstrate my skills in Python by creating a functional program.
Interview questions [1]
Question 1
Q: How do you write a SQL query to identify the region with the fifth highest revenue in the last 28 days from a 'region' table?
Q: How can a program determine the longest common subsequence between two given strings?
I had my final round of interview with BP on 26th September. The overall interview went very well — the panel was professional and the discussion was positive. However, after the interview, there was no communication from HR despite multiple follow-ups through calls and emails. Finally, on 8th October, I received a rejection email without any proper feedback.
It was disappointing because the interview process had gone smoothly, and the lack of timely communication showed poor candidate experience. I genuinely expected more transparency and prompt updates from such a reputed organization.
Interview questions [1]
Question 1
First round is full technical and coding
Final round is scenario based question
I applied online. The process took 2 months. I interviewed at bp (Kuala Lumpur)
Interview
Decent, I expect the interview a bit harder. The stages are as below:
1. Tehnical interview - standard data structure and algorithm interview
2. System design interview (Pipeline) - they asked about your experience in creating data pipeline
3. Interview with HM
3 rounds.
2 technical one managerial.
Focus on DSA and window functions of sql.
Test was done with screen sharing. Questions were asked on the approach taken and other things based on your code