Wipro

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

Backend Engineer • Coding • medium

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

#SQL #Subqueries #Database
Practice
Backend Engineer • Technical • medium

What is the difference between clustered and non-clustered indexes in a relational database?

#Database #Indexing #Performance
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 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 • 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 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 • 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
Data Scientist • Coding • hard

Write a SQL query to identify the top 3 most frequently purchased pairs of products (Market Basket Analysis prep).

#Self Joins #Aggregations #Data Mining
Practice
Data Scientist • Coding • medium

Write a SQL query to calculate the 7-day rolling average of daily revenue for a retail client.

#Window Functions #Time Series #SQL
Practice
Data Scientist • Coding • medium

Write a SQL query using window functions to find the second highest salary in each department for a client's HR database.

#Window Functions #Data Aggregation #SQL
Practice
Full Stack Engineer • Technical • easy

Explain the ACID properties in the context of database transactions.

#Databases #Transactions
Practice
Full Stack Engineer • Technical • easy

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

#Databases #Queries
Practice
Full Stack Engineer • Technical • medium

What is the difference between clustered and non-clustered indexes in SQL?

#Databases #Performance Tuning #Indexing
Practice
Machine Learning Engineer • Coding • medium

Write a SQL query to find the top 3 most frequently purchased items per customer in the last 30 days.

#Window Functions #Aggregations #Data Manipulation
Practice
Machine Learning Engineer • Coding • medium

Write a SQL query to calculate the 7-day rolling average of daily sales for a specific product.

#Window Functions #Time Series #Data Analysis
Practice
Product Manager • Coding • easy

Write a SQL query to identify users who haven't logged into the enterprise portal in the last 30 days.

#Data Extraction #User Engagement
Practice
Product Manager • Coding • medium

Write a SQL query to calculate the month-over-month churn rate of a subscription-based enterprise product.

#Data Analysis #Churn #Window Functions
Practice
Product Manager • Coding • easy

Write a SQL query to find the top 5 Wipro clients by revenue generated in the last quarter.

#Data Extraction #Aggregation
Practice
Software Engineer • Technical • easy

Write a SQL query to find the second highest salary of an employee from the 'Employees' table.

#Database #Queries #Aggregations
Practice
Software Engineer • Technical • easy

What are the differences between INNER JOIN, LEFT JOIN, and RIGHT JOIN? Provide a scenario for each.

#Database #SQL Joins
Practice
Software Engineer • Technical • easy

Write a SQL query to find all duplicate email addresses in a 'Users' table.

#Database #GROUP BY #HAVING
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