Applied on the company website and received an email for the online assessment which contained the following questions:
1 SQL question on Joins
1 Python question on DP
It's been a week since I submitted my answers but no response yet.
There was an online assement - 2 question. First was an SQL, second was a programming question, medium difficulty. Solved both of them and submitted. Did not hear a reply for 2 weeks, Checked the application status on their portal one day and I was not selected. There was no personal interactive and no mail.
Interview questions [1]
Question 1
Sql question - find 5th highest revenue generated state - no schema was given
Programming question about some matrix
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?