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
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
•
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 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
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.