Ernst & Young Analyst Interview Questions, Process, and Tips for Experienced

The first round consisted of aptitude test, encompassing logical reasoning, aptitude assessment, verbal ability, and technical questions.

The second round comprised straightforward coding questions.

The group discussion centered around self-introductions.

Q1. This round involved asking a few basic HR questions. Why should we hire you?
Add your answer
Q2. Why is working at EY important to you?
Add your answer

Q1. Explain the Architecture of Spark
Ans. 
Spark has a master-slave architecture with a cluster manager and worker nodes.
• Spark has a driver program that communicates with a cluster manager to allocate resources and schedule tasks.

• Worker nodes execute tasks and return results to the driver program.

• Spark supports multiple cluster managers like YARN, Mesos, and standalone.

• Spark also has a DAG (Directed Acyclic Graph) scheduler that optimizes task execution.

• Spark's...read more
Answered by AI
Add your answer
Q2. Write the pyspark query to find sum and avg using spark dataframes
Ans. 
The PySpark query to find the sum and average using Spark DataFrames.
• Use the `groupBy` method to group the data by a specific column

• Use the `agg` method to apply aggregate functions like `sum` and `avg`

• Specify the column(s) to perform the aggregation on
Answered by AI
Add your answer
Q3. Join 3 tables using SQL
Ans. 
Joining three tables using SQL
• Use the JOIN keyword to combine the tables based on a common column

• Specify the columns to select from each table

• Use the ON keyword to define the join condition
Answered by AI
Add your answer
Q4. Basic questions on Public cloud - Azure, AWS, GCP
Add your answer

Q1. Difference between GroupBy and Having and when to use
Ans. 
GroupBy is used to group data based on a column while Having is used to filter grouped data based on a condition.
• GroupBy is used with aggregate functions like SUM, COUNT, AVG, etc.

• Having is used to filter data after grouping based on a condition.

• GroupBy is used before Having in a SQL query.

• Example: SELECT department, COUNT(*) FROM employees GROUP BY department HAVING COUNT(*) > 5;

• Example: SELECT department, AVG(salary)...read more
Answered by AI
Add your answer
Q2. How to filter data according to particular condition in PySpark
Ans. 
Filtering data in PySpark based on a particular condition.
• Use the filter() function to filter data based on a condition.

• Conditions can be specified using logical operators such as ==, >, <, etc.

• Multiple conditions can be combined using logical operators such as and, or, not.

• Example: df.filter(df['age'] > 25).filter(df['gender'] == 'Male')

• This will filter the data where age is greater than 25 and gender is Male.
Answered by AI
Add your answer
Q3. Add/ remove/ columns in spark dataframes
Ans. 
Columns can be added or removed from Spark dataframes using select() and drop() functions.
• To add a column, use withColumn() function and provide a name and expression for the new column.

• To remove a column, use drop() function and provide the name of the column to be removed.

• To select specific columns, use select() function and provide the names of the columns to be selected.

• Example: df.withColumn('new_col', df.col1 + d
Answered by AI
Add your answer
Q4. Few basic conceptual questions on BigData
Add your answer

Q1. Why you want to join EY
Ans. 
I want to join EY because of its reputation for excellence, global presence, and opportunities for professional growth.
• EY is known for its high standards of excellence in the industry.

• EY has a strong global presence, which provides opportunities to work with diverse clients and gain international exposure.

• EY offers a wide range of services and sectors, allowing for professional growth and development.

• EY's collaborative...read more
Answered by AI
Add your answer
Q2. What is your expectations from ey
Ans. 
I expect EY to provide a challenging and rewarding work environment with opportunities for growth and development.
• Opportunities for professional growth

• Challenging work assignments

• Supportive and collaborative team

• Clear communication and feedback

• Recognition for achievements

• Work-life balance

• Competitive compensation and benefits
Answered by AI
View 1 more answer
Q3. Salary negotiation and location preference
Add your answer

Logical Reasoning, Accounting & Finance

Q1. How to calculate market share of a company in the industry
Ans. 
Market share can be calculated by dividing a company's sales revenue by the total sales revenue of the industry.
• Determine the company's total sales revenue for a specific period

• Determine the total sales revenue of the industry for the same period

• Divide the company's sales revenue by the industry's total sales revenue and multiply by 100 to get the market share percentage

• For example, if Company A has sales revenue of $1...read more
Answered by AI
Add your answer
Q2. Tell me about your education background
Add your answer

Q1. When would you be available to join
Add your answer

Forgot the round completed this before 1 year ago

Q1. I don't remember
Add your answer
Q2. I don't remember.
Add your answer
Q3. I did not remember
Add your answer

Q1. Basic last job questions
Add your answer
Q2. Financial aspects and law related
Add your answer

Q1. Cash and bank, trade receivable and payable
Add your answer

Q1. Why should we hire you?
Add your answer
Q2. Why are you looking for a change?
Add your answer
Q3. Where do you see yourself in 5 years?
Add your answer
Q4. What are your strengths and weaknesses?
Add your answer
Q5. Tell me about yourself.
Add your answer

Q1. About my qualifications, Job location preferences etc.
Add your answer

Q1. What do you know about this job role, Profile and Career opportunity in this domain
Ans. 
An analyst is responsible for gathering and analyzing data to provide insights and recommendations for decision-making.
• Analysts collect and organize data from various sources.

• They use statistical techniques and software to analyze data and identify trends.

• Analysts interpret the results and present findings to stakeholders.

• They provide insights and recommendations to support decision-making processes.

• Career opportunitie...read more
Answered by AI
Add your answer