Dataford
Top 37
Prep plan
Updated weekly · Last refresh Sep 9

Mastek Consultant Interview Questions

The questions to prepare for a Mastek Consultant interview. Questions from real interview reports rank first. Updated daily.

37questions
~5htotal time
Track your progressSign up free to work through all 37 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 10 questions + 3 drills · ~110 min
SQL Basics and QueriesMedium

Evaluates SQL query writing and core data type understanding.

sql queriesMastek
SQL on Paper Use CaseMedium

Tests SQL problem-solving ability without tooling.

sqlMastek
SQL Duplicate Record DetectionEasy
Practice
Practice drill

Find duplicate American Institutes for Research assessment submissions using a CTE, GROUP BY, HAVING, and joins.

deduplicationsqldata integrityAmerican Institutes for ResearchPublix Super MarketsMacy's
Second Highest Trader SalaryEasy
Practice
Practice drill

Find the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.

SubqueriesRankingSortingeClinicalWorksNNeenOpal CanadaInformatica
Top Customers by Sales RevenueEasy
Practice
Practice drill

Use GROUP BY and SUM to rank the top 10 customers by total revenue from a single sales table.

RankingGroup ByAggregationsHousecall ProEquifaxXYZ
More SQL & Data Manipulation questions with a free account
2
Finance & Accounting6 questions · ~48 min
P2P Cycle OverviewMedium

Tests understanding of procure-to-pay process flow in ERP/accounting contexts.

Mastek
Accounting Entries in P2PMedium

Evaluates ERP accounting knowledge tied to procure-to-pay activities.

Mastek
More Finance & Accounting questions with a free account
3
Behavioral & Leadership16 questions · ~128 min
More Behavioral & Leadership questions with a free account
4
More topics5 questions · ~40 min
Tell Me About YourselfEasy

Craft a concise self-introduction that highlights fit, communication style, and relevance for an Account Executive role.

brand cultureBusiness AcumenCompetitive AnalysisMastek
ERP Structure and Database BackboneMedium

Evaluates understanding of ERP architecture and database fundamentals.

Mastek
Internship Metrics and ToolsMedium

Assesses familiarity with analytics/CRM concepts and their business impact.

crmMastek
GD Topic: EV VehiclesMedium

Evaluates reasoning, communication, and structured argumentation in a GD setting.

market analysisMastek
More 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
The finish line: interview-readyComplete all 37 questions plus 3 hands-on drills to finish this plan.