Centific SQL Developer Interview Questions and Answers

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!

Round: Test
Experience: Questions were based on basic maths and english but time duration as per level of questions was very less. I was hardly able to attempt 90 question.
Tips: Firstly attempt questions from the topics in which you are more comfortable. Don't spend much time in thinking.
Duration: 60 minutes
Total Questions: 120

Round: Technical Interview
Experience: As I am from statistics background ao they asked me questions from regression and inference in depth. Rest all question were from basic stats. And yes they ask question from everything what is there in your resume.
Tips: Be ready for question from everything what is there in your resume and prepare them in advance.

Round: HR Interview
Experience: It was easy and hardly last for 10 min
Tips: Be confident on whatever you speak and prepare for general HR questions in advance.

College Name: IIT BOMBAY

Round: Test
Experience: Questions were simple but demanded faster solving ability especially the Quantitative ability section.
Tips: Solve every bit of R.S.Aggarwal for Aptitude problems. www.indiabix.com is a good site to solve questions from all the sections.
Duration: 90 minutes

Round: Interview
Experience: Started with self description to explaining what projects I was involved in. Talked about my role in the project. Then answered questions from C++ programming language and then wrote the program that the interviewer gave me to do.
Tips: Be Confident. Have the problem solving & "Yes I can Do" attitude. Go with a open mind. Listen to the interviewer carefully. Do not stammer. Keep yourself calm and cool. Be honest.

Round: Interview
Experience: Faced normal questions
Tips: Be confident & keep smiling. Keep track of your body language. Be fluent in speaking English.

General Tips: Be confident and a "can do" attitude will help you grab the job.
Skill Tips: """"
Skills: Communication Skill, Proficiency in English, Basic Computer Progamming Knowledge, Learning ability, Aptitude
College Name: IIT Madras

Round: Test
Experience: Fifty people appeared for the test out of which sixteen were shortlisted.

Round: Case Study Interview
Experience: How would you promote a newly launched product? What marketing strategies would you use? They asked very simple case studies.

Round: Technical Interview
Experience: Test was based on data analysis, mainly maths. The interview was to see how much 'C' and probability you know.
Tips: Customized preparation is must along with good CGPA.

Skill Tips: Work details about your internship helps!
Skills: General knowledge, Technical knowledge
College Name: IIT Madras

Round: Test
Experience: Shortlist is done based on the result of the test conducted. The test consists of two parts basic quantitative skills and a short essay to test your English
Tips: Math and Puzzle solving skills are useful They were looking for people with good math skills and team player

Round: Interview
Experience: Interview was held in two rounds. No technical round is held. One should be prepared for basic HR questions, your understanding of your projects etc.
Tips: There is no technical round and no emphasis on technical background
Prepare for all the basic HR questions beforehand, write them down
Get to know your resume very well

College Name: IIT Madras