Ernst & Young Analyst Interview Questions, Process, and Tips

Q1. Tell me about your Projects
Add your answer
Q2. What is goal in future
Ans. 
My goal in the future is to advance my career in data analysis and eventually become a senior analyst in a reputable company.
• Continue improving my data analysis skills through courses and certifications

• Seek opportunities for mentorship and networking in the industry

• Work on real-world projects to gain practical experience

• Set specific career milestones and track progress towards them
Answered by AI
Add your answer

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

Aptitude test was of 45 mins contains questions from basic maths, english, some accounting as well

Q1. Tell me about yourself
Add your answer
Q2. As I was a fresher, so asked about my internship experience
Add your answer
Q3. Then a few cross questions, basis my answer
Add your answer
Q4. Why Ersnt &Young?
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

It consists of the Quant, LRDI, Verbal reasoning & Email Writing.

Effect of Social Media and Internet in our Daily Life

Q1. Gone through my resume and ask the stuff from my resume itself, including my projects, certificates etc.
Add your answer

Q1. Do you know about EY? What is EY? How you can aligned yourself with EY
Add your answer

Q1. Basic of SQL, DBMS, Puzzle and project
Add your answer

Q1. Intro,project and some behavioral questions
Add your answer