AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Infosys
Compare
Filter interviews by
Infosys Data Architect Interview Questions, Process, and Tips
Infosys Data Architect Interview Experiences
1 interview found
Anonymous
I applied via Naukri.com and was interviewed in Feb 2021. There were 3 interview rounds.
Interview Questionnaire
6 Questions
- Q1. Difference between conceptual, logical and physical data models
- Ans.
Conceptual, logical and physical data models are different levels of abstraction in data modeling.
Conceptual model represents high-level business concepts and relationships.
Logical model represents the structure of data without considering physical implementation.
Physical model represents the actual implementation of data in a database.
Conceptual model is independent of technology and implementation details.
Logical mod...
- Q2. Difference between oltp and olap database
- Ans.
OLTP is for transactional processing while OLAP is for analytical processing.
OLTP databases are designed for real-time transactional processing.
OLAP databases are designed for complex analytical queries and data mining.
OLTP databases are normalized while OLAP databases are denormalized.
OLTP databases have a smaller data volume while OLAP databases have a larger data volume.
Examples of OLTP databases include banking sys...
- Q3. Dimensional model various type of dimensions
- Ans.
Dimensional model includes various types of dimensions such as conformed, junk, degenerate, and role-playing.
Conformed dimensions are shared across multiple fact tables.
Junk dimensions are used to store low-cardinality flags or indicators.
Degenerate dimensions are attributes that do not have a separate dimension table.
Role-playing dimensions are used to represent the same dimension with different meanings.
Other types o...
- Q4. Data governance capabilities
- Ans.
Data governance capabilities refer to the ability to manage and control data assets effectively.
Establishing policies and procedures for data management
Ensuring compliance with regulations and standards
Implementing data quality controls
Managing data access and security
Monitoring data usage and performance
Providing training and support for data users
- Q5. Difference between Kimball and inmon method of modelling
- Ans.
Kimball focuses on dimensional modelling while Inmon focuses on normalized modelling.
Kimball is bottom-up approach while Inmon is top-down approach
Kimball focuses on business processes while Inmon focuses on data architecture
Kimball uses star schema while Inmon uses third normal form
Kimball is easier to understand and implement while Inmon is more complex and requires more planning
Kimball is better suited for data ware...
- Q6. Improving performance of database and query fine tuning
- Ans.
To improve database performance, query fine tuning is necessary.
Identify slow queries and optimize them
Use indexing and partitioning
Reduce data retrieval by filtering unnecessary data
Use caching and query optimization tools
Regularly monitor and analyze performance metrics
Interview Preparation Tips
Skills evaluated in this interview
Data Architect Jobs at Infosys
What people are saying about Infosys
Interview questions from similar companies
I applied via Campus Placement and was interviewed before Jul 2020. There were 4 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Description of project
- Ans.
The project involved designing and implementing a new network infrastructure for a large corporation.
Conducted a thorough analysis of the existing network infrastructure
Designed a new network architecture that met the company's needs
Implemented the new network infrastructure with minimal disruption to business operations
Tested and optimized the new network to ensure optimal performance
Provided ongoing support and maint
- Q2. Your previous experince
Interview Preparation Tips
I applied via Naukri.com and was interviewed before Apr 2021. There were 2 interview rounds.
(3 Questions)
- Q1. Spring container and beans
- Q2. Annotations used in Springboot
- Ans.
Annotations are used in Springboot to simplify configuration and reduce boilerplate code.
Annotations are used to define the behavior of Spring components
They can be used to define the scope of a bean, inject dependencies, and handle exceptions
Some commonly used annotations include @Component, @Autowired, and @ExceptionHandler
- Q3. Java 8 New Features and explanation
- Ans.
Java 8 introduced several new features including lambda expressions, streams, and default methods.
Lambda expressions allow for functional programming and simplify code.
Streams provide a way to process collections of data in a functional style.
Default methods allow for adding new methods to interfaces without breaking existing implementations.
Other features include the Optional class, Date and Time API, and Nashorn Java
(1 Question)
- Q1. What is your expected package
Interview Preparation Tips
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Jul 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. The questions were on front end web development questions with managerial interview
Interview Preparation Tips
I applied via Naukri.com and was interviewed before Feb 2021. There were 2 interview rounds.
(1 Question)
- Q1. Questions on Salesforce Basics. One can learn all great features in Salesforce.com but we must know the basic admin functionalities and features in Saleforce.
(1 Question)
- Q1. The questions will be on your career, Resume. They will look for story telling skills, can you be a team player and individual player, etc. Can be technical as well.
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Feb 2021. There were 2 interview rounds.
Focus on industry-specific nuances
Interview Preparation Tips
I applied via Naukri.com and was interviewed before May 2021. There were 2 interview rounds.
Coding questions will be given
Interview Preparation Tips
I applied via Recruitment Consultant and was interviewed in Dec 2018. There were 3 interview rounds.
Interview Questionnaire
6 Questions
- Q1. What is basic function of firewall.
- Ans.
Firewall is a network security system that monitors and controls incoming and outgoing network traffic based on predetermined security rules.
Firewall acts as a barrier between a trusted, secure internal network and another network, such as the Internet.
It examines each packet of data that passes through it and determines whether to allow or block the traffic based on the set of rules.
Firewalls can be hardware or softwa...
- Q2. Which are the BGP attributes
- Ans.
BGP attributes are used to determine the best path for routing traffic between networks.
BGP attributes include: AS Path, Next Hop, Local Preference, MED, Origin, and Community
AS Path is a list of autonomous systems that the route has passed through
Next Hop is the IP address of the next router on the path
Local Preference is used to indicate the preferred path for outbound traffic
MED (Multi-Exit Discriminator) is used to...
- Q3. How VPN works
- Ans.
VPN stands for Virtual Private Network. It allows secure remote access to a private network over the internet.
VPN creates a secure and encrypted connection between the user's device and the private network.
It masks the user's IP address and location, providing anonymity and privacy.
VPN uses different protocols such as PPTP, L2TP, IPSec, and OpenVPN.
It can be used to access geographically restricted content, bypass cens...
- Q4. Which are the difference Routing protocols
- Ans.
Routing protocols are used to determine the best path for data to travel in a network.
Distance Vector protocols: RIP, IGRP, EIGRP
Link State protocols: OSPF, IS-IS
Hybrid protocols: BGP
Path Vector protocols: BGP
IGP vs EGP
- Q5. What is VTP
- Ans.
VTP stands for VLAN Trunking Protocol, used to manage VLANs in a switched network.
VTP is a Cisco proprietary protocol.
It allows for easy VLAN management by propagating VLAN information across the network.
VTP operates in three modes: server, client, and transparent.
Server mode allows for VLAN creation, deletion, and modification.
Client mode receives and stores VLAN information.
Transparent mode forwards VTP messages but ...
- Q6. What is the difference between Router and firewall
- Ans.
Routers connect networks while firewalls protect networks from unauthorized access.
Routers direct traffic between networks while firewalls filter traffic based on predefined rules.
Routers operate at layer 3 of the OSI model while firewalls operate at layer 4 or higher.
Examples of routers include Cisco routers, while examples of firewalls include Fortinet firewalls.
Routers can be used to segment networks while firewalls...
Interview Preparation Tips
Skills evaluated in this interview
I appeared for an interview before May 2021.
Quant, reasoning, English
(1 Question)
- Q1. Java/C language questions
(1 Question)
- Q1. About your self questions
Interview Preparation Tips
Respect time of others
I applied via Campus Placement and was interviewed before Nov 2019. There were 8 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Porters Generic Marketing Strategy
- Q2. Extempore Pitch to position a product differentially in the Market
- Ans.
Our product is the only one in the market that offers a unique combination of features and benefits.
Our product is designed to solve a specific problem that no other product in the market can solve.
Our product offers a unique combination of features and benefits that are not available in any other product.
Our product is backed by extensive research and development, ensuring that it is the most effective solution in the...
- Q3. Why MBA, Why Marketing
Interview Preparation Tips
2.Kindly understand the question and answer relating with some of the concepts you have studied
Infosys Interview FAQs
Tell us how to improve this page.
Infosys Interviews By Designations
- Infosys System Engineer Interview Questions
- Infosys Software Engineer Interview Questions
- Infosys Technology Analyst Interview Questions
- Infosys Associate Consultant Interview Questions
- Infosys Senior Systems Engineer Interview Questions
- Infosys Software Developer Interview Questions
- Infosys Business Analyst Interview Questions
- Infosys Senior Associate Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
- Database Architect Interview Questions
- Architect Interview Questions
- Solution Architect Interview Questions
- Database Developer Interview Questions
- Technical Architect Interview Questions
- Senior Architect Interview Questions
- Junior Architect Interview Questions
- SQL Server Developer Interview Questions
- Show more
Data Architect Interview Questions from Similar Companies
Fast track your campus placements
Infosys Data Architect Reviews and Ratings
based on 1 review
Rating in categories
|
Technology Analyst
55.3k
salaries
|  ₹3 L/yr - ₹11.1 L/yr |
|
Senior Systems Engineer
50.9k
salaries
| ₹2.5 L/yr - ₹7.9 L/yr |
|
System Engineer
31.5k
salaries
| ₹2.5 L/yr - ₹5.5 L/yr |
|
Technical Lead
30.9k
salaries
| ₹5.1 L/yr - ₹19.7 L/yr |
|
Senior Associate Consultant
28.4k
salaries
| ₹6.2 L/yr - ₹15 L/yr |
TCS
Wipro
Cognizant
Accenture
- Home >
- Interviews >
- Infosys Interview Questions >
- Infosys Data Architect Interview Questions
