SQL queries:
delete duplicate records from the table,
Nth highest salary,
Select 2 from employee,
Basic joins
Python:
1.Create list of integers from a list of string containing integers ( 'a_101_z', 'b_103_z')
2. String replace with characters based on dictionary values
3. 2nd highest array element without using inbuilt methods and functions
4. Smallest repeating substring

And there were some questions around project, Apache Kafka, basic data warehousing concepts, acid properties in rdbms etc

Question

SQL queries: 
delete duplicate records from the table, 
Nth highest salary,
Select 2 from employee,
Basic joins
Python:
1.Create list of integers from a list of string containing integers ( 'a_101_z', 'b_103_z')
2. String replace with characters based on dictionary values
3. 2nd highest array element without using inbuilt methods and functions
4. Smallest repeating substring

And there were some questions around project, Apache Kafka, basic data warehousing concepts, acid properties in rdbms etc

Utilisateur anonyme · Accepted Answer

Answered the conceptual questions very well, on the practical stuff didn't answer duplicate records properly and smallest repeating substring

Shaadi.com

Question d’entretien chez Shaadi.com

Réponse à la question d'entretien

Entreprises suivies

Recherche d’emplois