Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by HashedIn by Deloitte Team. If you also belong to the team, you can get access from here

HashedIn by Deloitte Verified Tick

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Clear (1)

HashedIn by Deloitte Data Engineer Interview Questions and Answers

Updated 14 May 2024

HashedIn by Deloitte Data Engineer Interview Experiences

3 interviews found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 14 May 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Basics concepts of Python, SQL, Spark. Few questions to write on the notepad also.
Round 2 - Technical 

(1 Question)

  • Q1. In dept discussion on spark, scenario based questions. Questions on Data Warehouse also.

Interview Preparation Tips

Interview preparation tips for other job seekers - Go for the basic concepts first then prepare accordingly.

Data Engineer Interview Questions & Answers

user image Mohit Pradhan

posted on 7 Mar 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. How do you handle Spark Memory management
  • Ans. 

    Spark Memory management involves configuring memory allocation, monitoring memory usage, and optimizing performance.

    • Set memory allocation parameters in Spark configuration (e.g. spark.executor.memory, spark.driver.memory)

    • Monitor memory usage using Spark UI or monitoring tools like Ganglia

    • Optimize performance by tuning memory allocation based on workload and cluster resources

    • Use techniques like caching and persistence t

  • Answered by AI
  • Q2. How do you work on Spark Optimisatiomn
  • Ans. 

    Spark optimization involves tuning configurations, partitioning data, using appropriate transformations, and caching intermediate results.

    • Tune Spark configurations based on cluster resources and workload requirements

    • Partition data to distribute workload evenly across nodes

    • Use appropriate transformations like map, filter, and reduce to minimize data shuffling

    • Cache intermediate results to avoid recomputation

  • Answered by AI

Skills evaluated in this interview

Data Engineer Interview Questions Asked at Other Companies

asked in Cisco
Q1. Optimal Strategy for a Coin Game You are playing a coin game with ... read more
asked in Sigmoid
Q2. Next Greater Element Problem Statement You are given an array arr ... read more
asked in Sigmoid
Q3. Problem: Search In Rotated Sorted Array Given a sorted array that ... read more
asked in Cisco
Q4. Covid Vaccination Distribution Problem As the Government ramps up ... read more
asked in LTIMindtree
Q5. 1) If you are given a card with 1-1000 numbers and there are 4 bo ... read more

Data Engineer Interview Questions & Answers

user image Abhilash Baroor

posted on 19 Apr 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Oct 2023. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Basics pf pyhthon, spark

Interview Preparation Tips

Interview preparation tips for other job seekers - keep husltling

Interview questions from similar companies

I was interviewed in Sep 2017.

Interview Questionnaire 

4 Questions

  • Q1. Technical interview take by client technical person actually they are hiring for another client so they took total 3 technical round and final will HR round
  • Q2. Asking about life cycle of Dot net mvc contols entity frame work and SQL queries
  • Q3. Problem based on oops and SQL queries outputs
  • Q4. Basic questions about my self ,salary discussion basic formalities form I have to fill up

Interview Preparation Tips

Round: Test
Experience: There were around 15 objective question that includes mvc, c#.net and SQL server. It was very simple question like different types of filters,Acton results in mvc. Basic oops concept and dot net web page regarding

Round: Resume Shortlist
Experience: After completing test round another was technical round discussed maily for mvc and SQL server questions. Around 30 mint discussion. After qualify this round another round will start from client technical staff.

General Tips: It was for 2-3 year experience person very simple to crack but focus on you which profile you are looking for study interview questions from net
Skills: Dot net mve oops concept jQuery and SQL server

Interview Questionnaire 

2 Questions

  • Q1. What is precompilaion unit?
  • Ans. 

    Precompilation unit is a compiled code that can be reused by multiple source files.

    • Precompilation unit is created by the compiler from the source code.

    • It contains the compiled code of header files and other dependencies.

    • It can be reused by multiple source files, reducing compilation time.

    • It is also known as precompiled header or PCH.

    • Example: stdafx.h in Visual Studio is a precompiled header file.

  • Answered by AI
  • Q2. About ur future,ur short term goal,why this company

Interview Preparation Tips

Skills: Resume, CGPA
College Name: IIT Kharagpur

