Mphasis Data Analyst Interview Questions

The questions to prepare for a Mphasis Data Analyst interview. Questions from real interview reports rank first. Updated daily.

32questions

~5htotal time

Track your progressSign up free to work through all 32 questions and resume where you left off.

Start practicing free →

SQL & Data ManipulationStart here. 15 questions + 1 drill · ~141 min

Highest Manager Salary QueryEasy

Practice

Use MAX and WHERE to find the highest salary among Mphasis managers.

sql

Mphasis

Second Highest Without AggregatesHard

Practice

Find the second highest salary in each department without using aggregate functions.

SubqueriesRankingSelf-Joins

Mphasis

Primary Key vs Foreign KeyEasy

Explain how primary keys and foreign keys differ and how together they keep related tables consistent.

data relationshipsdatabase designdata integrity

Mphasis

Window Ranking in Ticket QueuesMedium

Explain SQL window functions and when to use ROW_NUMBER() versus DENSE_RANK() for ranked ticket analysis.

Window FunctionsRankingrow_number

Mphasis

SQL Join TypesMedium

Practice

Practice drill

Demonstrate INNER, LEFT, RIGHT, and FULL OUTER JOIN behavior using matched and unmatched records.

null handlingJoinssql

SAIC

NPCI

Wipro

More SQL & Data Manipulation questions with a free account

Pipelines16 questions · ~140 min

Star vs Snowflake SchemaEasy

Compare star and snowflake schemas in a warehouse pipeline, including structure and transformation trade-offs.

snowflake schemastar schemaData Modeling

Mphasis

Data Quality in ETL PipelinesEasy

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQuality

Mphasis

Incremental Loading in ETLMedium

Tests ETL design knowledge for efficient updates and reduced processing time.

SchedulingETLBatch Processing

Mphasis

More Pipelines questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan