HSBC PAPER & INTERVIEW - 19 JUN 2010 - BANGALORE
I have appeared for the walk-in of HSBC GLT for Pune location. It was conducted in Bangalore for JAVA and Mainframe Experienced.
I am from Mainfreame stream, so gonna share the experiences to you all.. As I could not find their pattern anywhere before interview, so think will help to anyone of you, who wants to have interview in Mainframe stream.
There was three rounds of selection procedure :
2. Technical Interview
3. HR round
There were total 6 rounds of written test indiviually on Vocabulary test, Anlaytical ability, JCL, COBOL, DB2, and CICS.
Vocabulary test was of 20 marks. They picked up an article from some newspaper or online based on home inspection and introduced 20 blanks in the para. For every 20 blanks there will be four options given and based on the meanning and suitability at the postion, you have to find out the correct option.
Analytical test was of 20 questions and you have to cover it in 20 mins. I personally felt that the questions were not very tough but you need to be quick.
5 questions based on SET.
2 questions on Logical reasoning (QUITE easy)
5 on pure MATHS (Easy one)
In COBOL they asked 10 questions, need to be answered in 10 mins. Few questions I remember like:-
1. What is the default print format
a) DUMP b) hexadecimal c) binary
2. Pick the correct format to read an ESDS file
a) organisation is sequential
b) organisation is indexed
c)organisation is sequntial, record mode is FB
3. How do we cast a variable in COBOL
a)Can't be done
b)simply assign the variable to another variable
4. In case of file lengthe mismatch between logical and physical file, the erro no is:-
a)39 b)46 c)soc7
5. Whcih PIC clause is used for floating point
a)COMP b)COMP1 c)COMP2 d)COMP3
In JCL again there were 10 questions in 10 mins, need to be quick
1. What is allowed to check in condition parameter
a)RC b)CC c)ABNEDCC d)all of the options
2. What is true about JCL
a)It is not case sensitive
b)The job name should start from or before column 12
c)The job name is not required
DB2 was quite easy section but you need to be very very quick.. Questions was mostly on select statement.
1. Two table was given and you had to have a select statement which should satisfy the given condition.. You need to check relation between both the tables.
4-5 questions was on same.
2. What are the diff steps for CURSOr
a) Declare, Open, Fetch, Close
b) Define, open, fetch,close
c) open, fetch,close
3. 922 indicates
a)DB2resource not available
b)record lenght mismatch
c)object not found
CICS again was of 10 marks, in 10 mins.. All basic questions, can't remember much but few questions were like;;;-
1. MAPSET means:
a)Group of defined maps
b)Group of map fileds
c)group of maps
2. One questions on psuedo conversation
3. One questions on TDQ
4. Can one transcation invoke multiple task
a)can not invoke
c)Transaction Id can not invoke TASK itself
5. PPT is:-
a)contains transcation Id
b)contains mapset name and program name
Do not forget each round has sectional cut off, so you have to pass each section.. Finally, I got through written.
Next comes Technical Round....
HR was cool, first he asked me to intorduce myself in brief, basically he was intersted to know my work profile, I mean what extent I have worked on.
then he shot questions indiviually from all sections.
in DB2 a long time discussion on bind and package, confused me a lot.. so be thorough..
then he asked me about error -811 and how will I resolve it. Expalined the cursor concept
He asked about -818 and to expalin some more time related errors. Explained -180 and -181
Now he came on COBOL
asked me to explain all available PIC level
diff betwen COMP1 and COMP2
where do we define file structure and where do we declare it
tell me some of the control blocks and explain
diff betwen dynamic call and static calll
Don't remember much
tell me some cotrol tables
what is FCT and DCT
diff between TDQ and TSQ
which one is faster among TDQ and TSQ
relation between TDQ and DCT
Finally he was done and after 10 mins I got the result that I was selected for HR round
HR Round was just a formality to discuss the salary.. And finally I became part of HSBC GLT.
Hope this information will be worth for some of you...
All the best... CHEERS!!!!
Author : Jaswant
3i Infotech - AAI - ABACUS - ABB - Accel Frontline - Accenture - Aditi - Adobe - ADP - Agreeya - Akamai - Alcatel Lucent - Allfon - Alumnus - Amazon - Amdocs - AMI - Andhra Bank - AppLabs - Apps Associates - Aricent - Ashok Leyland - Aspire - Atos Origin - Axes - Bajaj - Bank of Maharashtra - BEL - BEML - BHEL - BirlaSoft - Blue Dart - Blue Star - BOB - BPCL - BPL - Brakes - BSNL - C-DOT - Cadence - Calsoft - Canara Bank - Canarys - Capgemini - Caritor - Caterpillar - CDAC - CGI - Changepond - Ciena - Cisco - Citicorp - CMC - Consagous - Convergys - CORDYS - Crompton - CSC - CTS - Cummins - Dell - Deloitte - Delphi-TVS - DeShaw - Deutsche - Dotcom - DRDO - EDS - EIL - ELGI - ELICO - ERICSSON - Essar - Fidelity - Flextronics - Freescale - FXLabs - GAIL - GE - Genpact - Geodesic - Geometric - Globaledge - GlobalLogic - Godrej - Google - Grapecity - HAL - HCL - Hexaware - Honeywell - HP - HPCL - HSBC - Huawei - Hughes - IBM - IBS - ICICI - iGate - Impetus - iNautix - Indian Airforce - Indian Airlines - Infosys - Infotech - Intec - Integra - Intergraph - IOCL - iSOFT - ISRO - Ittiam - JSW - Keane - Kenexa - L & T - L & T Infotech - LG Soft - Lifetree - LionBridge - Mahindra Satyam - Mastek - Maveric - McAfee - MECON - Microsoft - MindTree - Miraclesoft - Mistral - Motorola - Mphasis - MTNL - NIC - Nokia Siemens - Novell - NTPC - Nucleus - ORACLE - Patni - Perot - Polaris - Ramco - Robert Bosch - Samsung - SAP - Sapient - Sasken - SBI - Sierra Atlantic - Sonata - Sony India - Sutherland - Syntel - TCS - Tech Mahindra - VeriFone - Virtusa - Wipro - Zensar.