AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Infosys
Compare
Filter interviews by
Infosys Data Engineer Interview Questions, Process, and Tips for Experienced
Top Infosys Data Engineer Interview Questions and Answers for Experienced
- Q1. What is the process of performing ETL (Extract, Transform, Load), and can you provide an example?
- Q2. How to join 2 datasets if one is much larger than the other
- Q3. What are examples of iaas,paas,saas
Infosys Data Engineer Interview Experiences for Experienced
6 interviews found
Anonymous
- Q1. How to join 2 datasets if one is much larger than the other
- Q2. What is the process of performing ETL (Extract, Transform, Load), and can you provide an example?
- Ans.
ETL is a data integration process that involves extracting data, transforming it for analysis, and loading it into a target system.
Extract: Gather data from various sources like databases, APIs, or flat files. Example: Pulling customer data from a CRM system.
Transform: Clean and format the data to meet business requirements. Example: Converting date formats or aggregating sales data.
Load: Insert the transformed data in...
Param Nikhil
(1 Question)
- Q1. Mostly on Spark
Selected
I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.
(2 Questions)
- Q1. What are examples of iaas,paas,saas
- Ans.
Examples of IaaS, PaaS, and SaaS include AWS (IaaS), Google App Engine (PaaS), and Salesforce (SaaS).
IaaS - Infrastructure as a Service: AWS, Microsoft Azure, Google Cloud Platform
PaaS - Platform as a Service: Google App Engine, Heroku, Microsoft Azure App Service
SaaS - Software as a Service: Salesforce, Google Workspace, Microsoft Office 365
- Q2. Difference between Adf and ADB
- Ans.
ADF stands for Azure Data Factory, a cloud-based data integration service. ADB stands for Azure Databricks, an Apache Spark-based analytics platform.
ADF is used for data integration and orchestration, while ADB is used for big data analytics and machine learning.
ADF provides a visual interface for building data pipelines, while ADB offers collaborative notebooks for data exploration and analysis.
ADF supports various da...
Skills evaluated in this interview
Mataparthi Raghavendra Rao
(1 Question)
- Q1. Different ADF activities used by me
- Ans.
Some ADF activities include Copy Data, Execute Pipeline, Lookup, and Web Activity.
Copy Data activity for moving data between sources and sinks
Execute Pipeline activity for running another pipeline within a pipeline
Lookup activity for retrieving data from a dataset
Web Activity for calling a web service or API
Skills evaluated in this interview
Infosys interview questions for designations
Someshwar Kolluru
(1 Question)
- Q1. Datafactory, databricks sample questions
Interview Questionnaire
3 Questions
- Q1. Spark optimizations
- Q2. Last project work in and your role
- Q3. Basic aws services and use case
Interview Preparation Tips
Data Engineer Jobs at Infosys
What people are saying about Infosys
Interview questions from similar companies
I applied via Campus Placement and was interviewed in Aug 2020. There were 4 interview rounds.
Interview Questionnaire
4 Questions
- Q1. Best sorting although and its working they asked
- Q2. Write a program to replace the character with another character in java.
- Ans.
A program to replace a character with another character in Java.
Create a string variable with the original text
Use the replace() method to replace the character with another character
Print the new string with the replaced character
- Q3. SQL queries on order by, group by, and it's difference they asked.
- Q4. Project management experience they asked.
Interview Preparation Tips
Skills evaluated in this interview
I applied via Campus Placement and was interviewed in Jan 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Swap two number with and without temporary variable
- Ans.
Swap two numbers with and without temporary variable
Without temporary variable: Use addition and subtraction
With temporary variable: Use a third variable to store the value of one of the numbers
Example without temporary variable: a=5, b=7; a=a+b; b=a-b; a=a-b;
Example with temporary variable: a=5, b=7; temp=a; a=b; b=temp;
Interview Preparation Tips
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Oct 2020. There was 1 interview round.
Interview Questionnaire
3 Questions
- Q1. What is second level cache?How to implement second level cache?How to optimize sql query?what are solid principles?
- Ans.
Second level cache is a caching mechanism used to improve performance by storing frequently accessed data in memory.
Second level cache is implemented at the application level and can be configured using frameworks like Hibernate.
To optimize SQL queries, one can use indexes, avoid using SELECT *, and use JOINs instead of subqueries.
SOLID principles are a set of design principles for writing maintainable and scalable cod...
- Q2. Mostly FAQ but somewhat in depth?
- Q3. How to deploy application in aws?
- Ans.
To deploy an application in AWS, you need to create an EC2 instance, configure security groups, install necessary software, and upload your application code.
Create an EC2 instance in the desired region and select the appropriate instance type
Configure security groups to allow traffic to and from the instance
Install necessary software and dependencies on the instance
Upload your application code to the instance
Start the ...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Company Website and was interviewed before Aug 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. What is my longterm and short-term goals.
- Ans. My short-term is to become an expert in solving queries And long term is to become valuable employee in an organisation and managing a team, also helping new recruits to learn the work.
Interview Preparation Tips
Infosys Interview FAQs
Some of the top questions asked at the Infosys Data Engineer interview for experienced candidates -
Tell us how to improve this page.
Infosys Interviews By Designations
- Infosys System Engineer Interview Questions
- Infosys Software Engineer Interview Questions
- Infosys Technology Analyst Interview Questions
- Infosys Senior Systems Engineer Interview Questions
- Infosys Associate Consultant Interview Questions
- Infosys Software Developer Interview Questions
- Infosys Business Analyst Interview Questions
- Infosys Senior Associate Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Database Admin Interview Questions
- Senior Software Engineer Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Infosys Data Engineer Interview Process for Experienced
based on 5 interviews
1 Interview rounds
- Technical Round
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
Infosys Data Engineer Reviews and Ratings
based on 87 reviews
Rating in categories
|
Technology Analyst
55.4k
salaries
|  ₹3 L/yr - ₹11.2 L/yr |
|
Senior Systems Engineer
51.2k
salaries
| ₹2.5 L/yr - ₹8 L/yr |
|
System Engineer
31.7k
salaries
| ₹2.5 L/yr - ₹5.5 L/yr |
|
Technical Lead
31k
salaries
| ₹5.1 L/yr - ₹19.6 L/yr |
|
Senior Associate Consultant
28.8k
salaries
| ₹6.2 L/yr - ₹16.9 L/yr |
TCS
Wipro
Cognizant
Accenture
- Home >
- Interviews >
- Infosys Interview Questions >
- Infosys Data Engineer Interview Questions for Experienced
