Interview preparation

Mindrift interview process & preparation

Mindrift currently has 2+ live openings on OnJob.io, concentrated in Data Analyst and UI/UX Designer roles. There are no leaked or company-specific questions here — instead, prepare with the general, role-based interview rounds and most-asked questions for those role types below, then practise them free with OnJob's AI mock interview.

Honest note: OnJob.io does not publish leaked or company-confidential interview questions. The guides below are general, role-based preparation — the standard rounds and commonly-asked questions for the role types Mindrift is currently hiring for. Use them to prepare; your real Mindrift interview may differ.

What to expect when interviewing for Data Analyst and UI/UX Designer roles at companies like Mindrift

Mindrift is currently advertising these role types on OnJob.io. Each guide is the general interview structure and most-asked questions for that role — prepare with it, then rehearse free with the AI mock interview.

General Data Analyst interview prep

1 live role at Mindrift

SQL, Excel, statistics and storytelling with data — the analyst interview for product, BI and analytics teams across India.

Typical Data Analyst interview rounds

  1. 1 SQL round. Joins, aggregations, window functions and query writing.
  2. 2 Excel / spreadsheet round. Lookups, pivot tables and formulas.
  3. 3 Case / analytics round. Business case: define metrics, analyse and recommend.
  4. 4 Tool & viz round. Power BI / Tableau dashboards and stakeholder communication.

Commonly-asked Data Analyst questions

  • What is the difference between INNER JOIN, LEFT JOIN and FULL OUTER JOIN?
  • Write a SQL query to find the second-highest salary in a table.
  • What is the difference between WHERE and HAVING?
  • Explain window functions like ROW_NUMBER(), RANK() and DENSE_RANK().
  • What is the difference between mean, median and mode, and when is each misleading?
  • How do you handle missing or null values in a dataset?
  • Explain the difference between a primary key and a foreign key.
  • What is normalisation, and why does it matter for analysis?

General UI/UX Designer interview prep

1 live role at Mindrift

Design thinking, Figma, portfolios and usability — the product-design interview for startups, agencies and product companies.

Typical UI/UX Designer interview rounds

  1. 1 Portfolio review. Walk through 2–3 case studies: problem, process, decisions, impact.
  2. 2 Design exercise / whiteboard. Solve a design problem live or as a take-home.
  3. 3 Craft & tools. Figma skills, design systems, prototyping and handoff.
  4. 4 Collaboration & behavioural. Working with PMs and engineers, handling feedback.

Commonly-asked UI/UX Designer questions

  • Walk me through your favourite project in your portfolio.
  • What is the difference between UX and UI design?
  • Explain your design process from problem to final solution.
  • How do you conduct user research, and how does it shape your designs?
  • What is the difference between a wireframe, a mockup and a prototype?
  • How do you measure whether a design is successful?
  • How would you redesign [a common app] to improve a specific flow?
  • What is a design system and why does it matter?

Rehearse your Mindrift interview, free

Run a realistic AI mock interview for your target role and get instant feedback on your answers — or take a timed mock test to check your fundamentals before the real thing.

Interview prep at other companies

Mindrift interview — FAQs

How do I prepare for a Mindrift interview?

Prepare by role: identify the role you're applying for, then practise the standard interview rounds and most-asked questions for that role type. Mindrift is currently hiring for Data Analyst and UI/UX Designer roles, so focus there. Use OnJob's free AI mock interview to rehearse with instant feedback, and review the role-specific question lists below. These are general role-based questions, not leaked Mindrift questions.

What questions are asked in a Mindrift interview?

We don't publish leaked or company-specific Mindrift questions. What we do provide is the general, frequently-asked interview questions for the role types Mindrift hires for — such as Data Analyst and UI/UX Designer roles. For example, Data Analyst interviews commonly cover: What is the difference between INNER JOIN, LEFT JOIN and FULL OUTER JOIN? Write a SQL query to find the second-highest salary in a table. What is the difference between WHERE and HAVING? Prepare with these general questions and OnJob's free AI mock interview.

How many rounds does a Mindrift interview have?

It depends on the role. A typical Data Analyst interview runs across 4 rounds — SQL round, Excel / spreadsheet round, Case / analytics round, Tool & viz round. Round counts vary by company and seniority; treat this as the general structure to prepare for, not a guarantee of Mindrift's exact process.

Is Mindrift hiring right now?

Yes — Mindrift has 2+ live openings on OnJob.io, refreshed daily, mostly for Data Analyst and UI/UX Designer roles. Browse the live Mindrift jobs and see your AI match score on each before you apply.

Free forever — no credit card

Get matched to Mindrift roles you're ready for

Create a free profile to see your AI match score on every live Mindrift opening, practise the interview, and apply in one click.