Farfetch Senior Data Engineer Interview Questions and Answers

Details already shared in advice

Details already shared in advice.

Q1. Details already shared in advice.
Add your answer

Q1. Details already shared in advice.
Add your answer

Q1. Details already shared in advice
Add your answer

Q1. SQL question to return the shortest duration of flight to travel from NY to HND
Ans. 
Use SQL query to find shortest flight duration from NY to HND
• Use SQL query with MIN function to find shortest duration

• Filter flights from NY to HND using WHERE clause

• Calculate duration by subtracting arrival time from departure time
Answered by AI
Add your answer
Q2. Pyspark question to read data from a CSV file
Add your answer
Q3. There was no question 3
Add your answer

Q1. Mostly discussions on Projects at my current company, Design choices and spark related concepts used for optimisations.
Add your answer
Q2. SQL question to test syntax knowledge
Add your answer
Q3. HRM typical questions like: Why join Grab?
Add your answer

Test contains 26 questions for me 13 are java based 13 are c++ based

Q1. Indexing in dbms
Ans. 
Indexing in DBMS is a technique to improve the performance of queries by creating a data structure that allows for faster retrieval of data.
• Indexes are created on columns in a database table to speed up the retrieval of rows that match a certain condition.

• Types of indexes include clustered, non-clustered, unique, and composite indexes.

• Examples of indexing techniques include B-tree, hash, and bitmap indexes.

• Indexing can...read more
Answered by AI
Add your answer
Q2. Find whether two strings are or not anagrams
Ans. 
Check if two strings are anagrams by comparing the sorted characters in each string.
• Sort the characters in both strings and compare if they are equal.

• Ignore spaces and punctuation when comparing the strings.

• Example: 'listen' and 'silent' are anagrams.

• Example: 'hello' and 'world' are not anagrams.
Answered by AI
View 1 more answer

Q1. Inorder traversal without recursion
Ans. 
Use a stack to simulate the recursive inorder traversal process
• Create an empty stack to store nodes

• Start with the root node and push it onto the stack

• While the stack is not empty, keep traversing left and pushing nodes onto the stack

• Once you reach a leaf node, pop it from the stack, print its value, and move to its right child

• Repeat the process until all nodes have been visited
Answered by AI
Add your answer
Q2. How to make a class final
Ans. 
To make a class final, use the 'final' keyword in the class declaration.
• Use the 'final' keyword before the 'class' keyword in the class declaration

• A final class cannot be subclassed or extended

• Final classes are often used for utility classes or classes that should not be modified
Answered by AI
Add your answer

Q1. Data structure and algorithm
Add your answer
Q2. Some tricky logical question
Add your answer
Q3. Stack and queue
Add your answer
Q4. Some basic question about system Design
Add your answer

Hackerrank Coding Test, Leetcode medium questions

HLD test, was asked to design an online coding platform like leetcode

Q1. Most interesting project you have worked on
Add your answer
Q2. How do you handle conflict at workplace
Add your answer

Some database questions,some java questions .

Q1. What is the difference between javascript and jQuery.
Ans. 
JavaScript is a programming language used for web development, while jQuery is a library built with JavaScript to simplify HTML document traversal and manipulation.
• JavaScript is a programming language, while jQuery is a library written in JavaScript.

• JavaScript can be used for a wide range of tasks, while jQuery is mainly used for DOM manipulation and event handling.

• JavaScript is a core technology for web development, w...read more
Answered by AI
Add your answer
Q2. Define different types of join
Ans. 
Different types of joins are used in SQL to combine rows from two or more tables based on a related column between them.
• Inner Join: Returns rows when there is at least one match in both tables.

• Left Join (or Left Outer Join): Returns all rows from the left table and the matched rows from the right table.

• Right Join (or Right Outer Join): Returns all rows from the right table and the matched rows from the left table.

• Full ...read more
Answered by AI
Add your answer
Q3. Define multithreading concept and exception handling.
Ans. 
Multithreading allows multiple threads to run concurrently, while exception handling deals with errors in a program.
• Multithreading involves running multiple threads simultaneously to improve performance and responsiveness.

• Threads share the same memory space but have their own program counter and registers.

• Exception handling is a mechanism to handle errors or exceptional situations in a program.

• It helps prevent the prog...read more
Answered by AI
Add your answer

GD COMMON TOPIC WAS DISCUSSED

Q1. TELL ABOUT YOURSELF , SKILLSETS YOU BRING TO THE TABLE
Add your answer

Q1. EXPECTED INCOME , RELOCATION PREFERENCE
Add your answer

DSA has 2-3 rounds depending on the team that is hiring. coding and algorithms 1 and coding and algorithms 2 and concurrency.
Topics for coding and algorithms are into Tress, Graphs
Concurrency round is all about implementing base modules