Jobra
🐞Step 1 of Jobra:AI Debugging Rounds
DSA+AIPreparing you for both.
JOBRA · AI DEBUG ROUND (PREVIEW)sum.cpp
// buggy snippet
int total(vector<int>& a, int n) {
    int sum = 0;
    for (int i = 0; i <= n; i++) { // 🐞        sum += a[i];
    }
    return sum;
}
A real codebase. A real bug. You + AI.

Jobra drops you into a broken repo. Find it, fix it, ship it. AI helps you debug like on the job.

Prompt:Correct the loop condition
Tap 'Let Jobra fix it' below to simulate AI debugging...

How to crack Mastercard: The Consultant & Associate Product Specialist interview, from real experiences

8 min read

Mastercard Consultant & Associate Product Specialist (APS) interview guide for India campus hiring: the Aptitude/SQL/Python/Excel OA, with real reported questions.

In this article
On this page

Last reviewed November 17, 2026.

For students interviewing for the Consultant & Associate Product Specialist (APS) / Product and Consultant roles at Mastercard on Indian campuses.

Built by the Codinzhub team from Mastercard Consultant/APS online assessment papers that students shared on Codinzhub in October 2026, from IIT Roorkee. We also searched r/developersIndia (via the keyless Arctic Shift Reddit archive) for "Mastercard interview" and found general process-timeline and salary-negotiation threads, but nothing specific to this non-technical track, so none of that is used here. Use this guide as a map, not a promise.

The 30-second version. Mastercard's Consultant & Associate Product Specialist (APS) hiring, reported at IIT Roorkee (called "Product and Consultant" in one paper), runs a non-coding-heavy OA with 4 sections: Aptitude (about 20 questions), SQL (1 coding question plus 4-5 MCQs), Python (1 coding question plus 4 MCQs), and Excel/Power BI (about 10 MCQs). The reported SQL coding task and the Python coding task in two separate papers from the same drive are, in substance, the same two problems: a join-and-filter SQL query, and a "smallest number that starts with X and is divisible by Y" construction problem.

Important things to know before the interview

This is a largely non-technical, tools-and-aptitude OA, not a DSA test. Unlike Mastercard's SDE role, this OA tests SQL, Python basics, Excel/Power BI and aptitude — if you are preparing for this role, do not spend your time on DSA grinding; it does not match what was reported here.

The same two coding tasks appear in more than one reported paper from the same drive. One paper names the questions generically ("1 sql code," "1 python code"); another, from the same IITR drive, spells out the exact same SQL join-filter task and the exact same "smallest multiple with a given prefix" Python task. Treat these two as the one sample paper for this role, not two independent problems.

VLOOKUP came up in the Excel section, but the reporter couldn't recall more. One candidate explicitly said they "don't remember much" about the Excel/Power BI section beyond one VLOOKUP-related question — treat our evidence for that section as thin, and revise broadly rather than narrowly.

What this guide covers

This guide covers the Consultant & Associate Product Specialist (APS), also reported as "Product and Consultant," role at Mastercard, hired through on-campus drives at IIT Roorkee (HirePro platform, October 2026). It does not cover the SDE or Data Scientist roles; see our separate guides for those.

Round-by-round breakdown

Stage 1: Application, where candidates applied

How it works. Not reported in detail. Both OA reports in this guide are from an on-campus drive at IIT Roorkee, run on the HirePro platform.

Stage 2: Shortlisting, how candidates moved forward

How it works. Not reported.

Stage 3: Online assessment (OA)

How it works. The OA has four distinct sections: quantitative/logical aptitude, SQL (one coding query plus a few MCQs), Python (one coding question plus a few MCQs), and Excel/Power BI (MCQs only).

At a glance

  • Duration: Not reported
  • Questions per round: About 20 aptitude MCQs, 1 SQL coding + 4-5 SQL MCQs, 1 Python coding + 4 Python MCQs, about 10 Excel/Power BI MCQs
  • Topics: quantitative and logical aptitude, SQL joins and date-type conversion, basic Python/number-construction logic, Excel functions (VLOOKUP) and Power BI basics
  • Reported examples: compound depreciation, letter-pair distance puzzles, SQL date-string filtering, smallest multiple with a given prefix

Reported questions: aptitude

Question summarySkill or patternLevel / scopeCodinzhub question or experience
In the word "AUTUMN," find letter pairs whose position-gap in the word matches their alphabet-position gap.Logical reasoningConsultant & APS, IIT Roorkee, 2026MCQs: Consultant & APS Role
Arrange the letters of "POWERED" in reverse alphabetical order; find the 5th letter.Sorting/reasoningConsultant & APS, IIT Roorkee, 2026MCQs: Consultant & APS Role
An asset worth ₹54,000 depreciates 10% in Year 1, then 12.5% in Year 2; find its remaining value.Compound percentageConsultant & APS, IIT Roorkee, 2026MCQs: Consultant & APS Role
The difference between 21% and 12% of a number is 476; find 20% of that number.Percentage algebraConsultant & APS, IIT Roorkee, 2026MCQs: Consultant & APS Role

Reported questions: SQL

Question summarySkill or patternLevel / scopeCodinzhub question or experience
A Medicines table stores expiry_date as VARCHAR; pick the correct expression to convert it for comparison/filtering.SQL, string-to-date conversionConsultant & APS, IIT Roorkee, 2026MCQs: Consultant & APS Role
Given Medicine and Hospital tables, find medicines expiring after 18 May 2018 from hospitals with more than 15 branches.SQL, JOIN + filterAssociate Consultant / Product and Consultant, IIT Roorkee, 2026Return the new code · Mastercard OA, Product and Consultant

Reported questions: Python

