AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Random Trees Associate Data Engineer Interview Questions and Answers
Random Trees Associate Data Engineer Interview Experiences
1 interview found
Hari Pamidi
Selected
I appeared for an interview before Jul 2024, where I was asked the following questions.
- Q1. What are window functions in SQL, and how do they differ from aggregate functions?
- Q2. What is the difference between @staticmethod and @classmethod in Python
Top trending discussions
Interview questions from similar companies
Selected
I applied via Campus Placement and was interviewed before May 2022. There were 5 interview rounds.
It was a coding round with sql ,python questions , few aptitude questions
(2 Questions)
- Q1. They asked few questions sql and python and few questions - depending on the role
- Q2. BASIC SQL WHAT YOU HAD WRITTEN IN THE CODE
- Ans.
Basic SQL involves writing queries to manage and manipulate relational databases effectively.
SELECT statement: Used to retrieve data from a database. Example: SELECT * FROM employees;
WHERE clause: Filters records based on specified conditions. Example: SELECT * FROM employees WHERE age > 30;
JOIN operations: Combines rows from two or more tables based on a related column. Example: SELECT * FROM orders JOIN customers ...
(2 Questions)
- Q1. They asked me few questions related to sql
- Q2. BASIC PYTHON QUESTIONS LIKE WHAT YOU HAVE WRITTEN IN THE CODE
(1 Question)
- Q1. About yourself , your hobby etc
Interview Preparation Tips
Selected
I applied via Referral and was interviewed in May 2024. There were 4 interview rounds.
Python and SQL questions were asked
(1 Question)
- Q1. I was asked about the project
(1 Question)
- Q1. ACID properties of DBMS
- Ans.
ACID properties ensure data integrity in DBMS: Atomicity, Consistency, Isolation, Durability.
Atomicity ensures that all operations in a transaction are completed successfully or none at all.
Consistency ensures that the database remains in a consistent state before and after the transaction.
Isolation ensures that multiple transactions can be executed concurrently without affecting each other.
Durability ensures that once...
(1 Question)
- Q1. HR question and family background
Interview Preparation Tips
- SQL
- Python
Reasoning and aptitude questions were asked
(1 Question)
- Q1. Interview was around python programming and team fitment
Easy and moderate level question
Given a relevant topic and discussion on it
(2 Questions)
- Q1. Introducd yourself
- Q2. Why do you want to join us
I applied via Campus Placement and was interviewed in Jun 2024. There was 1 interview round.
This was my first campus drive,& it was one of the hardest one too.We had 3 coding problems for 60 mins.It was held on HackerRank & it was not so hard but not so easy for the beginners.
1)Lambda Sort
2) and 3) ques on SQL
It was different ques for each one.
Interview Preparation Tips
- Python
- MySQL
nandini Singh
(1 Question)
- Q1. The interviewer asked all the concepts of pyspark, ETL and a code on dsa
Data Engineer Interview Questions & Answers
Quantiphi Analytics Solutions Private Limited
Anonymous
posted on 12 Oct 2023
Question related to quantitative aptitude
(1 Question)
- Q1. Questions related to coading
Data Engineer Interview Questions & Answers
Quantiphi Analytics Solutions Private Limited
Anonymous
posted on 29 Nov 2023
Selected
I applied via Recruitment Consulltant and was interviewed in Oct 2023. There were 4 interview rounds.
(1 Question)
- Q1. Interviewer gave 2 tables and asked me to write pyspark code to generate output in required format.
- Ans.
Pyspark code to join and transform two tables for desired output format.
Use Spark DataFrame API to read the tables.
Perform join operations based on common keys.
Utilize select and withColumn to format the output.
Example: df1.join(df2, 'key').select('column1', 'column2')
(1 Question)
- Q1. Few optimization techniques on Spark were asked
(1 Question)
- Q1. General discussion
Interview Preparation Tips
- Databricks
- Pyspark
- Python
- SQL
- Azure Data Factory
Data Engineer Interview Questions & Answers
Quantiphi Analytics Solutions Private Limited
Anonymous
posted on 17 Apr 2024
A bit difficult Aptitude questions
(1 Question)
- Q1. SQl , python, and normal interview questions
Random Trees Interview FAQs
Tell us how to improve this page.
Random Trees Interviews By Designations
- Random Trees Data Engineer Interview Questions
- Random Trees Data Analyst Interview Questions
- Random Trees Senior Software Engineer Interview Questions
- Random Trees Business Analyst Interview Questions
- Random Trees Sdet Engineer Interview Questions
- Random Trees Associate Data Engineer Interview Questions
Interview Questions for Popular Designations
- Software Engineer Interview Questions
- Assistant Manager Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Data Engineer Interview Questions
- Project Engineer Interview Questions
- Associate Consultant Interview Questions
- Senior Data Engineer Interview Questions
- Show more
Overall Interview Experience Rating
based on 1 interview experience
Difficulty level
Duration
Interview Questions from Similar Companies
Random Trees Associate Data Engineer Reviews and Ratings
based on 2 reviews
Rating in categories
|
Data Engineer
36
salaries
|  ₹3.6 L/yr - ₹8 L/yr |
|
Data Scientist
23
salaries
| ₹8.6 L/yr - ₹18.5 L/yr |
|
Software Developer
8
salaries
| ₹4.1 L/yr - ₹10.9 L/yr |
|
Senior Software Engineer
7
salaries
| ₹11.7 L/yr - ₹24 L/yr |
|
Software Engineer
6
salaries
| ₹3.1 L/yr - ₹22 L/yr |
CMS IT Services
iMerit
Quantiphi Analytics Solutions Private Limited
PrimEra Medical Technologies
- Home >
- Interviews >
- Random Trees Interview Questions
