Add office photos
Filter interviews by
The Family Office Senior Data Engineer Interview Questions and Answers
Updated
31 Dec 2023
1 interview found
Sort by:
Popular
Anonymous
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Approached by Company and was interviewed in Dec 2023.
1 Interview Round
1
Technical Round (2 Questions)
- Q1. .Pyspark - 1.read a csv file in dataframe.
2. add a new column in the data frame with a default value.
3. add columns with split.
4. join mulitple dataframe. Add Answer
- Q2. What is the difficult task done by you. Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Prepared with coding mainly on pyspark and sql.
Senior Data Engineer Jobs at The Family Office
Top trending discussions
View All
Interview Tips & Stories
2w (edited)
a consultant
Alternate documents for Employee verification?
My new employer asked for my previous offer letters and salary slips. When I inquired, they said it was for background verification.
However, I feel that providing these documents might affect salary negotiations, and it feels a bit unethical too.
What alternative documents can I provide for employment verification?
Got a question about The Family Office?
Ask anonymously on communities.
Interview questions from similar companies
Interview experience
Good
Difficulty level
Easy
Duration
Less than 2 weeks
Result
No response
I applied via Naukri.com and was interviewed in Nov 2024.
1 Interview Round
1
Technical Round (6 Questions)
- Q1. Can you introduce yourself and describe your current project experience? View Answers (1)
- Q2. Decorators in python View Answers (1)
- Q3. What is the SQL query to group by employee ID in order to combine the first name and last name with a space? View Answers (1)
- Q4. What are constructors in Python? View Answers (1)
- Q5. Indexing in sql View Answers (1)
- Q6. Why spark works well with parquet files? View Answers (1)
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Naukri.com and was interviewed in Nov 2024.
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. All questions based on databricks and some pyspark , python , SQL only. Add Answer
- Q2. Learn windows function implementation in databricks note book. Add Answer
2
HR Round (1 Question)
- Q1. This round about your salary discussion around. Add Answer
Interview Preparation Tips
Topics to prepare for Accenture Senior Data Engineer interview:
- Python
- Pyspark
- SQL
- Databricks
Interview experience
Average
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Sql query to write max salary View Answers (1)
- Q2. What is dense rank in sql View Answers (1)
2
Technical Round (2 Questions)
- Q1. What is spark cluster View Answers (1)
- Q2. How hive works in hdfs View Answers (1)
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I was interviewed in Aug 2024.
3 Interview Rounds
1
Coding Test Round
Python and sql tasks
2
Technical Round (2 Questions)
- Q1. Project related questions Add Answer
- Q2. Coding questions on pyspark windows Add Answer
3
One-on-one Round (1 Question)
- Q1. Managerial discussions, mostly in and around the previous projects Add Answer
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I was interviewed in Sep 2024.
1 Interview Round
1
Technical Round (3 Questions)
- Q1. Coding in pyspark View Answers (1)
- Q2. Databricks optimisation technique View Answers (1)
- Q3. Aqe details in databricks View Answers (1)
Skills evaluated in this interview
Manoj Karan Singh
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in Sep 2024.
1 Interview Round
1
Coding Test Round
Spark Optimization, Transformation, DLT, DL, Data Governance
Python
SQL
Interview Preparation Tips
Interview preparation tips for other job seekers - Ingestion, Integration, Spark, Optimization, Python, SQL, Data Warehouse
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Naukri.com and was interviewed in May 2024.
2 Interview Rounds
1
Technical Round (1 Question)
- Q1. All medium level theory and SQL, python/pyspark code. Add Answer
2
Technical Round (1 Question)
- Q1. More in detail about tools and technologies, project handling, agile, CICD, scenario based. Add Answer
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
-
I applied via LinkedIn and was interviewed in Feb 2024.
3 Interview Rounds
1
Technical Round (2 Questions)
- Q1. How to work with nested json using pyspark View Answers (1)
- Q2. How to implement scd2 step by step View Answers (1)
2
Technical Round (2 Questions)
- Q1. Write a SQL query to select data from table 2 where data exists in table 1 View Answers (1)
- Q2. After performing joins how many records would be retrieved for inner, left, right and outer joins View Answers (1)
3
HR Round (1 Question)
- Q1. About previous company and reason for leaving Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Don't be afraid of giving interviews. Prepare well attend confidently if you clear it's an opportunity if you don't it's an experience!!
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Recruitment Consulltant and was interviewed in Mar 2024.
2 Interview Rounds
1
One-on-one Round (1 Question)
- Q1. How the files will be read in AWS GLUE View Answers (1)
2
Technical Round (2 Questions)
- Q1. How to get duplicate records View Answers (1)
- Q2. How to get the second highest salary Add Answer
Skills evaluated in this interview
The Family Office Interview FAQs
How many rounds are there in The Family Office Senior Data Engineer interview?
The Family Office interview process usually has 1 rounds. The most common rounds in the The Family Office interview process are Technical.
How to prepare for The Family Office Senior Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at The Family Office. The most common topics and skills that interviewers at The Family Office expect are Azure Data Factory, Clinical Data Management, Data Engineering, Data Ingestion and Data Integration.
Tell us how to improve this page.
Interview Questions for Popular Designations
- Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Senior Data Engineer Interview Questions from Similar Companies
The Family Office Company BSC - Senior Data Engineer - Data Pipeline (5-9 yrs)
5-9 Yrs
₹ 15-28 LPA
|
Data Scientist
3
salaries
|  ₹40.5 L/yr - ₹45 L/yr |
Explore more salaries
Compare The Family Office with
Edelweiss Private Wealth
Compare
IIFL Finance
Compare
Kotak Mahindra Bank
Compare
Motilal Oswal Wealth Management
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- The Family Office Interview Questions >
- The Family Office Senior Data Engineer Interview Questions
Share an Interview