Top 28
Prep plan
Updated weekly · Last refresh Aug 30

Infosys Data Analyst Interview Questions

The questions to prepare for a Infosys Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

28questions
~4htotal time
Track your progressSign up free to work through all 28 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 11 questions + 2 drills · ~113 min
Second-Highest Transaction Amount QueryMedium
Practice

Find the second-highest distinct transaction amount using a subquery in PostgreSQL without LIMIT.

SubqueriesRankingsalaryInfosys
Normalization vs Reporting DenormalizationMedium

Explain normalization for data integrity and when denormalization is useful for faster reporting and simpler analytical queries.

performancenormalizationdata integrityInfosys
Compare Join Types in ReportingEasy

Explain how INNER JOIN, LEFT JOIN, and RIGHT JOIN change row retention and NULL handling in reporting queries.

sql basicsJoinsjoin typesInfosys
Second Highest Without AggregatesHard
Practice
Practice drill

Find the second highest salary in each department without using aggregate functions.

SubqueriesRankingSelf-JoinsCredit GenieDevoteamCisco Restaurant + Bar
Top Customers by Net SalesMedium
Practice
Practice drill

Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.

SubqueriesJoinsData WranglingGain DigitalTCSZest AI
More SQL & Data Manipulation questions with a free account
2
Pipelines4 questions · ~34 min
Power BI Cleaning with Power QueryMedium

Tests your ability to clean and transform data effectively for BI reporting in Power BI.

Data Wranglingpower biInfosys
Alteryx Workflow and MacrosMedium

Tests your ability to build reusable, maintainable data workflows with Alteryx.

AutomationInfosys
Handle Missing Data in BI ToolsMedium

Tests your data quality handling approach for BI-ready datasets across multiple sources.

Data QualityData WranglingInfosys
More Pipelines questions with a free account
3
Behavioral & Leadership11 questions · ~93 min
More Behavioral & Leadership questions with a free account
4
More topics2 questions · ~17 min
Calculated Columns vs DAX MeasuresMedium

Explain how calculated columns and DAX measures differ, and when each is the right choice for KPI reporting and analysis.

daxKPIData ModelingInfosys
Billing and Enrollment Dashboard MetricsMedium

Tests your product sense for selecting actionable metrics and structuring a BI dashboard.

MetricsUser NeedsdashboardingInfosys

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
The finish line: interview-readyComplete all 28 questions plus 2 hands-on drills to finish this plan.