Ernst & Young Data Engineer Interview Questions and Answers for Freshers

Round 1 was online Test where one basic coding question was there and few aptitiude , verbal ability and python based question.

• Q1. What is Data WareHouse..?
  View Answers (1)
• Q2. Nested Queries in Bigquery..?
  View Answers (1)

• Q1. SQL ,Python,pyspark,ETL
  Add Answer

The test was conducted on AMCAT by SHL. The questions were pretty moderate

• Q1. I was asked SQL and about my project on data science. The interview was not much difficult
  Add Answer
• Q2. I was also asked a riddle. 9 coins with 1 coin having different weight - find odd one out
  Add Answer

• Q1. Was asked DBMS and about my project
  Add Answer

Asked questions on Datastructure manipulation

• Q1. Asked questions on Python,Spark and AWS
  Add Answer

• Q1. Salary negotiation
  Add Answer

Easy to crack, case study

• Q1. SQL queries were asked
  Add Answer

This aptitude + technical MCQ test was of 120 minutes in duration. Had MCQs on quantitative ability, logical ability, Language, and technical MCQs consisted of questions on DBMS, OS, Networks, DSA. There were two coding questions as well. One on Bit Manipulating, and the other on DFS.

• Q1. A question on BFS very similar to Leetcode 924. Was given one hour to discuss and come to an optimized solution with the interviewer.
  Add Answer

• Q1. Search an element in a sorted and rotated array
  View Answers (1)
• Q2. SQL query on left join
  Add Answer
• Q3. Questions on CPP memory management
  Add Answer
• Q4. Questions related to projects done
  Add Answer

• Q1. Propose a system for a popular media stream service
  View Answers (1)
• Q2. Questions related to Fullstack Tech Stacks
  Add Answer

Guesstimate on number of Reddit users in India. No starting input was given. Gave solution by using bottom to top approach. Tried to focus on quantifying teenagers with internet access and a particular interest about internet. Gave a figure around ~1 million in a year.

• Q1. Where do you see yourself at McKinsey?
  Add Answer

Aptitude have some basic questions that many of us can solve easily not that much difficult.

• Q1. Nothing much just simple questions about normal calculations, your Introduction, Be Frank keep smile and be confident.
  Add Answer
• Q2. They also checked your communication skills, grammar skills or some times they assign you to write formal letter or e-mails which could be pretty difficult some...read more
  Add Answer

• Q1. Project related discussions
  Add Answer
• Q2. Meduim level SQl and DSA
  Add Answer

• Q1. This was data modelling round
  Add Answer
• Q2. Design a uber data model
  View Answers (1)