How to crack Mastercard: The Consultant & Associate Product Specialist interview, from real experiences
Mastercard Consultant & Associate Product Specialist (APS) interview guide for India campus hiring: the Aptitude/SQL/Python/Excel OA, with real reported questions.
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 summary | Skill or pattern | Level / scope | Codinzhub question or experience |
|---|---|---|---|
| In the word "AUTUMN," find letter pairs whose position-gap in the word matches their alphabet-position gap. | Logical reasoning | Consultant & APS, IIT Roorkee, 2026 | MCQs: Consultant & APS Role |
| Arrange the letters of "POWERED" in reverse alphabetical order; find the 5th letter. | Sorting/reasoning | Consultant & APS, IIT Roorkee, 2026 | MCQs: Consultant & APS Role |
| An asset worth ₹54,000 depreciates 10% in Year 1, then 12.5% in Year 2; find its remaining value. | Compound percentage | Consultant & APS, IIT Roorkee, 2026 | MCQs: Consultant & APS Role |
| The difference between 21% and 12% of a number is 476; find 20% of that number. | Percentage algebra | Consultant & APS, IIT Roorkee, 2026 | MCQs: Consultant & APS Role |
Reported questions: SQL
| Question summary | Skill or pattern | Level / scope | Codinzhub 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 conversion | Consultant & APS, IIT Roorkee, 2026 | MCQs: Consultant & APS Role |
| Given Medicine and Hospital tables, find medicines expiring after 18 May 2018 from hospitals with more than 15 branches. | SQL, JOIN + filter | Associate Consultant / Product and Consultant, IIT Roorkee, 2026 | Return the new code · Mastercard OA, Product and Consultant |
Reported questions: Python
| Question summary | Skill or pattern | Level / scope | Codinzhub 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/greedy | Associate Consultant / Product and Consultant, IIT Roorkee, 2026 | Return the new code · Mastercard OA, Product and Consultant |
Reported questions: Excel / Power BI
| Question summary | Skill or pattern | Level / scope | Codinzhub question or experience |
|---|---|---|---|
| A VLOOKUP-related question (exact wording not recalled by the reporter). | Excel formulas | Product and Consultant, IIT Roorkee, 2026 | Mastercard 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
| Variation | What was reported |
|---|---|
| Role name | The 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
| Do | Don't | Why 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.
| Topic | What it means | Reported examples | Codinzhub practice |
|---|---|---|---|
| SQL joins and date handling | Combining tables and filtering with a converted date type | Medicines/Hospital join with expiry-date filter | Return the new code |
| Number construction with a divisibility rule | Building the smallest valid number under constraints | Smallest multiple starting with X | Return the new code |
| Aptitude and reasoning | Percentages, compound changes, word/letter puzzles | Compound depreciation, letter-pair distances | MCQs: Consultant & APS Role |
| Excel/Power BI | Spreadsheet functions and basic BI concepts | VLOOKUP-related question | Mastercard 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 problem | Pattern | Related reported question or variant |
|---|---|---|---|
| 1 | Customers Who Never Order (LeetCode: SQL JOIN/filter practice) | SQL JOIN + filter | Medicines/Hospital expiry-date query |
| 2 | Smallest-multiple-with-prefix construction (standard number-theory practice exercise) | Number construction, divisibility | "Return the new code" |
| 3 | VLOOKUP practice exercise (standard Excel-training exercise) | Spreadsheet functions | VLOOKUP-related question |
How to handle a question you have never seen
- For SQL, check column types first; a date stored as text needs explicit conversion before filtering or comparing.
- 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.
- 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
- This OA is non-technical overall: aptitude, SQL, Python basics and Excel/Power BI, not DSA.
- Convert date-as-text columns before filtering in SQL; this exact trap was reported.
- Practise "smallest number with a given prefix, divisible by Y" by appending digits.
- Revise Excel/Power BI broadly; our evidence for this section is thin.
- 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
Keep track of what you’ve learned.