Two technical rounds. They asked very Basic SQL questions that's it and few product situation based questions. Be prepared with query type of sql questions but they are very basic so think and answer
First round - SQL basics and SQL queries which you should solve by sharing the screen to the interviewer, Product-related questions, product thinking, feature improvement,
Second round - Guestimates, Product-related questions, Maths questions like percentages, basic calculations
Third round - HR behavioural round
Interview questions [1]
Question 1
Types of SQL quries, types of joins, window fuction and use, if instagram had one bad feature(you name it) and how would you improve it, how would you come to conclusion it would work, how would you extract data to find that is an actual problem, KPI metrics for the problem.
I applied through an employee referral. I interviewed at ShareChat in Jun 2021
Interview
I applied through referrals via some LinkedIn contacts. Recruiter posted the job description on her LinkedIn post. It was remote internship. After resume selection there was a round 1 call meeting was scheduled
Interview questions [1]
Question 1
Basic SQL and Data Science questions like types of join, central limit theorem, display median values of a dataset with Retention query
