Northern Trust Full Stack Software Developer Interview Questions and Answers

Q1. Describe previous projects Challenges you faced previously Some technical questions based on the experience
Add your answer

Nice interview with the friendly interviewer

Q1. Tell me about your self
Add your answer

Q1. Design a system where images and documents would be transferred to client.
Add your answer
Q2. Redis caching details
Add your answer
Q3. How to call rest api in Angular
Add your answer

GAVE AN ARRAY AND ASKED TO MOVE ZEROES TO THE END AND GROUPBY IN STREAMS JOINS IN SQL

Q1. Java OOPS concepts abstract class vs interface
Add your answer
Q2. SQL query to find duplicate values
Ans. 
Use GROUP BY and HAVING clause to find duplicate values in SQL.
• Use GROUP BY clause to group the data based on the column you want to check for duplicates.

• Use HAVING clause to filter out groups that have more than one entry, indicating duplicates.

• Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;
Answered by AI
Add your answer

Karet coding evaluation platform is used

Q1. Technical + coding assessment was there
Add your answer
Q2. Find max continous sub array with unique elements in an array
Ans. 
Find max continous sub array with unique elements in an array
• Use sliding window approach

• Keep track of unique elements in the window

• Update max length when a duplicate element is found
Answered by AI
Add your answer

Q1. Pure Technical round
Add your answer

Q1. Typical Managerial round
Add your answer

Q1. Payscale discussion round
Add your answer

Q1. Why microservices?
Ans. 
Microservices offer scalability, flexibility, and easier maintenance in software development.
• Scalability: Microservices allow for individual components to be scaled independently, leading to better resource utilization.

• Flexibility: Microservices enable teams to work on different services simultaneously, promoting faster development and deployment.

• Easier maintenance: With microservices, it's easier to identify and fix i...read more
Answered by AI
Add your answer
Q2. Why you went for microservices in your application
Add your answer
Q3. Mention about the design patterns you worked so far
Ans. 
I have worked with various design patterns such as Singleton, Factory, Observer, and MVC.
• Implemented Singleton pattern to ensure only one instance of a class exists

• Utilized Factory pattern to create objects without specifying the exact class

• Implemented Observer pattern to establish a one-to-many dependency between objects

• Utilized MVC pattern to separate the concerns of data, presentation, and user input
Answered by AI
Add your answer

Q1. Angular, JS , C# and SQL Server related questions
Add your answer

Q1. Questions related to Observables in Angular, C# advanced concepts.
Add your answer