i
Infosys
Filter interviews by
I applied via Naukri.com and was interviewed in Feb 2021. There were 3 interview rounds.
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...
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...
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...
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
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...
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
What people are saying about Infosys
I was interviewed before Feb 2016.
The success of a project can be measured by achieving the project goals within the given constraints.
Define clear project goals and constraints
Track progress regularly
Evaluate project outcomes against goals
Collect feedback from stakeholders
Compare project outcomes with industry standards
Consider cost, time, and quality factors
Celebrate achievements and learn from failures
We track/monitor it through various tools and software.
We use project management tools like Trello and Asana to track progress.
We use analytics tools like Google Analytics to monitor website traffic.
We use social media monitoring tools like Hootsuite to track brand mentions.
We use customer relationship management (CRM) software to track sales and customer interactions.
We conduct regular performance reviews and feedback...
Quality is the most important factor, followed by time and cost.
Quality should never be compromised as it affects the end product or service.
Time is also crucial as delays can lead to missed opportunities or loss of revenue.
Cost is important but should not be the sole focus as it can lead to cutting corners and sacrificing quality.
For example, in software development, a bug-free and user-friendly product is more import...
I grew in my previous company by taking on new responsibilities, learning new skills, and consistently delivering high-quality work.
Took on additional responsibilities and projects
Participated in professional development opportunities
Learned new skills and technologies
Received positive feedback and recognition for my work
Consistently met or exceeded performance goals
Built strong relationships with colleagues and client
As a consultant, I had to handle various roles and responsibilities.
Conducting research and analysis to identify client needs and provide strategic recommendations
Developing and implementing project plans to achieve client objectives
Providing expert advice and guidance to clients on business strategies and processes
Delivering presentations and reports to clients to communicate findings and recommendations
Collaborating ...
Some of the top questions asked at the Infosys Data Architect interview for experienced candidates -
based on 1 review
Rating in categories
Technology Analyst
55.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Systems Engineer
50.6k
salaries
| ₹0 L/yr - ₹0 L/yr |
System Engineer
39.5k
salaries
| ₹0 L/yr - ₹0 L/yr |
Technical Lead
30.7k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Associate Consultant
27.9k
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Wipro
Cognizant
Accenture