Shaadi.com Data Engineer interview questions

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