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

Q1. What is your experience with Angular, and how does it work? What are pipes and components in Angular?
Ans. 
I have 3 years of experience with Angular. Pipes are used for data transformation and components are building blocks of Angular applications.
• I have worked on Angular projects for 3 years, developing and testing various features.

• Pipes in Angular are used for transforming data before displaying it in the UI. For example, date pipe formats dates in a specific way.

• Components in Angular are reusable building blocks that enc...read more
Answered by AI
Add your answer
Q2. Can you replicate the screen in Angular that is currently visible on your display?
Ans. 
Yes, I can replicate the screen in Angular that is currently visible on my display.
• Use Angular's component structure to recreate the screen

• Identify the HTML elements and CSS styles used on the screen

• Fetch data from APIs if needed to populate the screen

• Ensure functionality like buttons, forms, and interactions are replicated accurately
Answered by AI
Add your answer

Multiple questions regarding data structures.

Q1. Show architecture of multiple microservice in MS Paint..
Ans. 
Architecture of multiple microservices in MS Paint
• Draw separate boxes for each microservice

• Connect the boxes with lines to show communication

• Label each box with the name of the microservice

• Include any databases or external services used by the microservices
Answered by AI
Add your answer
Q2. Why we use dependency injection, draw it inms paint...,first told me give real life example and when I gave the answer he cut me off again..
Add your answer

Q1. Write the sql query for 2nd highest salary .
Ans. 
Retrieve the second highest salary from a salary table using SQL.
• Use the 'DISTINCT' keyword to avoid duplicate salaries.

• Utilize 'ORDER BY' to sort salaries in descending order.

• Use 'LIMIT' or 'OFFSET' to fetch the second record.

• Example SQL: 'SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 1;'
Answered by AI
Add your answer
Q2. How we can optimize sql query
Ans. 
Optimizing SQL queries improves performance and reduces resource consumption, leading to faster data retrieval.
• Use indexes: Create indexes on columns frequently used in WHERE clauses. Example: CREATE INDEX idx_name ON table_name(column_name);

• Avoid SELECT *: Specify only the columns you need. Example: SELECT column1, column2 FROM table_name;

• Use WHERE clauses: Filter data as early as possible. Example: SELECT column1 FRO...read more
Answered by AI
Add your answer
Q3. Difference between slicer and filter
Ans. 
Slicers provide a visual way to filter data, while filters apply conditions to limit data in reports or dashboards.
• Slicers are visual elements that allow users to select values to filter data interactively.

• Filters are typically applied behind the scenes and can be more complex, allowing for multiple conditions.

• Example of a slicer: A dropdown menu for selecting a specific region in a sales dashboard.

• Example of a filter:...read more
Answered by AI
Add your answer
Q4. Dax for year over year growth
Ans. 
DAX calculates year-over-year growth by comparing current year values to previous year values using time intelligence functions.
• Use the DAX function 'SAMEPERIODLASTYEAR' to reference the same period in the previous year.

• Example: 'YoY Growth = (SUM(Sales[Amount]) - CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR(Date[Date]))) / CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR(Date[Date]))'

• Ensure your date table is mark...read more
Answered by AI
Add your answer
Q5. Difference types of filters in power BI
Ans. 
Power BI offers various filters to refine data visualizations, including report, page, and visual-level filters.
• Report-level filters: Apply to all pages in the report. Example: Filtering out data for a specific region across all visuals.

• Page-level filters: Apply to a single page in the report. Example: Showing sales data for a specific product category on one page.

• Visual-level filters: Apply to individual visuals. Exam...read more
Answered by AI
Add your answer

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
Answered by AI
Add your answer