Conga

Role: Associate Consultant

College: Not Specified

Interview Date: April 26, 2021

Interview Type: Full-Time

Result: Not Specified

Difficulty: Medium

Rounds: 4 rounds

Topics Asked: Aptitude, Reasoning, OOPs Concepts, Project Discussion, Pattern Printing, String Palindrome Check, String to Integer Conversion, Data Structures (Closest Value in Array), DBMS (Join Queries, Normalization), Conceptual Coding Output Questions.

Experience:

The interview process for the Associate Consultant role at Conga (Apttus Software Pvt Ltd) involved four rounds.

Round 1: Aptitude
This round consisted of an aptitude test with 20 questions to be completed in 60 minutes. The questions were basic aptitude and a few reasoning questions.

Round 2: Technical
This was a technical interview with one interviewer. Basic OOPs concepts were discussed, followed by a brief discussion on the candidate's projects. The interviewer asked the candidate to solve two problems by writing pseudocode: one for printing a number pyramid pattern and another to check if a string is a palindrome; if not, return the reversed string.

Round 3: Coding
This was a monitored coding round lasting approximately 90 minutes. Candidates needed to have their IDE set up. The round included four questions: two coding questions and two database questions. The coding questions were: 1) Given an array of integers, find the closest value to a given target number (the array could contain duplicates and negative numbers). Example: Array =, Target: 12, Output: 11. 2) Write a block of code to convert a string (e.g., "98989") into an integer without using any library functions. The database questions involved: A) Writing a query to retrieve records from both tables, showing NULL if no match is found in any table. B) Writing a query to fetch employee names even if they don't have a matching ID in the left table, ordered by the first name from `empdetails` and `projdetails`. C) Normalize a given table.

Round 4: Interview (Senior Director and Manager)
This round was with a senior director and a manager. They asked about the candidate's background and posed a few coding output questions. These were conceptual questions designed to test a deep understanding of how things work.