πŸ’¬ Interview Experience

Infosys Software Engineer IIM Lucknow Interview: Database & RDBMS Questions

Real Infosys Software Engineer IIM Lucknow interview with 2.5 years experience. Learn exact questions on database relevance, RDBMS fundamentals, life goals asked by IIM-L panelists.

From Code to Campus: How a Software Engineer Survived IIM Lucknow’s Grilling Panel. This detailed interview experience reveals how a B.Tech Computer Science graduate with 2.5 years at Infosys navigated a challenging mix of technical deep-dives, market awareness questions, and introspective queries at IIM Lucknow. Learn the specific questions on databases, RDBMS fundamentals, business trends, and personal growth that tested this candidate’s depth, presence of mind, and emotional intelligence.

πŸ“Š Interview at a Glance

Institute IIM Lucknow
Program PGP (MBA)
Profile Software Engineer (2.5 years at Infosys)
Academic Background B.Tech in Computer Science
Interview Format Offline in Mumbai (2 Panelists)
Key Focus Areas Databases & RDBMS, Business Awareness, Life Goals

πŸ”₯ Challenge Yourself First!

Before reading further, pause and thinkβ€”how would YOU answer these actual interview questions?

1 The Database Relevance Debate

“Do you think databases are irrelevant now?”

This is a provocative question designed to test your technical conviction and ability to defend your domain expertise.

βœ… Success Strategy

Structure your answer by first acknowledging the evolution of data storage (NoSQL, cloud databases, data lakes) while firmly asserting that traditional RDBMS remains fundamental for transactional systems, financial applications, and data integrity. Mention specific use cases like banking, e-commerce transactions, and enterprise systems. Show awareness of the NoSQL vs SQL debate while demonstrating that databases are more relevant than ever in a data-driven world. Avoid being defensiveβ€”show nuanced understanding.

2 The Market Opinion Test

“Nikhil Kamath said stocks are in a bubble. What do you think?”

The panel is testing your awareness of business news and your ability to form informed opinions on market trends.

βœ… Success Strategy

Start by acknowledging who Nikhil Kamath is (co-founder of Zerodha) to establish credibility. Present a balanced viewβ€”discuss valuation metrics like P/E ratios, FII flows, and retail participation. Avoid extreme positions; instead, show analytical thinking. You could mention sector-specific bubbles vs. overall market health. The key is demonstrating that you follow financial news and can think critically about expert opinions rather than blindly agreeing or disagreeing.

3 The Life Aspiration Question

“What do you want to be in life? What kind of person do you aspire to become?”

This deeply introspective question tests your self-awareness, maturity, and ability to articulate personal values.

βœ… Success Strategy

Be authentic and personalβ€”this isn’t about career goals but character. Mention values like integrity, continuous learning, impact on others, or work-life balance. Connect your aspirations to specific experiences or role models. Avoid generic answers like “I want to be successful.” Show emotional depth and self-reflection. A good structure: “The kind of person I aspire to become is… because… and I’m working towards this by…” This humanizes you beyond your resume.

4 The Technical Surprise

“What is the derivative of log(x)?”

A sudden math question to test if you remember fundamentals and can handle unexpected shifts in conversation.

βœ… Success Strategy

The answer is 1/x (for natural logarithm). State it confidently and quickly. If you’re unsure, say so honestly rather than guessing wrongβ€”panels respect honesty. The panel may follow up with quirky questions (like asking if you got answers from a Telegram group), so stay composed. This tests your ability to handle sudden topic switches and whether you’ve brushed up on basics. Quick tip: Review basic derivatives, integrals, and probability before technical interviews.

πŸŽ₯ Video Walkthrough

Video content coming soon.

πŸ‘€ Candidate Profile

Understanding the candidate’s background helps contextualize the interview questions and strategies.

πŸŽ“

Background

  • Education B.Tech in Computer Science
  • Work Experience ~2.5 years
  • Role Software Engineer at Infosys
  • Category OBC
πŸ“Š

Academic Record

  • Undergraduate B.Tech (Computer Science)
  • Performance Solid academic record
  • Consistency Throughout education
  • Strength Technical foundation in CS
🎀

