Company Name: Infosys
Position: Senior Associate Consultant-FSDGC
Location: Not specified
Application Process: I applied via a referral and was interviewed in June 2024.
Interview Rounds:
-
Round 1 - Technical Round:
- Questions Asked:
- Introduce yourself.
- Tell me about your current project and the domain you have worked on.
- What is the logic of the code for finding duplicate numbers in an array?
- What is the solution for resolving conflicts in a git merge?
- Why is object creation not possible for abstract classes?
- What is the purpose of exception handling in Java?
- What are the key differences between LinkedList and HashSet?
- Is it possible to achieve method overloading within a private class in Java?
- What are the different types of dependency injection?
- What is the flow of dependency injection in Spring Boot?
- How do you call a private method in another class?
- Which tree is used in TreeMap and what is the implementation of it?
- What is the inversion of control and how does it work?
- What is the difference between @RestController and @Request mapping?
- Tell me the flow of HTTP requests for the backend in Java.
- When can we use multiple catch blocks?
- How can we achieve inheritance in Java?
- What is the purpose of dependence injection?
- What is the difference between stream and collection in Java?
- What is the play framework and how is it different from spring boot? (I have majorly worked on play framework that’s why this question was asked to me)
- How do you create a spring boot application?
- What are starter dependencies in spring boot?
- What is a B-tree index?
- What is a trigger in SQL and how is it used?
- What are ACID properties?
- What are the types of joins and what is the difference between them?
- What is normalization?
- Suppose there are two tables: A Customer table and an Order table. The Order table has a column OrderID CustomerID, OrderStatus, and TotalAmount. The Customer table has the columns CustomerID, CustomerName, PhoneNumber, and Email. Write down a query to print The CustomerID, CustomerName, OrderStatus, and TotalAmount by excluding the orders placed in August.
- Your Approach: I answered the questions based on my experience and knowledge, focusing on clarity and relevance. For coding questions, I explained the logic step-by-step.
- Outcome: I passed this round.
- Questions Asked:
-
Round 2 - One-on-one Round:
- Questions Asked:
- Tell me about your family background, education, work experience, and project, on which you have worked.
- Write a Java code and Angular code to retrieve the data from the given URL.
- Your Approach: I provided a concise summary of my background and demonstrated my coding skills by writing the required Java and Angular code.
- Outcome: I passed this round as well.
- Questions Asked:
Preparation Tips:
For this role, your basics must be strong in JAVA, and you should have working knowledge of the Spring Boot framework.
Conclusion:
The interview process was thorough and tested both technical and problem-solving skills. I felt well-prepared, but I could have practiced more on SQL queries and Angular coding. My advice to future candidates is to focus on core Java concepts, Spring Boot, and hands-on coding practice.