Infosys interview questions

Q: Explain normalization and give an example of 1NF, 2NF, 3NF.

Standard InfyTQ / DBMS-round question. 1NF: atomic values, no repeating groups. 2NF: 1NF + no partial dependency on composite key. 3NF: 2NF + no transitive dependency. Walk through a concrete example (Student-Course-Instructor table) and normalize step by step. Mention BCNF and when denormalization is acceptable for read-heavy systems.

Q: Design a simple e-commerce database schema.

Tables: User, Product, Category, Cart, CartItem, Order, OrderItem, Payment, Address. Discuss primary/foreign keys, indexing on frequently-queried columns (product_id, user_id, order_status), and one or two representative queries with JOINs. For senior lateral rounds, extend to inventory locking (SELECT ... FOR UPDATE) and eventual consistency for order events.

Q: Tell me about a project from your resume — what was your specific contribution?

Infosys probes hard on ownership. If you list a group project, be crystal-clear on which modules you owned, which libraries you chose and why, what problem you personally debugged. Interviewers routinely catch inflated resumes here. Bring code-level specifics: 'I implemented the JWT auth middleware using jsonwebtoken, handled token refresh…' beats 'I worked on authentication.'

Q: Where do you see yourself in 3-5 years, and are you okay working in Mysore during training?

Infosys freshers train at the Mysore Global Education Center for 3-6 months — mandatory, residential, with periodic assessments. HR uses this question to gauge commitment and cultural fit. Answer with a realistic growth arc (individual contributor → tech lead → architect or domain specialist) and confirm Mysore willingness. Bond is typically 2 years or ₹1L penalty.

Question 1

Write a program to find the second-largest element in an array.

Accepted Answer

Single-pass with two variables (largest, second_largest). O(n) time, O(1) space. Handle edge cases: array of size <2, duplicates (is second-largest strictly less or can it equal?). Infosys interviewers explicitly ask about your handling of duplicates — clarify the requirement before coding.

Question 2

Explain normalization and give an example of 1NF, 2NF, 3NF.

Accepted Answer

Standard InfyTQ / DBMS-round question. 1NF: atomic values, no repeating groups. 2NF: 1NF + no partial dependency on composite key. 3NF: 2NF + no transitive dependency. Walk through a concrete example (Student-Course-Instructor table) and normalize step by step. Mention BCNF and when denormalization is acceptable for read-heavy systems.

Question 3

Design a simple e-commerce database schema.

Accepted Answer

Tables: User, Product, Category, Cart, CartItem, Order, OrderItem, Payment, Address. Discuss primary/foreign keys, indexing on frequently-queried columns (product_id, user_id, order_status), and one or two representative queries with JOINs. For senior lateral rounds, extend to inventory locking (SELECT ... FOR UPDATE) and eventual consistency for order events.

Question 4

Tell me about a project from your resume — what was your specific contribution?

Accepted Answer

Infosys probes hard on ownership. If you list a group project, be crystal-clear on which modules you owned, which libraries you chose and why, what problem you personally debugged. Interviewers routinely catch inflated resumes here. Bring code-level specifics: 'I implemented the JWT auth middleware using jsonwebtoken, handled token refresh…' beats 'I worked on authentication.'

Question 5

Where do you see yourself in 3-5 years, and are you okay working in Mysore during training?

Accepted Answer

Infosys freshers train at the Mysore Global Education Center for 3-6 months — mandatory, residential, with periodic assessments. HR uses this question to gauge commitment and cultural fit. Answer with a realistic growth arc (individual contributor → tech lead → architect or domain specialist) and confirm Mysore willingness. Bond is typically 2 years or ₹1L penalty.

Ace your Infosys interview

Interview loop

What Infosys values

Top questions with answer frameworks

Write a program to find the second-largest element in an array.

Explain normalization and give an example of 1NF, 2NF, 3NF.

Design a simple e-commerce database schema.

Tell me about a project from your resume — what was your specific contribution?

Where do you see yourself in 3-5 years, and are you okay working in Mysore during training?

Compensation

Culture note

Practice live

Similar interview loops

Ready for your next interview?