Premium Employer

i

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

Impetus Technologies Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Impetus Technologies Big Data Engineer Interview Questions, Process, and Tips

Updated 14 Dec 2022

Top Impetus Technologies Big Data Engineer Interview Questions and Answers

  • Q1. Difference between partitioning and bucketing. Types of joins in spark Optimization Techniques in spark Broadcast variable and broadcast join Difference between ORC and P ...read more
  • Q2. Second round: spark how to handle upserts in spark
  • Q3. SQL question Remove duplicate records 5th highest salary department wise
View all 6 questions

Impetus Technologies Big Data Engineer Interview Experiences

4 interviews found

I applied via Naukri.com and was interviewed in Jun 2022. There were 4 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 Resume tips
Round 2 - Technical 

(3 Questions)

  • Q1. Difference between partitioning and bucketing. Types of joins in spark Optimization Techniques in spark Broadcast variable and broadcast join Difference between ORC and Parquet Difference between RDD and D...
  • Ans. 

    Explaining partitioning, bucketing, joins, optimization, broadcast variables, ORC vs Parquet, RDD vs Dataframe, project architecture and responsibilities for Big Data Engineer role.

    • Partitioning is dividing data into smaller chunks for parallel processing, while bucketing is organizing data into buckets based on a hash function.

    • Types of joins in Spark include inner join, outer join, left join, right join, and full outer...

  • Answered by AI
  • Q2. SQL question Remove duplicate records 5th highest salary department wise
  • Ans. 

    Remove duplicate records and find 5th highest salary department wise using SQL.

    • Use DISTINCT keyword to remove duplicate records.

    • Use GROUP BY clause to group the records by department.

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

    • Use LIMIT clause to get the 5th highest salary.

    • Combine all the above clauses to get the desired result.

  • Answered by AI
  • Q3. Python List based questions Python Dictionaries based questions
Round 3 - Technical 

(1 Question)

  • Q1. Same Kind of questions and the same level of difficulty but another technical person took the interview
Round 4 - HR 

(1 Question)

  • Q1. General HR Discussions They will try to understand our area of interest They will explain learning opportunities in the company Give a brief about benefits and work culture Finally most important part is S...

Interview Preparation Tips

