Productivity Aids Plsql Developer Interview Questions and Answers

Interview preparation tips for other job seekers - For senior level they will expect knowledge on bulk processing exception handling packages collections

Interview preparation tips for other job seekers - Don't panic and answer questions with your best experience and knowledge.

Round: Test
Experience: It included quantitative ability questions and a few subjective coding type questions. Nothing known about cutoff as almost major chunk of people appearing for the test were called for the interview.The criteria for test is mainly on CGs and at timesdepartments too.There are rare companies like BCG, DB who actually refer your resumes for interviews without tests.
Duration: 1 hour minute

Round: Technical Interview
Experience: 2 rounds of interview were there – first the technical interview which included questions on your resume. Detailed questionson every point you have mentioned, cross checking whether you really know aboutit at times asking you for examples. No speed math was included. The interview was purely on all the stuff mentioned in the resume.
Tips: Study the resume thorough with every point mentioned. Questionswere asked about things externally related (not in the resume) to stuffmentioned as part of skills. So while exaggerating any point be aware of everyfact about it.

Round: HR Interview
Experience: The HR interview included personal level questions like tell me about yourself, where you hail from, positives, negatives, why cognizant, why non-core, how do you see yourself after 2-3 years etc.The second stage may depend upon GDs or interviews. In this case it was purely one –on-one interview in both rounds.

Round: Case Study Interview
Experience: Mentioned about R a tool used in analytics and was talked about linear and logistic regression. Questions about Big Data Analysis and hadoop etc were asked.

General Tips: Its better to start from August solving CAT papers which helps a lot. Purefin certifications do help for companies like DB, Futures First, Nomura and all. Read only quantitative and a few previous years’ case studies (googled as per the company). Read one to two cases everyday and discussions related to them on the internet and write relevant points in some notebook at times searching for terms or phrases. Read the newspaper daily be it times or even the economic times – know whats happening in the world. They may ask you questions like – whats happening in the world. Be sure to answer them with what they would like to hear rather than what you would like to talk on.The situation is better for non core companies because majority of them don’t see the word department while recruiting from iit. Both for non-core or core: give your best for every round andeven if you don’t get selected for first round you can try to push your resumein on spot interview calls for companies you really want to be part of.Although it isn’t fair play but that’s what happens from Placemnt season day 2.And if the rest do it there's no point regretting than to be a part of it.
College Name: IIT MADRAS

Round: Test
Experience: The testincluded quantitative ability questionsand a few subjective coding type questions. Nothing known about cutoff as almost major chunk of people appearing for the test were called for the interview.
Duration: 60 minutes

Round: Technical Interview
Experience: Technical interview included questions on your resume. Detailed questions on every point you have mentioned, cross checking whether you really know about it at times asking you for examples. No speed math was included. The interview was purely on all the stuff mentioned in the resume.
Tips: Suggestion: study the resume thorough with every point mentioned. Questions were asked about things externally related (not in the resume) to stuff mentioned as part of skills. So while exaggerating any point be aware of every fact about it.

Round: HR Interview
Experience: The HR interview included personal level questions like tell me about yourself, where you hail from, positives, negatives, why cognizant, why non-core, how do you see yourself after 2-3 years etc.

College Name: IIT MADRAS

Round: Test
Experience: to.me totally there were three sections.verbal,apti and reasoning.each section carries 15,15 and 10 questions respectively.to me verabal and apti was little bit easy and it consumes more time to solve the apti questions.so i have been solved 8 apti questions and at last 1minute i.just qlicked the answers for remaining questions randomly becasue we didnt have negative mark and finally reasobing was much easier and solved every answers.
Tips: to get selected in the first round you should practice more online tests.then you can easily manage your time.and be cool. so dont worry every thing will become easier and do well.
all the best!!!

Round: HR Interview
Experience: when i faced my HR he asked me to tell three things about me, i.have told generosity,confidence and friendship.and he asked me to elobrate it and i have done well and he goes with the projects that i have done .afterwards he asked about my stream and why it.and i have answered that iam from electrical and electronics background but now a days IT has been entered into every sector and without IT there would be nothing in this world.thats why i choose IT.and asked about my extra curricular activities and iam a sports person too and finally few questions from C and C++.
Tips: Be confident in your speech and try to answer even if not knows the answer well,because they will see how we are trying to answer so dont hesitate to answer.and keep your mind free and every thing will be alright.be cool and all the best

General Tips: start to prpare atleast before one week from the interview.and be cool at any situations and to get speak english fluently practice with your friends and try to converse every thing in english even with customer care, it will be funny to and thats make you to survive your interviews easily...
Skills:
College Name: sri krishna college of engineering and technology
Motivation: in this company there will be friendly environment and there will be less working pressure and have some cultural clubs to have fun with it
Funny Moments: before one week to our placements our friends get started to chat in english and every where we conversed in english it was funny and later we realised how it helped us. so dont bother about others and what they think. just go on with your friends confidently in english...

Round: Test
Experience: Two papers were held for aptitude and were easy enough for a person with good logical and reasoning skills.In the coding section, programs like string reversing were asked. easy enough for a good programmer to bang on!If you have a superb grammar and vocabulary, this section will not be hard enough to fry your brains consequently.
Tips: A good presence of mind and  apt time management will help in scoring well.
Duration: 180 minutes

Round: Technical Interview
Experience: This was a 10 minute round, where few questions on the previous tests held, coding and questions on aero courses were asked.
Tips: Knowledge definitely pays!

Round: HR Interview
Experience: A person should be witty enough in answering questions asked. A great presence of mind will act as a bonus.

General Tips: Right knowledge and understanding regarding coding or any programming language that you are confident enough about will be of great help.
Skill Tips: If the basics of programming are very fluent,then zero problem will arise in encoding or decoding programs.Extra curricular activities weren't given much of any importance.Going through case studies given on the company's website will increment your knowledge.
Skills: Coding, Aptitude
College Name: IIT MADRAS
Motivation: Presence of mind, knowledge and fine observation are the three key ingredients that will make you pass!
Funny Moments: I was sincere enough and on my best behavior, to cause any nerdy moments!