Ho presentato la mia candidatura tramite l'università. La procedura ha richiesto un giorno. Ho sostenuto un colloquio presso DTCC (Chennai) nel mese di apr 2025
Colloquio
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.
Domande di colloquio [1]
Domanda 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().
