I applied online. The process took 5 weeks. I interviewed at Glassdoor in Mar 2021
Interview
I applied for the position via Glassdoor. Initially, I was given an interesting take-home assignment that had a few questions related to querying data( in SQL or any other language). After my assignment was evaluated, I was invited to a 30-minute telecall with my hiring manager where we discussed possible projects I could work on at Glassdoor based on my interests.
The week after, I had two 45 minute technical interviews on the same day. One of them was focused on DSA. The other one was fixed on Data Warehousing, SQL (basically data). Both my interviewers were awesome and helpful. If there was a problem I was stuck on, they tried to give me subtle hints to help solve the problem.
Finally, I had a 20-30 min discussion the same day as my technical interviews with a senior talent acquisition partner related to starting date, etc.
Interview questions [1]
Question 1
Intermediate SQL queries based on the take-home assignment. I was also asked a window function query.
Thank you for taking time to share your interview experience and I am very glad that you enjoyed the interview process. Congratulations on your internship offer. On behalf of the Data Engineering family, I welcome you and wish you a very rich learning experience while you intern with us.
You may know, here at Glassdoor we are investing heavily to grow our early career talents and I look forward to exploring a career opportunity with you in future. - Jai Govardhan, Sr. Director of Data Engineering