Interview Questionnaire 

3 Questions

  • Q1. First 50 Prime Number
  • Ans. 

    The first 50 prime numbers are...

    • Start with 2, the first prime number

    • Check each odd number greater than 2

    • Use trial division to check if a number is prime

    • Stop when you have found 50 prime numbers

  • Answered by AI
  • Q2. How to sort the file in the range (hint provided)
  • Ans. 

    Sorting a file within a range

    • Use a sorting algorithm like quicksort or mergesort

    • Read the file and store the data in an array or list

    • Sort the array or list within the given range

    • Write the sorted data back to the file

  • Answered by AI
  • Q3. Tell me about yourself
  • Ans. 

    I am a passionate software engineer with experience in developing web applications using various technologies.

    • Experienced in developing web applications using HTML, CSS, JavaScript, and frameworks like React and Angular

    • Proficient in backend development with Node.js, Express, and MongoDB

    • Familiar with version control systems like Git and project management tools like Jira

  • Answered by AI

Interview Preparation Tips

Round: Resume Shortlist
Experience: Shortlist cut was 0.0 cgpa
Tips: Need to mention Programming skill in any one of three language C , C++ ,Java

Round: Test
Experience: Test was Average, Many question were from INDIABIX.COM , computer network, operating system ,data structure, c , c++ language
Tips: Understand Data Structure and Algorithm deeply, At least read about computer networks, operating system , DBMS 3-4 times for basic good understand, refer various site
Duration: 180 minutes

Round: Test
Experience: Two question were given , we have to write the code on A4 size sheet
Tips: Deep understanding of STACK AND QUEUE
Duration: 60 minutes

Round: Technical Interview
Experience: Previous Test (2 Questions on A4 size sheet) were discussed and is there any improvement that can be done, discussed each and every step.
Tips: Comments is important using programming
present with demo example (various cases)

Round: HR Interview
Experience: Be calm and show your interest in the company,
ask question about company, what are activity other than techincal technical stuff
Tips: Smile , if possible talk in Hindi - English,Try to Make the interview in discussion

General Tips: Practice Daily , Understand Each and Every Step in Detail , Try to code in A4 size paper then computer
Skill Tips: Read Good Books , Practice Daily

Skills: Algorithms And Data Structures
College Name: IIT Kharagpur

Skills evaluated in this interview

Interview Questionnaire 

