J'ai postulé via un établissement d'enseignement supérieur ou universitaire. J'ai passé un entretien chez ConsultAdd en avr. 2025
Entretien
Interview Experience
Interviewer - Mr. Sanskar Jain
Interviewee - Devansh Sharma
Introduction - Didn’t asked for Introduction. Just Hello-Hi and asked is the pronunciation of your name is correct or not. What are your major programming languages Java or Python. Also asked wether you know SQL or not and rate yourself in SQL and Java on a scale 1 to 10.
SQL Questions - First question was to calculate the second highest salary from the employees table and after that asked to try to solve it with nested or subqueries and write the query by sharing your screen.
Second question was what are self joins and write down the code for self join and explain it by sharing your screen
Third question was to do make 2 tables of student and teacher and write the query for left join for both table ids and also draw the table of output data.
DSA Questions - First question in dsa was that the list is generated of String and it contains some values of digits , numbers , brackets and special characters but we need to print each character and digit line by line while maintaining the order. This question was solved and I was facing some issue in running the code so he helped me by making some changes in the code and also at first he explained me the question by writing the output of 1st test-case and also asked for the approach how you have solved it and also asked to explain the code of each question.
Second question was of DP(Dynamic Programming) in which the question was of leetcode Longest Pallindromic Subsequence. Sir first asked me to explain the problem and also tell the approach. Then he asked is there any other approach in your mind. Then he asked to write down the code in compiler with screen shared.
Third question was of again DP which was to divide an array into two subset and return true if is possible to divide subset with the sum of each set equal otherwise false. He again asked the approach first and then asked me to write the code in compiler with screen shared.
Questions d'entretien [1]
Question 1
SQL 3 questions and 2 DP questions and 1 easy DSA question on basic iterations.
Overall good experience, they focused on DBMS and SQL queries, OOPS concept, DSA question(easy to medium).
1st round: coding test(2 ques based on array and string)
2 technical interviews
1 managerial interview
Questions d'entretien [1]
Question 1
In technical interview, they asked me questions related to oops,dbms, and dsa question-longest pallindromic substring in given string.
J'ai postulé via un établissement d'enseignement supérieur ou universitaire. Le processus a pris 1 semaine. J'ai passé un entretien chez ConsultAdd (Ghaziabad) en août 2021
Entretien
It was an On Campus process. The first round was Written round where there was 12 MCQ and only 1 coding question.
After Clearing that they will call you round-1 interview and ask you 1 or 2 medium level coding question which you have done by sharing your screen and Interviewer will also check your core subject knowledge.
In the 2nd round there will be on DP Coding Question and 1 SQL query.
I cannot make into 3rd round so I can' tell about it.
Questions d'entretien [1]
Question 1
1st Coding Question- You are given two array , print all the element that are unique in both the array.
2nd Coding Question- You have been given 2 sorted array find the element that has maximum frequency.
What is Polymorphism.
what is DBMS
Write Inner join query.
Do you have any question.