IBM
Global technology and consulting firm with deep roots in enterprise IT and AI.
3 Rounds
~14 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 paid employees in each department.
#Window Functions
#DENSE_RANK
#PARTITION BY
Data Engineer
•
Coding
•
medium
Write a SQL query to calculate a 7-day rolling average of daily sales.
#Window Functions
#Moving Average
#Date Functions
Data Engineer
•
Coding
•
medium
How would you delete duplicate rows from a massive table in DB2 or PostgreSQL without creating a new table?
#Data Cleaning
#CTID
#ROW_NUMBER
Data Engineer
•
Coding
•
medium
Write a SQL query to find the cumulative sum of sales by month.
#Window Functions
#Cumulative Sum
Data Engineer
•
Technical
•
easy
What is the difference between RANK(), DENSE_RANK(), and ROW_NUMBER() in SQL?
#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.