I applied through college or university. The process took 4 weeks. I interviewed at Cognizant (Hyderabad) in Oct 2024
Interview
1st Round
(Some Aptitude Questions and Communication Round)
2nd Round
(Technical Questions and Basic Coding Questions with basic SQL queries)
SQL -> JOINS
WHERE Clause
Coding -> Valid Password
Arctic Temperature Tracker
3rd Round
(Technical Interview + HR)
1) Introduce yourself (I Answered)
2) About the project (I Gave answer)
3) Remove duplicates in array (I Gave answer)
4) Sub-Queries(MySQL) (He Gave me Hint)
5) DDL and DML differences (I Gave answer)
6) ACID Properties explanation (I Gave answer)
7) Difference between set and tuple (I Gave answer)
8) What are lists? (I Gave answer)
9) What is Dictionary? (I Gave answer)
10) Reverse a String(But in one line) (He Gave me some Hint after i took time to think)
11) Remove Duplicates in list in one line (Done using Set())
12) Why we use COMMIT in SQL (I gave answer)
13) Given a code to guess output (I gave him wrong answer but then after some time i was able to crack it)
14) What are types of Joins? (I gave answer)
15) What is Self Join? (Not able to Answer as I don't know exactly) He said No Problem
16) What is __init__ method? (I gave answer)
17) What is Inheritance? (I gave answer)
18) Difference between DELETE and TRUCATE (Not Sure able TRUCATE But I was Confident)
19) What is pass keyword? (I was able to give general Answer)
20) what are args and *args ?(Unable to answer)
Interview questions [1]
Question 1
self intro
projects
internships
java language (i prefer )
The interview was primarily technical, concentrating on C#, .NET, SQL, and API concepts. Questions tested understanding of core principles and practical application. The process was straightforward, professional, and focused on technical depth.
I applied online and got a calll back, had 4 rounds in total. first was a behavioral phone call just casual talks about your skills and when can you start working and general questions, then two coding rounds in hackerrank - was asked to code in java although the job was for python and finally HR.
3 rounds of interviews with a technical interview. The technical interview involved questions on Java and sql. They were mildly difficult. The first 2 rounds were not so difficult, lots of situational judgement questions