I applied through university. The process took 1 day. I interviewed at DTCC (Chennai) in Apr 2025
Interview
The DDTC interview process comprised two challenging SQL questions and one Java file-handling problem. The SQL problems tested proficiency in advanced concepts like joins, window functions, subqueries, and data aggregation. Candidates were expected to write optimized queries to handle complex data scenarios. The Java question focused on reading/writing files using proper exception handling and clean coding practices. Overall, the interview assessed deep technical skills in database management and file-based data processing.
Interview questions [1]
Question 1
One of the key questions they asked involved advanced date manipulation in SQL, such as calculating differences between dates, extracting specific parts (like week number or quarter), and handling edge cases like leap years or month-end boundaries using functions like DATEDIFF(), DATEADD(), FORMAT(), and DATE_TRUNC().