I applied through a recruiter. The process took 1 week. I interviewed at WebMD Health in May 2024
Interview
After the application Shortlisting,
Round 1 - Online Technical Test (1hr)- Involved MCQs and 4 Coding questions (Python + SQL)
Round 2 - Technical Interview (45 mins)
Round 3 - Tech + Managerial Round - If you haven't worked on the exact tech stack then they will show hesitation in hiring you, but the HR was already aware my tech stack
Got ghosted after the 3rd round, I assume that I did not get the offer.
Interview questions [1]
Question 1
Asked about projects, ETL pipelines, Gave some ETL scenarios and asked how to solve them, diff between Natural key and Surrogate key, Asked to write a lot of SQL queries (~12 questions), questions about joins, dimensional modeling
Asked questions focusing on the tech stack used by them, indexing, coalesce, if null, how to increase query performance, factless fact, list vs tuple