Round 1: Online Assessment
Questions: The online assessment consisted of several sections including:
- Aptitude
- English Grammar
- Case Study
- 1 coding question
The test was conducted on HackerEarth and lasted for 2 hours. It included approximately 30-35 MCQ questions based on various topics, a case study question, and one coding question. The coding question was a medium-level DSA problem from LeetCode, requiring some critical thinking.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Round 2: Communication Round
Questions: This round was conducted on the Mettle platform and included 3-4 sections. Questions included:
- Read a statement on screen
- Introduce yourself for 1-2 minutes
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Round 3: Technical Round 1
Questions:
- SQL questions (tricky but manageable with clear basics)
- DSA question: Coin Change problem from LeetCode
- Questions about internships and side projects
- Some candidates were asked about Linked Lists
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Round 4: Technical Round 2
Questions:
- Tough SQL questions and their implementations
- Writing SQL queries
- Questions about COALESCE and other SQL functions
- In-depth questions about projects listed on the resume
- Basic CS fundamentals, particularly from DBMS
- Questions about ACID properties and Transactions
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Round 5: HR Round
Questions:
- Basic behavioral questions about yourself, hobbies, and projects
- Discussion about pay structure
- Questions about future goals and family background
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Tips:
- Prepare SQL thoroughly; recommended resources include:
- Apna College SQL Lecture by Shrradha Khapda
- LeetCode SQL 50 (a must)
- Be well-versed in your projects listed on your resume.