Question summarySkill or patternLevel / scopeCodinzhub question or experience
Given integers x and y, find the smallest integer m that starts with x's digits and is divisible by y, by appending digits to x.Number construction, BFS/greedyAssociate Consultant / Product and Consultant, IIT Roorkee, 2026Return the new code · Mastercard OA, Product and Consultant

Reported questions: Excel / Power BI

Question summarySkill or patternLevel / scopeCodinzhub question or experience
A VLOOKUP-related question (exact wording not recalled by the reporter).Excel formulasProduct and Consultant, IIT Roorkee, 2026Mastercard OA, Product and Consultant

Mastercard experiences shared on Codinzhub

No separate interview-stage experience reports exist yet for this role in this guide; only OA question records are available.

The Codinzhub next-round playbook

To prepare for the OA

  • Revise SQL JOINs and, specifically, converting a VARCHAR date column to a proper date type before filtering or comparing it — this exact trap appeared in the reported paper.
  • Practise the "smallest number starting with X, divisible by Y" construction pattern: try appending digits one at a time and check divisibility, since X may already need 0 or more digits appended.
  • Revise core Excel functions (VLOOKUP/XLOOKUP, pivot tables) and basic Power BI concepts, even though our evidence for this section is thin.
  • Time-box the aptitude section; it is the largest single block (about 20 questions) and covers percentages, compound changes, and letter/word puzzles.

Variations within this role

VariationWhat was reported
Role nameThe same drive is referred to as "Consultant & Associate Product Specialist (APS)" in one paper and "Product and Consultant" in another, both from IIT Roorkee in the same window (October 2026); treat them as the same hiring track.

Do's and don'ts

DoDon'tWhy it matters
Convert VARCHAR date columns to a real date type before filtering.Compare date strings directly in SQL.The reported SQL MCQ is built specifically around this trap.
Practise constructing numbers with a divisibility constraint by appending digits.Assume the answer is always the original number itself.The example shows digits must sometimes be appended (50 → 501), not just checked as-is.
Revise core Excel/Power BI functions broadly.Narrow your Excel prep to only VLOOKUP.Our only Excel evidence is a single, incompletely recalled VLOOKUP question; the actual section may cover more.
Budget your time across all 4 OA sections before starting.Spend disproportionate time on the aptitude section alone.The paper has 4 roughly equal-weighted sections (aptitude, SQL, Python, Excel/BI).

Most-asked topics

This dataset is small: 2 OA papers from one campus drive, covering the same underlying questions. We list what appeared without ranking by frequency.

TopicWhat it meansReported examplesCodinzhub practice
SQL joins and date handlingCombining tables and filtering with a converted date typeMedicines/Hospital join with expiry-date filterReturn the new code
Number construction with a divisibility ruleBuilding the smallest valid number under constraintsSmallest multiple starting with XReturn the new code
Aptitude and reasoningPercentages, compound changes, word/letter puzzlesCompound depreciation, letter-pair distancesMCQs: Consultant & APS Role
Excel/Power BISpreadsheet functions and basic BI conceptsVLOOKUP-related questionMastercard OA, Product and Consultant

Preparing for the behavioural aspects

Not reported. We have no interview-stage account for this role; only OA records.

Practice problems that match the experiences

These are practice analogues, not proof that Mastercard asked the exact problem, unless marked otherwise.

#Practice problemPatternRelated reported question or variant
1Customers Who Never Order (LeetCode: SQL JOIN/filter practice)SQL JOIN + filterMedicines/Hospital expiry-date query
2Smallest-multiple-with-prefix construction (standard number-theory practice exercise)Number construction, divisibility"Return the new code"
3VLOOKUP practice exercise (standard Excel-training exercise)Spreadsheet functionsVLOOKUP-related question

How to handle a question you have never seen

  1. For SQL, check column types first; a date stored as text needs explicit conversion before filtering or comparing.
  2. For the number-construction pattern, try appending digits one at a time (0, 1, 2, ...) and check divisibility after each append, stopping at the first valid number.
  3. For aptitude percentage questions, write the relationships as simple equations before solving, rather than estimating.

Why candidates were rejected

No report in this guide gives an outcome or rejection feedback for this role.

If you remember only five things

  1. This OA is non-technical overall: aptitude, SQL, Python basics and Excel/Power BI, not DSA.
  2. Convert date-as-text columns before filtering in SQL; this exact trap was reported.
  3. Practise "smallest number with a given prefix, divisible by Y" by appending digits.
  4. Revise Excel/Power BI broadly; our evidence for this section is thin.
  5. Budget time across all 4 OA sections rather than over-investing in one.

FAQ

Is this the same OA as the SDE role?

No. The SDE OA (see our separate guide) is 2 DSA questions only; this role's OA has aptitude, SQL, Python and Excel/Power BI sections instead.

Are "Consultant & APS" and "Product and Consultant" the same role?

Based on these reports, they appear to be the same IIT Roorkee drive referred to by two different names in different papers.

Do I need to know Power BI in depth?

Not confirmed. Our only evidence for this section is one VLOOKUP-related question that the reporter could not fully recall; revise broadly rather than assuming the section is Excel-only.

About this guide

The Codinzhub team wrote this guide from 2 Mastercard Consultant/APS OA papers shared on Codinzhub in October 2026, from an IIT Roorkee campus drive (HirePro platform). We also searched r/developersIndia via the keyless Arctic Shift Reddit archive for "Mastercard interview" and found only general process/salary threads unrelated to this specific role, so nothing from Reddit is used here. Questions are short paraphrases in our own words.

You can help other students by sharing your Mastercard experience on Codinzhub.

Interview processes change by campus, year and team. Your placement cell or recruiter can confirm the current format.

Other company and role guides

Ready for the next topic?

Keep track of what you’ve learned.