Infosys Analyst Interview Questions, Process, and Tips

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

Quant arthmetic reasoing

Q1. Finance related questions
Add your answer

Q1. What is replication task ?
Ans. 
Replication task refers to the process of copying data from one source to another to ensure consistency and availability.
• Replication tasks are commonly used in database management to create redundant copies of data for backup and disaster recovery purposes.

• They can also be used to distribute data across multiple servers to improve performance and scalability.

• Examples of replication tasks include master-slave replicatio...read more
Answered by AI
Add your answer