Consultadd Interview experience (On-campus)

Last Updated : 22 Nov, 2024

Consultadd visited our college to offer the role of Associate Software Engineer. The recruitment process consisted of an online assessment followed by three rounds: two technical rounds and one techno-managerial round. Each round was elimination-based. Here's a detailed breakdown of the experience.

ROUND 1: Online Assessment (Coding Round)

The first round was a coding challenge:

Structure:

  • 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 to Clear This Round:

  • Be confident in your coding skills and dry run explanations.
  • Practice 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:

1. Profile Overview: Walkthrough of my profile.

2. SQL Queries: Write SQL queries using aggregate functions such as AVG and COUNT.

3. ER Diagram:

  • Given a company scenario, design an ER Diagram.
  • Include all details and relationships between tables.

4. Normalization and Joins:

  • Questions on normal forms and database joins.

5. Types of Keys: Explanation of primary keys, foreign keys, etc.

6. DSA Problem:

  • Solve a medium-level problem on strings.
  • Explain the approach clearly and write a pseudo-code.

Theoretical Concepts:

OOPs: Runtime polymorphism, sorting, and related concepts.

Tips to Clear This Round:

  • Have a solid understanding of SQL, DBMS, and OOPs concepts.
  • Clearly explain the approach and logic behind coding solutions.
  • Practice designing ER Diagrams and solving medium-level DSA problems.

ROUND 3: Technical Round 2 (Advanced Technical Interview)

This round dived deeper into technical skills, projects, and problem-solving abilities.

Key Questions and Topics:

1. Introduction: Walkthrough of technical skills, projects, and internship experiences.

2. Project-Based Questions:

  • Discussed challenges faced and contributions during previous internships.
  • Detailed explanation of Flutter-based projects, including problem statements and solutions.

3. SQL Queries:

  • Write medium-level queries covering self joins, nested queries, and LIMIT.
  • Normalize a table violating a normal form.

4. Algorithm and DSA:

  • Explanation of merge sort and its applications.
  • Solve a medium-level coding question on strings using the sliding window technique.

5. Core Concepts:

  • Spanning Trees, Hashing, and Heaps (e.g., insertion in a min-heap).
  • Runtime Polymorphism: Method overloading, method overriding, and late binding.

6. C++ Debugging:

  • Analyzed 2–3 C++ codes to identify errors and violations of programming concepts.

Tips to Clear This Round:

  • Write optimized code and explain your logic clearly.
  • Be prepared to discuss your projects in-depth.
  • Brush up on advanced SQL queries, sorting algorithms, and core computer science concepts.

ROUND 4: Techno-Managerial Round

This round evaluated both technical skills and behavioral aspects.

Key Questions and Topics:

1. Introduction:

  • Why I chose engineering.
  • My internship experiences and achievements.

2. Coding Challenge:

  • Solve a recursion-based problem and explain the output step-by-step.

3. Brainstorming DBMS Question:

  • A schema-based question requiring strong observational skills and SQL knowledge.

4. Behavioral Questions:

  • My extracurricular activities.
  • Work preferences (e.g., preferred shift and willingness to relocate).

Tips to Clear This Round:

  • Be confident and positive in your responses.
  • Pay close attention to details in tricky DBMS questions.
  • Ask thoughtful questions about the company to show genuine interest.

Outcome

The result was announced the same day, and I was thrilled to be selected for the role of Associate Software Engineer!

Key Takeaways

Preparation:

  • Practice coding problems (easy to medium level) and SQL queries on platforms like GeeksforGeeks or LeetCode.
  • Strengthen your understanding of DBMS and OOPs concepts.

Communication:

  • Clearly explain your thought process during coding and problem-solving.
  • Be articulate and confident while discussing projects and experiences.

Confidence:

  • Maintain a positive attitude and engage actively in each round.

Final Words:

The placement process was both challenging and enriching. With proper preparation and a confident mindset, you can crack it. Best of luck for your journey!

Comment

Explore