Aggregated from 2 candidate experiences for ALL.
The candidate passed all rounds of the interview process for the ASDE role at CarWale. The process included an OA round, two technical rounds (one with a focus on DSA and projects, another with the CTO), a system design round, and a final technical/HR round. The candidate received positive feedback and was advised to strengthen system design basics.
Online test on Hackerrank with 4 DSA questions in 2 hours. Allowed languages: any except Python. Questions: 1. Easy (array and map), 2. Medium (matrix), 3. Medium (Priority Queue), 4. Hard (Graph).
Online assessment on Hackerrank with 4 DSA questions in 2 hours. Candidates could use any language except Python.
Easy question based on array and map
Medium question based on matrix
Medium question based on Priority Queue
Hard question based on Graph
A 60-minute round focused on DSA for most candidates, with 2-3 questions typically asked. The interviewer also discussed the candidate's projects (E-commerce website), including database design, API design, and functional requirements. The candidate was asked to solve a linked list problem and explain it using different methods.
https://leetcode.com/problems/intersection-of-two-linked-lists/
https://leetcode.com/problems/maximum-product-subarray/
Coin Change problem (variation)
Fibonacci number problem
Climbing Stairs problem (with variable step sizes)
A 60-minute round where the interviewer evaluated the candidate's logical thinking and system design basics. The interviewer focused on the candidate's project (online assessment platform) and asked about database design, scaling servers for millions of users, and implementing new functionalities.
A 90-minute round with the CTO of CarWale. The round started as an HR interview but turned technical for most candidates. The CTO asked about the candidate's family background, schooling journey, and activities. Technical questions were also asked on computer networks, OOPs, OS, and DBMS.
The overall experience was positive. The interviewers were described as approachable and helpful, providing hints when needed. The candidate found the rounds to be manageable with a mix of technical and personal questions.
The online assessment consisted of 6 questions based on a small dataset provided in Excel. The questions could be answered using basic Excel knowledge and formulas.
The candidate completed an online assessment with 6 questions based on a small dataset provided in Excel. The questions required basic Excel knowledge and formulas to solve.
A 30-minute online screening round where the interviewer asked a mix of personal and technical questions. The candidate was asked about their background, strengths, weaknesses, and future career goals. Technical questions included basic SQL JOINs, Python pandas, and numpy concepts.
Basic types of SQL JOINs
Usage of Python pandas and numpy
Knowledge about Python pandas and numpy
The technical interview consisted of 3 problem statements. The first involved operations on a Python dictionary dataset (e.g., accessing elements, inserting new data). The second required using pandas to perform operations like joining tables and filtering data based on conditions. The third involved writing SQL queries to join multiple tables and retrieve specific information, including hardcoding values in the query. The interviewer also asked about SQL joins, lambda functions in Python, and the differences between delete, truncate, and drop.
Python dictionary operations (e.g., accessing elements, inserting data)
Pandas operations (e.g., joining tables, filtering data)
SQL queries (e.g., joining tables, hardcoding values)
Explanation of SQL joins
Lambda functions in Python
Difference between delete, truncate, and drop
InterviewDigest