Deloitte Business Technology Analyst interview questions

I was contacted late June 2014 and the process took approximately 3 weeks (only because of July 4th, or it would be 2 weeks). This is for FEDERAL BTA, which means you will be working on government stuff. I was called by the recruiting coordinator. She was nice and wanted to help me as much as possible. We talked a bit about what the job was about and its location (consider it a very laid back interview, but dont discount that you can 'fail' it), and she asked me about relocation and salary and basic requisites like US citizenship and all that, then she paired me up with an interviewer. 1st Round- Technical Interview: As someone with a STEM degree, I was paired up with a developer for a initial technical phone interview. Be very careful, it is indeed technical. The person will be a senior specialist who knows their stuff and will definitely know when you are trying to play him/her. They will DEFINITELY scour your resume and ask you questions from it. Here are some questions I wrote down for yall: what is the difference between scripting and object oriented languages? what is the primary thing about oo languages? how to SELECT from a table (relational database)? what is a relational database? What is the steps in SDLC? What are JOIN? What is AJAX? You know what it means? What is it used for? Give me an example if an AJAX website. They can ask other meta questions. However do not base your preparations off of my exact questions. Base them of the format or depth. I told them I knew Java and the interviewer decided to test my knowledge on concepts. So kinda at least understand all terms and stuff you used in your resume. 2nd Round- All in one: I had a case, technical and culture fit/behavioural interview. 3 different people in different timeslots, singularly, in one day spanning 2 hours. Now, my situation is most likely going to be different from most of the reader's, because I had special arrangements. I had to do a teleconference (video chat) interview rather than a regular normal fly-to-location - face to face interview that my peers most likely did. So since I would be working in another state, I was asked by Deloitte to go their office in my current state (which is not where I am gonna work) and video chat them from there. Interesting experience, but each interview was exactly 30 minutes with the interviewers being cut off/interrupted when another has to come in (its all automatic). So yeah... But it was great and super prompt. I had the interview on friday and heard on monday.

The process was amazing. I went through campus recruiting, and now as an analyst on the other side can confirm that all school follow this process. About a week before the first interview, I received confirmation that I was chosen. The night before there was a meet and greet with recent alumni and the partners who would be administering the interviews (a bit nerve wracking). The interview process was the best part. On Monday, there were two 45 minute interviews, one case and one behavioral. The case was a bit difficult since I had a business background and the case was an SDLC case. Not quantitative at all. The behavioral was very relaxed. On Monday evening, I received a call for a second round which was to be conducted the next day. It was amazing not having to wait two weeks for the next round. The second round consists of one hour long joint behavioral and case interview. Again SDLC case with no calculations, just talk through the issues. About 10 days later, offers were distributed, it was great.