19 Questions

  • Q1. Tell me about yoruself
  • Ans. 

    I am a passionate software engineer with experience in developing web applications and a strong background in computer science.

    • Experienced in developing web applications using technologies such as HTML, CSS, JavaScript, and React

    • Strong background in computer science with knowledge in algorithms and data structures

    • Passionate about learning new technologies and solving complex problems

  • Answered by AI
  • Q2. Tell me about your projects
  • Ans. 

    I have worked on various projects including a web application for inventory management and a mobile app for fitness tracking.

    • Developed a web application using React for inventory management

    • Created a mobile app using Flutter for fitness tracking

    • Implemented RESTful APIs for communication between frontend and backend systems

  • Answered by AI
  • Q3. Area of interest
  • Ans. 

    My area of interest is artificial intelligence and machine learning.

    • I have experience in developing machine learning models for predictive analytics.

    • I am interested in natural language processing and computer vision applications.

    • I enjoy exploring deep learning algorithms and neural networks.

    • I have worked on projects involving recommendation systems and image recognition.

  • Answered by AI
  • Q4. What are features of C++?
  • Ans. 

    C++ is a high-level programming language with features like object-oriented programming, templates, and memory management.

    • C++ supports object-oriented programming concepts like encapsulation, inheritance, and polymorphism.

    • Templates allow generic programming and code reusability.

    • C++ provides low-level memory manipulation through pointers.

    • Standard Template Library (STL) provides a collection of classes and functions for ...

  • Answered by AI
  • Q5. What is Big Data?
  • Ans. 

    Big Data refers to large and complex data sets that cannot be processed using traditional data processing methods.

    • Big Data is characterized by the 3Vs - Volume, Velocity, and Variety.

    • It requires specialized tools and technologies such as Hadoop, Spark, and NoSQL databases.

    • Examples of Big Data include social media data, sensor data, and financial market data.

  • Answered by AI
  • Q6. Write a program for reversing a string without using string function
  • Ans. 

    Program to reverse a string without using string function

    • Iterate through the string from end to start and append each character to a new string

    • Use a loop to swap the first and last characters, then move towards the middle until the entire string is reversed

    • Convert the string to a character array, then swap the first and last elements until the entire array is reversed

  • Answered by AI
  • Q7. What is your role in final year project?
  • Ans. 

    I was responsible for designing and implementing the project's database and backend functionality.

    • Designed the database schema and created the necessary tables

    • Implemented the backend functionality using Java and Spring framework

    • Collaborated with team members to integrate the frontend and backend components

    • Tested the application and fixed any bugs or issues that arose

    • Presented the project to the faculty and received pos

  • Answered by AI
  • Q8. What are keys in database and why do we use them?
  • Ans. 

    Keys in a database are unique identifiers used to establish relationships between tables and ensure data integrity.

    • Keys are used to uniquely identify records in a database table.

    • Primary keys are used to uniquely identify each record in a table.

    • Foreign keys establish relationships between tables.

    • Keys help enforce data integrity and maintain consistency in the database.

    • Examples of keys include primary keys, foreign keys,

  • Answered by AI
  • Q9. What are issues in cloud?
  • Ans. 

    Issues in cloud include security, downtime, vendor lock-in, and data privacy.

    • Security concerns such as data breaches and unauthorized access

    • Downtime and service interruptions affecting business operations

    • Vendor lock-in and limited flexibility in choosing cloud providers

    • Data privacy and compliance with regulations such as GDPR and HIPAA

  • Answered by AI
  • Q10. Brief introduction of your project and algorithms used in project
  • Ans. 

    Developed a web application for online shopping using React and Node.js

    • Implemented user authentication and authorization using JSON Web Tokens (JWT)

    • Used MongoDB as the database to store user and product information

    • Implemented a search feature using Elasticsearch to provide fast and accurate search results

    • Integrated Stripe payment gateway for secure online transactions

  • Answered by AI
  • Q11. Flow diagram of final year project
  • Ans. 

    The flow diagram of my final year project showcases the step-by-step process of its execution.

    • The flow diagram illustrates the sequence of activities and their dependencies.

    • It helps in understanding the overall structure and logic of the project.

    • Each step in the diagram represents a specific task or action.

    • Arrows indicate the flow of control or data between different steps.

    • Decision points are represented by diamond-sha...

  • Answered by AI
  • Q12. Why do we normalise our database?
  • Ans. 

    Normalisation reduces data redundancy and improves data integrity in a database.

    • Prevents data duplication and inconsistencies

    • Simplifies database maintenance and updates

    • Improves query performance

    • Enforces data integrity and consistency

    • Follows best practices for database design

    • Examples: breaking down a customer table into separate tables for orders, addresses, and payments

    • Examples: creating a separate table for product ca...

  • Answered by AI
  • Q13. Tell me about yourself
  • Ans. 

    I am a passionate software engineer with experience in developing web applications and a strong background in computer science.

    • Experienced in developing web applications using technologies like HTML, CSS, JavaScript, and React

    • Strong background in computer science with knowledge of algorithms and data structures

    • Familiar with agile development methodologies and version control systems like Git

  • Answered by AI
  • Q14. Tell me your 5 qualities so that i should hire you
  • Ans. 

    I am a problem solver, team player, quick learner, detail-oriented, and have strong communication skills.

    • Problem solver - I enjoy tackling complex problems and finding innovative solutions.

    • Team player - I work well with others and value collaboration in achieving goals.

    • Quick learner - I am able to pick up new technologies and concepts quickly.

    • Detail-oriented - I pay attention to the smallest details to ensure high-qual...

  • Answered by AI
  • Q15. Do you have any engineering background
  • Ans. 

    Yes, I have a Bachelor's degree in Computer Engineering.

    • Bachelor's degree in Computer Engineering

    • Experience in software development

    • Knowledge of engineering principles applied to software design

  • Answered by AI
  • Q16. How was your day?
  • Ans. 

    My day was productive and challenging, with a lot of problem-solving and collaboration.

    • Completed a major coding project ahead of schedule

    • Participated in a brainstorming session with team members

    • Solved a tricky bug in the codebase

    • Attended a virtual meeting with stakeholders

  • Answered by AI
  • Q17. Do you have relatives in Pune? or what about your accomodation?
  • Ans. 

    No, I do not have any relatives in Pune. I have arranged for my accommodation in a rented apartment near the office.

    • No relatives in Pune

    • Accommodation arranged in a rented apartment near the office

  • Answered by AI
  • Q18. Do you know about My Passion Challenge test?
  • Ans. 

    Yes, My Passion Challenge test is a coding competition for software engineers.

    • My Passion Challenge test is a coding competition that evaluates the coding skills of software engineers.

    • It is designed to test problem-solving abilities, algorithmic thinking, and coding proficiency.

    • Participants are given a set of coding challenges to solve within a specified time limit.

    • The challenges can range from simple to complex, coveri...

  • Answered by AI
  • Q19. Any higher studies plan?
  • Ans. 

    Considering pursuing a Master's degree in Computer Science to deepen knowledge and advance career.

    • Considering pursuing a Master's degree in Computer Science

    • To deepen knowledge and advance career

    • Examples: MS in Computer Science at XYZ University, online courses in AI and Machine Learning

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: In this section, you will find questions from all technical subjects like data structures,design and analysis of algorithms, software testing and quality assurance , computer networks, database management , C , C++ , C# and java. The difficulty level is moderate.
For this section you can study from indiabix.com
In the 2nd section, we have to write a program and also have to follow constraints mentioned in the problem statement. Programs are based on file handling, structure and union , string operations,etc.
In 3rd round, you have to write an essay of about 10 lines. Essay topics are general issues like I had 'Traffic issues in India'.
Tips: Stick to your basics.
All the concepts should be clear.
Programs should be syntactically correct. Try to mention comments and also display output as expected. It adds up to your representation even if your logic goes wrong. :)
For essay writing round, there should be no grammatical mistakes.
Time management is very important.

