GS Lab Software Engineer Intern Interview Questions and Answers

Q1. Code pairing round - you will be given story where you need to add one API to the share repository. It is a simple problem but needs good understanding of the shared code. You should follow clean code pri...read more
Add your answer
Q2. Add one API to the existing repository
Ans. 
The API allows users to retrieve weather data based on location.
• Create a new endpoint that accepts a location parameter

• Use a weather API service to fetch weather data based on the location

• Return the weather data in a standardized format, such as JSON
Answered by AI
Add your answer

Q1. Project you are working on, do some changes to the project, how well you understand the project
Add your answer
Q2. Add some feature to the project
Ans. 
The feature added to the project is a user authentication system.
• Implement a login page with username and password fields.

• Create a database table to store user credentials.

• Hash and salt passwords for secure storage.

• Implement password reset functionality.

• Add user roles and permissions for access control.
Answered by AI
Add your answer

Q1. Technical round
Add your answer

Q1. Hr will not tell correct information
Add your answer

Q1. No job security in this company mostly they hire contract base
Add your answer

Q1. Not good for job security and salary package is less
Add your answer

Q1. About technology and tech latest
Add your answer

Q1. Technical questions about tech stack
Add your answer

Q1. Spark architecture pyspark coding sql coding
Add your answer

Q1. Spark architecture sql window functions,aggreate functions pyspark data frame coding
Add your answer

It was easy- moderate in difficulty level.

Q1. The questions were purely based on python and SQL
Add your answer
Q2. SQL- What are window functions and were asked to write some basic fetching queries
Add your answer

Aptitude questions and 2 coding questions were asked

Q1. What are indexes in DBMS
Ans. 
Indexes in DBMS are data structures that improve the speed of data retrieval operations on a database table.
• Indexes are used to quickly locate data without having to search every row in a table.

• They are created on columns in a table to speed up SELECT queries.

• Examples of indexes include primary keys, unique keys, and non-unique indexes.
Answered by AI
Add your answer
Q2. ACID propwrties in DBMS
Ans. 
ACID properties in DBMS refer to the key characteristics of a transaction: Atomicity, Consistency, Isolation, and Durability.
• Atomicity ensures that all operations in a transaction are completed successfully or none at all.

• Consistency ensures that the database remains in a consistent state before and after the transaction.

• Isolation ensures that the execution of multiple transactions concurrently does not interfere with ...read more
Answered by AI
Add your answer

Q1. Normal behavorial questions
Add your answer