Ho sostenuto un colloquio presso Tata Consultancy Services (Poona)
Colloquio
SQL and Databases
What is the difference between OLTP and OLAP systems?
How would you optimize a slow SQL query?
Explain the concepts of primary key, foreign key, and unique key.
Write a query to find duplicate records in a table.
How do you handle NULL values in SQL?
What are indexes, and how do they impact query performance?
What is a transaction, and how does ACID compliance ensure data integrity
1
Altre recensioni di colloqui per Data Engineer presso Tata Consultancy Services
Ho sostenuto un colloquio presso Tata Consultancy Services
Colloquio
As a fresher, you need to go through an online assessment, technical interview and a HR interview. Sometimes you can also expect Managerial round before HR round. You can expect questions from the skillset which was mentioned in your resume
Domande di colloquio [1]
Domanda 1
They focused on the basic and important skills like Python and SQL, most of the questions are from the skillset you mentioned in your resume
Ho sostenuto un colloquio presso Tata Consultancy Services (Noida)
Colloquio
3 rounds of interview, sql codes on paper and databricks question.
Manager round
Hr round
It was the whole day process all the processes that completed in a single day
Domande di colloquio [1]
Domanda 1
100 GB data have to move but pipeline can handle 30gb
Ho sostenuto un colloquio presso Tata Consultancy Services (Hyderabad)
Colloquio
Interview. was taken by bot. It was easy i answered everything perfectly. But i didn’t receive any email regarding the interview if i selected or not nothing. We would expect something reply from them right