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