Interview preparation tips for other job seekers - Very friendly interview and we must be confident with the skills we had mentioned in the resume.
For me, they asked questions mostly from SQL, Pyspark, and some basic python coding(List, Dict)

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Jul 2021. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. First round Spark: why and how accumulators Why and how reparation and coalesce How spark will generate code and executes Which operation executes where ( let's df2=df1.filter.map.collection d...
  • Q2. Second round: spark how to handle upserts in spark
  • Ans. 

    Spark can handle upserts using merge() function

    • Use merge() function to handle upserts in Spark

    • Specify the primary key column(s) to identify matching rows

    • Specify the update column(s) to update existing rows

    • Specify the insert column(s) to insert new rows

    • Example: df1.merge(df2, on='id', whenMatched='update', whenNotMatched='insert')

  • Answered by AI
  • Q3. Worst HR and time waste.. don't take it as final offer. Keep backup offer if u got offere here

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't go.. time waste

Skills evaluated in this interview

Big Data Engineer Interview Questions Asked at Other Companies

Q1. Difference between partitioning and bucketing. Types of joins in ... read more
asked in TCS
Q2. What optimization techniques have you utilized in your projects? ... read more
Q3. Checking whether a fibonacci number is present between a particuk ... read more
asked in TCS
Q4. What is the difference between lineage and directed acyclic graph ... read more
asked in TCS
Q5. What is the difference between cache and persistence?

I applied via Naukri.com and was interviewed in Jun 2021. There were 4 interview rounds.

Interview Questionnaire 

6 Questions

  • Q1. Tell me about your self.
  • Q2. Java collection vs collections
  • Ans. 

    Java collection is a single interface while collections is a utility class.

    • Java collection is an interface that provides a unified architecture for manipulating and storing groups of objects.

    • Collections is a utility class that provides static methods for working with collections.

    • Java collection is a part of the Java Collections Framework while collections is not.

    • Examples of Java collections include List, Set, and Map w...

  • Answered by AI
  • Q3. You know
  • Q4. Spark memory optimisation techniques
  • Ans. 

    Spark memory optimisation techniques

    • Use broadcast variables to reduce memory usage

    • Use persist() or cache() to store RDDs in memory

    • Use partitioning to reduce shuffling and memory usage

    • Use off-heap memory to avoid garbage collection overhead

    • Tune memory settings such as spark.driver.memory and spark.executor.memory

  • Answered by AI
  • Q5. Hive megastore
  • Q6. Hadoop serialisation techniques.
  • Ans. 

    Hadoop serialisation techniques are used to convert data into a format that can be stored and processed in Hadoop.

    • Hadoop uses Writable interface for serialisation and deserialisation of data

    • Avro, Thrift, and Protocol Buffers are popular serialisation frameworks used in Hadoop

    • Serialisation can be customised using custom Writable classes or external libraries

    • Serialisation plays a crucial role in Hadoop performance and ef

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be good in technical. You basic concepts should be good.
Analytical thinking 🤔.

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Jan 2021. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Can't tell specifics. But expect questions starting from basics till the advance level. And the major point is that your basic understanding has to be very good.

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be yourself. They are looking for passionate people who are serious about what they do and are also good at it, be it anything.

Impetus Technologies interview questions for designations

 Big Data Engineer Lead

 (1)

 Data Engineer

 (11)

 Senior Data Engineer

 (2)

 Gcp Data Engineer

 (1)

 Associate Data Engineer

 (1)

 Data Scientist

 (1)

 Data Analyst

 (1)

 Software Engineer

 (9)

Big Data Engineer Jobs at Impetus Technologies

View all

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 Other and was interviewed before Nov 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. What is bigdata
  • Ans. 

    Big data refers to large and complex data sets that cannot be processed using traditional data processing tools.

    • Big data is characterized by the 3Vs - volume, velocity, and variety.

    • It requires specialized tools and technologies such as Hadoop, Spark, and NoSQL databases.

    • Big data is used in various industries such as healthcare, finance, and retail to gain insights and make data-driven decisions.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Not a good persons are there

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

Impetus Technologies Interview FAQs

How many rounds are there in Impetus Technologies Big Data Engineer interview?
Impetus Technologies interview process usually has 4 rounds. The most common rounds in the Impetus Technologies interview process are Technical, HR and Resume Shortlist.
How to prepare for Impetus Technologies Big 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 Impetus Technologies. The most common topics and skills that interviewers at Impetus Technologies expect are Big Data, Spark, Python, Hive and Hadoop.
What are the top questions asked in Impetus Technologies Big Data Engineer interview?

Some of the top questions asked at the Impetus Technologies Big Data Engineer interview -

  1. Difference between partitioning and bucketing. Types of joins in spark Optimiza...read more
  2. Second round: spark how to handle upserts in sp...read more
  3. SQL question Remove duplicate records 5th highest salary department w...read more

Recently Viewed

SALARIES

Atos

SALARIES

Commonwealth Bank of Australia, India

DESIGNATION

JOBS

Wipro

No Jobs

INTERVIEWS

Micron Technology

No Interviews

JOBS

Varuna Integrated Logistics

No Jobs

SALARIES

Quantiphi Analytics Solutions Private Limited

INTERVIEWS

Wipro

10 top interview questions

JOBS

Balasore Alloys

No Jobs

SALARIES

TCS

Tell us how to improve this page.

Join Impetus Technologies The Intelligent Enterprise Delivered
Impetus Technologies Big Data Engineer Salary
based on 45 salaries
₹6.9 L/yr - ₹29 L/yr
55% more than the average Big Data Engineer Salary in India
View more details

Impetus Technologies Big Data Engineer Reviews and Ratings

based on 6 reviews

3.2/5

Rating in categories

2.9

Skill development

4.1

Work-life balance

3.5

Salary

4.3

Job security

3.5

Company culture

3.1

Promotions

3.4

Work satisfaction

Explore 6 Reviews and Ratings
Bigdata Engineers

Gurgaon / Gurugram,

Bangalore / Bengaluru

3-8 Yrs

Not Disclosed

Bigdata Engineers

Gurgaon / Gurugram,

Bangalore / Bengaluru

3-6 Yrs

₹ 15-29 LPA

J2EE and BigData Engineer

Bangalore / Bengaluru

5-10 Yrs

Not Disclosed

Explore more jobs
Senior Software Engineer
701 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
540 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Module Lead Software Engineer
276 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Module Lead
249 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Lead Software Engineer
201 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Impetus Technologies with

Persistent Systems

3.5
Compare

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

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