Cognizant Interview Experience | BIT Mesra (On Campus)
Cognizant came to our campus (BIT Mesra) this year (2018) for the hiring process. It was a 2 day long process i.e First day (Online test) and the Second day (Technical and HR). Trust me, there was a huge of competition among the candidates. The criteria that they had set was 60% throughout (including 10th, 12th and Graduation Degree). Relaxation of maximum 1 years within academics was entertained, with no active backlog in any subject among all semester. The post that they were offering was Program Analyst Trainee. I also didn’t know what to study for the online test, there came Prepinsta and GeeksForGeeks in the role. It helped me a lot.
Round 1: ONLINE TEST
The platform of the test was AMCAT, one of the platform that many companies uses for their recruitment process.
These were the following sections :
Quantitative – 14 Ques – 16 mins.
Verbal – 25 Ques – 22 mins.
Logical – 16 Ques – 14 mins.
AutoFix – 7 Ques – 20 mins.
The question in AutoFix consist of logical and syntactical errors present within the given code. Its like the executable code is given with error present within it. You just have to figure out the errors in the code. The questions in the section are quite easy and requires just the basic knowledge of programming and logic building.
The entire online test was of intermediate difficulty, if you are good at quantitative problems just the verbal section of the test needs a bit of attention. There are about 5-6 passages and each one have 2-3 questions related to it.
144 students cleared the online test the results were announced later that day in the evening.
Round 2: TECHNICAL INTERVIEW
The following day all the students those were shortlisted for the technical interview were excepted to submit their resumes to the officials. The process started around 3 p.m. and I got my call for the interview around 5 in evening.
1. Briefly introduce yourself.
2. Are you doing any project currently? Please elaborate it.
3. What’s your favourite subject? In my case, its Java and DBMS.
Afterward all questions will be related to your favourite subjects.
4. What is DBMS?
5. What are the different types of DMBS?
6. What is RDBMS?
7. What is the difference between RDBMS and DBMS?
8. What is MySQL? Is it RDBMS or DBMS?
9. How we store data in RDBMS?
10. RDBMS also store data in .sql format file. So how can we differentiate the file of DBMS and RDBMS?
11. What is Primary Key? How it is different from Unique Key?
12. What is Foreign Key and How we use it to create connection between tables?
13. What are attributes?
14. What are the different types of SQL Languages? Explain them briefly with examples.
15. Where we can use CREATE command? Write a query using CREATE.
16. Now, use CREATE command to create something else except these two (TABLE and DATABASE).
17. Which type of Programming Language is JAVA?
18. What is OOP?
19. What are the features of OOP?
20. What is Abstraction?
21. What is Abstract Class?
22. We can create how many instance of an abstract class? Explain with an example.
23. Do you want to ask any question?
Round 3 : TECHNICAL ROUND 2
1. Again, briefly introduce yourself.
2. How was your day today?
3. What have you done from the morning till now?
4. Do you have any project on which you are currently working?
5. Please can you explain that?
6. Please write some code of your project, starting with database connectivity. Take your time.
I wrote 1 page of JAVA code with database table schema and some random data in it.
7. Then he asked to explain the whole code.
8. After that he asked me, do you know about Software Development Life Cycle?
9. What are the different stages in it?
10. What are the different Life Cycle Model?
11. Which one of them is best and why?
12. Then he asked me to write to reverse the string without using reverse function.
13. Write a query to get the second highest number from the student_marks table.
14. Do you have any question to ask?
Round 4: HR INTERVIEW
1. Now Again, Introduce yourself.
2. What do you know about cognizant.
3. What is the current revenue of cognizant?
4. What are your hobbies?
5. Do you have any interest in sport? (I answered : Cricket)
6. Do you like fielding? What’s your favourite position?
7. What are the different fielding positions in cricket?
8. What’s your role in cricket? (I answered : Bowler)
9. Do you play for any team like college team or just casual? (I answered : Just Casual)
10. Who is your favourite cricketer? (I answered : Bhuvneshwar Kumar)
11. Okay, Apart from these things (cricket and college study), What do you do in your free-time?
12. Which type of sketch, you usually do?
13. Why do you want to join cognizant?
14. How cognizant will help you to improve your skill?
15. Do you have any problem from night shift?
Hope my interview experience helps you and all the best for your recruitment process. Cheers!! I would be happy to help further if needed.