DTCC Architect Interview Questions and Answers

Q1. Scenario based questions
Add your answer

Case studies and example

Q1. Questions related to the JD
Add your answer

Q1. Database questions for Java position
Add your answer
Q2. SQL performance techniques
Ans. 
SQL performance techniques
• Use indexes to speed up queries

• Avoid using SELECT * and only select necessary columns

• Use stored procedures to reduce network traffic

• Avoid using subqueries and instead use JOINs

• Use EXPLAIN to analyze query performance

• Normalize database tables to reduce redundancy

• Use connection pooling to reduce overhead

• Avoid using cursors and use set-based operations instead
Answered by AI
Add your answer

Q1. Linux shell script for reading and parsing the flat file
Ans. 
A Linux shell script can be used to read and parse a flat file.
• Use the 'read' command to read the file line by line

• Use 'cut' command to parse the data based on delimiter

• Use 'awk' command to filter and manipulate data

• Use 'sed' command to search and replace data

• Use 'grep' command to search for specific patterns in the file
Answered by AI
Add your answer

Q1. What are your salary expectations?
Add your answer
Q2. Why are you looking for a change?
Add your answer
Q3. Where do you see yourself in 5 years?
Add your answer
Q4. Minimum salary expectation
Add your answer

Q1. Products related
Add your answer
Q2. Journal entry
Add your answer

Q1. Salary expected
Ans. 
My expected salary is negotiable and dependent on the overall compensation package offered.
• My expected salary is based on my experience, skills, and the responsibilities of the role.

• I am open to discussing the salary range for this position during the interview process.

• I am looking for a competitive salary that aligns with industry standards and my qualifications.
Answered by AI
Add your answer
Q2. Notice period
Add your answer

Mix and match questions

Q1. Hypothetical questions and situations
Add your answer

Q1. About past experience, future goals and contributions
Add your answer

Q1. A good SQL query related to sales, transactions, statement.
Add your answer
Q2. Questions on group by, having, etc
Add your answer

Q1. Technical with offshore manager
Add your answer
Q2. All on the process as per the resume
Add your answer

Q1. Technical round with Onshore partner
Add your answer
Q2. As per the resume and on the basis of the process you are applying for
Add your answer