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 Engineer
•
Coding
•
medium
Write a SQL query to find the top 3 highest earning employees in each department, handling ties appropriately.
#Window Functions
#DENSE_RANK
#PARTITION BY
Data Engineer
•
Coding
•
medium
Write a SQL query to find the cumulative sum of sales per day for the current month.
#Window Functions
#Aggregations
#Date Functions
Data Engineer
•
Coding
•
medium
Write a SQL query to delete duplicate rows from a table, keeping only the record with the lowest ID.
#Data Cleaning
#CTEs
#DELETE
Data Engineer
•
Coding
•
easy
Write a SQL query to find all employees who earn more than their direct managers. The table 'Employee' has columns: Id, Name, Salary, ManagerId.
#Self Join
#Filtering
Data Engineer
•
Technical
•
easy
Explain the difference between ROW_NUMBER(), RANK(), and DENSE_RANK(). In what client reporting scenario would you choose DENSE_RANK over RANK?
#Window Functions
#Data Analysis
Data Engineer
•
Technical
•
easy
What is the difference between a Left Join and an Inner Join? What happens to the result set if the right table has multiple matching rows for a single row in the left table?
#Joins
#Data Duplication
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.