Add office photos
HSBC Group
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
HSBC Group Consultant Specialist Interview Questions and Answers
HSBC Group Consultant Specialist Interview Experiences
6 interviews found
Anonymous
Selected
I was interviewed before Feb 2023.
(2 Questions)
- Q1. About previous job profile
- Q2. Simple job related questions
(1 Question)
- Q1. Behavioral questions and technical understanding
(1 Question)
- Q1. Only salary discussion
(1 Question)
- Q1. Tell me about yourself
(1 Question)
- Q1. As a Consultant how will you manage a stubborn customer
(1 Question)
- Q1. What are your strengths and how do you plan to use them to add value to this job
Interview Preparation Tips
Hemant Kumar
Selected
I applied via Referral and was interviewed before Nov 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Mainframe technology vsam peeformance via jcl parameter
- Ans.
VSAM performance can be optimized using JCL parameters in mainframe technology.
Use IDCAMS utility to define VSAM datasets with optimal parameters like CISIZE, RECSIZE, etc.
Specify buffering options like BUFNO and BUFL in JCL to improve I/O performance.
Tune the SPACE parameter in JCL to allocate appropriate space for VSAM datasets.
Leverage features like AIX and RLS for improved VSAM performance.
Monitor performance using...
- Q2. Cobol handling of variable file
- Ans.
COBOL can handle variable-length files by using OCCURS DEPENDING ON clause to dynamically allocate memory based on the file size.
COBOL uses OCCURS DEPENDING ON clause to handle variable-length files.
The OCCURS DEPENDING ON clause allows for dynamic allocation of memory based on the file size.
Example: 01 EMPLOYEE-RECORD. 05 EMPLOYEE-ID PIC X(5). 05 EMPLOYEE-NAME PIC X(20). 05 EMPLOYEE-SALARY PIC 9(6)V99 OCCURS DEPENDING
(2 Questions)
- Q1. Salary expectation
- Q2. Notice period in current company
Skills evaluated in this interview
Interview Questionnaire
2 Questions
- Q1. Telll me something about your self
- Q2. Are you willing to work on any of technology related to your field or need to stay on current working technology
Interview Preparation Tips
HSBC Group interview questions for designations
Selected
I applied via Recruitment Consulltant and was interviewed before Jan 2022. There were 2 interview rounds.
(2 Questions)
- Q1. Tell me abut yourself.
- Q2. How you would handle a situation where your colleague is having less experience than you but assigns or directs work.
Interview Preparation Tips
First of all the best for all your interview preparation. I would like to share simple trick ,even though you have worked slightly on any technology just explain the interviewee with all confidence what bit of the technology has been tried hands on by you. Dont give up saying I dont know or I am not sure.This reflects your attitude to be honest and not giving up attitude.
I applied via Referral and was interviewed in Aug 2021. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Question on spark fundamental and concept like rdd, dataframe, performance tunning , data pipeline design, Hive , Hbase
Interview Preparation Tips
With spark Hadoop, Big Data, Hive,
Consultant Specialist Jobs at HSBC Group
Interview questions from similar companies
I applied via LinkedIn and was interviewed in Oct 2024. There was 1 interview round.
(2 Questions)
- Q1. What do inherent risk and residual risk
- Ans.
Inherent risk is the risk level before any actions are taken to mitigate it, while residual risk is the risk level after mitigation efforts.
Inherent risk is the risk level that exists before any actions are taken to mitigate it
Residual risk is the risk level that remains after mitigation efforts have been implemented
Inherent risk is inherent to the activity or situation, while residual risk is what is left over after c...
- Q2. What is the RCA
- Ans.
RCA stands for Root Cause Analysis, a method used to identify the underlying cause of a problem or issue.
RCA involves investigating and analyzing the factors that contributed to a specific outcome or event.
It helps in determining what went wrong, why it happened, and how to prevent it from happening again.
Common techniques used in RCA include 5 Whys, Fishbone Diagram, and Fault Tree Analysis.
Example: If a product fails...
Selected
I applied via Company Website
(1 Question)
- Q1. 1. Basic details
(2 Questions)
- Q1. Basic insurance details
- Q2. 2.Company business
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed in Feb 2024. There were 2 interview rounds.
(3 Questions)
- Q1. Unix Command, ITIL
- Q2. SQL query written
- Q3. General question
(2 Questions)
- Q1. Technical scenario based question
- Q2. ITIL process, previous experience
Interview Preparation Tips
I was interviewed in Nov 2023.
(5 Questions)
- Q1. What is Tred lifecycle
- Ans.
The Tred lifecycle refers to the stages involved in the testing and development of a software product.
Tred lifecycle includes requirements gathering, test planning, test execution, defect tracking, and test closure.
It ensures that the software meets the specified requirements and is free from defects.
Examples of activities in the Tred lifecycle include creating test cases, executing tests, and analyzing test results.
It...
- Q2. What is SDLC in testing
- Ans.
SDLC in testing refers to the Software Development Life Cycle, which is a process followed for developing and testing software.
SDLC is a systematic approach to software development and testing.
It consists of several phases such as requirements gathering, design, coding, testing, and deployment.
Each phase has specific objectives and deliverables.
Testing is an integral part of SDLC and is performed at various stages to e...
- Q3. What is a testing lifecycle
- Ans.
A testing lifecycle is a set of phases or stages that a software undergoes during the testing process.
A testing lifecycle typically includes planning, designing, executing, and evaluating tests.
It helps ensure that the software meets the desired quality standards.
The lifecycle may vary depending on the development methodology used, such as waterfall or agile.
Examples of testing lifecycle models include V-model, iterati
- Q4. Difference between C and C++
- Ans.
C is a procedural programming language, while C++ is an extension of C with added features of object-oriented programming.
C is a procedural language, meaning it focuses on procedures or functions.
C++ is an extension of C and supports both procedural and object-oriented programming.
C++ has additional features like classes, inheritance, polymorphism, and templates.
C++ allows for the use of objects and classes to organize...
- Q5. What is a difference Between Amazon Sites and app explain
- Ans.
Amazon Sites and app differ in their platform and user experience.
Amazon Sites can be accessed through web browsers on desktop or mobile devices.
Amazon app is a mobile application available for iOS and Android devices.
Amazon Sites offer a wider range of features and functionalities compared to the app.
The app provides a more streamlined and optimized user experience for mobile users.
Amazon Sites may have a responsive d...
HSBC Group Interview FAQs
Tell us how to improve this page.
HSBC Group Interviews By Designations
- HSBC Group Assistant Manager Interview Questions
- HSBC Group Software Engineer Interview Questions
- HSBC Group Analyst Interview Questions
- HSBC Group Business Analyst Interview Questions
- HSBC Group Senior Software Engineer Interview Questions
- HSBC Group Software Engineer Trainee Interview Questions
- HSBC Group Software Developer Interview Questions
- HSBC Group Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Technical Specialist Interview Questions
- Software Engineering Specialist Interview Questions
- Technology Specialist Interview Questions
- Specialist Testing Interview Questions
- Software Specialist Interview Questions
- Data Specialist Interview Questions
- Infrastructure Specialist Interview Questions
- Senior Specialist Interview Questions
- Show more
HSBC Group Consultant Specialist Interview Process
based on 3 interviews in last 1 year
Interview experience
People are getting interviews through
Interview Questions from Similar Companies
Fast track your campus placements
HSBC Group Consultant Specialist Reviews and Ratings
based on 89 reviews
Rating in categories
|
Assistant Manager
2.7k
salaries
|  ₹4.5 L/yr - ₹14.6 L/yr |
|
Manager
2k
salaries
| ₹8 L/yr - ₹28.1 L/yr |
|
Senior Software Engineer
1.7k
salaries
| ₹7.4 L/yr - ₹29 L/yr |
|
Assistant Vice President
1.4k
salaries
| ₹12.5 L/yr - ₹45 L/yr |
|
Software Engineer
1.3k
salaries
| ₹4.9 L/yr - ₹14.5 L/yr |
Standard Chartered
Citibank
ICICI Bank
Axis Bank
Calculate your in-hand salary
- Home >
- Interviews >
- HSBC Group Interview Questions >
- HSBC Group Consultant Specialist Interview Questions
