Ernst & Young Interview Questions, Process, and Tips

Q1. Introduction and role
Add your answer
Q2. ISO 27001, ITGC, Risk
Add your answer

Q1. Information security
Add your answer
Q2. Cyber security and Risk
Add your answer

Basic aptitude and coding

Q1. What is denormalization and explanation of projects
Ans. 
Denormalization is the process of adding redundant data to a database to improve read performance.
• Denormalization involves duplicating data from normalized tables into a single denormalized table.

• It can improve query performance by reducing the need for joins and aggregations.

• Denormalization is often used in data warehousing and reporting applications.

• Examples of denormalization include creating summary tables or addin
Answered by AI
Add your answer

Q1. Introduction, why ey
Add your answer

Q1. String Manipulations
Add your answer
Q2. Selenium coding
Add your answer
Q3. Dynamic table handling
Add your answer
Q4. Java related questions
Add your answer

Q1. Framework related
Add your answer
Q2. Cucumber related
Add your answer
Q3. API CRUD OPERATIONs
Add your answer
Q4. Response codes of API
Ans. 
Response codes of API
• Response codes are standardized status codes returned by an API to indicate the outcome of a request

• Common response codes include 200 for successful request, 404 for not found, and 500 for server error

• Response codes help developers understand the result of their API calls and troubleshoot issues
Answered by AI
Add your answer

Q1. Testng order of execution
Ans. 
TestNG executes test methods in alphabetical order by default, but can be customized using priority attribute or dependsOnMethods attribute.
• TestNG executes test methods in alphabetical order by default

• Customize execution order using priority attribute or dependsOnMethods attribute

• Priority attribute assigns a priority to test methods, lower number runs first

• dependsOnMethods attribute specifies which test methods should
Answered by AI
Add your answer
Q2. Class variables
Add your answer
Q3. Deserialization serialization pojo classes
Add your answer
Q4. Failed test cases
Add your answer
Q5. Parallel Execution
Add your answer
Q6. Excel data handling
Add your answer

Q1. Basic dsa ques were asked
Add your answer

Q1. Database realted questions was asked
Add your answer

Q1. Nodejs related questions was asked
Add your answer

It was an MCQ test with questions from Quantitative Ability, Logical reasoning, Verbal Abililty

Q1. Introduce yourself
Add your answer
Q2. Describe your internship experience and what was your contribution.
Add your answer
Q3. Why do you want to pivot to Cyber Security from your Electrical engineering degree?
Add your answer
Q4. Are you willing to learn?
Add your answer

Q1. Where are you from? What do you like about this city?
Add your answer
Q2. What do you think Consultants do?
Ans. 
Consultants provide expert advice and guidance to clients in a specific field or industry.
• Consultants analyze client needs and provide tailored solutions

• They offer recommendations based on industry best practices

• Consultants may also assist with implementation and training

• They often work on a project basis or provide ongoing support

• Examples: Cyber Security Consultants help organizations improve their security posture, I
Answered by AI
Add your answer
Q3. Would you like travelling for work?
Add your answer
Q4. Are you willing to relocate?
Add your answer

Q1. What is Kafka where we used kafka
Ans. 
Kafka is a distributed streaming platform used for building real-time data pipelines and streaming applications.
• Kafka is used for building real-time data pipelines to process and analyze data streams.

• It provides high-throughput, fault-tolerant, and scalable messaging system.

• Kafka is commonly used in scenarios like real-time analytics, log aggregation, monitoring, and more.

• Example: Retail banking can use Kafka for real-
Answered by AI
Add your answer
Q2. What is spring IOC
Ans. 
Spring IOC (Inversion of Control) is a design pattern used in the Spring Framework to manage dependencies in a more flexible and decoupled way.
• In Spring IOC, the control of creating and managing objects is shifted from the application code to the Spring container.

• It helps in achieving loose coupling between classes by removing the dependency from the code.

• Spring IOC is implemented through Dependency Injection (DI) wher...read more
Answered by AI
Add your answer
Q3. Difference between views and materialized view
Ans. 
Views are virtual tables that display data from one or more tables, while materialized views are physical copies of the data stored in the database.
• Views are created using a query and do not store data themselves.

• Materialized views store the results of a query in a physical table.

• Views are updated dynamically when queried, while materialized views need to be refreshed to reflect changes in the underlying data.

• Materiali...read more
Answered by AI
Add your answer
Q4. What is DB partition where it is used.?
Ans. 
DB partition is a technique used to divide a database into smaller, more manageable parts.
• DB partitioning is used to improve performance, scalability, and availability of a database.

• It involves dividing a database into smaller partitions based on certain criteria such as range, list, hash, or composite partitioning.

• Each partition can be stored on separate physical storage devices or servers.

• Examples of DB partitioning ...read more
Answered by AI
Add your answer
Q5. What is index what is the benefit
Ans. 
An index is a statistical measure used to represent the value of a group of assets or securities.
• Indexes help investors track the performance of a specific market or sector.

• They provide a benchmark for comparing the performance of individual investments.

• Examples include the S&P 500, Dow Jones Industrial Average, and Nasdaq Composite.
Answered by AI
Add your answer