Ernst & Young Interview Questions, Process, and Tips

Q1. Explain projects worked on and benefits
Add your answer
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 ...read more
Answered by AI
Add your answer

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 ...read more
Answered by AI
Add your answer
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...read more
Answered by AI
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. DAX Question related to Filter and Time Intelligence function
Add your answer
Q2. Power BI Service features such as Gateways, RLS, Schedule Refresh
Add your answer
Q3. Introduction and Current Role Project
Add your answer
Q4. Power BI desktop features such as Tooltip, Drill Through filter, Bookmarks etc
Add your answer

Q1. Incremental Refresh
Add your answer
Q2. DAX questions related to Filter, Relationship, Table Manipulation, and Time Intelligence functions
Add your answer
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
Answered by AI
Add your answer
Q4. SQL Interview Questions
Add your answer
Q5. Introduction and Current Role Project
Add your answer

Q1. Data Modeling Questions
Add your answer
Q2. Data Warehousing Concepts such as SCD, Dimension and Fact Tables
Add your answer
Q3. Scenario Question related to BI tool such as Why you would consider this tool and How is it different from other BI Tools
Add your answer
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
Answered by AI
Add your answer
Q5. Current role in the Project and ofcourse Introduction was in the first.
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

Q1. Git fetch vs git pull
Add your answer
Q2. How hpa works in kubermetes
Add your answer
Q3. How to terraforn check resources
Add your answer
Q4. Python basic questions
Add your answer
Q5. Ejati docker expose and publish command
Add your answer

An aptitude test was conducted prior to being selected for Interviews

Q1. Questions based on Resume
Add your answer
Q2. Questions relating to Accounting
Add your answer
Q3. Questions relating to IFRS
Add your answer

Q1. Self introduction
Add your answer
Q2. Hobbies and passions
Add your answer
Q3. Career goal in 5 years
Add your answer

Q1. It's according to your profile and experience
Add your answer
Q2. All about your skil sets
Add your answer

Q1. About your flexibility and all.
Add your answer