Sopra Steria Backend Developer Lead Interview Questions and Answers

Developed a web application for online shopping with microservices architecture using Node.js, Express, MongoDB, and React.

• Implemented microservices architecture to improve scalability and maintainability

• Used Node.js and Express for backend development

• Utilized MongoDB for database management

• Implemented React for frontend development

• Implemented business logic for user authentication, product management, and order proces

I have used the Singleton, Factory, and Observer design patterns in my projects.

• Singleton pattern: Used to ensure a class has only one instance and provides a global point of access to it. For example, I implemented a Logger class as a Singleton to manage logging throughout the application.

• Factory pattern: Used to create objects without specifying the exact class of object that will be created. For instance, I used a F...read more

Use LINQ queries to retrieve order id and list of products based on latest project.

• Use OrderByDescending to get the latest project first

• Join Order and Product tables on OrderId

• Select OrderId and list of Products

Use SQL query with ORDER BY and LIMIT to get 2nd largest salary.

• Use SELECT statement to retrieve salary column

• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT 1,1 to get the second row