Backbase Senior Solution Architect Interview Questions and Answers

Q1. Write an SQL query to fetch duplicates.
Ans. 
SQL query to fetch duplicates
• Use GROUP BY and HAVING clause to identify duplicates

• Select columns to be checked for duplicates

• Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;
Answered by AI
Add your answer
Q2. Write SQL query to fetch nth highest Salary.
Ans. 
SQL query to fetch nth highest Salary
• Use the ORDER BY clause to sort the salaries in descending order

• Use the LIMIT clause to fetch the nth highest salary

• Consider handling cases where there might be ties for the nth highest salary
Answered by AI
Add your answer

Q1. Java,oop, microservice, JPA
Add your answer
Q2. Spring boot , MySQL
Add your answer

Q1. Java, spring boot
Add your answer
Q2. Microservice, rest api
Add your answer

Q1. Angular Architecture, basic angular questions such as data binding, rxjs, dependency injection etc.
Add your answer

Q1. Coding assignment to fetch data from API and render on the UI. Using httpclient module.
Ans. 
Fetch data from API and render on UI using httpclient module
• Create an instance of httpclient module

• Use httpclient to make a GET request to API endpoint

• Parse the response data and render on UI
Answered by AI
Add your answer

Q1. Normal question on roles and responsibilities alongwith cultural fitment check.
Add your answer

Q1. Client interview to get the knowledge of UX and responsive web application. Css etc.
Add your answer

I asked basic questions related to coding and technical languages like MERN, and a few DSA questions about basic programming. The interview was around 45 minutes.

2nd round took about 1 hour and 15 minutes. There are a few technical scenario discussions and questions related to my tech stack like MERN and one coding task in React JS

Q1. The last round with the manager consisted of a discussion about day-to-day job handling as per different scenarios.
Add your answer

Q1. Notice Period and Salary
Add your answer

Java 8 , stream and a program to solve on String

Q1. 1. Pattern print code. 2. Types of S3 bucket in AWS. 3. Java basic question. 4. Spring/ Spring boot basic question. 5. Hibernate basic interview question. 6. Some behavioral question.
Ans. 
This is a list of questions asked in an interview for Senior Software Engineer position.
• 1. Pattern print code: Write a code to print a specific pattern using loops.

• 2. Types of S3 bucket in AWS: Explain the different types of S3 buckets in Amazon Web Services.

• 3. Java basic question: Provide a basic question related to Java programming language.

• 4. Spring/Spring Boot basic question: Give an example of a basic question rel...read more
Answered by AI
Add your answer

Q1. Core and Advance concepts of Java
Add your answer

Q1. Mainly on mutltithrerading concepts and previous experience on projects.
Add your answer

Q1. About projects and scenarios based questions.
Add your answer

Q1. About Salary negotiation and final round
Add your answer

Q1. Backend Questions regarding
Add your answer
Q2. UI Questions regarding Angular
Add your answer