IBM

Global technology and consulting firm with deep roots in enterprise IT and AI.

3 Rounds ~14 Days Medium

Start Mock Interview

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

All Roles Data Engineer 5 Data Scientist 3 Full Stack Engineer 1 Machine Learning Engineer 1 Product Manager 2

All Topics Algorithms 54 System Design 46 Culture Fit 38 SQL 12 Leadership 9 Machine Learning 8 Big Data Frameworks 7 Architecture 7

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

Practice

Data Engineer • Coding • medium

Write a SQL query to calculate a 7-day rolling average of daily sales.

#Window Functions #Moving Average #Date Functions

Practice

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

Practice

Data Engineer • Coding • medium

Write a SQL query to find the cumulative sum of sales by month.

#Window Functions #Cumulative Sum

Practice

Data Engineer • Technical • easy

What is the difference between RANK(), DENSE_RANK(), and ROW_NUMBER() in SQL?

#Window Functions #Ranking

Practice

Data Scientist • Coding • medium

Write a SQL query to find the top 3 highest paid employees in each department.

#SQL #Window Functions #Joins

Practice

Data Scientist • Coding • medium

Calculate the rolling 7-day average of API calls for watsonx endpoints using SQL.

#SQL #Time Series #Window Functions

Practice

Data Scientist • Coding • medium

Write a query to find the churn rate of IBM Cloud customers month-over-month.

#SQL #Aggregations #Business Logic

Practice

Full Stack Engineer • Coding • easy

Write a SQL query to find the second highest salary from an Employee table.

#Databases #SQL

Practice

Machine Learning Engineer • Coding • medium

Write a SQL query to find the nth highest salary from an Employee table.

#Database #Window Functions

Practice

Product Manager • Coding • medium

Write a SQL query to find the top 5 enterprise clients by monthly recurring revenue (MRR) who have experienced more than 1 hour of downtime in the last 30 days.

#Data Analysis #SQL #Customer Metrics

Practice

Product Manager • Coding • hard

Write a SQL query to calculate the month-over-month retention rate of users on a specific B2B SaaS product.

#Retention #Advanced SQL #Cohort Analysis

Practice

Difficulty Radar

Based on recent AI-sourced data.

Meet Your Interviewers

The "Standard" Interviewer

Senior Engineer

Focuses on core competencies, system constraints, and clear communication.

Simulate

Unwritten Rules

Think Out Loud

Always explain your thought process before writing code or drawing architecture.

Practice Now