Genpact

Role: Software Engineer

College: Not Specified

Interview Date: June 10, 2024

Interview Type: On-Campus

Result: Not Specified

Difficulty: Easy to Mid-Easy

Rounds: 2 rounds

Topics Asked: CS Fundamentals (OOPs, OS, DBMS, CN), General IQ and Aptitude, JavaScript Code Output, SQL, Projects (Web Sockets, Chat App)

Experience:

The candidate was shortlisted for an on-campus Software Engineer role based on CGPA (initially 7, later relaxed to 6.5) and skills. The candidate had a CGPA of 8+ and included three full-stack development projects on their resume.

Round 1: Online Assessment
The assessment included questions on CS fundamentals (OOPs, OS, DBMS, CN), general IQ and aptitude, and JavaScript code output. The overall difficulty was considered easy to mid-easy.

Round 2: Technical Interview
The interviewer directly started with SQL questions:

• Differences between `Delete`, `Drop`, and `Truncate`.
• Asked to verbally provide a query for "top 10 users based on their salary in a table" (Answer: `SELECT * FROM [table_name] ORDER BY salary DESC LIMIT 10;`).
• Follow-up for "lowest 10" (Answer: remove `DESC`).

The discussion then moved to the candidate's projects, particularly a "Chat App" project, where the interviewer inquired about Web Sockets and their usage (Socket.io). Towards the end, behavioral questions were asked, including "Do you have any questions for me?". The candidate asked about the company, and the interviewer provided details.

Tips: The candidate advised referring to INDIABIX for aptitude, GeeksforGeeks for CS fundamentals, and YouTube for learning JavaScript. For the interview, they suggested practicing DSA from GFG, knowing projects thoroughly, and studying SQL.