Duration: 90 minutes
Total Questions: 75

Round: Technical Interview
Experience: My first technical round really went well. So I was qualified for Hr round.
But some candidates had to appear for 2 technical interviews.

Tips: Stay confident about your answers and also mention area of interest in your resume and go through your resume before going to interview. 60% of technical interview is on projects. They are really interested in ideas used in your projects. Explain all the projects in detail like which front end and back end used.
Every round is an elimination round. So give your best and stay confident.


Round: HR Interview
Experience: Hr round is also elimination round. And you should have good communication skills.
There is always backfiring so you have to be attentive and confident.
Always try to reply in a positive way.
Tips: You should read about the history of company and also the domains on which they are working and their recent projects.

Skills: Verbal Communication Skills
College Name: Jawaharlal Nehru Engineering College

Skills evaluated in this interview

Interview Preparation Tips

Round: Test
Experience: An objective type written test. Around 60 questions in 1 hr which included around 10 aptitude questions and others from C, Datastructure, Operating System, Computer Network, Software Engineering, Database etc

Round: Technical Interview
Experience: Questions were mainly from Datastructure, Operating System and Database. I was asked to reverse a linked list using a stack and write some sql queries which included use of JOIN.

Round: HR Interview
Experience: At each stage, we get to know if we are still in the selection process of have been eliminated.They were looking for right logic rather than perfect syntax.

College Name: NA

Interview Preparation Tips

College Name: Vidyalankar Institute Of Technology

Interview Questionnaire 

