Skip to main content

Interview at Deloitte

 


 




Hi All, 

I am back now with one of my best interview experiences so far and this was of Deloitte India. The salary that they were ready to pay was approx 7 LPA and the location was supposed to be Hyderabad. The interview was scheduled in the mid of December. An interview link was shared the day before the interview. The candidates joined at 11:00 AM and there was a wait time of almost 40 minutes as the panelists were busy. At around noon I was routed to a lady panelist. She was convivial and she first asked me to introduce myself like any other interview.  

After this, she asked me about my projects and my roles in them. As I went on to explain my projects there were points when she interrupted me and asked me to elaborate. In the same process, she also asked me some questions related to them. Let me narrate one instance when I was telling about one of the mappings I developed. She asked me about the business logic and the purpose to develop the mapping. While I went on to explain how the logic was implemented in Informatica she asked me few questions about the transformations I used in the mapping. I had used both connected and unconnected lookup in the transformation so I was asked about their differences and also few tricky questions like can I have multiple values returned from an unconnected lookup?

I had then done a course on Snowflake so I was asked how a snowflake is different from a traditional data warehouse and what did I liked the most in it. I was asked about the SCDs and how to develop a mapping to implement an SCD type 2. While I was describing facts and dimensions one of her questions was can we have a fact table without measures?

I then moved on to depicting my experience with UNIX where I was asked some questions from AWK, Sed, and loops. I was asked to suggest an approach to remove duplicate lines using shell script and also to sort the content of a file based on the nth column value.

When I jumped to SQL she asked me about the database we use and what kind of optimization we have in the database. We use IBM DB2 for our data warehouse so she also asked me the reason for using it. Continuing with this she also asked me what kind of database suits bests for reporting activities.

So, it was all I had to face in this interview. It was a wonderful experience for me since the interviewer limited the question to my project works and experiences. Being in professional life it gets really difficult to manage time to prepare for the interview and limiting questions to only things one has worked on comes as a comport to the candidate.

I Hope, my experience will help you prepare well. Do like and share my blog to keep my motivation up too to keep writing. 


Labels:
Location: Hyderabad, Telangana, India

Comments

Post a Comment

Popular posts from this blog

KPMG Interview Experience

Hello Readers, This blog is about my interview experience with KPMG India. I have covered the intricacies of the interview process along with the questions asked. I must highlight my profile to you guys so that you get the context of the interview. I had 1 year of experience working as a web developer and had worked as an ETL developer at cognizant for 3 years. During my stint, I got to work on tools and technologies like Informatica Powercenter, Informatica B2B Dx, Informatica MFT, Splunk, Python, Shell Scripting, PHP, MongoDB, Laravel, NodeJS, and SQL.  So, let me begin. I have divided it into parts so that it gets easy to comprehend the sections separately.  The Application. I have been applying for jobs since September 2020. In the beginning, I hardly received any calls for the interview. I applied using Naukri and even got a Linkedin premium account. I must admit that most of the calls that I received later were via my applications over LinkedIn but during the initial period, I ha
8 comments
Read more

Cognizant Interview Experience

Hi all, I am back again with a new interview experience with cognizant. The interview was held on 11th March 18, at Unitech, Kolkata …. The candidates who cleared an online assessment by amcat were called for the interview. The assessment was on quantitative, verbal and non verbal questions. Also, there was a coding test of one hour that comprised of two programs. The problems were quite simple based on loops, arrays and functions. However, it must not be taken lightly because some Of the problems were quite challenging. I insists one to solve some questions from hackerank before you sit for the automata round. Let's move on to the interview experience now. My reporting time was 11:00 am and I reached there on time with all the asked documents. The amcat team was present there to assess and check the documents. I must highlight that they are very strict with the documents, so don't miss out carrying any of the document they have asked for. Each of the cand
1 comment
Read more

Technical Interview at Josh Technology

Hi, Its Suraj Jeswara, a Computer Engineer. I had my technical interview under Josh technologies on 29.03.17 conducted by Amcat at BP Poddar Institute of Management & Technology . The technical interview was basically comprised of an online and a written test . The test was far more challenging than anticipated at the beginning. The online test was comprised of quantitative aptitude, computer programming and automata . The quants portion was kinda the one we encounter in Amcat examination. Easy but time crux do exists. In automata section only 2 questions were to be done in 45. Seems pretty easy but I vouch if you are not in flow with coding you can not solve a single one. I could do a pattern problem. Question : Print the following pattern 1 3*2 4*5*6 10*9*8*7 11*12*13*14*15 For n rows… we were suppose to run and compile it against the test cases provided. The 2nd one was on linked list and unfortunetly I couldn’t dispose it on time. The computer prog
3 comments
Read more