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 per...
8 comments
Read more

Interview at Servian

 Hi All, I am back again with another wonderful blog sharing my experience about my interview at one of the very promising Australia Based Company, Servian. I happen to know about it from linkedin. After a good deal of research and seeing reviews from Glassdoor I finally applied for it.  the JD was for ETL Developer. At the very begining I received a call from their HR who was based on Bangalore. He asked me about my current job role and my relocation preference. They have been hiring for just Banagalore location so my saying that "I don't have any specific location preference did help!". I was asked about my current and expected CTC and then followed a question to justify such a hike :p Machine Round I was finally considered for a machine round and the interview was supposed to be scheduled once I clear this round. There were 15 Questions and the allocated time was 1 hour. The difficulty was not much. Question based on joins, aggregator and group by were there. I felt th...
Post a Comment
Read more

Starting with Amazon Athena

Hi All! Its long since I have offered my readers something  technical to go through. The wait is over and its really worth it. We will dive into  cloud  today. I will be explaining you in details how can you use one of the popular service of AWS known as  Athena . The blog is written keeping in mind that you have little or no idea about any AWS service. Albeit, a tad bit of knowledge on  S3  service will help you to understand the blog better. Lets take an use case before proceeding ahead. Suppose we have a csv file that contains some data into it. lets say it has details of Employees in a company. I have another csv file that contains details of the department of a company. Now, I wish to do some operations that needs data from the employee file and department file to be joined. e.g to get max salary of employee in every department etc. If we had the same data in 2 tables in a database, things had been simple. right? We could have just joined both ...
Post a Comment
Read more