Farfetch Data Engineer Interview Questions and Answers

Q1. Apache Spark and it's working
Add your answer
Q2. Past Experience
Add your answer

Q1. Git version control question
Add your answer
Q2. Python med DSA question
Add your answer

Python DSA Leetcode style questions, prepare.

Basic with python SQL and data models

Q1. Real life example
Ans. 
Developing a data pipeline to analyze customer behavior for an e-commerce company
• Collecting and storing customer data from website interactions

• Cleaning and transforming data to identify patterns and trends

• Building machine learning models to predict customer behavior

• Visualizing insights for stakeholders to make data-driven decisions
Answered by AI
Add your answer
Q2. Scenario based questions
Add your answer

Q1. Walk me through your resume
Ans. 
I have a strong background in data engineering with experience in various industries.
• Bachelor's degree in Computer Science with a focus on data engineering

• Worked as a Data Engineer at XYZ Company, where I developed and maintained data pipelines

• Implemented data quality checks and automated data validation processes

• Collaborated with cross-functional teams to design and implement scalable data solutions

• Experience with clo...read more
Answered by AI
Add your answer
Q2. Tell me why Facebook?
Ans. 
Facebook is a leading social media platform with vast user base and cutting-edge technology.
• Facebook has over 2.8 billion monthly active users, providing a massive data source for analysis and engineering.

• The company has a strong focus on innovation and constantly develops new technologies and tools.

• Facebook's data infrastructure is highly advanced, allowing for complex data processing and analysis.

• Working at Facebook ...read more
Answered by AI
Add your answer
Q3. Do you know what is Spark?
Ans. 
Spark is a distributed computing framework used for big data processing.
• Spark is an open-source project under Apache Software Foundation.

• It can process data in real-time and batch mode.

• Spark provides APIs for programming in Java, Scala, Python, and R.

• It can be used for various big data processing tasks like machine learning, graph processing, and SQL queries.

• Spark uses in-memory processing for faster data processing.
Answered by AI
Add your answer

Coding questions on SQL - given 2 tables, join and find the results after the join

1.Basic SQL
2. Python based question
3.Data modelling
4. Spark
5. Cloud based questions

Sql,Python,Data Modeling and Project based questions

Q1. Salary discussion and cultural fit.
Add your answer
Q2. Basic cultural fit.
Add your answer

Q1. Medium level DSA
Add your answer
Q2. 2 Medium SQL questions
Add your answer

Q1. Spark programming & Big Data concepts
Add your answer

Q1. Data Pipeline design
Add your answer

Q1. DE concepts, Previous Experience
Add your answer
Q2. Cultural and Team fitment
Add your answer

Q1. Study DSA SQL PYTHON
Add your answer

Q1. Study spark sql data warehousing
Add your answer

Q1. Hr managerial round
Add your answer

It was a mix of 1 coding question and MCQ's on topics like python, SQL, Git, Computer Networks, Linux etc.

Q1. This round was about SQL, Python the interviewer gave a problem and asked to write SQL query and they tested my SQL skills on basic concepts.
Add your answer
Q2. The interviewer asked to write python code for basic problems. This round was lasted about 40-45 mins
Add your answer

Q1. Again this round was focussed on my SQL skills the interviewer asked to write queries. SQL medium-hard level concepts. This lasted for 40-45 mins
Add your answer

Q1. This was final round the interviewer asked about everything I mentioned in my resume, behavioural questions, situational questions etc
Add your answer