PharmEasy

Role: Data Analyst

College: Not Specified (On-Campus)

Interview Date: December 2024

Interview Type: On-Campus

Result: Selected

Difficulty: Easy to Medium

Rounds: 3 rounds

Topics Asked: Data Science Basics, SQL (JOINs, Normalization), Python, Projects, Statistics, Probability, Machine Learning, Behavioral

Experience:

PharmEasy visited the candidate's campus for Data Analyst hiring in December 2024, and the candidate was one of two selected.

Round 1: Online Assessment: This round focused on Data Science basics. All questions were relatively easy. Verdict: 16 students were shortlisted for the next round.

Round 2: Technical Interview: The interview began with introductions. SQL: The interviewer shared a screen with two tables on Google Sheets and asked about INNER JOIN, LEFT JOIN, and CROSS JOIN queries. The candidate solved queries based on specific conditions and, with guidance, solved a three-table join. A few questions on Normalization were also asked. Python: Questions were asked about Python concepts. Projects: The candidate's projects were discussed in detail, including their thought process, challenges faced, and solutions. Overall, the focus was on technical skills, project knowledge, and problem-solving ability.

Round 3: Hiring Manager Round: This round focused on the candidate's experience and behavioral aspects. Verdict: Out of 9 students, 2 were selected, and the candidate was one of them.

Key Takeaways: Strong basics in SQL, Python, and Data Science fundamentals were crucial.