Ernst & Young Technology Consultant Interview Questions and Answers

Q1. Past Experience and work I performed in the Data Analytic team
Ans. 
I have 3 years of experience working in the Data Analytic team where I analyzed large datasets to provide insights and recommendations.
• Performed data cleaning and preprocessing tasks to ensure data accuracy

• Utilized statistical analysis and machine learning techniques to extract valuable information

• Created data visualizations and reports to communicate findings to stakeholders
Answered by AI
Add your answer
Q2. Power BI- DAX functions, Refresh Rates, Cardinality, Uses of several graphs, KPIs, Reporting
Add your answer
Q3. SQL- Uses of several functions, intermediate logics asked, Eg- Finding 2nd highest salary, function of RankX, Window functions
Add your answer
Q4. Data Cleansing and ways to analyse data
Ans. 
Data cleansing involves identifying and correcting errors in data to improve its quality. Ways to analyze data include using statistical methods, data visualization, and machine learning algorithms.
• Identify and remove duplicate records

• Standardize data formats and values

• Fill in missing values using imputation techniques

• Use data profiling to understand data quality issues

• Apply data validation rules to ensure accuracy

• Util...read more
Answered by AI
Add your answer

Q1. Raw data was provided and a proper PBI report was asked to be designed.
Add your answer

Q1. Expected Salary and why you find yourself fitting for the role?
Add your answer
Q2. Working in a Big4 can be overwhelming at times, how would you deal with it as you have already worked for one.
Ans. 
I would deal with the overwhelming nature of working in a Big4 by prioritizing tasks, seeking support from colleagues, and practicing self-care.
• Prioritize tasks based on deadlines and importance to avoid feeling overwhelmed

• Seek support from colleagues or mentors to discuss challenges and brainstorm solutions

• Practice self-care activities such as exercise, meditation, or hobbies to manage stress and maintain work-life ba...read more
Answered by AI
Add your answer

Basic aptitude and coding

Q1. What is denormalization and explanation of projects
Ans. 
Denormalization is the process of adding redundant data to a database to improve read performance.
• Denormalization involves duplicating data from normalized tables into a single denormalized table.

• It can improve query performance by reducing the need for joins and aggregations.

• Denormalization is often used in data warehousing and reporting applications.

• Examples of denormalization include creating summary tables or addin...read more
Answered by AI
Add your answer

Q1. Introduction, why ey
Add your answer

Q1. Mcqs based on oops, coding
Add your answer

Q1. Normal technicall question on c++
Add your answer

Q1. Tell about yourself, why would you like to join e&y
Add your answer

Aptitude Test was fairly moderate. There were questions which are quite easy and there were 4/5 question which were tricky and those decided the cutoff.

Two questions were asked. One was string manipulation and another was dynamic programming. Nothing too crazy, the questions were solvable.

In my Group Discussion Round, our group asked to introduce ourselves. The selection happened based on how well you can introduce yourself. They were looking for professional background, personal and social background.

Q1. I was asked questions based on my projects that i have done and was asked to explain those. and there were questions on case study. My interviewer was very friendly, hew keenly listening to what i was sayi...read more
Add your answer