HSBC Group Technology Analyst Interview Questions and Answers

Coding, DSA, OOPS, Mathematical Aptitude, Logical Reasoning

Q1. Questions were based out of SQL, Python libraries and Machine learning projects as a part of my resume.
Add your answer
Q2. Resume based projects
Add your answer

Q1. Despite being from engineering background, why do you wanted to join a financial industry?
Add your answer
Q2. Where do you see yourself after 5 years?
Add your answer

Q1. SQL concepts related questions
Add your answer

Q1. Mid level SQL related questions
Add your answer

Q1. Why do you want to join JPMC
Add your answer

Round duration - 90 Minutes
Round difficulty - Medium

The round was conducted early in the morning.There were 3 sections:
1.Aptitude based on Maths and Logic
2.Questions based of core subjects and basic Data Structures
3.Coding Round -2 questions

Q1. Minimum Number Of Vertices To Reach All Nodes
Given a directed acyclic graph having ‘N’ nodes. A matrix ‘edges’ of size M x 2 is given which represents the ‘M’ edges such that there is an edge directed fro...read more
Ans. 
I applied DFS to solve this problem.
Answered by CodingNinjas
View 3 more answers
Q2. Box Stacking
You are given a set of ‘n’ types of rectangular 3-D boxes. The height, width, and length of each type of box are given by arrays, ‘height’, ‘width’, and ‘length’ respectively, each consisting ...read more
Ans. Brute Force
• This is a recursive approach.
• Make an integer matrix ‘boxes’ of dimension (3*n, 3), we will store all three rotations of each type of boxes in it.
• Generate all 3 rotations for all ‘n’ types of boxes,  for simplicity we will consider ‘width’ always smaller than or equal to ‘length’. Store them in matrix ‘boxes’ such that boxes[i][0], boxes[i][1], boxes[i][2] give height, width, length of ‘i’th box respecti...read more
Answered by CodingNinjas
View 1 more answer

Round duration - 90 Minutes
Round difficulty - Medium

A face to face interview was scheduled with the interviewer.I was asked to solve a few coding questions and then asked questions based on OS and OOPS and some questions related to the working of my projects.

Q1. Sort 0 1
You have been given an integer array/list(ARR) of size N that contains only integers, 0 and 1. Write a function to sort this array/list. Think of a solution which scans the array/list only once an...read more
Ans. Space Complexity: Explanation: Time Complexity: Explanation:
Answered by CodingNinjas
Add your answer
Q2. Flatten A Linked List
You are given a linked list containing N nodes, where every node in the linked list contains two pointers, first one is ‘NEXT’ which points to the next node in the list and the second...read more
Ans. Brute Force
The idea is to use an extra array to first store all the elements of the linked list and then sort the array and finally put those elements back into the linked list and return.
 
• Declare an array ‘Answer’ to store the elements of the linked list.
• Run a while loop till the next of the linked list reaches NULL.
  • Add the current pointer data to Answer.
  • Inside this loop, traverse the CHILD nodes of the current n...read more
Answered by CodingNinjas
View 2 more answers
Q3. OS Questions
Basic Questions on Scheduling Algorithms
Difference between Processes and Thread
Disk Scheduling Algorithms-I was asked to explain the difference between the algorithms
LRU Page replacement and th...read more
Ans. 
Tip 1 : Go through the topics and understand the concept and the difference between the different algorithms you read.
Tip 2 : Be confident while explaining to the interviewer and try explaining the important points.
Answered by CodingNinjas
Add your answer
Q4. DS Questions
I was asked to explain the basic oops concepts. I did that using real-life examples.
Difference between abstraction and interface.
Virtual Functions
Method Overloading and overriding
Ans. 
Tip 1 : The concepts should be clear and explaining using examples around you shows that you have clarity.
Answered by CodingNinjas
Add your answer

Round duration - 40 Minutes
Round difficulty - Easy

I was asked basic HR questions and some questions based on my resume.
 

Q1. Basic HR Questions
Introduce yourself
Where do you see yourself in 2-3 yrs
What are your hobbies
How do you feel you have done something productive
If you were forced to work with someone you don't like, what w...read more
Add your answer

Discussing the merits and drawbacks of different workplace initiatives

Q1. Discuss Database Design
Ans. 
Database design involves creating a structure that efficiently stores and organizes data for easy retrieval and manipulation.
• Identify the data requirements and relationships between different entities

• Normalize the database to reduce redundancy and improve data integrity

• Choose appropriate data types and constraints for each field

• Create indexes to optimize query performance

• Consider scalability and future growth when desi
Answered by AI
Add your answer
Q2. Logical thinking on how to evacuate a retail store and how you would prioritise.
Add your answer

Q1. Interview questions were based on basic computer knowledge
Add your answer
Q2. Basic computer questions
Add your answer
Q3. Basic computer knowledge
Add your answer

Q1. During the hackathon, I was asked about what I felt about the team dynamics and what strategies I would take to ensure everyone arrives at consensus to work together.
Add your answer

Q1. I was asked to explain a college project and was asked follow on questions on the same
Add your answer
Q2. Questions on linked lists, algorithm to identify 2nd, 3rd connections on a site like LinkedIn. I was asked some other data structure questions that I don't recollect as this interview took place years ago
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

This was a technical round with questions on DSA and OOPS.

