Tata Consultancy Services - Hyderabad, October 31, 2012.
I'm Kishore frm University of Hyderabad doing M.C.A final year. First of all thanks for your interest to learn about experience of the snrs that makes your 50% succeess.
TCS Visited my campus on 30, Oct, 2012, and this time it took very less number as TCS is in crisis, the number is 7(33 in the last year) .
Now let us come to Interview process as u all know the TCS interview is of 4 rounds,
Written Test is a bit tough.. another three rounds TR,MR,HR its of Average.
Written Test : Practice well all arithmetic questions from R.S.Agarwal aptitude.
TR : Basics of OS, DBMS, Software Engineering, Networks,DS. A bit confidence on one of these subject that must be your Area of Interest.
MR and HR : Confidence about you, dont bother about communication, its no longer valid until you have some thing to express. and use your common sense to answer the question in a polite manner, which doesnt show ur attitude.
First round after written:
ME : May I come in sir,
TR : Yes, Take ur seat (after come into the room).
ME : Thank you sir.
TR : Tell me about ur self.
ME : told.
TR : What is your interesting subject
ME : Operating system and DBMS concepts.
TR : What is Deadlock?
ME : Told (not like a defination)
TR : Write a query in sql that can cause Deadlock and refine ur query which avoid the dead lock.
ME : I got clarity about question after I ask him for explain your requirement for query (I have tried a minute as I have a confident that i can do it.)
TR : How many tables u require for doing this? (while i'm trying on the paper with a single table schema)
ME : I said confidently that single table is enough i'm trying to make this table resource busy with more than one process to bring system into deadlock state.
TR : Ok, carry on.
ME: i wrote the query which does update as well as retrieves same time using sub query and explained syntax may not be correct but the logic i told.(He accepted my logic as well as avoiding mechanism.)
TR: write a query to delete a record from a table where the attribute 'total' is max?
ME : Wrote.
TR : Change the query to delete second maximum.
ME : tried and told the logic .
TR : IS using a rowid correct thing?(as my logic of prev question involves the rowid)
ME : No, using surrogate key is not preferable, in general DBA has to take prevention to maintain correct normalization to avoid these kinds of problems based on the requirements (as I don't know why its not preferable I extended my answer to what I know i.e Normalization concept. in fact I expected the next question from TR.)
TR : What is Normalization (I'm so happy that my interview is now on my track)
ME : told.
TR : What is anomaly?
ME : told.
TR : What is good whether to normalize or demoralize the database schema?
ME : told (includes my clarity about normalization)
TR : What is page replacement algorithm?
ME : told (strategy of the algorithm)
TR : What is the name of this algorithm?
ME : sorry sir, i could not able to recollect the name(as i tried 30 sec)
TR : Are you from govt. school and colleges ? (with unbelievable expression)
ME : Yes sir!!
TR : ho! what is your father? (May be my MR round start from this question as i directly went hr round after this round)
ME : He is a former.
TR : Ok, then why don't you help your father why did you studied by struggling up to now.
ME : He never feel my education struggled him, and my brother is working in Kuwait in a oil company and helping my family financially and my family feel really happy if i'm in a big position in my future, that hope gives me lot of energy to work hard and seek knowledge to full fill my family desire.
TR : Thank you kishore, Do you have any question to ask me?
ME : sir, I have studied in the forum using surrogate key ex: rowid is not preferable and i also answered to you. may i know the reason sir?
TR : He explained me as industrial manner saying some reasons.
ME : K sir, Thank you.
After 4 hours i directly called for HR, before me there are 4 students went they all are saying he z so arrogant and it is the elimination panel, but still i dint loose my confidence as my TR/MR was done nicely.
ME : Excuse me sir. May i come in ?
HR : Door is already open man and i m free only why r u asking me permission.
ME : I don't care his words as i know he is in angry mood, Good Evening sir!
HR : Sit down.
ME : Thank you sir.
HR : R U from Rajahmundry?
ME : No, sir my village is near to rajahmundry its seethanagram, 23km far from Rajahmundry.
HR : where is in sitanagaram?
ME : told (I thought he z from my location)
HR : Which movie have you watched recently ?
ME : Brothers (a Tamil movie dobbed in Telugu).
HR : Explain the story?
ME : I started with description of movie
HR : I don't want your comments on movie i want the story
ME : K, sir ( trying to explain the story)
HR : What is the product name in that movie.
ME : I said its ENERGY ION
HR : Ok, Carry on.
ME : continuing story
HR : interrupted me and ask me which year that Olympic games held in that movie?
ME : I said the main competition between USA and Russia but the year not mentioned.
HR : Is it not mentioned or u don't know?
ME : no sir I dint observe the year in the movie (accepted mistake frankly)
HR : I have watched in the last night it was 1924
ME : k, sir.
HR : when did you watch this movie?
ME : 15 days back. (he got a call and talked in Tamil then I understood that he is a tamilian)
HR : Ok, you dint tell this point and that point like 3 points he posed on me about the movie.
ME : I accepted politely my mistakes and saying that for expressing some point I dint get the word.(in this way I cover my mistakes.)
HR : Ok, is it your first interview?
ME : Yes sir.
HR : You can leave.
ME : Thank you sir.
On next day results came among 19 students who went for HR 7 shortlisted and I'm the one student in that list.
I would like to suggest you one thing be confident on your self. feel interview as discussion between you and interviewer so use the terminology what you know so can drive your interview in your way.
All the best to all of You.!!
Thank you very much to indiabix.com.
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.