Hi Friends... Last Week i was interviewed by AMDOCS so i'm here again to share my experience with you.
It was the end of the placement for the batch 2012 and we got the mail that amdocs is going to visit in our campus (Earlier it was planned to visit but they postponed it due to some reason) so i was happy by hearing that amdocs again scheduled a drive.
Amdocs is a dream company (package 4.2 LPA) for many students.
Amdocs selection process have 3 Rounds.
1. Written Test
2. Technical Interview
3. HR Round.
a) Aptitude Section
b) Technical Section.
When i appeared for the first round. it was written objective type test (NOT ONLINE). The test was designed by Marittrac and there was no negative marking. There was total 95 question and 115 minutes.
Aptitude section was divided into 3 subsections.
Quantitative Aptitude - 25 questions
Attention to Detail - 15 questions
Technical paragraph- 10 question.
Quantitative Aptitude: It was simple portion. RS Aggrawal is good enough for preparing for it. But keep in mind that it was simple for everyone. Approx. all the student can easily solve the question in this section.
Attention to detail: This section is also very simple we have to just match the string with given strings and find out the same string and some question are about + is changed with *, - changed with / , * changed with - and / changed with +
what would be answer of
5+3-2/7 (this type question not sure about the actual statement)
So everyone can solve this.
Technical paragraph: in this section we are given with a technical paragraph and 10 questions. we have to read the para and find out the answer of the given question. This one is also very simple round.
So, According to my experience overall aptitude section doesn't play main role in selection. Everyone get approx. equal marks in this round. But we have to clear the cutt off of both section and cutt offs are high(around 70%) So practice hard before appear.
Technical Section: it was the hard part of the test. it was also a written test. if you have good knowledge of technical stuff then you can easily go through it and This part decide either you would clear written or not.
Technical section is also divided into 3 subsections.
Programming skill Test (c,c++,Java).
DBMS skill Test
Unix skill test
Programming Skill test(15 question): This section is optional you have to select one from c, c++, java.
i selected C and my advise is that don't select cpp or java unless you are not sound in OOPS. In C test paper they test your programming skills some questions was from TEST YOUR C SKILLS. They also test pointers deeply. so you should have good knowledge of pointers. Some question was for testing our reading and understanding of other's code.
Q) which code is correct for finding palindrome of strings.
Then 4 options contain full code and we have to select one from them.
*IF YOU HAVE GOOD KNOWLEDGE OF 'C', 'CPP', JAVA YOU CAN MAKE DIFFERENCE IN THIS SECTION EASILY*
DBMS skill Test(15 question): It was a very very difficult section frankly speaking a DBA can't solve this section completely. When i read the question i was thinking that are they hiring DBA or programmer. i knew the answer of only 7 to 8 questions and a day before the test i got 9 sample questions from my friend and 3 of them was in paper. so in my test i was sure about around 11 questions rest was TUKKA :)
for this round read about joins, views, cursors, triggers, store procedure and indexes deeply specially internal working.
Here are some sample question to panic you.
1. Min. permission required to execute drop database command
DB Admin
DB Owner
Control
User
2. You want to create an index on a column such that the select statement require min time to retrieve the data. The column is unique and if data is physically sorted, query will be faster. Which index would you see.
Clustered
Non-Clustered
Unique
Composite
3. Which of the following can appear in any order, so relation still will be the same and therefore convey the same meaning.
Attributes
Entity
Tuples
Entity Set
4. How will you enable SQL 2005 to physically store computed values in the table and update when any other columns are updated?
Use computed expressions and provide the expression
Use persisted option during the table creation
Create a clustered index on the computed column
Create a default constraint in computed expr.
5. Which of the given stmt. is related to following created view?
Create VIEW emp_dept_outerjoin1 AS SELECT empno, ename, e.deptno,dname,loc FROM emp_tab e, dept_tab d WHEN e.deptno = d.deptno(+);
View successfully created
Views that involve outer joins are not modifiable
Column in base empt_tab table of emp_dept_outerjoin1 are modifiable through the view
Columns in dept_tab table of emp_dept_outerjoin1 are modifiable through the view
Column in base emp_tab of emp_dept_outerjoin1 are not modifiable through the view
6. Which of the following comes under DML
Drop
Alter
Insert
Create
Unix skill test: This was also a tough section i have no idea what they asked (all was unix command). prepare for unix commands specially CHMOD , SED, TEE, SORT,LS, KILL, commands of VI editor. here is link for unix commands. No one would be good in this round so if you will prepare hard you can easily make difference.
Then after 4 days we got mail about amdocs result. Luckily my name was in list and it was on the TOP :)
total 156 appeared for written and only 32 selected.
It was the end of the placement for the batch 2012 and we got the mail that amdocs is going to visit in our campus (Earlier it was planned to visit but they postponed it due to some reason) so i was happy by hearing that amdocs again scheduled a drive.
Amdocs is a dream company (package 4.2 LPA) for many students.
Amdocs selection process have 3 Rounds.
1. Written Test
2. Technical Interview
3. HR Round.
Written Test:
On 18th july we received mail that amdocs visiting on 20th july so we have only 2 days for the preparation. i googled and found some written stuff about amdocs but it screwed me because differ people posted different views about the test. some telling that test would be online. some are talking about another type of question and also ambiguity about negative marking. so i concluded that amdocs frequently change their question paper style but the fix thing is that test paper must have 2 section.a) Aptitude Section
b) Technical Section.
When i appeared for the first round. it was written objective type test (NOT ONLINE). The test was designed by Marittrac and there was no negative marking. There was total 95 question and 115 minutes.
Aptitude section was divided into 3 subsections.
Quantitative Aptitude - 25 questions
Attention to Detail - 15 questions
Technical paragraph- 10 question.
Quantitative Aptitude: It was simple portion. RS Aggrawal is good enough for preparing for it. But keep in mind that it was simple for everyone. Approx. all the student can easily solve the question in this section.
Attention to detail: This section is also very simple we have to just match the string with given strings and find out the same string and some question are about + is changed with *, - changed with / , * changed with - and / changed with +
what would be answer of
5+3-2/7 (this type question not sure about the actual statement)
So everyone can solve this.
Technical paragraph: in this section we are given with a technical paragraph and 10 questions. we have to read the para and find out the answer of the given question. This one is also very simple round.
So, According to my experience overall aptitude section doesn't play main role in selection. Everyone get approx. equal marks in this round. But we have to clear the cutt off of both section and cutt offs are high(around 70%) So practice hard before appear.
Technical Section: it was the hard part of the test. it was also a written test. if you have good knowledge of technical stuff then you can easily go through it and This part decide either you would clear written or not.
Technical section is also divided into 3 subsections.
Programming skill Test (c,c++,Java).
DBMS skill Test
Unix skill test
Programming Skill test(15 question): This section is optional you have to select one from c, c++, java.
i selected C and my advise is that don't select cpp or java unless you are not sound in OOPS. In C test paper they test your programming skills some questions was from TEST YOUR C SKILLS. They also test pointers deeply. so you should have good knowledge of pointers. Some question was for testing our reading and understanding of other's code.
Q) which code is correct for finding palindrome of strings.
Then 4 options contain full code and we have to select one from them.
*IF YOU HAVE GOOD KNOWLEDGE OF 'C', 'CPP', JAVA YOU CAN MAKE DIFFERENCE IN THIS SECTION EASILY*
DBMS skill Test(15 question): It was a very very difficult section frankly speaking a DBA can't solve this section completely. When i read the question i was thinking that are they hiring DBA or programmer. i knew the answer of only 7 to 8 questions and a day before the test i got 9 sample questions from my friend and 3 of them was in paper. so in my test i was sure about around 11 questions rest was TUKKA :)
for this round read about joins, views, cursors, triggers, store procedure and indexes deeply specially internal working.
Here are some sample question to panic you.
1. Min. permission required to execute drop database command
DB Admin
DB Owner
Control
User
2. You want to create an index on a column such that the select statement require min time to retrieve the data. The column is unique and if data is physically sorted, query will be faster. Which index would you see.
Clustered
Non-Clustered
Unique
Composite
3. Which of the following can appear in any order, so relation still will be the same and therefore convey the same meaning.
Attributes
Entity
Tuples
Entity Set
4. How will you enable SQL 2005 to physically store computed values in the table and update when any other columns are updated?
Use computed expressions and provide the expression
Use persisted option during the table creation
Create a clustered index on the computed column
Create a default constraint in computed expr.
5. Which of the given stmt. is related to following created view?
Create VIEW emp_dept_outerjoin1 AS SELECT empno, ename, e.deptno,dname,loc FROM emp_tab e, dept_tab d WHEN e.deptno = d.deptno(+);
View successfully created
Views that involve outer joins are not modifiable
Column in base empt_tab table of emp_dept_outerjoin1 are modifiable through the view
Columns in dept_tab table of emp_dept_outerjoin1 are modifiable through the view
Column in base emp_tab of emp_dept_outerjoin1 are not modifiable through the view
6. Which of the following comes under DML
Drop
Alter
Insert
Create
Unix skill test: This was also a tough section i have no idea what they asked (all was unix command). prepare for unix commands specially CHMOD , SED, TEE, SORT,LS, KILL, commands of VI editor. here is link for unix commands. No one would be good in this round so if you will prepare hard you can easily make difference.
Then after 4 days we got mail about amdocs result. Luckily my name was in list and it was on the TOP :)
total 156 appeared for written and only 32 selected.
TECHNICAL INTERVIEW
On 24th july we got the mail about selection and schedule of interview. it was 25th july so again we have no time for preparation. i googled and found that in interview round they will only ask questions about UNIX and DBMS so i only prepared about unix and dbms. But when i was interviewed they didn't ask even a single question from UNIX and DBMS but from other students they asked.
Everyone have to undergo both interview HR and TI (technical interview) one followed by other.
My TI was last long for around only 15 minutes and it was 2-to-1 round and HR was about 30 minutes. it was 1-to-1 round.
Here is conversation:
Interviewer: Tell me about yourself.
Me: first of all i would like to thank you for giving me an opportunity of introducing myself to you.
I am AMRITPAL SINGH. i was born and bought up...... blah blah blah................
.....coming to my interesting subjects, during my graduation i studied only C, Data Structure, and Analysis & Design of algorithms so you can ask any thing from this portion ( i was weak in DBMS and UNIX so indirectly i told that i know only these subject so ask me form this domain. In this question you can make clear to interviewer that what you know).
Interviewer: So you know DS and ADA. ok good. and what are your hobbies ?
Me: solving puzzles and playing chess.
Interviewer: then here is puzzle about chess. "You have to place 8 queen on a fair chess board but condition is that no queen should be under attack of other queen."
Me: ok so i have to design algorithm for it or simply solve the problem? (Actually it was a general 8-queen problem from ADA i solved it before but i pretended them that i dont know about it).
Interviewer: you have to design algo and solve it.
then i explained each and everything about it and designed algo for it. and then they came to my resume. Oh god!!! they asked each and everything in my resume so be very true about your resume.
Interviewer: Good !!! You mention that you was Admin of college labs what you did for managing labs and what was you responsibilities?
ME: I installed the window server and managed group policies (explained everything).
intervewer: Ok. now coming to your project how did you get idea to design these projects tell me about each project who inspired you to design it. did u designed it alone? or it was designed by team?? ( Then for next 10 minutes i explained all my projects)
And thats it!!!
then without any delay i was moved to HR room. HR manager asked me many questions. During HR round BE very TRUE about yourself don't be fake.
Welcome Amrit How was your interview?
Tell me about youself & family?
why you want to join Amdocs?
Any offer in hand?
Why you dont want to join TCS?
Any Problem in relocation & shifts?
Your strengths?
Your Weekness? ( Be True!!! dont say like that my hand writing is poor they have no concern with it tell him actual week point when you come to know about your week points and what you did till now to cover it.)
Followed by this many another general HR questions.
Uffff............ i'm tired now. i think that is enough for cracking Amdocs.
So see you in Amdocs
BEST OF LUCK !!!