Q1. Technical Question
What is AVL Tree?
Ans. 
AVL tree is a self-balancing Binary Search Tree (BST) where the difference between heights of left and right subtrees cannot be more than one for all nodes.
Answered by CodingNinjas
Add your answer
Q2. Technical Question
Why is the time complexity of Binary Search O(Logn)?
Ans. 
Let say the iteration in Binary Search terminates after k iterations. 
At each iteration, the array is divided by half. So let’s say the length of array at any iteration is n
At Iteration 1 : 
Length of array = n
At Iteration 2 : 
Length of array = n⁄2
At Iteration 3: 
Length of array = (n⁄2)⁄2 = n⁄22
Therefore, after Iteration k : 
Length of array = n⁄2k

Also, we know that after 
After k iterations,...read more
Answered by CodingNinjas
Add your answer
Q3. Implement a priority queue
Ninja is given a task to implement a priority queue using Heap data structure. The Ninja is busying preparing for the tournament., So he asked for your help.
Your task is to us...read more
Ans. 
Priority Queues can be implemented using common data structures like arrays, linked-lists, heaps and binary trees. Here we are using a linked list.
The list is built up in such a way that the element with the highest priority is always at the top. The elements are listed in descending order of priority in the list. This allows us to remove the element with the highest priority in O(1) time. To insert an element, we must...read more
Answered by CodingNinjas
View 1 more answer
Q4. Sum of Digits
Ninja is given an integer ‘N’. One day Ninja decides to do the sum of all digits and replace the ‘N’ with the sum of digits until it becomes less than 10. Ninja wants to find what will be the...read more
Ans. 
Algorithm : 
1. Declare a variable to store the sum and set it to 0
2. Repeat the next two steps till the number is not 0
3. Get the rightmost digit of the number with help of the remainder ‘%’ operator by dividing it by 10 and add it to sum.
4. Divide the number by 10 with help of ‘/’ operator to remove the rightmost digit.
5. Return the sum
Answered by CodingNinjas
View 2 more answers
Q5. OOPS Question
Difference between Hashmap and Hashset
Ans. 
1. Hash Set implements Set interface while hash map implements Map interface . 
2. No duplicates allowed in hash set. In hash map, duplicates values are allowed but no duplicate key is allowed 
3. Only 1 Object is required during an add operation for hash set while 2 objects are required for hash map. 
4. Hash set uses a hash map object for adding and storing mechanism while hashmap uses a hashing technique...read more
Answered by CodingNinjas
Add your answer
Q6. OOPS Question
Difference between Abstract Class and Interface
Ans. 
1) Abstract class can have abstract and non-abstract methods. Interface can have only abstract methods. Since Java 8, it can have default and static methods also.
2) Abstract class doesn't support multiple inheritance. Interface supports multiple inheritance.
3) Abstract class can have final, non-final, static and non-static variables. Interface has only static and final variables.
4) Abstract class can provide the implem...read more
Answered by CodingNinjas
Add your answer
Q7. OOPS Question
Why are virtual destructors needed?
Ans. 
Virtual destructors in C++ are used to avoid memory leaks especially when your class contains unmanaged code, i.e., contains pointers or object handles to files, databases or other external objects. A destructor can be virtual.
Answered by CodingNinjas
Add your answer

Round duration - 60 minutes
Round difficulty - Medium

This was a technical round with questions on OS and OOPS. A design question was also discussed.

Q1. OS Question
What is Round Robin Algorithm?
Ans. 
In Round-robin scheduling, each ready task runs turn by turn only in a cyclic queue for a limited time slice. This algorithm also offers starvation free execution of processes.
The name of this algorithm comes from the round-robin principle, where each person gets an equal share of something in turns. It is the oldest, simplest scheduling algorithm, which is mostly used for multitasking.
Answered by CodingNinjas
Add your answer
Q2. System Design Question
Build a system where people subscribe to a particular topic . And if any message is posted regarding the particular topic then the people who have subscribed to that system must get t...read more
Ans. 
Tip 1: Firstly, remember that the system design round is extremely open-ended and there’s no such thing as a standard answer. Even for the same question, you’ll have a totally different discussion with different interviewers.
Tip 2: Before you jump into the solution always clarify all the assumptions you’re making at the beginning of the interview. Ask questions to identify the scope of the system. This will clear the i...read more
Answered by CodingNinjas
Add your answer
Q3. Technical Question
How is memory allocation done in recursion?
Ans. 
When a function is called, its memory is allocated on a stack. Stacks in computing architectures are the regions of memory where data is added or removed in a last-in-first-out (LIFO) process. Each program has a reserved region of memory referred to as its stack. When a function executes, it adds its state data to the top of the stack. When the function exits, this data is removed from the stack.
Answered by CodingNinjas
Add your answer
Q4. OS Question
Why are threads needed ?
Ans. 
It takes far less time to create a new thread in an existing process than to create a new process.
Threads can share the common data, they do not need to use Inter- Process communication.
Context switching is faster when working with threads.
It takes less time to terminate a thread than a process.
Answered by CodingNinjas
Add your answer

Round duration - 45 minutes
Round difficulty - Easy

This was a group activity round.

Q1. Group Activity
Here, they gave us some wooden blocks and crayons and asked us to make a logo for Morgan Stanley and prepare a slogan individually which shows the technological development of MS with collabo...read more
Add your answer

Round duration - 30 minutes
Round difficulty - Easy

HR round with typical behavioral problems.

Q1. Basic HR Questions
Q1. Projects which I did in the academic years .
Q2. Then he asked me that your idea was not brought into the group activity but still you said you will be the leader and How would I accep...read more
Ans. 
Tip 1 : The cross questioning can go intense some time, think before you speak.
Tip 2 : Be open minded and answer whatever you are thinking, in these rounds I feel it is important to have opinion.
Tip 3 : Context of questions can be switched, pay attention to the details. It is okay to ask questions in these round, like what are the projects currently the company is investing, which team you are mentoring. How all is the
Answered by CodingNinjas
Add your answer