Gainsight Software Senior Software Engineer Interview Questions and Answers

Duration was 1 hour, Topics covered were DSA, Concurrency in golang, Databse questions

Q1. About the project. and asked what i did in project. how to create schema in pyspark. what is ADE. what are the difficulties i faced in project. what is spark submit command how we write sparksubmit command...read more
Add your answer
Q2. No of occurrences of letter in a string.
Ans. 
Count occurrences of a letter in a string.
• Iterate through each character in the string and count occurrences of the specified letter.

• Use a hashmap to store the count of each letter.

• Handle both uppercase and lowercase letters to ensure accurate counting.
Answered by AI
Add your answer

There was mcq test with 1 sql code based question.

Q1. It was technical interview of around 30 min, questions were direct and short on react lifecycle and basic concepts of js.
Add your answer
Q2. What is debounce and throttling?
Ans. 
Debounce and throttling are techniques used in web development to limit the number of times a function is called.
• Debounce delays the execution of a function until after a specified time period has elapsed without additional calls.

• Throttling limits the rate at which a function is called, ensuring it is not called more than once within a specified time interval.

• Debounce is useful for handling events like resizing a windo...read more
Answered by AI
Add your answer
Q3. What is diff between git merge and rebase?
Ans. 
Git merge combines changes from different branches, while rebase moves the current branch to the tip of another branch.
• Merge creates a new commit with combined changes, while rebase rewrites commit history.

• Merge preserves the commit history of both branches, while rebase creates a linear history.

• Merge is non-destructive and suitable for public branches, while rebase is destructive and should be used for private branche...read more
Answered by AI
Add your answer
Q4. What is diff between git fork and clone?
Ans. 
Git fork creates a copy of a repository under your GitHub account, while git clone creates a local copy of a repository.
• Fork creates a copy on GitHub, clone creates a local copy on your machine

• Forking allows you to make changes without affecting the original repository

• Cloning downloads the entire repository to your local machine

• Forking is commonly used for contributing to open source projects
Answered by AI
Add your answer
Q5. What is DOM in react?
Ans. 
DOM in React stands for Document Object Model, representing the structure of a web page as a tree of objects.
• DOM in React is a virtual representation of the actual HTML elements on a web page.

• React uses a virtual DOM to improve performance by updating only the necessary components.

• Changes to the virtual DOM are compared with the real DOM, and only the differences are updated.

• This helps in minimizing the number of DOM m...read more
Answered by AI
Add your answer

Q1. It was based on round 2 but in detail.
Add your answer

Q1. Write code based on situation with proper implementation using Design patterns etc.
Ans. 
Implement a code scenario using design patterns
• Identify the problem statement and requirements

• Choose appropriate design patterns like Singleton, Factory, Observer, etc.

• Implement the code following the selected design patterns

• Test the code for functionality and efficiency
Answered by AI
Add your answer
Q2. Coding question in which you need to write optimize program.
Add your answer

Q1. Linked list Coding questions
Add your answer
Q2. Design a database scheme of one of the known website.
Ans. 
Design a database scheme for Amazon website
• Create tables for users, products, orders, reviews, and payments

• Use primary and foreign keys to establish relationships between tables

• Include attributes such as user_id, product_id, order_id, review_id, and payment_id

• Implement indexes for faster data retrieval

• Consider denormalization for performance optimization
Answered by AI
Add your answer

Q1. Salary discussion
Add your answer

Q1. SQL query to join 3 tables
Ans. 
Use SQL JOIN to combine data from 3 tables based on a common key.
• Use INNER JOIN, LEFT JOIN, or RIGHT JOIN depending on the desired result

• Specify the columns to select from each table

• Use ON clause to specify the join condition
Answered by AI
Add your answer
Q2. Spring boot annotations
Add your answer
Q3. Hibernate annotations
Add your answer
Q4. Java 8 Streams + Lambda
Add your answer

Q1. Working style: Independent contributor or Team
Add your answer
Q2. Are green-field projects alright?
Ans. 
Green-field projects are great opportunities to start fresh and implement new technologies.
• Green-field projects allow for creative freedom and innovation

• They provide the opportunity to work with the latest technologies and tools

• Starting from scratch can lead to cleaner code and better architecture

• Examples: Developing a new mobile app, creating a new website from scratch
Answered by AI
Add your answer
Q3. Are you ok with learning new tech stacks?
Add your answer

Q1. Sql question, joins , store procedure
Add your answer
Q2. Mvc question, mvc frame work
Add your answer

Q1. What is dependency injection in laravel
Ans. 
Dependency injection in Laravel is a technique to manage class dependencies and improve code flexibility.
• Dependency injection allows for easier testing and maintenance of code.

• It involves passing dependencies to a class through its constructor or method parameters.

• Laravel's container class manages the dependencies and resolves them when needed.

• Example: injecting a database connection into a repository class.

• Can also us...read more
Answered by AI
View 1 more answer
Q2. How do you find the second largest number in a coulmn in mySQL
Ans. 
To find the second largest number in a column in MySQL, you can use the ORDER BY and LIMIT clauses.
• Write a SELECT statement to retrieve the column values in descending order using ORDER BY.

• Use the LIMIT clause to limit the result set to the second row.

• The value in the second row will be the second largest number in the column.
Answered by AI
View 1 more answer

Q1. What do you know about magic Edtech
Ans. 
Magic Edtech is an innovative educational technology company.
• Magic Edtech develops interactive learning platforms and tools.

• They use advanced technologies like AI, AR, and VR to enhance the learning experience.

• Their products include virtual classrooms, adaptive learning systems, and educational games.

• Magic Edtech focuses on personalized learning and data-driven insights.

• They collaborate with schools, universities, and
Answered by AI
View 1 more answer
Q2. What was the most challenging task you faced and how you overcame it
Add your answer