Infosys Senior Software Engineer Interview Questions, Process, and Tips

This was a on paper round consisting of various aptitude, qualitative analysis type questions.

What is Linked List ? And linked list are stored in cpu.

What is red-black tree ? What are its significance ?

Q1. Whats a difference upper join or low join?
Ans. 
There is no such thing as upper join or low join in software engineering.
• There is no concept of upper join or low join in software engineering.

• It is possible that the interviewer meant inner join or outer join.

• Inner join returns only the matching rows from both tables while outer join returns all rows from both tables.

• Examples of SQL queries with inner join and outer join can be given.
Answered by AI
Add your answer
Q2. Write a SQL statement using upper join.
Ans. 
SQL statement using upper join
• Use the UPPER function to convert the join condition to uppercase

• Join two tables using the converted join condition

• Example: SELECT * FROM table1 JOIN table2 ON UPPER(table1.column) = UPPER(table2.column)
Answered by AI
Add your answer
Q3. Define joins in table
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables in a single query.

• Common types of joins are inner join, left join, right join, and full outer join.

• Inner join returns only the matching rows from both tables.

• Left join returns all the rows from the left table and matching rows from the right table.

• Right join returns all the ...read more
Answered by AI
Add your answer

Q1. Architect an Authentication and authorization module
Ans. 
Architect an authentication and authorization module
• Identify the user roles and permissions

• Choose an appropriate authentication mechanism (e.g. OAuth, JWT)

• Implement secure password storage and retrieval

• Use encryption for sensitive data

• Implement session management and token expiration

• Integrate with existing user management systems if applicable
Answered by AI
Add your answer
Q2. What are the Components used in deploying the previous Projects in AWS?
Ans. 
Components used in deploying previous projects in AWS
• Amazon EC2 instances

• Amazon S3 buckets

• Amazon RDS databases

• Elastic Load Balancers

• Auto Scaling Groups

• Amazon CloudFront

• AWS Lambda functions

• Amazon ECS containers
Answered by AI
Add your answer

Q1. Share details of your previous job.
Add your answer
Q2. Why are you looking for a change?
Add your answer
Q3. What are your strengths and weaknesses?
Add your answer