Avant Garde Clean Room & Engineering Solution Interview Questions and Answers

Round: Test
Experience: There were 15 questions from quant’s, 10 questions from data interpretation with 1 mark each and -.5 for wrong answer also there were 2 case studies with 10 marks each with no –ve marks. Total 45 marks question, I did only 9 from quant and 7 from DI total 16 out of 25 questions and didn’t touch case studies. Quanta and DI were very basics level.

In those 16, 1 question was wrong so basically I did 14.5 out of 45, but with a accuracy of 90%. Didn’t expect to get shortlisted but was very tensed and angry upon myself coz it was my level paper. But around 12 mid night shortlist came and I was at 11th position out of 31 students in the list.

There were total around 90 students who appeared for written test. They allowed Mtech and Mca guys not Btech.
Total Questions: 25

Round: TECHNICAL INTERVIEW
Experience: I went there and greeted him. Firstly he told me to introduce myself, later he asked what I like the most. I told analytical thinking and logical reasoning and yeah I relate it with data base.(since I knew they came for Data analyst profile).

He asked me about join, gave me a table and told me to perform all joins. I did that and he asked me about Order by clause and, having clause then asked me normal forms up to bcnf.

Later asked about pl/sql difference b/w sql and pl/sql, what is trigger explain in detail. Some basics questions of DBMS theory asked me about my 2 projects and at the end he gave me a situation where I have a grocery shop outside nit Surathkal, and from last few days/months I realized a downfall in sales, what possible reasons could I find? I gave him 8 reasons within 2/3 mins. He was impressed…

After 1st round out of 31 only 13 were selected and I was there in d list.

Round: TECHNICAL INTERVIEW
Experience: As soon as I entered the room, mam told me “Ooo tum aao aao ”. I smiled because I was the 1st guy during presentation who asked the first question (she made every1 clap for me there) and she remembered my face. And eventually she did study from IIT Kanpur so yes she was able to speak fluent Hindi (plus point for guys like me :p). with her there was a guy he asked me to write code for taking a no and converting it into binary and 1 question from array- very simple later she gave me a table with employee id, order date and order amount. A customer can place max 1 order in 1 day. I had to find the latest transaction of every customer with amount as well. i did it using max function over date and group by with sub query, she asked me about my resume at the end she gave me 7,9,21,63,100 and told me to find the no of numbers between 1 to 50000 which are exactly divisible by all, i did it in 1 min.

but she was smiling, I thought I made some mistake in hurry, then I asked mam m I doing right or wrong (in curiosity as I find very comfortable there) she smiled and said “Chalo bhago ynha se ye interview h ”.I said sorry but yeah she was impressed with my interview so told ki “you will learn all these things very quickly”.

Round: TECHNICAL INTERVIEW
Experience: After 2nd round 9 were selected and I was one of them. It was basically a Managerial round and it scheduled over Skype. I had to introduce myself as well as my family background. Here comes the harder part when he asked me why you have such a poor academic back ground? I was speechless for a moment but I started telling the truth.

I told despite getting 68% marks in my 10th I was the third topper of my class. I got 60.66 % in 12th but yeah there also out of 700 students only 14 got first division. So basically I concluded that in my state board marking is not that much good. He said ok but what happened in graduation(64%) when you studied in Delhi?(what to say now :p) I said sir I did it from IGNOU and you can Google the fact that even less than 5% of student are able to clear the degree in 3 years. Later I explicitly mentioned that I m not blaming my boards but this is the fact which can’t be change.

Now He asked what happened in PG here also you scored only 7.50 CGPA which is less than even standard score of 8(Meri to jaan hi nikal gayi :p). Then I told him that sir u can see my pointer in first semester is very less close to 6.5 but after that I constantly improved myself. He was smiling …..

He asked me about my family background and then I told him how I struggled, I was giving tuition in my grads to continue my education and after grads took a gap of 1 year and cleared all MCA entrance examination and now sitting in front of him.

