I applied through university. The process took 4 days. I interviewed at Cognizant (Calcutta) in Jan 2025
Interview
Round 1: Online Aptitude + Technical Test
The test consisted of 20 aptitude questions and 2 SQL-based coding questions.
Topics covered: joins, aggregations, and writing efficient queries.
One SQL question was to find the second highest salary from an employee table without using LIMIT.
Round 2: Technical Interview (Virtual)
The interviewer started with a quick introduction and asked me to explain a project I had worked on.
I explained my project on predictive analytics using machine learning, where I used Python, Pandas, and scikit-learn.
Then I was asked:
Difference between primary key and unique key in SQL.
Write a query to fetch duplicate rows from a table.
Explain normalization and why it is important.
Some scenario-based questions on data cleaning (e.g., handling missing values).
Round 3: HR Round
The HR focused more on cultural fit and communication.
Questions included:
"Why do you want to join XYZ?"
"Where do you see yourself in 5 years?"
"Tell me about a time you worked in a team and resolved a conflict."
Interview questions [1]
Question 1
Tell me about a time you worked in a team and resolved a conflict.
asked to write a basic codelike prime number asked some OOP questions,dbms andosquestions and projects in detail asked to write code for merge sort asi am from aiml background asked to write in python
Moderate they asked about java sql and code spring resume certification sql joins related coding and inheritance coding apditude patterns problem reverse a number string related question willing to relocate
Interview questions [1]
Question 1
Explain oops explain solid principle sql joins related
It was too quick, i felt like they did warmup on me, I answered almost all the question but couldnt land a job It was too quick, i felt like they did warmup on me, I answered almost all the question but couldnt land a job