Cognizant
American multinational information technology services and consulting company.
4 Rounds
~21 Days
Medium
The Interview Loop
Recruiter Screen (30 min)
Standard fit check, behavioral questions, and resume overview.
Technical Loop (3-4 Rounds)
Deep dive into domain knowledge, coding, and system design.
Interview Question Bank
Data Scientist
•
Coding
•
medium
Write a SQL query to find the second highest salary within each department from an Employee table. How would you handle ties?
#Window Functions
#DENSE_RANK
#Data Aggregation
Data Scientist
•
Coding
•
medium
For a retail client, we need to calculate the 7-day rolling average of daily sales. Write the SQL query to achieve this.
#Window Functions
#Time Series
#Moving Averages
Data Scientist
•
Coding
•
medium
Given a table of customer transactions, write a query to identify 'churned' customers, defined as those who made a purchase in the last 6 months but not in the last 30 days.
#Filtering
#Date Functions
#Conditional Logic
Data Scientist
•
Technical
•
easy
Explain the difference between RANK, DENSE_RANK, and ROW_NUMBER. Give a business scenario where you would use each.
#Window Functions
#Ranking
Difficulty Radar
Based on recent AI-sourced data.
Meet Your Interviewers
The "Standard" Interviewer
Senior EngineerFocuses on core competencies, system constraints, and clear communication.
SimulateUnwritten Rules
Think Out Loud
Always explain your thought process before writing code or drawing architecture.