Upload Button Icon Add office photos
Engaged Employer

i

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

PBI Analytics Verified Tick

Compare button icon Compare button icon Compare
3.4

based on 13 Reviews

Filter interviews by

PBI Analytics Azure Data Engineer Interview Questions and Answers

Updated 10 Jun 2024

1 interview found

Sort by: Popular

Azure Data Engineer Interview Questions

user image Anonymous

posted on 10 Jun 2024

Interview experience
2
 Poor
Difficulty level
 Moderate
Duration
 6-8 weeks
Result
Selected  Selected

I applied via Naukri.com and was interviewed in May 2024.

1 Interview Round

1

One-on-one Round (2 Questions)

  • Q1. What are type of triggers
  • Q2. What is tumbling window trigger

Interview Preparation Tips

Interview preparation tips for other job seekers - Nooot good interviwer onky didnt join

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 Not Selected

I applied via Naukri.com and was interviewed in Nov 2024.

2 Interview Rounds

1

Technical Round (5 Questions)

  • Q1. How would you create a pipeline for ADLS to SQL data movement?
  • Q2. How would you create a pipeline from REST API to ADLS? What is there are 8 million rows of records?
  • Q3. IF data needs filtering, joining and aggregation, how would you do it with ADF?
  • Q4. Explain medallion architecture.
  • Q5. Explain medallion with databricks
2

HR Round (1 Question)

  • Q1. Basic questions and salary expectation.

Interview Preparation Tips

Topics to prepare for Capgemini Azure Data Engineer interview:
  • ADF
  • Databricks
Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via Recruitment Consulltant and was interviewed in Aug 2024.

3 Interview Rounds

1

Technical Round (4 Questions)

  • Q1. Lets say you have table 1 with values 1,2,3,5,null,null,0 and table 2 has null,2,4,7,3,5 What would be the output after inner join?
  • Q2. Lets say you have customers table with customerID and customer name, Orders table with OrderId and CustomerID. write a query to find the customer name who place...read more
  • Q3. Spark Architecture, Optimisation techniques
  • Q4. Some personal questions.
2

Technical Round (5 Questions)

  • Q1. Explain the entire architecture of a recent project you are working on in your organisation.
  • Q2. How do you design an effective ADF pipeline and what all metrics and considerations you should keep in mind while designing?
  • Q3. Lets say you have a very huge data volume and in terms of performance how would you slice and dice the data in such a way that you can boost the performance?
  • Q4. Lets say you have to reconstruct a table and we have to preserve the historical data ? ( i couldnt answer that but please refer to SCD)
  • Q5. We have adf and databricks both, i can achieve transformation , fetching the data and loading the dimension layer using adf also but why do we use databricks if...read more
3

HR Round (1 Question)

  • Q1. Basic HR questions

Interview Preparation Tips

Topics to prepare for Tech Mahindra Azure Data Engineer interview:
  • SQL
  • Databricks
  • Azure Data Factory
  • Pyspark
  • Spark
Interview preparation tips for other job seekers - The interviewers were really nice.

Skills evaluated in this interview

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 No response

I applied via Job Portal and was interviewed in Aug 2024.

2 Interview Rounds

1

Coding Test Round

Sql queries and knowledge of different syntaxes

2

One-on-one Round (2 Questions)

  • Q1. Find the student with marks greater than 80 in all subjects
  • Q2. Write the syntax to define the schema of a file for loading.
Interview experience
5
 Excellent
Difficulty level
 -
Duration
 -
Result
 -

2 Interview Rounds

1

Technical Round (2 Questions)

  • Q1. Activities used in ADF
  • Q2. Dataframes in pyspark
2

HR Round (2 Questions)

  • Q1. Managerial Questions
  • Q2. About project roles and resposibilities

Skills evaluated in this interview

Interview experience
4
 Good
Difficulty level
 -
Duration
 -
Result
Selected  Selected

I applied via Naukri.com

2 Interview Rounds

1

Technical Round (4 Questions)

  • Q1. Based on my previous company projects
  • Q2. SQL based questions are asked
  • Q3. ADF based questions are asked
  • Q4. Azure related questions are asked
2

HR Round (1 Question)

  • Q1. Reg salary discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - NA
Interview experience
3
 Average
Difficulty level
 Easy
Duration
 Less than 2 weeks
Result
 Not Selected

I applied via Recruitment Consulltant and was interviewed in Mar 2024.

1 Interview Round

1

Technical Round (4 Questions)

  • Q1. How are you connecting your onPerm from Azure?
  • Q2. What is Autoloader in Databricks?
  • Q3. How do you normalize your Json data
  • Q4. How do you read from Kafka?

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on core technical

Skills evaluated in this interview

Interview experience
1
 Bad
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via Company Website and was interviewed in Apr 2024.

1 Interview Round

1

Technical Round (2 Questions)

  • Q1. Challenges faced in production deployment
  • Q2. Tell me about your project

Skills evaluated in this interview

Interview experience
3
 Average
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 Not Selected

I applied via Approached by Company and was interviewed in Mar 2024.

1 Interview Round

1

Technical Round (2 Questions)

  • Q1. Basics of adf adb
  • Q2. What is IR in adf pipe line

Skills evaluated in this interview

Interview experience
5
 Excellent
Difficulty level
 -
Duration
 -
Result
Selected  Selected

3 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

Technical Round (1 Question)

  • Q1. Brief about your projects Be much prompt with your roles and responsibilities. Good to know SQL better
3

HR Round (1 Question)

  • Q1. Salary negotiation and about relocation

PBI Analytics Interview FAQs

How many rounds are there in PBI Analytics Azure Data Engineer interview?
PBI Analytics interview process usually has 1 rounds. The most common rounds in the PBI Analytics interview process are One-on-one Round.
How to prepare for PBI Analytics Azure 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 PBI Analytics. The most common topics and skills that interviewers at PBI Analytics expect are Data Warehousing, SQL and SSIS.
What are the top questions asked in PBI Analytics Azure Data Engineer interview?

Some of the top questions asked at the PBI Analytics Azure Data Engineer interview -

  1. What is tumbling window trig...read more
  2. What are type of trigg...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 PBI Analytics interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Data Analyst
5 salaries
unlock blur

₹2.1 L/yr - ₹4.5 L/yr

Data Engineer
5 salaries
unlock blur

₹4 L/yr - ₹6 L/yr

Explore more salaries
Compare PBI Analytics with

Fractal Analytics

4.0
Compare

Mu Sigma

2.7
Compare

Tiger Analytics

3.6
Compare

LatentView Analytics

3.7
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
write
Share an Interview