Tip 1: Practice coding regularly and revise important topics consistently instead of studying everything at once.
Tip 2: Focus on understanding concepts rather than just memorizing questions in DSA and core subjects.
Tip 3: Build at least 2–3 real projects and know everything about them.
Tip 1: Keep your resume simple and highlight 2–3 strong projects that you can confidently explain.
Tip 2: Make sure to mention only the skills you actually know, as everything on your resume can be asked in the interview (don’t lie).
It was around the afternoon.
It was a virtual interview conducted over Superset.
It included screening and technical concepts.
The round started around 11 AM and was conducted in a cabin with our group and the interviewer present. It was mainly focused on the project we developed during the hackathon. We were first asked to present our project, and the interviewer interacted with us throughout the presentation by asking questions.
The questions were based on our tech stack, dataset used, implementation details, and core machine learning concepts. We were also asked to present ourselves as individuals during the interview and clearly explain our own contributions.
The interviewer was attentive and focused on understanding our depth of knowledge and clarity of concepts. Overall, the round was interactive and primarily evaluated our project understanding and fundamentals rather than just theoretical knowledge.
The round focused on a detailed discussion of the hackathon project. Questions were asked about the overall approach, tech stack used, dataset selection, preprocessing steps, model choice, and evaluation metrics. The interviewer also asked about individual contributions, challenges faced during development, and how the solution could be improved or scaled.
In addition, some basic questions on core machine learning concepts, such as overfitting, model accuracy, and data handling, were asked to test conceptual clarity.
Tip 1: Be ready to clearly explain your individual contribution, even in a group project.
Tip 2: You should know everything about the project, not just your part.
The round included technical questions focused mainly on SQL and basic programming. I was asked to write SQL queries, such as finding the highest value (e.g., highest salary) and calculating the total salary of a department based on a given employee’s name. There were multiple SQL-based questions to test query writing and understanding.
I was also asked about the most complex SQL query I had worked on and to explain it. In addition, some basic Python coding questions and fundamental technical concepts were discussed to evaluate problem-solving skills and clarity of understanding.
Write an SQL query to find the total salary of a department based on a given employee’s name. Also, write queries to find the highest salary from a table and perform basic aggregate operations.
Step 1: First, identify the required tables, such as Employee and Department, and understand the relationship between them (using department_id).
Step 2: To find the total salary of a department based on an employee’s name, first fetch the department_id of that employee using a subquery.
Step 3: Then, use the department_id to calculate the total salary using the SUM() function with GROUP BY.
Step 4: For the highest salary, use MAX(salary) to directly fetch the result from the Employee table.
Step 5: Ensure proper use of JOINs or subqueries depending on the table structure.



Step 1: Traverse the string and store the frequency of each character using a dictionary.
Step 2: Traverse the string again and find the first character with a frequency equal to 1.
Step 3: Return that character.
Step 4: If no such character exists, return -1.
The round consisted of general HR questions to assess communication skills, attitude, and cultural fit. Questions included self-introduction, strengths and weaknesses, reasons for choosing the company, and career goals.
The questions were mainly HR-based, including self-introduction, strengths and weaknesses, reasons for choosing the company, and future career goals. There were also a few situational questions to understand behaviour, teamwork, and how I handle challenges.

Here's your problem of the day
Solving this problem will increase your chance to get selected in this company
Which data structure is used to implement a DFS?