This was for the consultant SFO role at Eli Lilly. First round was functional/technical interview with senior manager, second round was case study. the third and fourth round were general discussions with the associate director and director of the hiring team. Interview questions were valid for the role applied. HR scheduled interview on time and supported all along the process. No complaints as such with the process and it went smoothly.

The interview process generally includes fundamental SQL questions to assess technical proficiency, alongside structured problem‑solving exercises and case study‑based scenarios. These components are designed to evaluate analytical thinking, logical reasoning, creativity in approaching challenges, and the ability to apply practical solutions effectively in real‑world business contexts. Candidates are expected to demonstrate clarity of thought, communication skills, and adaptability when working through examples that mirror actual workplace situations, ensuring both technical depth and problem‑solving aptitude are thoroughly tested.