GSPANN Technologies Technical Lead Interview Questions, Process, and Tips

Q1. Tell us about yourself
Add your answer
Q2. Lot of questions on SQL and Linux commands
Add your answer

Q1. Tell us about yourself
Add your answer
Q2. It was a manager round combined with some technical questions
Add your answer

Questions about java concurrency framework, java 8 and 11 features, Code chef coding problem

Q1. Discussion about current project architecture
Add your answer
Q2. Microservices and cloud foundry
Add your answer

Q1. React Life cycle methods
Add your answer
Q2. Machine coding with crypto price api
Ans. 
Using a crypto price API to fetch and display real-time cryptocurrency prices in a machine coding project.
• Utilize a crypto price API to fetch real-time cryptocurrency prices

• Implement error handling for API requests

• Display the fetched prices in a user-friendly format
Answered by AI
Add your answer

Q1. Mix of coding, theory and design questions
Add your answer

Q1. Solid principle implemantion in c#
Ans. 
Solid principles are a set of design principles that help make software more maintainable, flexible, and scalable.
• Single Responsibility Principle (SRP) - A class should have only one reason to change.

• Open/Closed Principle (OCP) - Software entities should be open for extension but closed for modification.

• Liskov Substitution Principle (LSP) - Objects of a superclass should be replaceable with objects of its subclasses wi...read more
Answered by AI
Add your answer
Q2. Write a code for Entity framework DB connection
Ans. 
Code snippet for Entity Framework DB connection
• Install Entity Framework NuGet package

• Create a DbContext class

• Define DbSet properties for each entity

• Configure connection string in app.config/web.config

• Use DbContext to interact with the database
Answered by AI
Add your answer
Q3. Get 3 rd highest salary
Ans. 
To get the 3rd highest salary, we can use a SQL query with the 'LIMIT' and 'OFFSET' keywords.
• Use a SQL query with 'ORDER BY salary DESC' to sort salaries in descending order.

• Use 'LIMIT 1 OFFSET 2' to skip the first two highest salaries and get the 3rd highest salary.

• Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 2;
Answered by AI
Add your answer
Q4. Why we using interface in C#
Ans. 
Interfaces in C# provide a way to define a contract for classes to implement, promoting code reusability and flexibility.
• Interfaces allow for multiple inheritance in C# by allowing a class to implement multiple interfaces.

• Interfaces help in achieving loose coupling between classes, making the code more maintainable and testable.

• Interfaces are used to define common behavior that multiple classes can share, promoting cod...read more
Answered by AI
Add your answer

Q1. Why you want to change the company
Add your answer

Q1. Work experience
Add your answer

Hackerrank test with combination of MCQ and java program coding.

Q1. L1 technical and L2 client technical rounds. Asked questions from core java, spring boot, micro service and some java coding questions.
Add your answer

Q1. Basic questions on personal details and overview about company and salary discussion.
Add your answer