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 Senior Consultant Interview Questions and Answers
54 Interview questions
IT General Controls (ITGC) ensure the integrity, confidentiality, and availability of data in IT systems.
Access Controls: Manage who can access systems and data. Example: Role-based access control (RBAC).
Change Management: Ensure that changes to systems are made in a controlled manner. Example: Documenting and approving changes.
Data Backup and Recovery: Protect data from loss and ensure it can be restored. Example...
Key risks and controls in experienced processes include operational, compliance, and financial risks, with tailored controls for each industry.
Operational risks: Inefficiencies in processes can lead to delays; implementing process automation can mitigate this risk.
Compliance risks: Industries like finance face strict regulations; regular audits and compliance training are essential controls.
Financial risks: Market...
Find the median of two sorted arrays efficiently using binary search.
Combine both arrays and sort them, then find the median. Example: [1, 3] and [2] -> [1, 2, 3] -> median is 2.
Use binary search to partition the arrays. This reduces time complexity to O(log(min(n, m))).
Handle edge cases where arrays are of different lengths or empty.
If total length is odd, median is the middle element; if even, it's the ave...
I faced challenges in project management, stakeholder communication, and adapting to changing client needs.
Managing tight deadlines: For instance, I had to deliver a comprehensive report within a week due to an unexpected client request.
Navigating conflicting stakeholder interests: In one project, I facilitated discussions between departments to align their goals.
Adapting to changing client needs: A client shifted...
What people are saying about Ernst & Young
Remove duplicates from an array of strings
Iterate through the array and store each element in a Set to remove duplicates
Convert the Set back to an array to get the final result
The singleton pattern restricts a class to a single instance and provides a global point of access to it.
Ensures only one instance of a class exists throughout the application.
Provides a global access point to that instance.
Commonly used in logging, configuration settings, and thread pools.
Example in Java: Using a private constructor and a static method to get the instance.
Example in Python: Using a class variable...
Ref and out are keywords in C# used for passing parameters by reference or for output parameters in methods.
ref allows a method to modify the value of a parameter passed to it.
Example: void UpdateValue(ref int number) { number = 10; }
out is similar to ref but requires the method to assign a value before returning.
Example: void GetValues(out int number) { number = 5; }
Both keywords enable methods to return multiple...
Acceptance criteria are conditions that a product must satisfy to be accepted by a user, customer, or stakeholder.
Acceptance criteria are typically defined during the planning phase of a project.
They are used to determine whether a product or feature is complete and functioning as expected.
Acceptance criteria are often written in a specific format, such as 'Given X, when Y, then Z.'
They help ensure that the produc...
To create a new market in Vietnam for LC/BG, we can start by conducting market research, building relationships with local businesses and government agencies, and offering tailored financial solutions.
Conduct market research to understand the needs and preferences of Vietnamese businesses
Build relationships with local banks, businesses, and government agencies to establish credibility and trust
Offer tailored finan...
Designing an ADF pipeline to efficiently load multiple files into a data store.
Use Azure Data Factory (ADF) to create a pipeline for file ingestion.
Utilize the Copy Data activity to load files from various sources like Blob Storage.
Implement a ForEach activity to iterate over multiple files in a directory.
Use parameters to dynamically handle file names and paths.
Consider using Data Flows for transformation during ...
Ernst & Young Senior Consultant Interview Experiences
121 interviews found
Anonymous
Selected
(2 Questions)
- Q1. Explain projects worked on and benefits
- Q2. What is agile , SDLC, user stories
- Ans.
Agile is a project management methodology focused on iterative development, SDLC is the software development life cycle, and user stories are short descriptions of a feature told from the perspective of the end user.
Agile is a project management approach that emphasizes flexibility, collaboration, and customer feedback.
SDLC is the process of planning, creating, testing, and deploying software applications.
User stories ...
(2 Questions)
- Q1. How will to create a new market in vietnam for LC/BG
- Ans.
To create a new market in Vietnam for LC/BG, we can start by conducting market research, building relationships with local businesses and government agencies, and offering tailored financial solutions.
Conduct market research to understand the needs and preferences of Vietnamese businesses
Build relationships with local banks, businesses, and government agencies to establish credibility and trust
Offer tailored financial ...
- Q2. What is acceptance criteria
- Ans.
Acceptance criteria are conditions that a product must satisfy to be accepted by a user, customer, or stakeholder.
Acceptance criteria are typically defined during the planning phase of a project.
They are used to determine whether a product or feature is complete and functioning as expected.
Acceptance criteria are often written in a specific format, such as 'Given X, when Y, then Z.'
They help ensure that the product mee...
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed in Aug 2024. There were 3 interview rounds.
(4 Questions)
- Q1. DAX Question related to Filter and Time Intelligence function
- Q2. Power BI Service features such as Gateways, RLS, Schedule Refresh
- Q3. Introduction and Current Role Project
- Q4. Power BI desktop features such as Tooltip, Drill Through filter, Bookmarks etc
(5 Questions)
- Q1. Incremental Refresh
- Q2. DAX questions related to Filter, Relationship, Table Manipulation, and Time Intelligence functions
- Q3. Power BI Services features
- Ans.
Power BI Services features include data visualization, interactive reports, dashboards, and data connectivity.
Data visualization tools like charts, graphs, and maps
Interactive reports for exploring data and gaining insights
Dashboards for monitoring key metrics and KPIs
Data connectivity to various sources like Excel, SQL databases, and cloud services
- Q4. SQL Interview Questions
- Q5. Introduction and Current Role Project
(5 Questions)
- Q1. Data Modeling Questions
- Q2. Data Warehousing Concepts such as SCD, Dimension and Fact Tables
- Q3. Scenario Question related to BI tool such as Why you would consider this tool and How is it different from other BI Tools
- Q4. Why are you leaving your last Organisation
- Ans.
Seeking new challenges and growth opportunities in a different environment.
Desire for career advancement
Looking for new challenges
Seeking a change in work environment
Opportunity to learn and grow in a different setting
- Q5. Current role in the Project and ofcourse Introduction was in the first.
Interview Preparation Tips
For Power BI - You can pick for DAX - Learnwidgiggs, and for Others - Amit Chandak, Analytics With Nag playlist are enough to crack the interviews.
Also, you can refer Reza Rad Book, Power Query Book(Ken Puls), Phillip Seamark and Marco Russo DAX book for deep understanding. (these 4 books are enough to crack any interviews)
Skills evaluated in this interview
Selected
(2 Questions)
- Q1. Sorting the array
- Q2. Remove duplicates
- Ans.
Remove duplicates from an array of strings
Iterate through the array and store each element in a Set to remove duplicates
Convert the Set back to an array to get the final result
(1 Question)
- Q1. Normal previous project related questions. Not so hard
Interview Preparation Tips
Deep Patkar
Selected
(2 Questions)
- Q1. Tell me about ur self
- Ans.
I am a dedicated and experienced Senior Consultant with a strong background in project management and client relations.
Over 10 years of experience in consulting roles
Expertise in project management and client relations
Proven track record of delivering successful projects on time and within budget
Strong communication and leadership skills
Ability to work effectively in cross-functional teams
- Q2. Why to left last company
- Ans.
Seeking new challenges and growth opportunities
Desire for career advancement
Looking for a more challenging role
Seeking new learning opportunities
Company restructuring or downsizing
Relocation to a different city
Interview Preparation Tips
Taume Taume
I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.
Next.js, 20 mins, platfomr, topics et duration
Interview Preparation Tips
Selected
I applied via Job Portal and was interviewed in Apr 2024. There were 3 interview rounds.
(1 Question)
- Q1. Questions asked on Accounts payable , accounts receivable,banking , custom developments
(1 Question)
- Q1. Questions asked on client interaction, functional knowledge on all the submodules in FI
(1 Question)
- Q1. General questions asked about my professional journey
Selected
I appeared for an interview in Dec 2024, where I was asked the following questions.
- Q1. Can you describe your past experiences, including how you faced challenges and the solutions you implemented?
- Ans.
I navigated complex projects, overcoming obstacles through strategic planning and collaboration with stakeholders.
Led a project to streamline operations, reducing processing time by 30% through process mapping and automation.
Faced a budget cut challenge; implemented cost-saving measures that maintained project quality while reducing expenses by 15%.
Collaborated with cross-functional teams to resolve a major client issu...
- Q2. Few Technical Questions on Auditing, Audit Approaches etc.
(2 Questions)
- Q1. Ask Question based on Azure
- Q2. ADF questions- design pipeline for loading multiple files
- Ans.
Designing an ADF pipeline to efficiently load multiple files into a data store.
Use Azure Data Factory (ADF) to create a pipeline for file ingestion.
Utilize the Copy Data activity to load files from various sources like Blob Storage.
Implement a ForEach activity to iterate over multiple files in a directory.
Use parameters to dynamically handle file names and paths.
Consider using Data Flows for transformation during the l...
(1 Question)
- Q1. Scenario based questions
(2 Questions)
- Q1. Query Optimization Technique
- Ans.
Query optimization techniques are used to improve the performance of database queries.
Use indexes to speed up query execution
Avoid using SELECT * and only select the necessary columns
Optimize joins by using appropriate join types like INNER JOIN, LEFT JOIN, etc.
Use WHERE clause to filter data before processing
Consider denormalizing data for frequently accessed columns
- Q2. Partition Table
I applied via Naukri.com and was interviewed in Mar 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Basic of BA. Process of BA
- Q2. Basic of product owner
(1 Question)
- Q1. Basic of product owner
Interview Preparation Tips
Ernst & Young Interview FAQs
Some of the top questions asked at the Ernst & Young Senior Consultant interview -
The duration of Ernst & Young Senior 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 Senior Associate Interview Questions
- Ernst & Young Manager Interview Questions
- Ernst & Young Technology Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 117 interview experiences
Difficulty level
Duration
Senior Consultant Interview Questions from Similar Companies
Ernst & Young Senior Consultant Reviews and Ratings
based on 1.4k reviews
Rating in categories
2-5 Yrs
₹ 5-32.4 LPA
Bangalore / Bengaluru,
Delhi/Ncr
5-10 Yrs
₹ 16-33.8 LPA
|
Senior Consultant
19.3k
salaries
|  ₹15 L/yr - ₹27 L/yr |
|
Consultant
13.1k
salaries
| ₹10 L/yr - ₹18 L/yr |
|
Manager
8k
salaries
| ₹23 L/yr - ₹40 L/yr |
|
Assistant Manager
6.8k
salaries
| ₹14.3 L/yr - ₹25.5 L/yr |
|
Associate Consultant
4.3k
salaries
| ₹5.2 L/yr - ₹12 L/yr |
Deloitte
PwC
EY Global Delivery Services ( EY GDS)
Accenture
- Home >
- Interviews >
- Ernst & Young Interview Questions
