projects
sql
python
coding questionrojects: “Explain your project architecture, technologies used, your individual contribution, challenges faced, database design, API flow, deployment process, and improvements you would make if given another chance.”
SQL: “Difference between joins, primary and foreign keys, normalization, group by vs having, subqueries, indexes, aggregate functions, and writing optimized queries for real-time scenarios.”
Python: “Explain Python basics, OOP concepts, lists vs tuples, dictionaries, functions, exception handling, file handling, modules, libraries, and advantages of Python in development and automation.”
Coding Questions
I applied through college or university. The process took 2 months. I interviewed at LTM Limited (Pune) in Nov 2024
Interview
My LTIMindtree interview focused on Java fundamentals, OOP, collections, Spring Boot basics, SQL joins, and simple DSA like arrays/strings. They examined my projects, asked scenario-based questions, and checked communication and problem-solving confidence