Upload Button Icon Add office photos

Filter interviews by

Infobell IT Solutions Data Engineer Interview Questions and Answers for Experienced

Updated 22 Sep 2022

Infobell IT Solutions Data Engineer Interview Experiences for Experienced

1 interview found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 22 Sep 2022

I applied via Naukri.com and was interviewed in Aug 2022. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. 1) Optimizations techniques used while working on Spark and hive. 2) difference between partitioning and bucketing 3) How to add column in Data frame 4) Difference between cache and persistent
  • Ans. 

    Answers to questions related to Spark, Hive, and Data Frames

    • Optimization techniques in Spark and Hive include partitioning, bucketing, and caching

    • Partitioning divides data into smaller, more manageable chunks while bucketing groups data based on a specific column

    • Adding a column to a Data Frame can be done using the 'withColumn' method

    • Caching stores data in memory for faster access while persistence stores data on disk

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. All questions related to current and previous projects. What is mean by ETL Day to day responsibilities

Interview Preparation Tips

Interview preparation tips for other job seekers - Should focus on job description. The technology they have mentioned should be prepared theoretically and practically. Some common tricky questions should be prepared.

Skills evaluated in this interview

Interview questions from similar companies

I was interviewed before Sep 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 140 minutes
Round difficulty - Medium

Test timing was at 2:00 pm , it was conducted in a college and the environment was good for the test. Camera was a primary part of test, so no suspicious activity.

  • Q1. 

    Sum of Two Numbers Represented as Arrays

    Given two numbers in the form of two arrays where each element of the array represents a digit, calculate the sum of these two numbers and return this sum as an ar...

  • Ans. 

    Given two numbers represented as arrays, calculate their sum and return the result as an array.

    • Iterate through the arrays from right to left, adding digits and carrying over if necessary

    • Handle cases where one array is longer than the other by considering the remaining digits

    • Ensure the final sum array does not have any leading zeros

  • Answered by AI
Round 2 - Face to Face 

Round duration - 20 minutes
Round difficulty - Easy

The round was conducted at around 12 p.m. I was called at the college location and then it was conducted. The interviewer was quite polite and frank.

Round 3 - HR 

Round duration - 8 minutes
Round difficulty - Easy

This round was conducted right after finishing and clearing the technical round at the same place and on the same day.

Interview Preparation Tips

Eligibility criteriaAbove 60 %Wipro Limited interview preparation:Topics to prepare for the interview - OOPS, Data Structures, Database Concepts, Coding problemsTime required to prepare for the interview - 2-3 monthsInterview preparation tips for other job seekers

Tip 1 : Practice atleast 2-3 Coding problems daily so your logic building becomes stronger.
Tip 2 : Exercise problems based on OOPS concepts and others too.
Tip 3 : If you can have your own project built, then it's the major point and will act as a plus point.

Application resume tips for other job seekers

Tip 1 : Your resume should be in standard form, short and simple will be more effective.
Tip 2 : Whatever you have learned, you need to mention it in your resume as that will be your primary source of selection and having project on your resume is important.

Final outcome of the interviewSelected

Skills evaluated in this interview

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

Interview Questionnaire 

1 Question

  • Q1. Hr

Interview Preparation Tips

Interview preparation tips for other job seekers - You should be true to what you are putting before the interviewer . Try to put your ideas Add something you did well in your career like in projects /research which you know very well and versed in concepts about it for open interview so that interviewer can get bandwidth where he can ask questions from. This is simply a key .

I applied via Campus Placement and was interviewed in Dec 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. 1.Describe a situation where you have taken a quick decision and failed, and a situation where you succeeded. 2. What is a skill you have tried to achieve but failed? 3. Describe a decision you have taken ...

Interview Preparation Tips

Interview preparation tips for other job seekers - 1. Always try to take risk in small problems . When you face the consequences, you would be able to tackle bigger problems.
2. Every skill you learn, even if you didn't excel in it is not to be considered a waste of time/failure, you learn something simply by participating.

I applied via Campus Placement and was interviewed before Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Tell me about Yourself, some questions related to machine learning, and I was asked more questions to differentiate like differences between ml and ai, python and c, c and java and procedural and functiona...

Interview Preparation Tips

Interview preparation tips for other job seekers - Get a complete grip on your resume and be confident about what you say, If you don't know the answer it is okay to agree that you don't know the answer so that interviewer can ask the next questions.

I applied via Job Portal and was interviewed before Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Oops Concepts,JAVA 8

Interview Preparation Tips

Interview preparation tips for other job seekers - Quite simple and easy. 1st round technical.2nd round HR

I applied via Campus Placement and was interviewed before Aug 2021. There were 2 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 - Coding Test 

Easy DSA questions and some questions on resume

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't join if you are a fresher and want to grow as a developer. I had resigned that time I am writing this review

I applied via Campus Placement and was interviewed in Mar 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. How do you get the second to last element from a SQL table?
  • Ans. 

    To get the second to last element from a SQL table, use the OFFSET-FETCH clause.

    • Use the ORDER BY clause to sort the table in descending order.

    • Use the OFFSET-FETCH clause to skip the last row and fetch the second to last row.

    • Example: SELECT column_name FROM table_name ORDER BY column_name DESC OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY;

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice by building a simple full stack web application.

Skills evaluated in this interview

I applied via Naukri.com and was interviewed before Aug 2021. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. C language and Java questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Be ready with good technical skills to face the interview

Interview Questionnaire 

1 Question

  • Q1. Drupal data migration

Infobell IT Solutions Interview FAQs

How many rounds are there in Infobell IT Solutions Data Engineer interview for experienced candidates?
Infobell IT Solutions interview process for experienced candidates usually has 2 rounds. The most common rounds in the Infobell IT Solutions interview process for experienced candidates are Technical.

Tell us how to improve this page.

Infobell IT Solutions Data Engineer Salary
based on 6 salaries
₹9.6 L/yr - ₹11 L/yr
5% less than the average Data Engineer Salary in India
View more details
Software Engineer
32 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Junior Software Engineer
13 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
12 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Junior Software Developer
7 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Information Technology Recruiter
7 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Infobell IT Solutions with

TCS

3.7
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare

Tech Mahindra

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