ROUND 1: Online Test Time Limit: 1 hour

1. Write a program to get user withdrawal amount as input and calculate the necessary tax and bank charges for the listed conditions (There were several if else conditions) and display the result. (Programming)

2. Load the list of books from the Library database and produce a report showing number of books borrowed and available. (SQL)

3. Given a table “Person” with Name, Account Type and Amount as attributes. Reformat the table into attributes having Name, Balance, Number of deposits, Number of withdrawals and more. The question is similar to this leetcode question
   https://leetcode.com/problems/reformat-department-table/ (SQL)

4. Create a Table called “Student” along with his five subject marks provided necessary foreign key, primary key constraints. Write a select query to display student name if the student scored above 50 in any three subjects or scored 100 in any one of the subject in ascending order. (SQL)

   Next section was essay writing on given case study – Suppose you are a sports coach for your favourite game. You are working so hard to win the upcoming match. Suddenly, one of your key players has met with an accident. You have substitute player but he is no match for the opponent team. How will you tackle this situation?

ROUND 2: Technical Discussion

• My self-introduction was more detailed and I mentioned all my projects and skill sets along with it.
• She asked about Node.js and react.js which I did in my intern projects.
• And then, she asked me to explain about my “Sentiment Analysis Framework” project in detail.
• She asked me to choose either Java or C++ and I chose C++.
• She told me to share screen and code it in notepad. The question she gave was “Given a sentence, display the words that are repeated more than once in the sentence with proper OOP structure”. I gave O(n2) approach.
• Then, she asked me why I have not used any inbuilt string functions such as strtok(), strcmp() etc... I told her that I don’t know much inbuilt functions in C++.
• Later, she told me to explain why we need Select, Create, Update commands in SQL. I explained clearly about the DML, DDL, and TCL commands.
• How will you rate yourself in python on a scale out of 10. I told 8/10. (Note: You should have good knowledge in OOP concepts, Decorators, Memory Representation etc…)
• Finally, she said “We will direct you to HR. Our HR will contact you!”
• Before concluding, I asked her few questions such as work life balance, why there is no Temenos client from India etc…

ROUND 3: HR Discussion
He just asked my personal details that's it!

**I got Selected with 7.5 LPA**