Infosys Data Analyst Interview Questions, Process, and Tips

Online aptitude test with maths and statistics and data analysis

Q1. Joins sql groups python numpy pandas
Add your answer

Q1. What are the methods and best practices for cleaning up data?
Ans. 
Methods and best practices for cleaning up data include removing duplicates, handling missing values, standardizing formats, and validating data accuracy.
• Remove duplicates by identifying and deleting identical records.

• Handle missing values by imputing with mean, median, or mode.

• Standardize formats by converting data into a consistent structure.

• Validate data accuracy by cross-referencing with external sources or using d
Answered by AI
Add your answer
Q2. What are the best practices for optimizing SQL code?
Ans. 
Best practices for optimizing SQL code
• Use indexes on columns frequently used in WHERE clauses

• Avoid using SELECT * and only retrieve necessary columns

• Optimize joins by using INNER JOIN instead of OUTER JOIN when possible

• Avoid using subqueries and instead use JOINs or CTEs

• Regularly analyze query performance using EXPLAIN or query execution plans
Answered by AI
Add your answer

Basic level aptitude questions that are easy to answer.

A general group discussion.

Q1. Basic sql problems and basic python question
Add your answer

Q1. Sql questions case study
Add your answer