Consilio SQL Server Database Administrator Interview Questions and Answers for Experienced

Round: Resume Shortlist
Experience: They generally have resume based short listing. And I was shortlisted.

Round: Test
Experience: Aptitude test was easy, in fact 2 or 3 puzzles were directly from -----/.

Round: Technical Interview
Experience: Since iRunway is a technology consulting firm and One of my projects was IR based barcode reader so he asked questions about that. There were total 2 technical interviews.

College Name: IIT KANPUR

Round: Resume Shortlist
Experience: They look for a good CPI, projects and a little bit of extracurricular (to make sure you are a team player). Improvise accordingly.

Round: Test
Experience: Their test is a little different. The job requires one to understand technology so they have a section where one has to read a typical extract of a paper and choose the simplified meaning of the same. It also contains some cat type questions and general questions about technology (like the principle of a microwave oven, etc). It was a miracle I got through the test.

Round: Interview
Experience: The interviewer mainly concentrated on my technical projects (especially BTP) and my internships (be thorough in both these to be able to crack core companies). There were other technical questions broadly on chemical engineering (principle of so and so instrument etc) and other HR questions like how you rate yourself in technology on a scale of 1 to 5, career
plans, reason to join the company etc.
Tips: The interview went pretty well. I answered all questions to his satisfaction with enthusiasm and confidence. This was one place I was sure I‟d get through, but sadly never made it to the second round of interviews. Some say they didn‟t have a requirement for chemical engineering students and they needed only CSE and EE people, but we never know.

General Tips: Internship: (attention third year people!)
When it comes to the placement interview, internships play pivotal role. There are rarely any interviews where the interviewee isn't drilled on their internships. So, please don‟t treat an internship as a paid vacation. Good work done during the internship gives one the confidence that can very well bowl the interviewer over (as it did in my case :D). Believe me confidence does much more than get you a job; it determines success and failure in mostundertakings. Internship gives you the first chance to build that up … use it! 


Pre Placement Talks:
Please attend the ppts of at least those companies which fall into your sector of interest. At ppts you get to see a lot more things than the boring presentations and the pay package. Most companies bring along with them alumni who have spent a few years in the company. Observing or interacting with them will give you a good assessment of what you are going to be a few years from now if you join that company. For example I observed that alumni of XYZ Company were not as upbeat and confident as alumni of ABC Company (names havebeen hidden on request ;) ) even if XYZ was paying plenty more than ABC. I knew then and there that I would want to join ABC and never applied to XYZ. Be sure to utilize them and be sure to clear all your doubts and conceptions. Once you start attending presentations you will observe junta asking questions just to score brownie points with the speaker. Believe me it won't help one bit in landing them a job!


Resumes:
Making an appealing resume is the single most important step in the placement process and IITK is notorious for its bad resumes, so attend workshops. Like most IITK junta I sucked at making a resume (and still do), but whatever little skill I have, I got through workshops. One workshop I would advise everyone to attend is the resume making workshop of McKinsey. Get your resumes checked and edited by those who have been through placement especially by those from other IITs (I know this will hurt a lot of egos, but IITB's resumes are some of the best. Those dudes have mastered the art of making an impact with whatever little they've got, while we excel at doing exactly the opposite :P). Prepare an impactful resume and don't submit the same resume to every company, make changes based on the profile.
College Name: IIT KANPUR

Round: Resume Shortlist
Experience: They look for a good CPI, projects and a little bit of extracurricular (to make sure you are a team player). Improvise accordingly.


Round: Test
Experience: Their test is a little different. The job requires one to understand technology so they have a section where one has to read a typical extract of a paper and choose the simplified meaning of the same. It also contains some cat type questions and general questions about technology (like the principle of a microwave oven, etc). It was a miracle I got through the test.

Round: Technical + HR Interview
Experience: The interviewer mainly concentrated on my technical projects (especially BTP) and my internships (be thorough in both these to be able to crack core companies). There were other technical questions broadly on chemical engineering (principle of so and so instrument etc) and other HR questions like how you rate yourself in technology on a scale of 1 to 5, career plans, reason to join the company etc.

Interview preparation tips for other job seekers - You can join it there is nothing which you’ll dislike. Just prepare yourself well before hr round

Interview preparation tips for other job seekers - be confident on what you know and willingness to learn new things.

Interview preparation tips for other job seekers - Good company to work

Interview preparation tips for other job seekers - Be confident and speak
Have patience bcz it almost took 1 and half month to complete my total interview process