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

1️⃣ Online Aptitude + Technical Test Covers quantitative aptitude, logical reasoning, verbal, and technical MCQs (CS basics, OOPS, DBMS, OS, CN, sometimes coding). May include 1-2 coding problems (easy-medium level, e.g. arrays, strings, sorting). Platforms used: AMCAT, CoCubes, or HackerRank. 2️⃣ Technical Interview Questions on core CS subjects: OOPS concepts, inheritance, polymorphism (often asked in Java/C++ context) DBMS: normalization, joins, indexing OS: processes, deadlock CN: TCP/IP basics, HTTP vs HTTPS Plus: simple coding questions (reverse a string, find duplicates, recursion examples).

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