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
Ans. 
I am a Cyber Security Consultant with 5 years of experience in network security and threat detection.
• 5 years of experience in network security

• Skilled in threat detection

• Certified in CISSP and CEH

• Strong knowledge of firewalls and encryption protocols
Answered by AI
Add your answer
Q2. Describe your internship experience and what was your contribution.
Ans. 
I interned at a cybersecurity firm where I conducted vulnerability assessments and implemented security measures.
• Conducted vulnerability assessments on client systems

• Implemented security measures to protect against cyber threats

• Assisted in developing incident response plans

• Participated in security audits and compliance checks
Answered by AI
Add your answer
Q3. Why do you want to pivot to Cyber Security from your Electrical engineering degree?
Ans. 
I am drawn to the challenge of protecting critical systems and data from cyber threats.
• Passion for problem-solving and critical thinking

• Interest in technology and cybersecurity trends

• Desire to make a positive impact in protecting organizations from cyber attacks
Answered by AI
Add your answer
Q4. Are you willing to learn?
Ans. 
Yes, I am always eager to learn and stay updated with the latest trends and technologies in cyber security.
• I am committed to continuous learning and professional development.

• I actively seek out new information and training opportunities.

• I am open to feedback and constructive criticism to improve my skills.

• Examples: attending workshops, obtaining certifications, participating in online courses.
Answered by AI
Add your answer

Q1. Where are you from? What do you like about this city?
Ans. 
I am from New York City. I love the diversity, culture, and endless opportunities this city offers.
• Diversity: NYC is a melting pot of cultures, languages, and traditions.

• Culture: The city is home to world-class museums, theaters, and restaurants.

• Opportunities: NYC is a hub for various industries, providing endless career possibilities.
Answered by AI
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?
Ans. 
Yes, I enjoy travelling for work as it allows me to visit new places, meet new people, and gain diverse experiences.
• I enjoy experiencing new cultures and environments

• Travelling for work allows me to meet new clients and build relationships

• I appreciate the opportunity to explore different cities and countries
Answered by AI
Add your answer
Q4. Are you willing to relocate?
Ans. 
Yes, I am open to relocating for the right opportunity.
• I am open to relocating for the right opportunity

• I am flexible and willing to consider different locations

• I understand the importance of being geographically flexible in the cyber security field
Answered by AI
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