ConsultAdd

Role: Associate Software Engineer

College: Not Specified

Interview Date: 2024-11-22

Interview Type: On-Campus

Result: Not Specified

Difficulty: Medium

Rounds: 4 rounds

Topics Asked: Data Structures, Algorithms, OOPs, DBMS, SQL, Core Computer Science Concepts

Experience:

The recruitment process for the Associate Software Engineer role at Consultadd consisted of an online assessment followed by three rounds: two technical rounds and one techno-managerial round. Each round was elimination-based.

ROUND 1: Online Assessment (Coding Round)
This round was a coding challenge with 2 medium-level coding questions. Candidates were required to write the code and provide a dry run explanation for each problem based on the test case provided. Tips included being confident in coding skills and dry run explanations, and practicing medium-level coding problems on platforms like LeetCode or HackerRank.

ROUND 2: Technical Round 1
This was the first technical interview, focusing on databases, problem-solving, and OOPs concepts. Key questions and topics included a profile overview, SQL queries (using aggregate functions like AVG and COUNT), designing an ER Diagram for a company scenario, questions on Normalization and Joins, explanation of Types of Keys (primary, foreign, etc.), a medium-level DSA problem on strings (with pseudo-code and explanation), and OOPs concepts like runtime polymorphism and sorting. Tips for this round were to have a solid understanding of SQL, DBMS, and OOPs, clearly explain logic, and practice ER Diagrams and medium-level DSA problems.

ROUND 3: Technical Round 2 (Advanced Technical Interview)
This round delved deeper into technical skills, projects, and problem-solving abilities. Specific questions are not detailed but the round focused on advanced technical aspects.

ROUND 4: Techno-Managerial Round
This was the final round. Details on specific questions were not provided in the snippet.