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

Anonimo · Accepted Answer

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

Shaadi.com

Domanda di colloquio di Shaadi.com

Risposta di colloquio

Aziende seguite

Ricerche di lavoro