Interview Panel

  • Format Offline (Mumbai)
  • Panel Composition 2 Interviewers (Both Male)
  • M1 Style Serious, mid-50s (Technical)
  • M2 Style Friendly, mid-40s (Business/Personal)

πŸ—ΊοΈ Interview Journey

Follow the complete interview flow with all questions asked and strategic insights.

1
Phase 1

Written Ability Test (WAT)

“Women in C-suite and the challenges they face”
Essay topic testing awareness of gender diversity in leadership
πŸ’‘ Strategy

Structure your essay around gender diversity, leadership barriers, societal expectations, and cite examples of successful women leaders like Indra Nooyi or Kiran Mazumdar-Shaw. Discuss glass ceiling, work-life balance challenges, and organizational bias while offering solutions.

2
Phase 2

Icebreaker & General Questions

“Where did you come from?”
Standard opener to ease into the conversation
πŸ’‘ Strategy

Keep it brief and friendly. Mention your current city and how you traveled. These questions set the toneβ€”stay calm and polite before the grilling begins.

“Are you from Mumbai? Did you arrive today?”
Follow-up to build rapport
πŸ’‘ Strategy

Answer naturally. If you traveled from another city, briefly mention it. This is about making you comfortableβ€”don’t overthink.

3
Phase 3

Technical & Analytical Deep-Dive (M1)

“Tell me about yourself.”
The classic openerβ€”your chance to set the narrative
πŸ’‘ Strategy

Use a 60-90 second structured response: Education β†’ Work experience β†’ Key achievement β†’ Why MBA β†’ Why now. Highlight your technical background while connecting it to business aspirations.

“Describe your job role.”
Testing depth of understanding of your own work
πŸ’‘ Strategy

Be specific about technologies, team size, projects, and impact. Quantify achievements where possible. Connect your role to business outcomesβ€”show you understand beyond just coding.

“Do you think databases are irrelevant now?”
Provocative question testing technical conviction
πŸ’‘ Strategy

Confidently defend databases while acknowledging evolution. Mention RDBMS for ACID compliance, NoSQL for scalability, and how both coexist. Show you understand the NoSQL vs SQL debate.

“RDBMS – 3 technical questions” (Candidate couldn’t answer)
Deep technical drilling on database fundamentals
πŸ’‘ Strategy

Brush up on RDBMS fundamentals: normalization, ACID properties, indexing, joins, transactions. If you claim database knowledge, be ready for deep dives. Honesty about gaps is better than bluffing.

“Types of data models?”
Testing breadth of database knowledge
πŸ’‘ Strategy

Cover: Hierarchical, Network, Relational, Object-oriented, and NoSQL models (Document, Key-Value, Graph, Column-family). Explain when each is appropriate with real-world examples.

4
Phase 4

Business Awareness & Current Affairs (M2)

“How are you preparing for post-MBA life?”
Testing clarity of MBA goals and career planning
πŸ’‘ Strategy

Show you’ve thought beyond just getting in. Mention target roles, industries, skills you want to develop, networking plans, and how you’ll leverage the MBA. Be specific, not generic.

“Do you watch business news or follow current affairs?”
Assessing awareness beyond technical domain
πŸ’‘ Strategy

Name specific sources (Economic Times, Mint, CNBC). Mention recent topics you’ve followed. This sets up follow-up questionsβ€”be ready to discuss what you claim to follow.

“Any business entrepreneur you follow? (Excluding Shark Tank panelists)”
Testing depth of interest in business beyond TV shows
πŸ’‘ Strategy

The candidate mentioned Nikhil Kamath. Choose someone you genuinely followβ€”know their background, business philosophy, recent news, and controversies. Be prepared for follow-up questions on their views.

“Nikhil Kamath said stocks are in a bubble. What do you think?”
Testing ability to form and defend market opinions
πŸ’‘ Strategy

Show balanced thinking. Discuss metrics (P/E ratios, market cap to GDP), acknowledge bubble concerns in specific sectors while noting fundamentals elsewhere. Avoid extreme positionsβ€”demonstrate analytical thinking.

“Have you watched Shark Tank?”
Light question but tests awareness of startup ecosystem
πŸ’‘ Strategy

If yes, mention interesting pitches and business lessons learned. If no, be honest but show interest in the startup ecosystem through other means.

“What other IIM calls do you have?”
Standard question about your options
πŸ’‘ Strategy

