Wipro

Global information technology, consulting and business process services company.

4 Rounds ~21 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 Backend Engineer 2 Data Engineer 7 Data Scientist 3 Full Stack Engineer 3 Machine Learning Engineer 2 Product Manager 3 Software Engineer 3

All Topics SQL 7 Big Data 7 PySpark 4 System Design 4 Culture Fit 3 Python 3 Data Warehousing 2 Cloud 1

Data Engineer • Coding • medium

Write a SQL query to find all employees who earn more than their direct managers.

#Self Join #Filtering

Practice

Data Engineer • Coding • medium

Write a SQL query to find the 3rd highest salary from an Employee table without using the LIMIT keyword.

#Window Functions #DENSE_RANK #Subqueries

Practice

Data Engineer • Coding • medium

Write a SQL query to calculate the cumulative sum of sales per month for each product category.

#Window Functions #Aggregations

Practice

Data Engineer • Coding • hard

Write a SQL query to find the cancellation rate of unbanned users on a specific date. (Similar to LeetCode 'Trips and Users').

#Joins #Aggregations #Case Statements

Practice

Data Engineer • Coding • medium

Write a SQL query to identify duplicate records in a table based on 'email' and 'username', and keep only the record with the latest 'created_at' date.

#CTEs #Window Functions #Data Cleansing

Practice

Data Engineer • Technical • easy

Explain the difference between ROW_NUMBER(), RANK(), and DENSE_RANK() with a real-world data engineering example.

#Window Functions #Ranking

Practice

Data Engineer • Technical • easy

What is the difference between an Inner Join, Left Join, and Full Outer Join? How do NULL values affect these joins?

#Joins #Relational Algebra

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