Premium Employer

i

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

Infosys Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Infosys Azure Data Engineer Interview Questions and Answers

Updated 9 Jan 2025

Infosys Azure Data Engineer Interview Experiences

2 interviews found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Dec 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. SCD type 1 and SCD type 2 in databircks
  • Ans. 

    SCD type 1 overwrites existing data, while SCD type 2 maintains historical data

    • SCD type 1 updates existing records with new information, losing historical data

    • SCD type 2 creates new records for changes, preserving historical data with effective start and end dates

    • In Databricks, SCD type 1 can be implemented using overwrite function, while SCD type 2 can be implemented using merge function

  • Answered by AI
  • Q2. How to pass parameters form ADF to ADB
  • Ans. 

    Parameters can be passed from Azure Data Factory (ADF) to Azure Data Factory (ADB) using linked services and datasets.

    • Create a linked service in ADF to connect to ADB

    • Define parameters in ADF pipeline and pass them to ADB activities

    • Use dynamic content expressions to pass parameters between ADF and ADB

    • Example: Pass a parameter for a SQL query in ADB from ADF pipeline

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well on basics of dataenigineer
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Challenges faced in production deployment
  • Ans. 

    Challenges in production deployment include scalability, data consistency, and monitoring.

    • Ensuring scalability to handle increasing data volumes and user loads

    • Maintaining data consistency across different databases and systems

    • Implementing effective monitoring and alerting to quickly identify and resolve issues

  • Answered by AI
  • Q2. Tell me about your project
  • Ans. 

    Developed a data pipeline to ingest, process, and analyze customer feedback data for a retail company.

    • Used Azure Data Factory to orchestrate data flow

    • Implemented Azure Databricks for data processing and analysis

    • Utilized Azure Synapse Analytics for data warehousing

    • Generated visualizations using Power BI for insights

    • Implemented machine learning models for sentiment analysis

  • Answered by AI

Skills evaluated in this interview

Azure Data Engineer Interview Questions Asked at Other Companies

asked in TCS
Q1. 7. How can we load multiple(50)tables at a time using adf?
asked in KPMG India
Q2. Difference between RDD, Dataframe and Dataset. How and what you h ... read more
asked in Techigai
Q3. What is incremental load and other types of loads? How do you imp ... read more
asked in TCS
Q4. 2. What is the get metadata activity and what are the parameters ... read more
asked in KPMG India
Q5. What are key components in ADF? What all you have used in your pi ... read more

Azure Data Engineer Jobs at Infosys

View all

Interview questions from similar companies

I applied via Company Website and was interviewed before Oct 2019. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basics of c, matrix multiplication, sql,he said to write group by query and swapping program without using third variable

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well with basics of the mentioned languages in the resume.

I applied via Campus Placement and was interviewed before Oct 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions Will be asked as per your CV

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with all the elements written in CV

I appeared for an interview before Jul 2021.

Round 1 - Technical 

(4 Questions)

  • Q1. What is Polymorphism and it’s type?
  • Ans. 

    Polymorphism is the ability of an object to take on many forms. It allows objects of different classes to be treated as if they were of the same class.

    • Polymorphism is achieved through method overriding and method overloading.

    • Method overriding is when a subclass provides a specific implementation of a method that is already provided by its parent class.

    • Method overloading is when a class has two or more methods with the ...

  • Answered by AI
  • Q2. What is Dependency Injection?
  • Ans. 

    Dependency Injection is a design pattern where the dependencies of an object are injected into it rather than created within it.

    • It helps in achieving loose coupling between objects

    • It makes testing easier as dependencies can be mocked or stubbed

    • There are three types of Dependency Injection - Constructor Injection, Setter Injection, and Interface Injection

    • Example: In a web application, the database connection object can ...

  • Answered by AI
  • Q3. How Garbage Collection works in .Net?
  • Ans. 

    Garbage Collection in .Net automatically manages memory by freeing up unused objects.

    • Garbage Collector runs in the background and periodically checks for unused objects.

    • It frees up memory by deallocating objects that are no longer being used.

    • GC can be configured using different modes like Server, Workstation, Concurrent, etc.

    • GC can also be manually triggered using GC.Collect() method.

    • GC.SuppressFinalize() method can be...

  • Answered by AI
  • Q4. What is LINQ and some basic concept related it?

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was easy. Go through basic concepts of OOPs and SQL.

Skills evaluated in this interview