Be honestβ€”they often verify. List your calls but emphasize why IIM Lucknow is a top choice for you specifically. Don’t make it seem like a backup.

5
Phase 5

Quirky & Personal Questions

“What is the derivative of log(x)?”
Sudden math question to test recall and composure
πŸ’‘ Strategy

The answer is 1/x. Stay calm during topic switches. Quick mathematical recall impressesβ€”review basic calculus before interviews. If unsure, admit it honestly.

“Did you get this answer from a Telegram group? How is this group created? How can I join?”
Humorous follow-up testing your sense of humor and composure
πŸ’‘ Strategy

This is the panel having funβ€”respond with a smile and play along appropriately. Shows they’re testing your personality and ability to handle lighter moments. Don’t get defensive.

“How do you work on your stammering?”
Personal question about overcoming challenges
πŸ’‘ Strategy

Be candid about your journey. Discuss specific techniques, practice methods, and progress. This shows self-awareness and ability to address weaknesses. Turn it into a story of perseverance.

6
Phase 6

Introspective Closing

“What do you want to be in life? What kind of person do you aspire to become?”
Deep question assessing values, maturity, and self-reflection
πŸ’‘ Strategy

Be authenticβ€”this isn’t about career goals. Discuss values: integrity, impact, continuous learning, being a good mentor/leader. Connect to personal experiences or role models. Show depth beyond professional ambitions.

πŸ“ Interview Readiness Quiz

Test how prepared you are for your IIM Lucknow interview with these 5 quick questions.

1. When asked “Do you think databases are irrelevant now?”, the best approach is to:

βœ… Interview Preparation Checklist

Track your preparation progress with this comprehensive checklist.

Your Preparation Progress 0%

Self-Awareness

Technical & Domain Knowledge

Business & Current Affairs

Institute Research

🎯 Key Takeaways for Future Candidates

The most important lessons from this interview experience.

1

Be Ready for a Mix of Technical, Personal, and Quirky Questions

IIM Lucknow panels test you across multiple dimensionsβ€”from database fundamentals to life aspirations to sudden math questions. This diversity assesses your depth, breadth, presence of mind, and emotional intelligence. Don’t prepare in silos.

Action Item Create a preparation matrix covering: Technical concepts from your domain, personal introspection questions, basic math/aptitude, and current affairs. Practice transitioning between these topics smoothly.
2

Stay Updated on Business News with Informed Opinions

The panel asked about Nikhil Kamath’s market views and tested whether the candidate could engage in meaningful discussion. Surface-level awareness isn’t enoughβ€”you need to form and defend opinions backed by facts.

Action Item For the next 30 days, read one business article daily and write 3 bullet points: (1) Key fact, (2) Your opinion, (3) Supporting argument. Track 3-5 business personalities beyond Shark Tank panelists.
3

Know Your Resume and Job Role Thoroughlyβ€”Technical Depth Matters

The candidate faced deep RDBMS questions and couldn’t answer all of them. Your resume is your battlegroundβ€”every technology, project, and skill mentioned will be tested. Surface-level familiarity exposes gaps quickly.

Action Item For each item on your resume, prepare 3 levels of depth: (1) 30-second overview, (2) 2-minute detailed explanation, (3) Technical deep-dive with examples. Have colleagues quiz you on your own resume.
4

Handle Lighter Moments with Graceβ€”Personality Matters

When M2 jokingly asked about joining a Telegram group, the panel was testing personality and composure. MBA interviews assess not just competence but whether you’d be a good classmate and future colleague. Take yourself seriously, but not too seriously.

Action Item Practice with friends who can throw unexpected or humorous questions at you. Work on smiling naturally, acknowledging humor, and redirecting gracefully. Record yourself to check body language.
5

Practice Introspective Questions About Life Goals and Challenges

The closing questionβ€””What kind of person do you aspire to become?”β€”requires genuine self-reflection. This candidate was also asked about working on stammering. Such questions assess maturity, self-awareness, and authenticity beyond professional achievements.

Action Item Write 500 words answering: “What are my core values? Who has shaped me? What personal challenges have I overcome? What kind of impact do I want to make?” Use these reflections to craft authentic responses.

❓ Frequently Asked Questions

