Infosys Data Analyst Interview Questions and Process 2026

Cracking the Infosys Data Analyst Interview

Infosys handles massive data warehousing and analytics projects for global retail, banking, and manufacturing clients. The Data Analyst role requires translating this raw data into actionable business dashboards. The interview process focuses heavily on data manipulation (SQL) and data visualization.

Phase 1: The Technical Screening (SQL & Logic)

Data Analysts at Infosys spend the majority of their time writing queries.

• SQL Mastery: This is the most critical part of the interview. You will be given scenarios and asked to write complex queries on the spot. Expect heavy focus on JOINs (Inner, Left, Outer), GROUP BY, Aggregate Functions, and especially Window Functions (RANK(), DENSE_RANK(), ROW_NUMBER()).
• Data Cleaning: "How do you handle missing values in a dataset?" You must explain your approach to dealing with nulls, duplicates, and outliers using SQL or Python (Pandas).

Phase 2: Visualization and BI Tools

Infosys needs analysts who can present data to non-technical client stakeholders.

• Tableau or Power BI: Be prepared to discuss your dashboards. "Explain a complex dashboard you built. What was the business problem? What KPIs did you track?"
• Tool Specifics: If you claim Tableau expertise, expect questions on Level of Detail (LOD) expressions, parameters, and calculated fields. For Power BI, expect questions on DAX functions and data modeling (Star Schema vs. Snowflake Schema).
• Advanced Excel: Do not underestimate Excel. You may be asked about complex VLOOKUP/XLOOKUP nesting, Pivot Tables, and handling large datasets.

Phase 3: Managerial and Business Acumen Round

Infosys evaluates whether you can understand the client's actual business needs.

• Scenario-Based Questions: "If our banking client sees a 10% drop in credit card applications this quarter, how would you use data to investigate the cause?" They want to see your analytical thinking process, not just your coding skills.
• Stakeholder Management: "How do you present data to a client who disagrees with your findings?" Emphasize data-backed arguments, clear visualizations, and excellent communication skills.

Top 3 Technical Questions to Prepare

1. Write a SQL query to find the 3rd highest salary in each department using Window Functions.
2. Explain the difference between a LEFT JOIN and an INNER JOIN, and provide a business scenario where you would use each.
3. What are LOD expressions in Tableau, and why are they useful? Provide a business example where they are necessary.