Upload Button Icon Add office photos

Filter interviews by

Techtitans Solutions Azure Data Engineer Interview Questions and Answers

Updated 15 Oct 2024

1 interview found

Sort by: Popular

Azure Data Engineer Interview Questions

user image Anonymous

posted on 14 Oct 2024

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

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

2 Interview Rounds

1

Technical Round (2 Questions)

  • Q1. Moderate level questions
  • Q2. How to find max value and min value in PySpark
2

Coding Test Round

How to duplicate value find?

Interview Preparation Tips

Interview preparation tips for other job seekers - Good friendly nature

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
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
5
 Excellent
Difficulty level
 Moderate
Duration
 4-6 weeks
Result
 No response

I applied via Referral and was interviewed in May 2024.

1 Interview Round

1

Technical Round (2 Questions)

  • Q1. What is polybase?
  • Q2. Explain your current project architecture.
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
 -

3 Interview Rounds

1

Technical Round (1 Question)

  • Q1. Spark Architecture
2

Technical Round (2 Questions)

  • Q1. Explain your project
  • Q2. Remove duplicates
3

HR Round (1 Question)

  • Q1. Salary expectations

Skills evaluated in this interview

Techtitans Solutions Interview FAQs

How many rounds are there in Techtitans Solutions Azure Data Engineer interview?
Techtitans Solutions interview process usually has 2 rounds. The most common rounds in the Techtitans Solutions interview process are Technical and Coding Test.
What are the top questions asked in Techtitans Solutions Azure Data Engineer interview?

Some of the top questions asked at the Techtitans Solutions Azure Data Engineer interview -

  1. how to find max value and min value in PySp...read more
  2. Moderate level questi...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Techtitans Solutions interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Devops Engineer
6 salaries
unlock blur

₹5.6 L/yr - ₹10 L/yr

Software Engineer
5 salaries
unlock blur

₹3.5 L/yr - ₹9 L/yr

Senior Software Engineer
5 salaries
unlock blur

₹7.2 L/yr - ₹15 L/yr

Softwaretest Engineer
5 salaries
unlock blur

₹3 L/yr - ₹7.5 L/yr

Java Developer
4 salaries
unlock blur

₹3 L/yr - ₹8 L/yr

Explore more salaries
Compare Techtitans Solutions with

TCS

3.7
Compare

Accenture

3.9
Compare

Wipro

3.7
Compare

Cognizant

3.8
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