11 Questions

  • Q1. Hobbies: Drawing. Asked about drawing and pencil shading. Draw in next 5 mins something great to impress me else rejected
  • Q2. Sketch my face
  • Q3. If you are told to do a job of a peon for the company will you?
  • Q4. Remove all the pcs from the lab and keep in other lab RIGHT NOW?
  • Ans. 

    Yes, I can remove all the pcs from the lab and keep them in another lab right now.

    • Ensure all the necessary equipment and tools are available for the move

    • Coordinate with the lab staff to ensure a smooth transition

    • Label and document each PC for easy identification and setup in the new lab

    • Ensure proper packaging and handling to prevent any damage during the move

  • Answered by AI
  • Q5. Impress me with your talents
  • Q6. If a person asks you on a construction site to pick up bricks will you?
  • Q7. How crazy are you?
  • Q8. Show me how crazy are you in next 5 mins?
  • Q9. Write down Fibonacci series and also explain pseudo code for it?
  • Ans. 

    Fibonacci series is a sequence of numbers where each number is the sum of the two preceding ones.

    • The first two numbers of the series are always 0 and 1

    • The next number is the sum of the previous two numbers

    • The series goes on infinitely: 0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89, 144, ...

    • Pseudo code: 1. Initialize variables a=0, b=1, c=0 2. Print a and b 3. Repeat steps 4-6 until desired number of terms 4. c=a+b 5. Pr

  • Answered by AI
  • Q10. Write algorithm for matrix multiplication?
  • Ans. 

    Algorithm for matrix multiplication

    • Create a result matrix with dimensions of the two input matrices

    • Iterate through each row and column of the result matrix

    • For each element in the result matrix, multiply corresponding row in first matrix with corresponding column in second matrix

    • Add the products obtained in the previous step to get the final value for the element

  • Answered by AI
  • Q11. Explain your project and which algorithm you used in it. Why that algorithm?
  • Ans. 

    I worked on a project that involved sentiment analysis of customer reviews using Naive Bayes algorithm.

    • The project involved collecting customer reviews from various sources.

    • Preprocessing the data by removing stop words, stemming, and tokenizing.

    • Used Naive Bayes algorithm for sentiment analysis.

    • The algorithm was chosen because of its simplicity and effectiveness in text classification tasks.

    • The accuracy of the model was

  • Answered by AI

Interview Preparation Tips

Round: HR Interview
Experience: Confused

If they say do you have any questions?
NEVER ASK about your performance in that round.

Round: Technical Interview
Experience: Good
Tips: Interview depends on your basic knowledge

Skills: Presence Of Mind, Technical Skills, Analytical Skills
College Name: Vidyalankar Institute Of Technology
Motivation: Got rejected for TCS aptitude.
Funny Moments: Whole HR interview

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

HashedIn by Deloitte Interview FAQs

How many rounds are there in HashedIn by Deloitte Data Engineer interview?
HashedIn by Deloitte interview process usually has 1-2 rounds. The most common rounds in the HashedIn by Deloitte interview process are Technical and One-on-one Round.
How to prepare for HashedIn by Deloitte Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at HashedIn by Deloitte. The most common topics and skills that interviewers at HashedIn by Deloitte expect are AWS, Big Data, HBase, Hadoop and Hive.
What are the top questions asked in HashedIn by Deloitte Data Engineer interview?

Some of the top questions asked at the HashedIn by Deloitte Data Engineer interview -

  1. How do you handle Spark Memory managem...read more
  2. How do you work on Spark Optimisati...read more
  3. Basics concepts of Python, SQL, Spark. Few questions to write on the notepad al...read more

Recently Viewed

INTERVIEWS

Trianz

No Interviews

INTERVIEWS

Magna International

No Interviews

SALARIES

HashedIn by Deloitte

INTERVIEWS

Magna International

No Interviews

INTERVIEWS

Magna International

20 top interview questions

INTERVIEWS

HashedIn by Deloitte

No Interviews

INTERVIEWS

Trianz

No Interviews

INTERVIEWS

Trianz

No Interviews

INTERVIEWS

99Games

No Interviews

INTERVIEWS

Trianz

No Interviews

Tell us how to improve this page.

HashedIn by Deloitte Data Engineer Interview Process

based on 3 interviews

Interview experience

4
  
Good
View more
HashedIn by Deloitte Data Engineer Salary
based on 36 salaries
₹8 L/yr - ₹19.1 L/yr
14% more than the average Data Engineer Salary in India
View more details

HashedIn by Deloitte Data Engineer Reviews and Ratings

based on 3 reviews

4.4/5

Rating in categories

4.4

Skill development

4.4

Work-life balance

4.2

Salary

4.4

Job security

4.4

Company culture

3.9

Promotions

4.4

Work satisfaction

Explore 3 Reviews and Ratings
Software Engineer
412 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer2
376 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
206 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer II
173 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Product Specialist
165 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare HashedIn by Deloitte with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview