Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by phData Team. If you also belong to the team, you can get access from here

phData Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

phData Associate Data Engineer Interview Questions and Answers

Updated 26 Aug 2024

phData Associate Data Engineer Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Aug 2023. There were 3 interview rounds.

Round 1 - Coding Test 

Pen and paper test that included writing SQL queries. And there was a basic programing question for which you could only use python or java.There was also a google form with MCQs of computer fundamentals.

Round 2 - Technical 

(3 Questions)

  • Q1. Resume based questions
  • Q2. Pillars of Object oriented programing
  • Ans. 

    Pillars of OOP are Inheritance, Encapsulation, Abstraction, and Polymorphism.

    • Inheritance allows a class to inherit properties and behaviors from another class.

    • Encapsulation restricts access to certain components of an object, protecting its integrity.

    • Abstraction hides complex implementation details and only shows necessary features.

    • Polymorphism allows objects to be treated as instances of their parent class.

  • Answered by AI
  • Q3. Given a node value in a linked list, delete the node.
  • Ans. 

    To delete a node in a linked list, update the pointers of the previous node to skip the node to be deleted.

    • Traverse the linked list to find the node to be deleted.

    • Update the pointers of the previous node to skip the node to be deleted.

    • Free the memory allocated to the node to be deleted.

  • Answered by AI
Round 3 - Technical 

(2 Questions)

  • Q1. Resume based round and questions on project
  • Q2. A few mangerial questions.

Skills evaluated in this interview

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Sep 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist 
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
Round 2 - Technical 

(1 Question)

  • Q1. 1. Types of cloud 2.Different Activity in ADF 3.Advance SQL 4.Basic OPPS concepts
  • Ans. 

    Questions related to cloud types, ADF activities, advanced SQL, and basic OOPs concepts.

    • Types of cloud include public, private, and hybrid

    • ADF activities include data ingestion, transformation, and loading

    • Advanced SQL includes window functions, subqueries, and joins

    • Basic OOPs concepts include encapsulation, inheritance, and polymorphism

  • Answered by AI
Round 3 - Behavioral 

(1 Question)

  • Q1. 1. Secenario bases case study. 2.Performance tuning in Datebases and warehouse. 3.SQL Logics

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and and answer to the point as per knowledge and experience and understanding.
Talk about past work experiences

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. NLP based question
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Sep 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. SQL problems to solve nth highest salary
  • Ans. 

    Use SQL query with subquery to find nth highest salary

    • Use ORDER BY and LIMIT to get the nth highest salary

    • Use a subquery to exclude the top n-1 salaries before selecting the nth highest salary

  • Answered by AI
Round 2 - One-on-one 

(1 Question)

  • Q1. GCP big query Architecture

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(4 Questions)

  • Q1. Components of Databricks
  • Ans. 

    Databricks is a unified data analytics platform that includes components like Databricks Workspace, Databricks Runtime, and Databricks Delta.

    • Databricks Workspace: Collaborative environment for data science and engineering teams.

    • Databricks Runtime: Optimized Apache Spark cluster for data processing.

    • Databricks Delta: Unified data management system for data lakes.

  • Answered by AI
  • Q2. How to read a json file
  • Ans. 

    To read a JSON file, use a programming language's built-in functions or libraries to parse the file and extract the data.

    • Use a programming language like Python, Java, or JavaScript to read the JSON file.

    • Import libraries like json in Python or json-simple in Java to parse the JSON data.

    • Use functions like json.load() in Python to load the JSON file and convert it into a dictionary or object.

    • Access the data in the JSON fi...

  • Answered by AI
  • Q3. Second highest salary SQL
  • Ans. 

    To find the second highest salary in SQL, use the MAX function with a subquery or the LIMIT clause.

    • Use the MAX function with a subquery to find the highest salary first, then use a WHERE clause to exclude it and find the second highest salary.

    • Alternatively, use the LIMIT clause to select the second highest salary directly.

    • Make sure to handle cases where there may be ties for the highest salary.

  • Answered by AI
  • Q4. How to configure the spark while creating the cluster
  • Ans. 

    Spark cluster configuration involves setting up memory, cores, and other parameters for optimal performance.

    • Specify the number of executors and executor memory

    • Set the number of cores per executor

    • Adjust the driver memory based on the application requirements

    • Configure shuffle partitions for efficient data processing

    • Enable dynamic allocation for better resource utilization

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Jan 2024. There were 3 interview rounds.

Round 1 - Coding Test 

Basics of SQL, Python

Round 2 - Coding Test 

Experience based questions, SQL and Python

Round 3 - One-on-one 

(2 Questions)

  • Q1. Tell me about the projects you worked on
  • Ans. 

    I have worked on projects involving building data pipelines, optimizing data storage, and developing machine learning models.

    • Built data pipelines using Apache Spark and Airflow

    • Optimized data storage by implementing partitioning and indexing strategies

    • Developed machine learning models for predictive analytics

  • Answered by AI
  • Q2. Based on experience some questions related to projects.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Spark and airflow related questions
  • Q2. AWS services and it's related questions
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. How to build data pipeline
  • Ans. 

    Building a data pipeline involves extracting, transforming, and loading data from various sources to a destination for analysis.

    • Identify data sources and determine the data to be collected

    • Extract data from sources using tools like Apache NiFi or Apache Kafka

    • Transform data using tools like Apache Spark or Python scripts

    • Load data into a destination such as a data warehouse or database

    • Schedule and automate the pipeline fo...

  • Answered by AI
  • Q2. IICS

I applied via LinkedIn and was interviewed in Jun 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Technical Questions were easy. No coding questions just on architecture level and basic system design questions were asked

Interview Preparation Tips

Interview preparation tips for other job seekers - Got selected in interview. However offer was not released. Time to time HR would call to check whether I am serving notice. "You were searching from long time, still you don't have any other offer yet ". This shows HR team just want to hire someone who is already serving notice irrespective of the rounds cleared
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Tell me about yourself, second highest salary , question related to coleasce function

phData Interview FAQs

How many rounds are there in phData Associate Data Engineer interview?
phData interview process usually has 3 rounds. The most common rounds in the phData interview process are Technical and Coding Test.
How to prepare for phData Associate 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 phData . The most common topics and skills that interviewers at phData expect are Machine Learning, Python, Analytical, Application Development and Big Data.
What are the top questions asked in phData Associate Data Engineer interview?

Some of the top questions asked at the phData Associate Data Engineer interview -

  1. Given a node value in a linked list, delete the no...read more
  2. Pillars of Object oriented program...read more
  3. Resume based round and questions on proj...read more

Tell us how to improve this page.

phData Associate Data Engineer Interview Process

based on 2 interviews

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Mu Sigma Interview Questions
2.6
 • 229 Interviews
Tiger Analytics Interview Questions
3.7
 • 222 Interviews
Fractal Analytics Interview Questions
4.0
 • 204 Interviews
HCL Infosystems Interview Questions
3.9
 • 140 Interviews
Axtria Interview Questions
3.1
 • 115 Interviews
Webdew Interview Questions
4.5
 • 106 Interviews
HyScaler Interview Questions
4.5
 • 91 Interviews
View all
phData Associate Data Engineer Salary
based on 19 salaries
₹2 L/yr - ₹8 L/yr
14% less than the average Associate Data Engineer Salary in India
View more details

phData Associate Data Engineer Reviews and Ratings

based on 2 reviews

4.6/5

Rating in categories

4.4

Skill development

5.0

Work-life balance

4.4

Salary

4.4

Job security

5.0

Company culture

4.0

Promotions

4.4

Work satisfaction

Explore 2 Reviews and Ratings
Data Engineer
35 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Data Engineer
21 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Data Engineer
19 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Solution Architect
13 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Devops Engineer
10 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare phData with

Fractal Analytics

4.0
Compare

Mu Sigma

2.6
Compare

LatentView Analytics

3.7
Compare

Tiger Analytics

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview