AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Techigai
Compare
Filter interviews by
Techigai Interview Questions, Process, and Tips
Top Techigai Interview Questions and Answers
- Q1. What is incremental load and other types of loads? How do you implement incremental load in your ADF pipeline?asked in Azure Data Engineer interview
- Q2. What are the error handling mechanisms in ADF pipelines?asked in Azure Data Engineer interview
- Q3. Implement IF Else activity in your pipeline.asked in Azure Data Engineer interview
Techigai Interview Experiences
2 interviews found
Anonymous
Selected
I applied via Recruitment Consulltant and was interviewed in Feb 2023. There were 3 interview rounds.
(3 Questions)
- Q1. What are the error handling mechanisms in ADF pipelines?
- Ans.
ADF pipelines have several error handling mechanisms to ensure data integrity and pipeline reliability.
ADF provides built-in retry mechanisms for transient errors such as network connectivity issues or service outages.
ADF also supports custom error handling through the use of conditional activities and error outputs.
Error outputs can be used to redirect failed data to a separate pipeline or storage location for further...
- Q2. Sql queries using window functions
- Ans.
Window functions are used to perform calculations across a set of rows in a table.
Window functions are used to calculate values based on a subset of rows within a table
They are used to perform calculations such as running totals, ranking, and moving averages
Examples of window functions include ROW_NUMBER(), RANK(), and SUM() OVER()
- Q3. Questions related to ADF based on your project.
(3 Questions)
- Q1. Advanced level SQL queries
- Q2. What is incremental load and other types of loads? How do you implement incremental load in your ADF pipeline?
- Ans.
Incremental load is a process of updating only the new or changed data in a target system. Other types of loads include full load and delta load.
Incremental load reduces the time and resources required to update the target system.
Full load loads all the data from the source system to the target system.
Delta load loads only the changed data from the source system to the target system.
In ADF pipeline, incremental load ca...
- Q3. Implement IF Else activity in your pipeline.
- Ans.
IF Else activity can be implemented using the Switch activity in Azure Data Factory.
Create a Switch activity in your pipeline
Define the condition in the expression field
Add cases for each condition with corresponding activities
Add a default activity for cases that do not match any condition
Interview Preparation Tips
Skills evaluated in this interview
Azure Data Engineer Interview Questions asked at other Companies
I applied via Campus Placement and was interviewed in Aug 2021. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Simple programming questions
Interview Preparation Tips
SDE (Software Development Engineer) Interview Questions asked at other Companies
Top trending discussions
Interview questions from similar companies
I applied via Referral and was interviewed before Jan 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Java questions
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Feb 2021. There were 3 interview rounds.
Aptitude round consists Logical reasoning, General Aptitude, Grammar related questions etc. All are moderate level questions.
(3 Questions)
- Q1. Explain OOPs w.r.t Java
- Ans.
OOPs is a programming paradigm that uses objects to represent real-world entities. Java is an OOPs language.
OOPs stands for Object-Oriented Programming System
Java is a class-based OOPs language
Encapsulation, Inheritance, Polymorphism, and Abstraction are the four pillars of OOPs
Objects have state and behavior
Java supports interfaces, which allow for multiple inheritance
Example: A car can be represented as an object wit...
- Q2. Explain about the projects that you have worked on
- Q3. Explain how Java solves machine dependency of code execution
- Ans.
Java solves machine dependency by using bytecode and virtual machine.
Java code is compiled into bytecode which is platform-independent
The bytecode is executed by the Java Virtual Machine (JVM) which is platform-specific
JVM translates bytecode into machine code for the specific platform
This allows Java code to run on any platform with a JVM installed
Example: A Java program compiled on Windows can run on Linux or Mac as
(2 Questions)
- Q1. Why should we hire you?
- Q2. Tell me about yourself.
Interview Preparation Tips
- Java
Skills evaluated in this interview
I applied via Campus Placement and was interviewed before May 2021. There were 2 interview rounds.
Numerical ability and logical reasoning followed by some coding mcqs
(1 Question)
- Q1. Print 1 to 100 without for loop
- Ans.
Printing 1 to 100 without for loop
Use recursion to print numbers from 1 to 99
Print 100 outside the recursion
Use a base case to stop recursion at 100
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Jun 2021. There were 2 interview rounds.
Simple aptitude test
(1 Question)
- Q1. General questions as per your cv
Interview Preparation Tips
- Aptitude
I applied via Campus Placement and was interviewed before Aug 2021. There were 2 interview rounds.
It was a basic aptitude test.
(1 Question)
- Q1. Interview was fine. Mostly asked about my final year project.
Interview Preparation Tips
I applied via Newspaper Ad and was interviewed before Jun 2021. There were 3 interview rounds.
(1 Question)
- Q1. Basic questions of java.
(1 Question)
- Q1. Intro and other hr related questions.
Interview Preparation Tips
I applied via Naukri.com and was interviewed before Jun 2021. There were 2 interview rounds.
English is the main focussed part
(1 Question)
- Q1. Basic introduction and project based questions.
Interview Preparation Tips
Arham Khokhar
I applied via Company Website and was interviewed before Apr 2021. There were 2 interview rounds.
It's totally based on Basic understanding of concepts such as Linear arrangement, circular arrangement، blood relation, direction sense, ratio proportion, time, speed, distance
(3 Questions)
- Q1. It's based on OOPS Concepts,
- Q2. Strength and weaknesses
- Q3. About yourself, about educational background, why should we hire you
Interview Preparation Tips
Techigai Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
Techigai Interview Process
based on 2 interviews
Interview experience
Interview Questions from Similar Companies
Techigai Reviews and Ratings
based on 37 reviews
Rating in categories
|
Software Engineer
48
salaries
|  ₹7 L/yr - ₹16.1 L/yr |
|
Senior Software Engineer
34
salaries
| ₹8.5 L/yr - ₹25 L/yr |
|
Associate Software Engineer
27
salaries
| ₹3 L/yr - ₹8.5 L/yr |
|
Data Engineer
13
salaries
| ₹5 L/yr - ₹12 L/yr |
|
Software Developer
7
salaries
| ₹6 L/yr - ₹8 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- Techigai Interview Questions
