Infosys Analyst Interview Questions, Process, and Tips

Q1. Tell me about yourself
Add your answer
Q2. Questions on everything that I mentioned in resume.
Add your answer

Easy round to go through interview

Q1. Tell me about yourself
Add your answer
Q2. What have you achieved earlier
Add your answer

Q1. Case study of any previous work
Add your answer

Q1. Tell about the project experience
Ans. 
Led a team in implementing a data analytics project for a retail company
• Managed a team of 5 analysts to collect and analyze customer data

• Developed predictive models to forecast sales trends

• Presented findings to senior management and recommended strategic actions

• Achieved a 10% increase in sales revenue within 6 months
Answered by AI
Add your answer
Q2. Details of project
Add your answer

Basic coding question

2 DS questions were asked

Q1. Explain Oops concept
Ans. 
Oops concept stands for Object-Oriented Programming. It is a programming paradigm based on the concept of objects.
• Oops concept focuses on creating objects that contain data in the form of fields and code in the form of procedures.

• It allows for the creation of modular programs and reusable code.

• Key principles of Oops include encapsulation, inheritance, polymorphism, and abstraction.

• Encapsulation refers to the bundling o...read more
Answered by AI
Add your answer
Q2. Explain diamond problem
Ans. 
Diamond problem occurs in multiple inheritance when a class inherits from two classes that have a common ancestor.
• Diamond problem is a common issue in programming languages that support multiple inheritance.

• It occurs when a class inherits from two classes that have a common ancestor.

• This leads to ambiguity in the inheritance hierarchy, causing conflicts in method resolution.

• Languages like C++ resolve this by using virt...read more
Answered by AI
Add your answer

Q1. What is partition and group by ? How do we do migration ?
Ans. 
Partition and group by are SQL operations used for organizing data. Migration involves transferring data from one system to another.
• Partition is used to divide a table into smaller, more manageable parts based on a specific column or condition.

• Group by is used to group rows that have the same values into summary rows.

• Migration involves transferring data from one database or system to another, often using tools like ETL...read more
Answered by AI
Add your answer
Q2. How to find 3rd highest salary in each dept
Add your answer
Q3. How to find employees who earn more than their manager ?
Ans. 
Compare salary data of employees and managers to identify those earning more.
• Collect salary data of all employees and managers

• Analyze the data to identify employees earning more than their managers

• Consider factors like experience, qualifications, and performance in the analysis

• Conduct interviews or surveys to validate the findings
Answered by AI
Add your answer
Q4. On tableau - what is row level security ?
Ans. 
Row level security in Tableau allows users to restrict access to specific rows of data based on their role or permissions.
• Row level security is used to control which rows of data a user can access in Tableau.

• It is typically implemented by creating a security table that defines the relationship between users and the data they can access.

• Users can be granted access to specific rows based on their role or permissions.

• Row ...read more
Answered by AI
Add your answer
Q5. What is different license in tableau ?
Ans. 
Tableau offers different types of licenses for individuals and organizations based on their needs and usage.
• Tableau Creator license includes all the features for creating and sharing visualizations.

• Tableau Explorer license allows users to explore and interact with visualizations created by others.

• Tableau Viewer license is for users who only need to view and interact with visualizations without creating them.

• Tableau off...read more
Answered by AI
Add your answer

What is your role and responsibilities in previous organisation

Difference between tableau and power bi

Q1. Reason for job change
Ans. 
Seeking new challenges and opportunities for growth.
• Looking for new challenges to expand my skill set

• Seeking opportunities for career advancement

• Interested in working in a different industry or with a different team
Answered by AI
Add your answer