All Out Interview Questions and Answers

• Q1. Tell me about yourself View Answers (2)
• Q2. Walk me through the different types of markets that you have worked with and what are the risks associated with each project of each market. View Answers (1)
• Q3. Share an experience where you faced an extremely demanding client and how you delivered the project within the agreed time. View Answers (1)
• Q4. Share an experience where you balanced multiple projects at a time and what factors did you consider for this. View Answers (1)
• Q5. Share an experience where you successfully mitigated a risk and how did you create a contingency plan for this. View Answers (1)

• Q1. No questions asked by HR - Directly started explaining the cost breakup, did not even let me know CTC, did not even let me speak or negotiate Add Answer
• Q2. No questions asked - Offered a completely different role than what was promised and what I interviewed for. Add Answer

• Q1. Lets say you have table 1 with values 1,2,3,5,null,null,0 and table 2 has null,2,4,7,3,5 What would be the output after inner join? View Answers (1)
• Q2. Lets say you have customers table with customerID and customer name, Orders table with OrderId and CustomerID. write a query to find the customer name who place...read more Add Answer
• Q3. Spark Architecture, Optimisation techniques Add Answer
• Q4. Some personal questions. Add Answer

• Q1. Explain the entire architecture of a recent project you are working on in your organisation. View Answers (1)
• Q2. How do you design an effective ADF pipeline and what all metrics and considerations you should keep in mind while designing? View Answers (1)
• Q3. Lets say you have a very huge data volume and in terms of performance how would you slice and dice the data in such a way that you can boost the performance? Add Answer
• Q4. Lets say you have to reconstruct a table and we have to preserve the historical data ? ( i couldnt answer that but please refer to SCD) Add Answer
• Q5. We have adf and databricks both, i can achieve transformation , fetching the data and loading the dimension layer using adf also but why do we use databricks if...read more Add Answer

• Q1. Basic HR questions Add Answer

First round is TCS NQT test, which contains 2 sections
1. Foundation section contains (Verbal, reasoning and quantitative questions)
2. Advanced section contains(Advance quant, advance reasoning and 2 coding questions)

If you clear this based on your marks and no of coding questions solved, you will get shortlisted for the interview.
I got shortlisted for the digital role for package of 7 LPA

• Q1. This is MR and TR round , in that mostly I got the questions from my resume View Answers (1)
• Q2. Introduce yourself and then started asking questions on my final year projects View Answers (14)
• Q3. Java related questions based on OOPS concept, collections, HashMap internal implementation? Add Answer
• Q4. Questions on Different skills that I mentioned on my resume, I answered all the questions correctly Add Answer
• Q5. Questions on DBMS, Joins, and SQL query and asked me to write query on join opearations Add Answer
• Q6. Asked to write the code for prime number and asked to optimize the code, I tried and they are okay with that Add Answer
• Q7. Next then jumped on my achievements, as me with my team winner as SIH 2023, I got the questions based on the work we done, how we won, what are difficulties we ...read more Add Answer
• Q8. Lastly MR asked me some questions, like what will you do, if you are team lead of small team and suddenly one major project comes in our organization and we wan...read more Add Answer
• Q9. Lastly, they asked me am I aware about the AIML,I mentioned yes, But they didn't asked any question on that Add Answer
• Q10. At last, I asked feedback. I suggest to all who is reading this, try to mention that things only in your resume that you're good in. and suggest you to follow t...read more Add Answer

• Q1. Asked me to give my introduction Add Answer
• Q2. Then asked same hr questions that you can check on google like are you comfortable with night shift, with any package, on any domain Add Answer