Common questions about IIM Lucknow interviews answered by experts.

What types of questions are asked in IIM Lucknow interviews?

IIM Lucknow interviews cover a diverse range of topics based on your profile:

  • Technical Questions: Deep dives into your domain expertise (databases, programming, engineering concepts)
  • Business Awareness: Current affairs, market trends, and opinions on business personalities
  • Personal Questions: Life goals, challenges, values, and introspective queries
  • Academic Basics: Sudden math questions, fundamental concepts from your degree

How long is the IIM Lucknow interview?

IIM Lucknow interviews typically last 15-25 minutes, though this can vary based on the conversation flow:

  • Shorter interviews: May indicate either strong performance or the panel has made a quick assessment
  • Longer interviews: Often mean the panel is engaged and wants to explore your profile deeply
  • WAT: Usually 15-20 minutes for the written component before the interview

How should IT professionals prepare for IIM Lucknow interviews?

IT candidates face specific challenges and opportunities:

  • Technical Depth: Know your tech stack thoroughlyβ€”databases, programming languages, system design
  • Business Connect: Articulate how your technical work impacts business outcomes
  • Current Tech Trends: Be ready to discuss AI, cloud computing, data privacy, and industry disruption
  • Why MBA: Have a compelling answer for why you’re leaving tech for management

What if I can’t answer a technical question?

Honesty is the best policy when you don’t know something:

  • Admit gracefully: “I don’t recall the exact answer, but here’s my thought process…”
  • Show learning attitude: Demonstrate curiosity rather than defensiveness
  • Don’t bluff: Panels can tell immediately, and it hurts credibility
  • Pivot if possible: Share related knowledge that demonstrates competence

How important is the WAT component?

The Written Ability Test (WAT) is a crucial component:

  • Topic variety: Can range from abstract to current affairs (like “Women in C-suite”)
  • Structure matters: Have a clear introduction, body with examples, and conclusion
  • Time management: 15-20 minutes means you need to write efficiently
  • Quality over quantity: A well-structured 200-word essay beats a rambling 400-word one

What mistakes should I avoid in IIM Lucknow interviews?

Common mistakes that can hurt your chances:

  • Surface-level prep: Knowing topics superficially without depth gets exposed quickly
  • Ignoring fundamentals: Basic math, your graduation subjects, and core concepts matter
  • Getting defensive: When challenged, stay composed and engage constructively
  • Generic answers: “I want to be successful” or “I want to make an impact” without specifics
  • Not knowing current affairs: Following business news is non-negotiable

How do panels at IIM Lucknow differ from other IIMs?

Each IIM has its own interview culture:

  • IIM Lucknow: Known for thorough technical drilling and testing emotional intelligence through quirky questions
  • Panel composition: Typically 2 panelists with distinct styles (serious + friendly is common)
  • Focus areas: Strong emphasis on domain depth, market awareness, and personal reflection
  • Preparation tip: Don’t rely on one interview styleβ€”be ready for anything
πŸ“‹ Disclaimer: The above interview experience is based on real candidate interactions collected from various sources. To ensure privacy, some details such as location, industry specifics, and numerical figures have been altered. However, the core questions and insights remain authentic. These stories are intended for educational purposes and do not claim to represent official views of any institution. Any resemblance to actual individuals is purely coincidental.

Ready to Ace Your Interview?

Get access to 50+ more interview experiences, personalized mock interviews, and expert feedback.

Prashant Chadha
Available

Connect with Prashant

Founder, WordPandit & The Learning Inc Network

With 18+ years of teaching experience and a passion for making MBA admissions preparation accessible, I'm here to help you navigate GD, PI, and WAT. Whether it's interview strategies, essay writing, or group discussion techniquesβ€”let's connect and solve it together.

18+
Years Teaching
50K+
Students Guided
8
Learning Platforms
πŸ’‘

Stuck on Your MBA Prep?
Let's Solve It Together!

Don't let doubts slow you down. Whether it's GD topics, interview questions, WAT essays, or B-school strategyβ€”I'm here to help. Choose your preferred way to connect and let's tackle your challenges head-on.

🌟 Explore The Learning Inc. Network

8 specialized platforms. 1 mission: Your success in competitive exams.

Trusted by 50,000+ learners across India

Leave a Comment