27 FEB 2005 INTERVIEWS (TECH + HR)
First I had 2 fill up a blue form which was very important w.r.t upcoming tech & hr interviews. Then tech interview.one lady (LD) and one gentleman (GM) I only will provide u with the tech interview questions. My tech interview was 80% project based. Some of the single questions I remember are as follows
GM: any application softwares u know???
LD: diff btwn dbms & rdbms????? What r codd rules???
GM: how many types of relationship??? Eg. Of many-to-many relationship???
GM: relationship btwn a foreign and primary key??? Smart-key????
LD: eg of left-outer join??? Recursive join????
GM: one complex query involving join!!!
LD: why have u used access instead of oracle in yr project???
I: (remember don't mumble in the interview. If ur saying something 'false' show the confidence in u that yr answer is correct.) Our client told me so. (then smile to yrself!!!!!)
GM: types of dbms?? Give eg of each!!!!!!
LD: give an eg of a table which is in 3nf not in bcnf??? Eg of reverse????
GM: goal in 5 yrs??? Can u achieve that????
LD: what is software configuration management???? What is QA????
GM: what is CMM??? Why level 5??? Advantages of spiral model??????
******** 70% of the interviews are dbms related even if u haven't mentioned dbms as a favorite. Show confidence in all answers. Jus prepare yr basics in dbms, ds, os, software engg, oops, c, c++, corejava , sql server, networking (optional) and get yr ATTITUDE RIGHT********
Again there was on lady (YL) and one gentleman (YM) My hr interview was mixture of discussion, friendly chat, hr, management interview and technical.
YM: so u are from sphs??
YL: meaning of yr name?? What's special abt yr birthday??? Expand yr name to show yr personality???
YM: have u prepared for this interview??? Sources???
YM: what the common questions asked in hr interviews???
YL: one of us is from tech one from hr. guess who's from hr and who's from tech???
YL: are we Bengali or any other religion???
YM: tell us any website from where u can get all tcs previous questions???
YL: your sun-sign??? (mine is Aquarius) common characteristics of Aquarius???? Justify that u r an Aquarius???
YL: do u have a girlfriend???
I: yes. I don't differentiate btwn boyfrnd and girlfrnd . Thats why I have a lot of them!!
YL: will u marry ur galfrnd???
I: I am only 23. I want to give my spouse all comforts of life that's why I will marry after achieving all pleasures and comforts of life!!!!!!!!!!!!
YL: do u want yr spouse to be from IT industry or a non-it???
YL: do u want yr spouse to cook food 4 u or to b a careeristic???
I: I want her to b self-dependant to live her life of her own!!!!!!
YL: if she hags out with her boss?? Come late at night???
I: I have faith in her. As long there is love-bond btwn us there is no problem and she will not do anything to hurt my feelings. (She was impressed!!!!!!)
YL: if she works in an equally competitive environment in a company better than yrs??
I: (at this point I was frustrated. I want to stop the gal frnd episode) Carrer is my first gal friend. Others come after that.
YM: derive complexity for bubblesort
YM: whats the worst case complexity of qiucksort. Practically describe insertion sort.
YM: depth of a binary tree. Derive expression???? Height of binary tree??
YM: eg of recursive function??? Show by an eg.
YM: disadvantage of circular linked list??? Insert in a doubly linked list.
YM: hobbies??? in priority wise???
I: software collection, listening to English hard rock, reading autobiography
YL: whose autobiography???
I: business @ speed of thought by bill gates..
YL: what kind of books u read???? Fiction or non-fiction???
YM: what the latest version of windows???
I: windows Longhorn!!!!!!!!!!
YL: what type of hard-rock??? do ever people around u complain to loud noise??? Why u listen to hard-rock??? Name some famous rock stars.
YM: career plan?? How can u contribute to tcs???
YM: mention some point abt yrself not written in yr bio-data??? Beware if u say something common yr candidature will simply be cancelled?????
YM: ready to sign agreement bond now????
YL: what other companies u appeared for???? Why were u rejected ????
YM: do u have any question???
I: career path in tcs???? How can u become a project manager with tcs provided u perform well??? How tcs is going to be among global top 10 by 2010???? How was my performance??? How can I improve myself????
I believe that is the greatest tcs resource one can find in internet. So get benefited from it!!!!!! Just remember to get yr attitude right. Guys remember besides apti and interviews dress code, smartness, eye contact, positive attitude, friendliness, blue form, communication skill, extra curricular activity, general knowledge, presentation, iq, mental ability, decision taking ability are also tested during interviews. This is from a personal experience besides ask the interviewer as many questions as u can. Show the interviewer u r dying 2 get in his organisation.
With more than three decades of experience in diverse areas of industry and commerce, Tata Consultancy Services (TCS) offers end-to-end strategy consulting and system integration services to Fortune 500 clients across 55 countries. With over 100 offices in 32 countries, TCS employs 24,000 consultants and has 100,000 man-years of experience. TCS posted revenues of Rs 5,012 crores ($1.04 billion) in 2002-2003.
Collaborative research with industry and academia, partnerships with global technology leaders, and innovative projects for over 1,000 clients give TCS an in-depth knowledge of the global economy. Its SEI-CMM (Software Engineering Institute's Capability Maturity Model) Level 5 status, the expertise of its consultants, its world-class products, and proven offshore capabilities strengthen TCS's value proposition (eight of the US Fortune top 10 are TCS clients).
TCS follows a continuous quality-enhancement process, and 15 of its delivery centers in India have been assessed at SEI-CMM Level 5. All of TCS's major development centres are ISO 9001:2000 certified, and its quality management system is also ISO 9001:2000 compliant.
TCS consultants set standards of excellence in the industry. They have consistently topped the worldwide certified quality analyst (CQA) exams. More than 2,300 TCS consultants -- the highest in any organisation -- have qualified as CQAs. Over 17,000 TCS engineers operate from SEI-CMM Level 5 centers -- again the highest number in any organisation in the world. TCS became the first organisation to be assessed at PCMM Level 4 when its Gurgaon II, Noida, Kolkata and Tidel Park centres were assessed at this level in August 2001.
Areas of business
TCS leverages its expertise in its service practices -- eBusiness, Application Development and Maintenance, Architecture and Technology Consulting, Engineering Services, eSecurity, Large Projects, Quality Consulting, and Infrastructure Development and Management -- to provide strategic consulting and system integration services to worldwide clients in banking, insurance, other financial services, telecom, manufacturing and process industries, retail, transportation, healthcare, government and utilities.
Besides providing IT solutions to its clients, TCS develops and markets a variety of products in nearly all streams of industry. It has developed products such as Hospital Management System for the healthcare industry, eIBS, NCS, FIG and Quartz for the banking and financial services industry, CemPac for the cement industry, TARABS, Insurance Product Designer Workbench and Issue Quote for the insurance industry, and also software development tools such as MasterCraft, Assent, DataClean and Infrex.
TCS increases the diversity of its offerings through strategic alliances and joint ventures with global leaders in technology and eBusiness, such as IBM, Netscape, Microsoft, SAP, Oracle and Compaq, to name a few. TCS is also a founder member of the Internet Security Alliance (ISA) and a member of the Universal Description, Discovery and Integration project (UDDI), through which it works with world technology leaders to enhance Internet security and usability.
Joint ventures and subsidiaries
TCS has numerous joint ventures and subsidiaries. Among them are:
Aviation Software Development Consultancy (ASDC), Chennai, in collaboration with Singapore Airlines. ASDC is engaged in the development and maintenance of software for the aviation industry and also offers technical support services to Singapore Airlines.
Airline Financial Support Services, Mumbai,. this fully owned subsidiary renders revenue accounting services to Swissair, Austrian Airlines, Sabena, Lauda Air, and Air Europe. It has now diversified into Qualiflyer support services, distribution support services, navigation support, etc.
eAsiaFinance, Singapore -- an Internet banking solutions company with Ankar Capital, New York, Skandinaviska Enskilda Banken (SEB), Sweden, and Compass Venture Capital (the venture capital arm of McKinsey & Co). eAsiaFinance offers a comprehensive range of wealth management products and services to leading banks and financial institutions in 13 Asian countries.
InnovaTV, San Diego -- formed between TCS America and the head of the multimedia department, University of California, San Diego. InnovaTV, a subsidiary of TCS, undertakes research and development in streaming video.
CMC -- Tata Sons is a 51 per cent stakeholder in CMC, one of India's leading computer networking, facilities management, and maintenance companies. TCS has management control of the company.
TCS has alliances with a large number of academic institutes in India and abroad, including the Indian Institute of Technology in Mumbai, Chennai and Kanpur, the Indian Institute of Science, Bangalore, the University of California, San Diego, the University of California, Riverside, the University of Humberside, the University of Waterloo, the Rotterdam School of Management, Carnegie Mellon University and the University of Wisconsin.
Research and development
The Tata Research Development and Design Centre (TRDDC), TCS's research and development hub, provides critical inputs to the organisation's consulting practice. TRDDC studies, invents and improves leading-edge technology tools and engineering techniques, and applies its intellectual property to TCS's worldwide commercial projects.
The following is a selection of the many awards TCS has won:
Top Software Exporter Award for 2001-2002 (Software Technology Parks of India)
Banker Technology Award 2003 for hallmark project CDSX, executed for the Canadian Depository for Securities Limited (June 6, 2003)
Lotus Beacon 2003 Award from IBM for SmartGov solution (client: the government of Andhra Pradesh; January 27, 2003)
Ranked No 1 in DataQuest IDC CSA survey for CIOs' choice of IT services companies in India (Dataquest, January 15, 2002)
Rajiv Gandhi National Quality Award for TCS's Shollinganallur Center (December 30, 2002)
Best IT Consultant (Asia Pacific) for the year 2002-03 (Global Finance, January 3, 2002)
Silicon India Company of the Year 2002 (November 16, 2002)
DataQuest Top Indian Software Company for 2002
A representative list of TCS's clients: General Motors, Ford Motors, General Electric, Citibank, IBM , ChevronTexaco , AT&T , Verizon Communications, British Telecom, Canadian Mutual Life, Lucent Technologies, Unigraphics, UBS, AXA Insurance, Nike, Nortel Networks, Deutsche Bank, NASD, P&O Nedlloyd, Qwest Communications, United Utilities
TCS has offices in more than 100 cities across 32 countries globally, including 14 in India. TCS is headquartered in Mumbai and serves clients in 55 countries.
I hope u had liked my resource because this is 100% authentic and complete in all respects. This is the greatest tcs resource u can find in any yahoogroup. So guys get the maximum out of it if u r serious abt career in tcs. I got the offer letter today. Next will be training(possibly trivandam) and allotment of project, permanent posting