There was a total of 4 rounds and No HR Round, The eligibility criteria for the hiring process was CGPA 7+ or 70% throughout, only me selected from my college.
Difficulty level: Medium according to me
Round 1: Coding Round
There were 2 coding questions (easy) conducted on skype. The duration of the round was 40 minutes.
- Given an array of distinct integers, we need to replace each element of the array with its rank. the minimum value element will have the highest rank.
Input:{10,8,15,12,6,20,1}
Output:{ 4,3,6,5,2,7,1}- Given an integer N and a Flag
- If the flag is True then return the sum of even position digits of integer N.
- If the flag is False then return the sum of odd position digits of integer N.
Input: 43125 and Flag is True Output: 5
Tips: Be very active and observe every detail very carefully, don’t hurry and jump on a solution.
I cleared the first round and after 5 days received a mail for the next round on the next day. Out of 30 students, 2 were selected for the next round including me.
Round 2: Technical Round-1
This round was 75 minutes round on skype where I was asked questions from OOPS, DBMS, DSA, SQL.
- Interviewer: Tell me about Yourself.
- Me: I Introduced Myself.
- Interviewer: What are Aggregate functions in DBMS.
- Me: Explained.
- Interviewer: Explain Normalization, 1NF, 2NF, 3NR, BCNF.
- Me: Explained with example.
- Interviewer: perform query- Insert a value in name Colum in the student table.
- Me: write the query successfully.
- Interviewer: perform query- Display 2nd record from the student table.
- Me: write the query successfully.
- Interviewer: perform query- Display name column from student table where the third letter of the name is “r”.
- Me: write the query successfully.
- Interviewer: Asked Puzzle.
- Me: Try to Solve but unable to solve Interviewer explains the solution.
- Interviewer: Asked Puzzle.
- Me: solved successfully.
- Interviewer: write a code to sort the array in ascending order using a single for loop.
- Me: Not able to write solution but explain all sorting Technique.
- Interviewer: Explain Armstrong Number and write the code.
- Me: Explained and write the code successfully.
- Interviewer: Write a code to remove the white space from the sentence.
- Me: Explained my Approach and write the code successfully.
- Interviewer: What is Recursion and write the code for recursion Example.
- Me: Explained and write the code successfully.
- Interviewer: Difference between Array and linked list and Explain all types of Linked list.
- Me: Explained.
- Interviewer: Explain Abstraction and Polymorphism.
- Me: Explained
- Interviewer: What is polymorphism Explain its types.
- Me: Explained
- Interviewer: perform overriding.
- Me: performed Successfully.
- Interviewer: Any questions from your side.
- Me: I asked one question.
- Cleared this round and received a call for the next coding round the next day.
Note- All Query and code performed on Notepad.
Round 3: Coding Round
This round was conducted on Hacker Earth and there were 2 coding questions and the time was 40 minutes.
- I solved the first coding question completely with all test cases and half of the second question.
- Cleared this round and received a call for the next Technical round on the next day.
Round 4: Technical Round -2
This round was 30 minutes round on skype where I was asked questions from DBMS, DSA, SQL, and My Projects.
- Interviewer: Tell me about Yourself.
- Me: I Introduced Myself.
- Interviewer: What is recursion and what are the Advantages of recursion.
- Me: Explained.
- Interviewer: write a code to return the sum of all even No present in the Digit N of length M.
- Me: write the code successfully.
- Interviewer: write a code to find the frequency of letters from the given sentence.
- Me: write the code successfully.
- Interviewer: what is calloc or malloc in C.
- Me: Explain the malloc but forget the calloc so I told him no idea.
- Interviewer: perform query- display all duplicate names from the student table.
- Me: write the query successfully.
- Interviewer: perform query- display the 3rd highest salary from all departments.
- Me: write the query successfully.
- Interviewer: Why do we use Linked list over Array.
- Me: Explained
- Interviewer: How do we find the middle element from the linked list-only approach.
- Me: Explain the Approach
- Interviewer: What is Indexing in DBMS why do we use them.
- Me: Explained.
- Interviewer: Do You Know C++.
- Me: I said No
- Interviewer: Explained your Project Deeply.
- Me: Explained.
- Interviewer: Any questions from your side.
- Me: I asked one question.
Result: Selected
Name: chanchal pal
Successfully cleared this Round and received call from HR the next day.
TIP: Be clear with fundamentals (DBMS, OOPs, DSA, SQL) and read about the company before your interview be confident and think before giving your answer.
I hope it will help you. Thank you