I applied through college or university. I interviewed at Infosys (Gurgaon, Haryana) in Nov 2022
Interview
easy level as compared to other companies..ques like cte , joins , windows function are mostly asked.Diagnosing and resolving SQL load failures
Hierarchical queries
Advanced SQL functions (analytic/window)
Performance tuning and query optimization
ETL & data pipelines
Azure SQL-specific considerations
It has lot of questions related to sql and also python.Overall interview was decent and lot of thought provoking stuff.Unfortunately I was little tensed and couldn’t answer everything.Keep calm to succeed in those interviews
I applied online. I interviewed at Infosys (Mumbai) in Nov 2024
Interview
the interview process was medium to tough .
solving case studies and questions will help..
they needed analytical skills and problem solving skills
they and Strong in querying logic and data interpretation
Solid communication and articulation skills
Able to handle stakeholders independently with less interventions of reporting manager
Develop strategies to solve problems in logical yet creative ways.
Create custom reports and presentations accompanied by strong data visualization and storytelling.
Interview questions [1]
Question 1
they asked about sql and python intermediate questions
about recursive cte etc