Interview Location : India Hyderabad,
Round 1: was an online assesment on hacker rank , which I thought I failed but somehow made it.
Round 2 : was a phone screen with the hiring manager.
SQL: Write SQL code to show the previous sale and next sale for each date?
date, sales_amount
10-10-2022, 2500
18-10-2022, 1600
12-10-2022, 1200
13-10-2022, 1500
14-10-2022, 700
20-10-2022, 2400
11-10-2022, 1000
16-10-2022, 2000
17-10-2022, 1900
15-10-2022, 900
19-10-2022, 3200
- what are the optimization techniques you have used before.
- what are the differences between CTEs and Temp tables.
was able to explain the logic of the query , but failed to write the correct one and the interview kep rushing me that there were only had 2 mins to conclude.
Behaviour:
Tell me about a time , you did something innovative which helped the team?
tell me about a time where you did something that helped the team a lot of effort?
tell me about a time where you made some data recomendations and it was accepted by the team ?
tell me about a time where you used some data points to make a business recomendation.
over all I felt like they understood that I was not a good fit to the team, the hiring manager himself seems uninstrested
interview ended 15 mind early, since I did not ask any question as I could sense that they were unintrested.
result rejected