One thing they asked me was how I would approach integrating and normalizing data from multiple sources with different formats and grading systems. They were interested in understanding how I would handle discrepancies in movie titles, genres, and ratings across platforms, and how I would design a system to ensure consistency and reliability in the final aggregated ratings.
Question in Python: There was an input of a list of numbers and I had to return how many each value is in the list
they had asked queries and scenario based questions
What are dimensional and snowflake models?
Narrow and wide transformation in Spark
Clustered vs Non-clustered index? Schema changes? Incremental loads?
What port does SSL communicate over. What is the difference between TCP & UDP.
1. Recursion 2.window function 3 difference between rank and row_number 4. sql with lead and lag function
Explain “Normal Distribution and its implementation
Comment optimiser une requête SQL pour améliorer les performances de la base de données ?
Viewing 451 - 460 interview questions