JobsJob TrackerJob alerts

IDFC First Bank ยท 42 questions

All 42Coding 10System Design 2Low-Level Design 1Behavioral 15Product Sense 9
  • Hard-edge-case problem solved with a simple greedy approachCoding
  • Employee free timeCoding
  • Explain projects, tech choices, contribution and challengesBehavioral
  • Career goals and interest in banking and fintechBehavioral
  • Find the repeating and missing number in an arrayCoding
  • OOP pillars and polymorphism types with implementation
  • Two-sum-like problem with explanation and complexityCoding
  • Find the highest playing card from a listCoding
  • What do you know about IDFC First Bank?Behavioral
  • What is IDFC First's customer-first philosophy?Behavioral
  • Where do you see yourself growing in IDFC First?Behavioral
  • Explain retail vs corporate banking
  • What is asset-liability management (ALM)?
  • Library summarizer problemCoding
  • DSA problems on arrays and linked listsCoding
  • Design a University Academic Tracking SystemSystem Design
  • Complex SQL queriesCoding
  • General HR questionsBehavioral
  • Explain callback functions in Node.js
  • Split long texts into positive and negative parts
  • Maximum level sum of a binary treeCoding
  • Design the architecture of a hotel management systemSystem Design
  • Design a schema for a car-engine problem statement and normalize to 3NFLow-Level Design
  • Optimal Fibonacci with overlapping subproblemsCoding
  • Opinion on credit and debit cards going digital; implement a hobby on a websiteBehavioral
  • How would you improve the user experience of our mobile banking app?Product Sense
  • Design a feature for small business owners to manage their finances better.Product Sense
  • How would you prioritize features for a new product launch?Product Sense
  • Discuss a time when you had to make a trade-off between user needs and business goals.Behavioral
  • How would you measure the success of a new feature?Product Sense
  • What metrics would you track for a digital lending product?Product Sense
  • How would you identify and address key user pain points in a banking/fintech product?Product Sense
  • Which metrics would you analyze to evaluate the impact of a newly launched feature?Product Sense
  • How would you design and interpret an A/B test for a new app feature?Product Sense
  • How do you connect product KPIs to business objectives?Product Sense
  • Tell me about yourself.Behavioral
  • Describe a challenging situation you faced at work and how you handled it.Behavioral
  • Why do you want to join IDFC FIRST Bank as a Product Manager?Behavioral
  • How do you see yourself growing in this role?Behavioral
  • Given multiple scenarios, which one would you choose and why?Behavioral
  • How do you handle conflicting priorities among stakeholders?Behavioral
  • How do you collaborate with engineering, design, and marketing?Behavioral
โ† IDFC First Bank questions
  1. Interview questions
  2. IDFC First Bank
  3. Complex SQL queries
Coding

Complex SQL queries

Filed under IDFC First Bank

The question

Write two complex SQL queries.

No write-up yet. Related questions below have one.

Related IDFC First Bank questions

  • Hard-edge-case problem solved with a simple greedy approach
  • Employee free time
  • Find the repeating and missing number in an array
  • Two-sum-like problem with explanation and complexity
  • Find the highest playing card from a list
โ† Design a University Academic Tracking SystemGeneral HR questions โ†’

Collected from public candidate posts and coding forums. Updated Nov 2026.