DXC Technology
American multinational B2B IT services provider.
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
Backend Engineer
•
Technical
•
medium
What is the difference between a clustered and a non-clustered index in a relational database?
#Database Architecture
#Performance Tuning
Backend Engineer
•
Technical
•
easy
Write a SQL query to find the second highest salary from an Employee table.
#Queries
#Database
Data Engineer
•
Coding
•
medium
Write a SQL query to find the second highest salary from an Employee table without using the LIMIT or TOP keywords.
#SQL
#Subqueries
#Aggregations
Data Engineer
•
Coding
•
medium
Write a SQL query to calculate the cumulative sum of sales by month for each region.
#SQL
#Window Functions
#Data Aggregation
Data Engineer
•
Technical
•
medium
You have a query that is taking too long to execute. Walk me through the steps you would take to optimize it.
#Performance Tuning
#Execution Plans
#Indexing
Data Engineer
•
Technical
•
medium
What is the difference between a Common Table Expression (CTE) and a Temporary Table? When would you use one over the other?
#SQL
#Database Architecture
#Performance
Data Engineer
•
Technical
•
easy
Explain the difference between RANK(), DENSE_RANK(), and ROW_NUMBER() in SQL. Provide a scenario where you would use each.
#SQL
#Window Functions
Data Scientist
•
Coding
•
medium
Write a SQL query to find the top 3 highest-paid employees in each department. Handle ties appropriately.
#SQL
#Window Functions
#Ranking
Data Scientist
•
Coding
•
medium
Write a SQL query to calculate the cumulative sum of revenue per month for the year 2023.
#SQL
#Window Functions
#Cumulative Sum
Data Scientist
•
Coding
•
hard
Write a SQL query to find the retention rate of users. Specifically, find the percentage of users who logged in on day 1 and also logged in on day 2.
#SQL
#Self Joins
#Cohort Analysis
#Product Analytics
Data Scientist
•
Coding
•
medium
Write a SQL query using window functions to calculate the 7-day rolling average of daily transaction volumes for a specific enterprise client.
#SQL
#Window Functions
#Data Aggregation
Full Stack Engineer
•
Coding
•
medium
Write a SQL query to find the second highest salary from an Employee table. If there is no second highest salary, return null.
#Database
#Queries
#Aggregation
Machine Learning Engineer
•
Coding
•
medium
Write a SQL query to identify clients who have a churn probability greater than 0.8 and have not logged in for the past 30 days, joining a predictions table and a user_activity table.
#SQL
#Joins
#Filtering
Machine Learning Engineer
•
Coding
•
medium
Write a SQL query to calculate the 7-day rolling average of model inference latency times from a logs table.
#SQL
#Window Functions
#Time Series
Product Manager
•
Coding
•
medium
Write a SQL query to find the average time it takes to resolve a critical severity IT support ticket, grouped by client.
#Data Aggregation
#ITSM Metrics
#Performance Tracking
Product Manager
•
Coding
•
medium
Write a SQL query to find the top 5 enterprise clients by monthly recurring revenue (MRR) who have an active 'CloudRight' subscription.
#Data Extraction
#Revenue Metrics
#Database Querying
Product Manager
•
Coding
•
hard
Write a SQL query to calculate the month-over-month churn rate of our SaaS enterprise offering.
#Data Analytics
#Churn
#Window Functions
Product Manager
•
Coding
•
easy
Write a SQL query to identify users who have an active license but haven't logged into the enterprise portal in the last 90 days.
#User Engagement
#Data Extraction
#Filtering
Software Engineer
•
Coding
•
medium
Write a SQL query to find all employees who earn more than their managers.
#Databases
#Joins
Software Engineer
•
Coding
•
easy
Write a SQL query to find the second highest salary from an Employee table. If there is no second highest salary, return null.
#Databases
#Aggregation
Software Engineer
•
Technical
•
easy
Explain the difference between an INNER JOIN and a LEFT JOIN in SQL. When would you use one over the other?
#Databases
#Joins
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.