I applied via Company Website and was interviewed before Jul 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

The first round is an aptitude online test that had Basics of Computer Science, Mathematics, English and then finally one basic program to code and compile like Palindrome.

Round 2 - Group Discussion 

Three panellists were present and it was a face-face round, Panellist 1 and 2 takes the technical discussions like classes, inheritance, oops concept, basic syntax, and such. Panellist 3 talks more about your resume skills, hobbies and the company overview.

Interview Preparation Tips

Topics to prepare for TCS System Engineer interview:
  • Basic Promgramming Questions
  • Aptitiude
Interview preparation tips for other job seekers - Since this was my first job it was slightly challenging in several ways in terms of how to present yourself, confidence and such. But make sure to stay humble and agree to most of the requests made and stick to the resume.

I applied via Campus Placement and was interviewed before Aug 2021. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. What is Data Structure?
  • Ans. 

    Data structure is a way of organizing and storing data in a computer so that it can be accessed and used efficiently.

    • Data structures are used to manage large amounts of data efficiently.

    • They can be implemented using arrays, linked lists, trees, graphs, and other techniques.

    • Examples include stacks, queues, hash tables, and binary search trees.

    • Choosing the right data structure for a particular problem is important for op...

  • Answered by AI
  • Q2. Real time use of stack and Queue?
  • Ans. 

    Stack and Queue are used in real-time systems for managing tasks and events.

    • Stack is used for managing function calls, undo/redo operations, and backtracking.

    • Queue is used for managing events, scheduling tasks, and buffering data.

    • Real-time systems use both data structures for managing tasks and events in a time-sensitive manner.

    • Examples include task scheduling in operating systems, event handling in GUI applications, a

  • Answered by AI

Interview Preparation Tips

Topics to prepare for TCS Software Engineer interview:
  • C
  • C++
  • Java
  • Pyth
Interview preparation tips for other job seekers - 1 hr C/ python Programming, Debugging, Programming, Networking

Skills evaluated in this interview

I applied via Walk-in and was interviewed before Apr 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. .Net related technical questions
Round 3 - HR 

(3 Questions)

  • Q1. Tell me about yourself.
  • Q2. What are your strengths and weaknesses?
  • Q3. What are your salary expectations?

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well basic concepts like OOPs

Interview Questionnaire 

1 Question

  • Q1. Basic questions in C and oops concepts

Interview Preparation Tips

Interview preparation tips for other job seekers - Be calm and answer bold.

Interview Questionnaire 

1 Question

  • Q1. Basic questions of C and C++, then H.R questions, time management

Infosys Interview FAQs

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

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

  1. How to pass parameters form ADF to ...read more
  2. Challenges faced in production deploym...read more
  3. SCD type 1 and SCD type 2 in databir...read more

Tell us how to improve this page.

Infosys Azure Data Engineer Interview Process

based on 3 interviews

Interview experience

3
  
Average
View more
Join Infosys Creating the next opportunity for people, businesses & communities
Infosys Azure Data Engineer Salary
based on 293 salaries
₹2.5 L/yr - ₹12 L/yr
25% less than the average Azure Data Engineer Salary in India
View more details

Infosys Azure Data Engineer Reviews and Ratings

based on 18 reviews

3.4/5

Rating in categories

3.7

Skill development

3.3

Work-life balance

2.5

Salary

3.8

Job security

3.2

Company culture

2.6

Promotions

3.3

Work satisfaction

Explore 18 Reviews and Ratings
Azure Data Engineer

Hyderabad / Secunderabad,

Chennai

+1

5-9 Yrs

Not Disclosed

Azure Data Engineer

Pune,

Chennai

+1

5-9 Yrs

Not Disclosed

Explore more jobs
Technology Analyst
55.4k salaries
unlock blur

₹3 L/yr - ₹11 L/yr

Senior Systems Engineer
51k salaries
unlock blur

₹2.5 L/yr - ₹7.8 L/yr

System Engineer
31.6k salaries
unlock blur

₹2.5 L/yr - ₹5.5 L/yr

Technical Lead
30.9k salaries
unlock blur

₹5.1 L/yr - ₹19.5 L/yr

Senior Associate Consultant
28.5k salaries
unlock blur

₹6.2 L/yr - ₹17 L/yr

Explore more salaries
Compare Infosys with

TCS

3.7
Compare

Wipro

3.7
Compare

Cognizant

3.7
Compare

Accenture

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