On-campus: ~250 shortlisted for OA, 10 for interview; 1.5hr online interview on internship deep-dive, DB fundamentals, 3 DSA

Hi everyone, recently zomato visited our campus to hire for SDE-1 position. Here is my full interview experience.

1. Resume shortlisting:-
   Around 250 students got shortlisted for the OA

2. OA was on hackerrank platform, 10 students got shortlisted after this round including me.

3. Online Interview:
   Started off with intro of both of us, then he deep dived into my internship project details,asked about the whole pipeline of the project ,my specific role, and some cross cs-fundamentals based on the project for eg:what activation function did you use, what was your model accuracy,etc.
   Then he asked some CS fundamentals:

4. What is Postgres?

5. Why you didn't use MongoDB?

6. When shall i use Postgres?

7. Do postgres satisfy ACID properties ?

8. CAP theorem ?

9. Is CAP theorem applicable to SQL ?

10. What happens when you type zomato.com in the web browser?
    Then he deep dived into one of my personal projects and asked some cross-questions regarding it.
    Then he asked 3- DSA Q's in google docs.

11. LC- Easy - Missing Number

12. LC-Medium - Minimum Size Subarray Sum

13. LC-Hard - The Skyline Problem
    Then he asked few Q's related to my hackathon participation.
    And then finally he asked if i had any Q's for him.
    It was total of 1.5 hr.

14. Final Status- rejected
    Although i couldn't make it but will improve for future opportunities.

Thanks for reading.
Happy Coding!