Later asked about my best qualities….i told him that I can lead group of people very well. I gave example of me being captain of my department cricket team and I was class monitor through 3rd to 12th std and also some stuff regarding my college events. He noted down something .I don’t know what.

I was not sure that I could clear that interview. When the result came they called all 9 students and said that they find is difficult to eliminate 4 names .i was sure that I m out of picture now but fortunately my name was at 2nd position. Wowwwww

Round: HR Interview
Experience: It was telephonic round and just my hobbies and all, he asked me about my poetry writing hobby as well as Hindi Shayaris. I was told to recite 1 …when he listened, he was very impressed…

College Name: IIT KANPUR

Round: Test
Experience: Aptitude part has easy questions, including number series, picture series, interest rate and some quant based questions.

The coding part is difficult.2-3 coding questions, Codes will be related to linked lists , trees or sorting.
Tips: Try to get maximum marks in aptitude, which should be fine with some practice . One of the code will be easy, so complete it and make a try for second
Duration: 1 hour
Total Questions: 30

Round: Puzzle Interview
Experience: very easy puzzles, I was able to solve all puzzles in first attempt
Tips: Be confident in your approach they are locking for approach more than result

Round: Technical Interview
Experience: I answered all resume based questions, he liked my choice of projects, though they were not exactly related to the profile. He liked me and said I would recommend you directly to HR round
Tips: Prepare in details about all points in resume, course work mentioned and projects, Based on performance in this interview, they decide to whether to take one more technical interview or send directly to HR

Skills: Behavioural Skills, Puzzle Solving Capability, Approaching A Problem, Basic Coding
College Name: IIT Madras

Round: Test
Experience: Test was conducted by AMCAT at Madras School of Economics. Test was an adaptive test. Accuracy matters along with the speed. Do focus on all the sections. Questions were easy to moderate.
Tips: Prepare well before the test. HSBC was the second company to conduct test. DO NOT IGNORE RETAIL BANKING.

Preparation Material: Arun Sharma
Duration: 55 minutes
Total Questions: 50

Round: Technical + HR Interview
Experience: HSBC had skype interview at MSE. I was waiting from 11am in the morning. And it was already 6pm in the evening. One girl before me took around 45 minutes. As i entered, they were in hurry. They wanted to finish soon. As i started interview, they directly told me that they are getting late so they would finish things quickly. I was not asked even to introduce myself.

They asked me one project i have worked on and which i think was the best. I told them a project on Credit Risk Modelling. Luckily interviewer was also from the Credit Risk Team at HSBC. He started grilling over all the concepts. Why i used the particular model? What is ROC? What was the delinquency period and why ? I had done that project too seriously. I made him clear all the concepts. They focus more on your concepts and understanding. They also asked my few basic questions on Statistics which were related to my project.

I told them everything in just 10 minutes. And right after that the interviewer told me that it would be the last question they will ask me. I started thinking i won't get selected as no one finished in just 10 minutes. Then interview went on for 5 more minutes. I was given a case study on decreasing sales of a particular departmental store's division.

At last there were some HR questions. At last interviewer was really impressed by me. Guys a

College Name: Madras School of Economics

Round: Test
Experience: 10 single correct questions, 10 CAT based questions, 5 data sufficiency questions, 2 subjective questions were asked.
Tips: All the objective questions were easy so everyone would have solved. Subjective questions were important for selecting candidates .Final solution for subjective questions are not important ,the way you approach is important.
Duration: 45 minutes

Round: Case Study Interview
Experience: Questioned on Resume points. A case study was given and the student has to analyse it.

Round: Case Study Interview
Experience: Case study question and brain teaser were asked. Brainteaser was an easy question.

Skill Tips: Mock interviews with friends and ready with all resume points of how to explain them each helps. Solved many case studies. Updated myself with latest news. I also read Wiki questions like how to get 3 wolnes, 2 men to other side of river?.
Skills: Soft skills, Case study solving ability
College Name: IIT MADRAS