HSBC Group Technology Analyst Interview Questions and Answers

Interview preparation tips for other job seekers - I went for Enterprise Testing Senior Associate. The person who interviewed me was very well known to me. He worked with me for more than a year at the same level. Asked illogical questions. All hypothetical questions he asked in which I was the one who was getting demoted or denied bonus or increment.
He should not have taken my interview as it was conflict of Interest. 99% of questions was asked by this guy and the other lady in VC only asked 1 general question.
I reported conflict of interest issue to the hiring HR but no action was taken not any reply toy email came.

Interview preparation tips for other job seekers - Scenario based questions on real time examples like ticket reservation, data processing. SAGA pattern

Interview preparation tips for other job seekers - Equip yourself with confidence and enthusiasm highlighting your best working experience and achievements!

Interview preparation tips for other job seekers - Be yourself.
Go through your resume and be accurate what you say

Round: Test
Experience: Apptitude test (16 shortlisted out of 65) 10 quant + logic 10 data structure , operating systems 30 programming questions (you have option to select c/c++/java)Passing individually in all sections compulsorygood quality of questionskeep concepts well in place

Round: Technical Interview
Experience: 1. Given an array of size n this contains all integers from 1 to n+1 except one. Array is notsorted. You have to find the missing element by traversing the array only once and no extraspace allowed.(the solution I proposed was to xor all elements of array and all numbers from1 to n+1 the final value of xor is the answer . He asked me to code this).2. Given a string of characters like “34235” convert it to integer format. (I answered like simplesolution. Was told to code it).3. Given a large file. Each line has some string you have to find palindrome in the string andappend the middle element of palindrome to end of string. It was v important to considercase like when you append characters to end of string it may go to next line and create newpalindromes in next line.(I read 1 line from input file found middle letters of all palindromesappended to string and outputted it in new file say output.txt. Now if it has over flown inoutput file handle it in next iteration …).4. Given a program find output c++ program quite tricky. It was using pointers as member ofclass to test allocation and deallocation of memory.

Round: Technical Interview
Experience: Final Technical Interview 2 Interviewers

1. Tell me something about yourself

2. Explain me your project (was in my resume).

3. Write all dbms tables used in ur project4. How will you represent matrix of any arbitrary size say m*n in a database.(I answered 

5. Given 2 matrix in your database write a sql query to add them.

6. Now write a sql query to multiply 2 matrix

7. Program to find height of a binary tree.(I gave recursive solution)

8. Without recursion

9. Find loop in a binary tree and also find whether loop is sibling loop or ancestor loop or 

10. Can a constructor be virtual?(in c++)

11. Can a destructor be virtual?

12. Can a constructor b private?13. Can a destructor b private?

14. Can a destructor b pure virtual function?......

15. Given a file having 10000 lines I want to read all lines v fast(multi threading)

16. Last do you want to ask some thing ?

(id row col data))

arbitrary loop

Round: Group Activity
Experience: Group Activity-(now no further eliminations) we were divided in group of 3 and 4, 8 or 9 panelists were watching us We were given a list of servers databases and client systems having pros and cons. We were asked to choose the best possible combination that suits all client requirements.

Round: HR Interview
Experience:  Tell something about yourself Greatest achievement in your life
 Achievements of others that u like
 Gave me scenario like you are team leader and you have to instruct your team to deliver blood from blood bank to hospital v v fast as someones life is in danger.. 
 1 more similar case
 Then he asked me r u a team player
 He was like what you do to motivate your team as a leader and how would you make your team perform best.
 Do you want to ask some thing to me???(this is v important ask abt company ur role in it….).

General Tips: Be honest.Do not write anything on resume,people are v v smart they will catch youThey touch all domains so b strong in all areas, dbms os datastructure programmingIf you don’t know something ,tell them, they will help youInterviewers are v cooperative, help you a lot and if you get stuck they will drop hintsBe CALM confident and positiveFinally I would say, interviews with Morgan Stanley , it is a great experience!!ALL THE BEST !!!! 
College Name: VJTI

Round: Test
Experience: Aptitude Part : There were 30 questions to be completed in 45 minutes. There were 10 aptitude questions which were quite time-taking. Questions were

from Data Interpretation as well. Then we had to choose a section out of C/C++/JAVA and the rest 20 questions were from your chosen section. The chosen section was also time-consuming.Coding Test : There were 3 questions to be completed in 1 hour. Program 1 was to find the required element of Pascal’s triangle. Program 2 was to count all the palindromic substrings in a string. I am sorry but I do not remember Program 3.
Duration: 105 minutes
Total Questions: 33

Round: Technical Interview
Experience: It lasted for around 30-35 minutes. Questions were on array, hash map, file handling and string theory. All questions were generally algorithmic in nature.

Round: HR Interview
Experience: It lasted for around 50-55 minutes. We were basically grilled in this interview.

Round: Technical Interview
Experience: It lasted for around 1 hour. In this round, there were questions based on real-life scenario like designing a shopping cart for an e-commerce website etc. Then there were algorithmic questions on queue, graph and trees. A problem was given and I was asked to reason out the best data structure to solve that problem. There were simple problems on linked list.

Round: Group Discussion
Experience: It was an entertaining round but was quite pressurising. We were divided into groups and asked to make something with LEGO Blocks that they had provided. There is a time-constraint in this round. We had to explain all the design aspects of our construction like name, choice of colour, significance of buildings, structure strength etc.Finally after 5 rounds of interviews, I got selected. I thank my parents, friends and my seniors.

College Name: NA

Round: Test
Experience: Aptitude Questions and Questions based on Data Structures, Algorithms, Operating System were asked. Two coding questions were also asked.
Tips: Practice Competitive Programming and some basic aptitude questions as well as basics of CS subjects.
Duration: 1 hour 30 minutes
Total Questions: 17

Round: Technical Interview
Experience: Most question were based on Data Structures and Algorithms. Some questions on Object Oriented Programming were also asked.
Tips: Practice Competitive Programming and Object Oriented Programming Concepts.

Round: Group Activity
Experience: We were given Lego Blocks and told to come convince investors to invest in our product. The Lego blocks were used to make the prototype of our product.

Round: HR Interview
Experience: Normal HR questions were asked

Round: Technical Interview
Experience: Questions on Operating Systems, Databases and Object Oriented Programming were asked

College Name: Fr. Conceicao Rodrigues College Of Engineering