Status: Final year student from tier-2 college
Position: Data Analyst
Location: Bengaluru/Chennai
Date: June-July 2022
- Originally gave OA for the role of software engineer through college placement cell. Shortlisted but did not get chance to interview since the first 10-15 interviews fulfilled their requirement for SE role.
- After 2-3 weeks, was given a chance to interview for Data Analyst (I was ecstatic; it fit my experience, skillset and interests much better).
First round -- Technical Interview (video meet)
- ~1 hour
- Given a real-world scenario of multiple SQL tables, and deriving useful insights from it using joins/subqueries, using clauses such as DISTINCT or GROUP BY as necessary.
- Giving exact syntax was not necessary, just the overall query structure.
- Talked about some of the company's new initiatives to improve customer satisfaction, asked my opinions. Also asked of the things I would do to make Paypal better.
- Asked me whether I had questions: I asked about their internal proprietary ML tools, how they tackle fraud, etc.
- P.S: the interviewer was sweet but some of my other friends didn't have such a good experience.
Final round -- Managerial Interview (video meet)
- ~40 minutes
- Asked about my previous projects, location preference, and whether I was comfortable with developing a new tech stack of ML tools in the role
- Told me which team I would be working in
Final result: offered internship leading to full-time role via PPO (package: 25+ LPA)