Upload Button Icon Add office photos
Engaged Employer

i

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

Techigai Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Techigai Interview Questions and Answers

Updated 21 Mar 2023

Techigai Interview Experiences

Popular Designations

2 interviews found

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

I applied via Recruitment Consulltant and was interviewed in Feb 2023. 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 

(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...

  • Answered by AI
  • 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()

  • Answered by AI
  • Q3. Questions related to ADF based on your project.
Round 3 - Technical 

(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...

  • Answered by AI
  • 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

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well in SQL window functions and stored procedures. ADF questions will be asked based on your projects.

Skills evaluated in this interview

Azure Data Engineer Interview Questions asked at other Companies

Q1. 7. How can we load multiple(50)tables at a time using adf?
View answer (4)

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

Interview preparation tips for other job seekers - Prepare oops and simple programs

SDE (Software Development Engineer) Interview Questions asked at other Companies

Q1. A string is given consisting of lowercase alphabets. Write a function which returns yes if the string has all the lowercase letters appearing in it at least once. O(N) time and without using extra space
View answer (3)

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Sep 2020. There were 4 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Database related questions
  • Q2. Api
  • Q3. Two basic coding questions
  • Q4. Some apti based questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Just try to attempt all the sample questions available in geeks for geeks

I applied via Recruitment Consultant and was interviewed in Dec 2020. There were 3 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. API testing methods
  • Ans. 

    API testing methods involve functional, performance, security, and exploratory testing.

    • Functional testing ensures that the API meets the requirements and specifications.

    • Performance testing checks the API's response time, throughput, and resource utilization.

    • Security testing verifies the API's authentication, authorization, and encryption mechanisms.

    • Exploratory testing involves ad-hoc testing to discover defects and usa...

  • Answered by AI
  • Q2. Difference between sanity and smoke
  • Ans. 

    Sanity and Smoke are types of software testing. Sanity tests a specific functionality while Smoke tests the entire system.

    • Sanity testing is a narrow and deep testing approach while Smoke testing is a broad and shallow testing approach.

    • Sanity testing is performed after a small change in code while Smoke testing is performed after a major change in code.

    • Sanity testing is used to check if the critical functionalities are ...

  • Answered by AI
  • Q3. Difference between retesting and regression
  • Ans. 

    Retesting is testing the same functionality again after fixing the defects. Regression is testing the unchanged functionality after making changes.

    • Retesting is done to ensure that the defects have been fixed and the functionality is working as expected.

    • Regression is done to ensure that the changes made to the software have not affected the existing functionality.

    • Retesting is a subset of regression testing.

    • Retesting is ...

  • Answered by AI
  • Q4. Bug life cycle

Interview Preparation Tips

Interview preparation tips for other job seekers - It was technical based interview round.

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. SOLID principles examples in depth,given to design user management database in sql(just flow diagram,and in which table which value is used),some basic c# questions related to how you log in c#

I applied via Recruitment Consultant and was interviewed in Jul 2021. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Oops concepts

Interview Preparation Tips

Interview preparation tips for other job seekers - interview is nice and cool,be confident and honestly.
oops ,java ,c and data structure basics.

I applied via Approached by Company and was interviewed in Aug 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Covered OOP fundamentals and Java

Round 2 - HR 

(1 Question)

  • Q1. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - Read the study guide. it helps a lot

I applied via Naukri.com and was interviewed in Mar 2021. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. SQL window functions
  • Q2. Basic SQL queries
  • Q3. Basic Power BI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be kind and humble and don't cheat. The interview will be a cup of cake if you even have some decent experience. Just get your basic right. There won't be much scenarios and coding questions
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

2 coding question, 20 aptitude questions and english questions in 90 minutes

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

I applied via Campus Placement and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. Question related to oops
  • Q2. Question related to coding
  • Q3. I was rejected after 2nd round
Round 2 - Technical 

(2 Questions)

  • Q1. Question related to advanced topic in oops
  • Q2. Question related to coding

Techigai Interview FAQs

How many rounds are there in Techigai interview?
Techigai interview process usually has 3 rounds. The most common rounds in the Techigai interview process are Technical and Resume Shortlist.
How to prepare for Techigai 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 Techigai. The most common topics and skills that interviewers at Techigai expect are Javascript, SQL, HTML, .Net Core and Angular.
What are the top questions asked in Techigai interview?

Some of the top questions asked at the Techigai interview -

  1. What is incremental load and other types of loads? How do you implement increme...read more
  2. What are the error handling mechanisms in ADF pipelin...read more
  3. Implement IF Else activity in your pipeli...read more

Tell us how to improve this page.

Techigai Interview Process

based on 2 interviews

Interview experience

4.5
  
Good
View more

Interview Questions from Similar Companies

Affine Interview Questions
3.3
 • 49 Interviews
Cyfuture Interview Questions
3.0
 • 45 Interviews
IT By Design Interview Questions
3.6
 • 40 Interviews
Revature Interview Questions
3.5
 • 40 Interviews
ConsultAdd Interview Questions
3.5
 • 36 Interviews
View all

Techigai Reviews and Ratings

based on 37 reviews

3.8/5

Rating in categories

4.4

Skill development

3.8

Work-life balance

3.9

Salary

4.2

Job security

3.7

Company culture

3.8

Promotions

3.8

Work satisfaction

Explore 37 Reviews and Ratings
Software Engineer
48 salaries
unlock blur

₹7 L/yr - ₹16.1 L/yr

Senior Software Engineer
34 salaries
unlock blur

₹8.5 L/yr - ₹25 L/yr

Associate Software Engineer
26 salaries
unlock blur

₹3 L/yr - ₹8.5 L/yr

Data Engineer
13 salaries
unlock blur

₹5 L/yr - ₹12 L/yr

Software Developer
7 salaries
unlock blur

₹6 L/yr - ₹8 L/yr

Explore more salaries
Compare Techigai with

Maxgen Technologies

4.5
Compare

Cyfuture

3.0
Compare

Value Point Systems

3.7
Compare

JoulestoWatts Business Solutions

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