AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Ernst & Young
Compare
Filter interviews by
Ernst & Young Consultant Interview Questions, Process, and Tips
Top Ernst & Young Consultant Interview Questions and Answers
- Q1. list tuple difference Dictionary and list comprehension Decorators with example Sequencial non sequencial data types Pandas Create dataframe from dictionary Fillna, Merge ...read more
- Q2. Expalin what is supply chain management?
- Q3. What are the top risks faced by an IT company at enterprise level?
Ernst & Young Consultant Interview Experiences
134 interviews found
Anonymous
I applied via Naukri.com and was interviewed in Sep 2023. There were 3 interview rounds.
(2 Questions)
- Q1. Convert the table rows into columns
- Ans.
To convert table rows into columns, transpose the data by switching rows and columns.
Identify the unique values in the original table that will become the new columns
Create a new table with these unique values as columns and fill in the corresponding data from the original table
Transpose the data by switching rows and columns
- Q2. Difference between truncate and delete
- Ans.
Truncate is a DDL command that removes all rows from a table, while delete is a DML command that removes specific rows.
Truncate is faster than delete as it does not log individual row deletions.
Truncate resets identity column values, while delete does not.
Truncate cannot be rolled back, while delete can be rolled back using a transaction.
Truncate does not fire triggers, while delete does.
Truncate is a table-level opera
(1 Question)
- Q1. For unconnected lookup how can we obtain more than 1 return value
- Ans.
Use a connected lookup to obtain more than 1 return value in an unconnected lookup
Use a connected lookup transformation to retrieve multiple values based on a common key
Join the output of the connected lookup with the main pipeline using a joiner transformation
Configure the connected lookup to return multiple rows for a single input key
Interview Preparation Tips
Skills evaluated in this interview
(2 Questions)
- Q1. Why do you want this role
- Q2. Why do you want to work with EY
Interview Preparation Tips
(2 Questions)
- Q1. Something about yourself
- Q2. Current profile
What people are saying about Ernst & Young
Selected
I applied via Referral and was interviewed in Jul 2023. There were 3 interview rounds.
(3 Questions)
- Q1. Practical questions on SQL window functions
- Q2. Types of joins and use case questions with different types of joins
- Q3. Difference between where and having
- Ans.
WHERE is used to filter rows before grouping, HAVING is used to filter groups after grouping.
WHERE is used with SELECT, UPDATE, DELETE statements to filter rows based on a condition
HAVING is used with GROUP BY clause to filter groups based on a condition
WHERE is applied before data is grouped, HAVING is applied after data is grouped
Example: SELECT * FROM table WHERE column = value;
Example: SELECT column, COUNT(*) FROM
(3 Questions)
- Q1. Deduplicate table with duplicate rows using window functions
- Ans.
Use window functions to deduplicate table with duplicate rows
Use the ROW_NUMBER() window function to assign a unique row number to each row
Partition by the columns that you want to deduplicate on
Filter out rows where the row number is greater than 1 to keep only unique rows
- Q2. Order of execution of SQL statements in a query
- Ans.
SQL statements in a query are executed in a specific order to ensure accurate results.
SQL statements are executed in the following order: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
The FROM clause retrieves data from tables, WHERE filters the data, GROUP BY groups the data, HAVING filters groups, SELECT retrieves specific columns, and ORDER BY sorts the results.
For example, in the query SELECT * FROM employees WHE...
- Q3. String manipulation functions like substr, length, replace
Interview Preparation Tips
- SQL
- Supply Chain Management
Skills evaluated in this interview
Ernst & Young interview questions for designations
Selected
I applied via Recruitment Consulltant and was interviewed in Nov 2023. There were 2 interview rounds.
(1 Question)
- Q1. Explain existing role
(1 Question)
- Q1. Challenges in existing role
Get interview-ready with Top Ernst & Young Interview Questions
(2 Questions)
- Q1. Types of servers?
- Ans.
Types of servers include web servers, email servers, file servers, and database servers.
Web servers - serve web pages and content over the internet (e.g. Apache, Nginx)
Email servers - handle email communication (e.g. Microsoft Exchange, Postfix)
File servers - store and manage files for network users (e.g. Windows File Server, Samba)
Database servers - manage databases and allow access to data (e.g. MySQL, Oracle)
- Q2. Have you worked on IOT devices?
- Ans.
Yes, I have worked on IOT devices in previous projects.
Developed software for IOT devices to collect and analyze data
Implemented security measures to protect IOT devices from cyber attacks
Integrated IOT devices with cloud platforms for remote monitoring and control
Skills evaluated in this interview
Consultant Jobs at Ernst & Young
Aneeta Rose TR
Numerical ability was there with reasoning ,logical
2coding questions where any coding language can be used
Selected
I applied via Referral and was interviewed in Jul 2023. There were 4 interview rounds.
(1 Question)
- Q1. Taxation amendments New scheme for companies Equalization levy Tds 194R Resume based questions Tax rates Appeals
(1 Question)
- Q1. JDA Appeals Amendments TDS Why Ey
- Ans.
JDA, Appeals, Amendments, TDS are all related to tax consulting. Ey is a leading consulting firm in the field.
JDA stands for Joint Development Agreement, a legal contract between two or more parties to develop a property.
Appeals refer to the process of challenging a decision made by a government authority, such as a tax assessment.
Amendments are changes made to a legal document or contract, often to correct errors or u...
(1 Question)
- Q1. Resume based Why EY JDA Articleship experience
(1 Question)
- Q1. Resume based Why EY
Selected
I applied via LinkedIn and was interviewed before Jul 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Question about self was asked
- Q2. Scenario questions based on your role
(2 Questions)
- Q1. Detailed questions about tools and technology used
- Q2. Functions used in tools were asked
Vinay Jain
(1 Question)
- Q1. TECHNICAL QUESTIONS BASED ON IT ACT
Ernst & Young Interview FAQs
The duration of Ernst & Young Consultant interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Ernst & Young Interviews By Designations
- Ernst & Young Consultant Interview Questions
- Ernst & Young Senior Consultant Interview Questions
- Ernst & Young Analyst Interview Questions
- Ernst & Young Associate Consultant Interview Questions
- Ernst & Young Tax Analyst Interview Questions
- Ernst & Young Manager Interview Questions
- Ernst & Young Technology Consultant Interview Questions
- Ernst & Young Senior Associate Interview Questions
- Show more
Interview Questions for Popular Designations
- Associate Consultant Interview Questions
- Senior Consultant Interview Questions
- Lead Consultant Interview Questions
- Senior Associate Consultant Interview Questions
- Technical Consultant Interview Questions
- SAP Abap Consultant Interview Questions
- AST Consultant Interview Questions
- SAP Fico Consultant Interview Questions
- Show more
Ernst & Young Consultant Interview Process
based on 115 interviews
5 Interview rounds
- Technical Round - 1
- Technical Round - 2
- One-on-one Round
- HR Round - 1
- HR Round - 2
Top Skills for Ernst & Young Consultant
Consultant Interview Questions from Similar Companies
Fast track your campus placements
Ernst & Young Consultant Reviews and Ratings
based on 1k reviews
Rating in categories
|
Senior Consultant
15.8k
salaries
|  ₹9 L/yr - ₹33.8 L/yr |
|
Consultant
12k
salaries
| ₹6.5 L/yr - ₹20.3 L/yr |
|
Manager
7.6k
salaries
| ₹12 L/yr - ₹51.2 L/yr |
|
Assistant Manager
6.4k
salaries
| ₹9.5 L/yr - ₹28.9 L/yr |
|
Associate Consultant
3.9k
salaries
| ₹3.3 L/yr - ₹12 L/yr |
Deloitte
PwC
EY Global Delivery Services ( EY GDS)
Accenture
- Home >
- Interviews >
- Ernst & Young Interview Questions >
- Ernst & Young Consultant Interview Questions
