WRITTEN TEST

• Logical Reasoning
• Verbal English
• Computer Programming

Topics

• Inductive & Deductive & Abductive Reasoning
• Statements and Conclusions
• Verbal English
• Computer Programming: C, C++, DBMS, OOPS, OS Concepts
• Reasoning
• Data Interpretation
• Retail Banking
• Econometrics

GROUP DISCUSSION: NO

SKILLS REQUIRED

• DBMS
• SQL
• R/Python
• Statistics
• Machine Language
• Excel

INTERVIEW GUIDELINES

Round 1 : Telephonic Interview

• Case Studies
• Current Affairs

Questions

• How can a common problem in our field of study be solved?
• How will you resolve a conflict with a coworker?
• If the govt. wants to dig 100 wells in a city/province to mitigate water scarcity problems, what should guide their decision?
• Give me an example of dealing with a wide array of users and stakeholders.
• Tell me about a time when the outcome wasn't achieved and what you did to justify and mitigate the issues?
• Give me a specific example of a time when you used good judgment and logic in solving a problem.
• Describe a situation in which you were able to use persuasion to successfully convince someone to see things your way.
• What is the biggest business saving you did for your organization?

Round2: Technical Interview Round

• This round include questions from your final year projects
• Explain in detail every technology that was used in making the project, the reason for choosing that project and what the project is about
• Basic coding questions
• Knowledge of the latest tools and innovations helps boost your chances of getting selected

Questions

• How to merge 2 datasets?
• How to extract top 10 customers based on amount, month, number of transactions?
• How to de-duplicate transactions?
• How to do sampling in SAS?
• Why do you want to work in Financial Services?
• Difference between SQL and NoSQL database (basically on the performance side)
• Linear Regression, Market Basket Analysis, Time Series Analysis
• How will you find the top 5 customers of HSBC from the entire world?
• How to calculate the average number of people coming to the airport daily?
• How would you return values from two tables using SQL?
• Tell me what you know about financial instruments used by banks?
• What is linear and logistic regression?
• How is interest calculation done and applied on an account?
• How cash is managed in the branch and what sort of entries are made in ledger for cash payment/deposit?
• What is the meaning of General Ledger?
• How will you manage stakeholders?

Round3: HR Interview Round

• Tell me something about yourself?
• Where do you see yourself in the coming 5 years?
• Tell me something about the company and its CEO?
• Why HSBC?
• Are you comfortable with the location of the job?
• What salary do you expect?
• What can you tell us about HSBC?
• What are your short-term and long-term goals?
• Why do you want to work for HSBC?
• Where do you see yourself in 5 years?
• Why should I hire you?
• What are your strengths and weaknesses?
• Describe your internship in detail and why you chose it?
• How does your prior work experience relate to this current role?
• How can we support you to do your best?
• What value addition will you make to HSBC?

MPLOYEE.ME TIPS

• Pay a lot of attention when filling the application form as it will be the only point of reference for any future interviews
• Briefly explain the skills you possess that make you an ideal candidate for HSBC
• HSBC grades you on your responses to various situations so choose wisely as to what is most beneficial
• Use STAR approach to solve case studies and situation based questions