I applied online. The process took 2 days. I interviewed at Infosys (Pune)
Interview
1) Group Discussion
2) Pen Paper test
Above rounds were conducted by recruitment firm and they shortlisted around 46 candidates from 2000+ candidates.
3) 2 online test by yaardi in which first round was basic aptitude and lr, while second was technical, java and .net based mcqs were present.
Shortlisted ones were called in yaardi for interview rounds.
4) In yaardi first was Pre Hr round .
5) Technical 1
6) Managerial round which was like technical + HR mix kindoff.
7) HR round
Interview questions [1]
Question 1
Technical 1
Q.1) What are joins, explains it's types. I was given a table and was asked to draw all different types of joins
Q.2) Pattern based questions
Q.3) Difference between Drop Delete Truncate
Q 4) Explain Angular Typescripting, components
Q.5) Primary key vs unique key
Q.6) Query based on GROUP BY clause.
Q.7) If I join the table and want to convert the null values to default 0, how can I do it?
Q.9) All about my internship project as my project consist of database optimisation he asked me how did you do that as they were very interested in any SQL based project.
Managerial Round
Q.1) What did you learn from previous interviews?
Q 2) Code for getting last word of a statement
Q.3) Code for traingle pattern
Q 4) Rigorously asked about my project, specifically database related projects.
Q.5) Queries on ORDER BY and JOINS
Q.6) Normalisation
first was a online assesment after getting shortlisted in that you recive an interview mail within 2 days, you have to appear for the interview in campus on the day of interview as there were alot of students appearing for the process there will be a long waiting time after that when you appear for the interview it will be a short interaction hardly 20 mins and then you have to wait for few days for the final result
1. Telefonic round
Introduction,Basic questions Resume based
2.L2 Technical
Resume Based, Coding, Basic of java
Polymorphism.
Question on internship and project
3 to 5 simple coding questions
Asking for Senario
I applied through a recruiter. I interviewed at Infosys (Ciudad de Mexico) in Jan 2026
Interview
Entrevista en inglés con conversación inicial y ejercicios técnicos enfocados en lógica de programación. El equipo se mostró profesional y el ambiente laboral es adecuado, con oficinas bien ubicadas y accesibles.