TIAA Global Business Services Software Analyst Interview Questions and Answers

Asked questions on arrays

Q1. Questions on databases
Add your answer
Q2. Questions on data structures
Add your answer
Q3. Questions on sql
Add your answer
Q4. Questions on projects
Add your answer
Q5. Questions on java
Add your answer

Q1. Find the character with the maximum frequency
Ans. 
Iterate through each character in the array of strings and keep track of the frequency of each character. Return the character with the maximum frequency.
• Create a dictionary to store the frequency of each character

• Iterate through each string in the array and then through each character in the string

• Update the frequency count of each character in the dictionary

• Return the character with the maximum frequency
Answered by AI
Add your answer
Q2. Valid parenthesis
Add your answer

Q1. Have you used Junit? What is the difference between SQl and NoSQl Databases? have you worked with Kafka? Kafka based questions. explain dockerization/ containerization. which java8 feature did you work wit...read more
Ans. 
Yes, I have experience with Junit, SQL and NoSQL databases, Kafka, Dockerization, Java 8 features, stream() operations, and shell scripting in Unix.
• I have used Junit for unit testing in Java projects.

• SQL databases are relational databases that use structured query language for data manipulation, while NoSQL databases are non-relational databases that provide flexible schema design and horizontal scalability.

• I have work...read more
Answered by AI
Add your answer

Q1. What is the most complex sql query you have written till date. Why did you use nested query to achieve your goal? explain the query. which join did you use in the query. have you implemented hashset? how w...read more
Ans. 
The most complex SQL query involved nested queries for data manipulation. Used inner join. Implemented hashset and avoided trees due to their drawbacks.
• Nested SQL query used for complex data manipulation

• Inner join used for combining data from multiple tables

• Implemented hashset for efficient data storage and retrieval

• Avoided trees due to their drawbacks such as unbalanced structure and slower traversal times
Answered by AI
Add your answer
Q2. Find and replace words in a file using shell scripting. add an index in the beginning of each line in a file using shell scripting. what is multithreading? difference between single threaded and multithrea...read more
Ans. 
Shell scripting for find and replace, adding index to lines, multithreading, hashmap vs hashtable, stack vs queue
• Use sed command for find and replace in shell scripting

• Use awk command to add an index at the beginning of each line in a file

• Multithreading is the ability of a CPU to execute multiple threads concurrently

• Single threaded means only one thread is executed at a time, while multithreaded allows multiple threads...read more
Answered by AI
Add your answer

Q1. Behavioral questions- tell me about yourself. do you have any questions for us?
Add your answer

Basic array and vectors DSA questions

Q1. Asked me about my past project and my contribution in it
Add your answer
Q2. Linux commands and c++ language control
Add your answer
Q3. Asked me to write last function i wrote and explain what it does
Add your answer

Q1. Asked me about my past projects and my contribution
Add your answer
Q2. Checked my work ethics
Add your answer

Q1. Basic hr questions
Add your answer
Q2. Salary negotiation
Add your answer

70 minutes 90 questions

Q1. About oops few questions was asked
Add your answer
Q2. What is static in java and what is the difference between cpp and java
Ans. 
Static in Java is a keyword used to create class-level variables and methods. Difference between cpp and java includes memory management, platform independence, and syntax.
• In Java, 'static' keyword is used to create class-level variables and methods, while in C++, 'static' keyword is used to create variables with internal linkage.

• Java has automatic memory management through garbage collection, while C++ requires manual...read more
Answered by AI
Add your answer

Febonaci series in Kortin

Math and Reasoning along with Puzzle

Q1. On demand video assessment that include questions to answer.
Add your answer
Q2. Games designed to test different ability.
Add your answer

It continues for 15 mins