I applied through university. The process took 4 weeks. I interviewed at HSBC (Pune) in Nov 2023
Interview
so this was an on-campus opportunity first round was online and had two parts, the aptitude round + some technical questions and then OA round which had fairly easy questions
135 selected after first round
second round was f2f interview round in which in which there was 8 panel one members each from hsbc after this there was HR round
6. a scenario-based question on a cloud garage that initially had a primary key order_id which is varchar(10) but after the order got increased it had to be changed to varchar(20) or maybe varchar(30) so does alter command sufficient or we may face some other problems (basically can it be done in one day)
It is based on the interviewer My interview experience was good but i am not selected and they covered all the basics and covers all points in resume basics of sql python questions and basic coding and also operating system questions networking questions
Interview questions [1]
Question 1
they covered all the basics and covers all points in resume basics of sql python questions and basic coding and also operating system questions networking questions
It was good.They covered all the core CS subjects which includes OS,DBMS,SQL,CN and even on some cloud technologies.overall experience is good fair interview.There were so many panels during interview and overall good
Once you clear online assessments, the on-campus interview rounds begin.
Technical Interview:
Self-introduction, discussion of your project(s) and resume. Then there were questions on OOPs, sorting algorithms, data structures, basic system design questions (entities, classes) and some easy puzzles.
If you clear this round, then you will have the HR round directly.
Questions like: Tell me something not on your resume, Why HSBC, past teamwork/leadership, how you deal with pressure or conflicting feedback.
The interviewers were generally friendly from my experience and from the experience of other candidates too.
Interview questions [1]
Question 1
One of the questions they asked was:
“Walk me through a technical challenge you faced in a project and how you solved it.”
I described a performance issue I encountered while building a web application, where inefficient database queries slowed response time. I walked through how I identified the bottleneck using logs and query profiling, optimized the queries using indexing, and validated improvements through testing.
They wanted to evaluate structured problem-solving, clarity of thought, and ability to translate technical work into business value.
