Add office photos
Filter interviews by
The Family Office Senior Data Engineer Interview Questions and Answers for Experienced
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
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
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Approached by Company and was interviewed in Jun 2024.
2 Interview Rounds
1
Coding Test Round
Python coding question and couple of SQL questions
2
Technical Round (3 Questions)
- Q1. Spark Optimization techniques View Answers (1)
- Q2. Current Project discussions Add Answer
- Q3. Difficulties I have faced during during ETL pipelines View Answers (1)
Skills evaluated in this interview
Interview experience
Bad
Difficulty level
Easy
Duration
Less than 2 weeks
Result
No response
I applied via Walk-in and was interviewed in Apr 2024.
2 Interview Rounds
1
Technical Round (3 Questions)
- Q1. No questions just asked to write SQL query and Python script. Not sure what they expect from it. Add Answer
- Q2. Write a SQL query View Answers (1)
- Q3. Write a Python program View Answers (1)
2
One-on-one Round (1 Question)
- Q1. Self intro and questions based on previous experiance Add Answer
Skills evaluated in this interview
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
Interview experience
Average
Difficulty level
Hard
Duration
Less than 2 weeks
Result
No response
I was interviewed in Jul 2023.
2 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
2
One-on-one Round (7 Questions)
- Q1. 1) Snowflake architecture in your current project. View Answers (1)
- Q2. 2) Database roles in Snowflake. View Answers (1)
- Q3. 3) Session Policy in Snowflake. View Answers (1)
- Q4. 4) Describe the SSO process between Snowflake and Azure Active Directory. View Answers (1)
- Q5. 5) Network Policy in Snowflake. View Answers (1)
- Q6. 6) Automatic data loading from pipes in to Snowflake. View Answers (1)
- Q7. 7) How does query acceleration speed up query processing? View Answers (2)
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
Selected
I applied via Company Website and was interviewed in Aug 2023.
1 Interview Round
1
Coding Test Round
Find duplicates in a list
Interview Preparation Tips
Interview preparation tips for other job seekers - Leetcode easy to medium questions, data warehousing concepts
Interview experience
Good
Difficulty level
Moderate
Duration
4-6 weeks
Result
Selected
I applied via Naukri.com and was interviewed before Jan 2023.
1 Interview Round
1
Technical Round (3 Questions)
- Q1. Rank types in SQL View Answers (1)
- Q2. Row_Number in sql server View Answers (1)
- Q3. Performance Tuning in sql View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Please prepare basics before going for interview
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Aug 2020.
4 Interview Rounds
Interview Questions
- Q1. Round 1-Sql based theoretical questions Round 2- sql coding questions Round 3- Project based questions Round 4-Project based questions
Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - For the logical round be very confident with string based logical sql question.
Like- How many , is there in the given sentence
Like- How many , is there in the given sentence
The Family Office Interview FAQs
How many rounds are there in The Family Office Senior Data Engineer interview for experienced candidates?
The Family Office interview process for experienced candidates usually has 1 rounds. The most common rounds in the The Family Office interview process for experienced candidates are Technical.
How to prepare for The Family Office Senior Data Engineer interview for experienced candidates?
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 for Experienced
Share an Interview