Ernst & Young Data Architect Interview Questions and Answers

Q1. What are fear that you overcome
Add your answer

Python coding test that was baasic included panadas framework

Q1. Behavioural round
Add your answer

Q1. It was Moderate
Add your answer

Q1. It was moderate
Add your answer

Q1. Salary negotiation
Add your answer

Q1. Design a system for ticket booking platform
Ans. 
Design a system for ticket booking platform
• Utilize a database to store information about events, venues, and available tickets

• Implement a user-friendly interface for customers to search, select, and purchase tickets

• Incorporate payment gateway for secure transactions

• Include features like seat selection, ticket printing, and email confirmation

• Develop an admin panel for managing events, venues, and ticket inventory
Answered by AI
View 1 more answer

Q1. Project related
Add your answer

Q1. What is static class. What is polymorphism Basic's of Oops concept. How to improve performance of query in sql.
Ans. 
Static class is a class that cannot be instantiated and its members can be accessed without creating an object. Polymorphism is the ability of an object to take on many forms. OOP is a programming paradigm based on the concept of objects.
• Static class is used for creating utility classes or for grouping related methods and properties.

• Polymorphism allows objects of different classes to be treated as if they were of the s...read more
Answered by AI
Add your answer
Q2. Basics of C#, ASP.Net , SQL , Javascript , Azure. They have asked everything.
Add your answer

Q1. Data model for book lending
Ans. 
A data model for book lending
• Create entities for books, borrowers, and loans

• Include attributes such as book title, author, borrower name, loan date, and due date

• Establish relationships between books and borrowers through loan transactions

• Consider additional attributes like book genre, borrower contact information, and loan status
Answered by AI
Add your answer

Q1. Explain your project Design
Add your answer
Q2. Design pattern used and purpose
Ans. 
The design pattern used is the Model-View-Controller (MVC) pattern.
• MVC separates the application into three interconnected components: the model, the view, and the controller.

• The model represents the data and business logic of the application.

• The view displays the data to the user and handles user interactions.

• The controller handles the communication between the model and the view, and manages the flow of data and user...read more
Answered by AI
View 4 more answers
Q3. As a lead what you expect from your team member ?
Add your answer
Q4. Which version controller tool used and CI/CD ?
Ans. 
We use Git as our version control tool and Jenkins for CI/CD.
• We use Git for version control as it is widely used and has a lot of community support.

• Jenkins is our preferred CI/CD tool as it is open-source and has a large number of plugins available.

• We have also used other version control tools like SVN and Mercurial in the past.

• For CI/CD, we have used tools like Travis CI and CircleCI for specific projects.

• We follow th...read more
Answered by AI
Add your answer
Q5. How do you establish connection b/w the services that are running in different cloud provider
Ans. 
To establish connection between services running in different cloud providers, we can use various methods.
• One way is to use APIs provided by the cloud providers to connect the services.

• Another way is to use middleware like Apache Kafka or RabbitMQ to connect the services.

• We can also use VPNs to establish a secure connection between the cloud providers.

• Container orchestration tools like Kubernetes can also be used to co...read more
Answered by AI
Add your answer

Q1. Various question about the project work experience.
Add your answer

Q1. Technology deep knowledge discussions and challenges faced.
Add your answer

Q1. Package negotiation.
Add your answer