Infosys System Engineer Interview Experience - 5

Company -  Infosys
Date          - 24 AUG 2021 
Branch     -  IT
Duration  -  25 MINS

Q1. Introduce yourself.

The first question in most of the interviews is usually to introduce yourself.Prepare a crisp answer about the things you have done,technologies you work on,internships and projects you have done.talk about anything you are confident about.this answer will decide the further questions of the interviewer and will give a direction to your interview.so,don't forget to mention about your most confident skills and anything you want to discuss and talk about.

Sample Answer:

hello , My name is XYZ from ABC college IT branch.In my 4 years at college I have worked to explore both technical and non technical part in me.I have worked with PQR firm where i have worked on android development. My major work was to work on the UI part of the application. Along with that I have participated in various hackathons and coding challenges. I have worked on few personal projects in my college like...(mention 1-2 in short).

Tips: talk about your confident part in a very humble way.Introduction part can take up  around 2-3 mins. 

Q2. Explain about your project mentioned in the resume.

This is very important question.interviewer will know about the technologies you have worked on and then further questions will be asked from that topics.

Fully prepare the technologies used in the project.

Say what you have done.

Talk about how this project helped you learn new things.

Follow STAR approach in answering the questions. 

Situation

Task

Approach

Result

1.Project Introduction
Give an introduction of your project, what problem you tried to solve with your project.

2.Modules Description:
Divide your project in various modules and describe modules to the interviewer.

3.Advantages and main functionality of your project
describe your main functionality of the project and main problem you want to solve.

4.Tools,Technologies and platform used
This is also a very important aspect when explaining a project. Tools, Technologies, and platforms used will help the interviewer understand better about the working of the project. As well as it will create an impact on how new is your project. Try to explain it very short and be to the point.

5.Personal Contribution in the project
Interviewer is interested to know what have you done in the project and what part you have worked on.

Q3. What are the difficulties you faced in project.

Mention about difficult parts of your project and how you solved it.

Mention your approach you followed.

Q4. Explain different phases of SDLC.

• Phase 1: Requirement collection and analysis
• Phase 2: Feasibility study
• Phase 3: Design
• Phase 4: Coding
• Phase 5: Testing
• Phase 6: Installation/Deployment
• Phase 7: Maintenance

Q5. What are joins?

Sql join statements allow us to access information from two or more tables at once.

• (INNER) JOIN: Returns dataset that have matching values in both tables
• LEFT (OUTER) JOIN: Returns all records from the left table and matched records from the right s
• RIGHT (OUTER) JOIN: Returns all records from the right table and the matched records from the left
• FULL (OUTER) JOIN: Returns all records when there is a match in either the left table or right table 

Q6. Define different OOPS Concepts.

Inheritance - When one object acquires all the properties and behaviors of a parent object, it is known as inheritance. It provides code reusability. It is used to achieve runtime polymorphism.

Encapsulation - Binding (or wrapping) code and data together into a single unit are known as encapsulation. For example, a capsule, it is wrapped with different medicines.

Polymorphism - If one task is performed in different ways, it is known as polymorphism. For example: to convince the customer differently, to draw something, for example, shape, triangle, rectangle, etc.

Abstraction - Hiding internal details and showing functionality is known as abstraction. For example phone call, we don't know the internal processing.

Q7. difference between DDL and DML commands

DDL COMMANDS	DML COMMANDS
It stands for Data Definition Language.	It stands for Data Manipulation Language.
It is used to create database schema and can be used to define some constraints as well.	It is used to add, retrieve or update the data.
It basically defines the column (Attributes) of the table.	It add or update the row of the table. These rows are called as tuple.

Q8. Where do you see yourself in 5 years?

This is one of the questions you will see in many interviews. With this the interviewer wants to know what are your professional goals in next 5 years, what are your goals and aspirations and will the company be able to offer what you are looking for. So, get clear about your career goals so that you sound confident when you answer this question to the interviewer.

Sample answer:

A few of the goals I’ve set for myself over the next few years include becoming a senior  software developer and would work on major projects and gain knowledge in the same. I’m excited about the opportunities this job would provide me, as I believe they will support my long-term career goals and allow me to grow.

HAPPY LEARNING

refer important interview subjects here-

https://www.youtube.com/playlist?list=PLnfCacCyFMlYGY7HDesLgyf9L8DPCbh2c