Saturday, August 11, 2012

Amdocs Placement Papers 2011



Paper and Interview Experience

Hi guyz!

On 27th September 2011 , Amdocs visited our college ,they selected 11 out of  around 150 students from BIT MESRA.

Here I m sharing my experience with  you people .I hope it will help you.
Plz listen their PPT carefully,It will help you a lot during interview. Although it was too boring for me . I dnt remember all the questions but I hav tried my best to share with u people.


There would be 6 subjects sections :

1. Quantitative aptitude: 20 questions, 25 mins

(Venn diagrams, DS, Some questions on average, 2 Logical Reasoning Caselets each comprising of 4-5 questions) 



2. Attention TO detail (Easiest Section of paper): 15 questions 15 mins

(Pattern matching, arithmetic operators substitution (if + is *), 2 Decision making questions each comprising of 4-5 questtions.) This section in sample paper comprise mostly of pattern matching questions which is not the case in actual paper and would follow the above pattern.



3. Technical passage: 10 questions, 15 mins

(This sub-section comprise of a technical passage (USB, Cookies, Computer N/w, File Organization, O.S etc) and is followed by 10 questions. Don't commit the mistake of reading the whole passage as all the questions are direct, so just browse through the passage.)



4. Programming ability test (C / C++ / Java): 20 questions, 25 mins


I would recommend you to choose between C and C++ as Java was quite difficult and remember that based on your language selection in this test you would be asked question in technical interview.



5. SQL (Toughest section of paper): 15 questions, 15 mins

This is indeed the toughest section of the paper. There can be things which you must have not heard of earlier. Remember questions given in sample paper are quite different from what actually appears in paper

6. UNIX: 15 questions, 15 mins


Basic commands 
Tee, chmod (would always be asked), tail, head, cut, paste, sed, vi editor internal commands(i, I, a, A), grep, etc.

System calls
May or may not be asked.
Do remember meaning of special symbols such as $$,$!,$#,$*,$1 etc.



Questions asked are mainly based on:

1. Index (Clustered, Non Clustered)
2. Views (Updateble and read only views, How they are internally stored)
3. Where condtion involving columns that contain NUll values (so in this case you must remember how AND and OR operators work on NULL values)
4. INSERT statements to a table.
5. Some built in functions (Decode(), Substr(), Instr() )
6. Nested queries
7. Join operations (involves ANSI AND THETA notations)
8. Result of a Query (A table schema would be given and you would be required to determine what would be its output whether it contains any error)

9. Error Correction in a Query i.e what should be modified to make a query run succesfully.
This mainly comprise of errors in group by, having clause, joins (for e.g. Joining two tables without any condition although is correct but would not yield the result)



Written was consist of two section. 
It was a online test. Sectional Cut-off was there.

1 - Technical ( (C/C++/JAVA), sql,unix)
2 - Non-Technical (Data Interpretation (very easy),  Time Distance (2 or 3 ques), Train(1 ques), etc but simple ques were there in this section, And a big  Comprehension from HOW stuff works.com).

Non-Tech portion was very easy,cut off goes till 90% in this section.U can refer R.S. Agarwalfor this.For this portion u require atmost An half day to prepare.

Now lets talk abt tech portion, it was difficult at least for me.
I opted  for  C++. 

C++ all question were from Test Your C++ Skills,And I  had revised so ,it was easy for me.

SQL queries were from join,Subqueries,Clusters etc,This portion was tough for me,
Unix was consist of  Pipelining,Shell Scripting and other vi' Commands.It was very -very difficult for me.

I attempted more questions in C++ in comparison to Unix, I haven't studied Unix any time before, I read unix   just for 2 or 1 day before the visit of AMDOCS.

25 students could clear Written.


Now the Time for INTERVIEW.
It was consist of two rounds.

1 - Pure Tech(around 30-35 minute)
2 - HR round( around  35-40 minute)

GUYZ KEEP IN MIND YOUR  HR INTERVIEW(COMMUNICATION SKILL) WILL PLAY A BIG ROLE IN SELECTION.
Actually ,I was unaware of this fact till the announcement of the AM DOCS Result.

In tech round ,I was asked abt ( What is autometa theory,Give me an example of Autometa theory application,Then I was asked to draw a flow chart  and to write Code for that example).Then I was asked puzzles.I coulnt ans any puzzle.

This interview was not a good experience for me. Others were also asked for writing SQL queries SQL datatypes etc.Be honest with whatever u hav mentioned in ur CV.He can ask question from any subject.Even they checked our result cards during interview .Some students were asked question from the subjects which they have studied in their Graduation.

Now it's the time for HR INTERVIEW.
It started with my INTRODUCTION(Tell me abt yourself).
He asked me in which area I m intresetd to work(development/Testing).I was asked abt my projects etc.s
Guyz , be ready wid ur reason in whichever area u want to work. 

Then asked abt location preference(GURGAON/PUNE).
I  had already offer from Infosys . they asked  me Y AMDOCS?
He asked many question. I was feeling Like I wont be selected, I gave  so many unsatisfactory answers in both the interviews.

But I don't know what happened I was suddenly called for 3rd interview,None other than me appeared for 3rd interview, This interview was taken by their senior executive Manager.I was so scared .I felt like ,I am forced to sent in jail and  I didn't know what mistake I had committed.

Well ,Finally ,I went  for 3rd interview, it again started wid my introduction.
This round went for 40-45 minutes.This round was  of 80% tech and 50% non tech questions.

He asked question from DATA STRUCTURE, SOFTWARE ENGINEERING,C++(MANY CONCEPTS like object oriented ,object based, virtual destrutor  etc).
He asked my area of intrest to work(DEVLOPMENT/TESTING). And Y and Y not?
He asked in which phase of SDLC I m interested to work.

I felt HR interview was not easy to satisfy the interviewe.

In 3rd round ,I could ans 80% and of tech ques. It was little bit satisfactory for me.

They started taking interview in morning at 10:15 am, and they declared results at  9:30 pm.

Finally I was one of those 11. THANX TO GOD!
ALL THE BEST.