Impetus Technologies Interview Questions, Process, and Tips

Q1. Is passible map-reduce have 0 reducer ?
Ans. 
Yes, it is possible to have a MapReduce job with 0 reducers.
• In some cases, the output of the map phase may not require any further processing or aggregation, so having 0 reducers is sufficient.

• For example, if the goal of the MapReduce job is simply to filter out certain data points based on a condition, there may be no need for a reducer.

• Having 0 reducers can also be useful for jobs where the output of the map phase is...read more
Answered by AI
Add your answer
Q2. Write code in spark
Ans. 
Code in Spark for Big Data Engineer Lead interview
• Use SparkSession to create a Spark application

• Read data from a source like HDFS or S3

• Perform transformations and actions on the data using Spark RDDs or DataFrames

• Write the processed data back to a sink like HDFS or S3
Answered by AI
Add your answer

Html5 tags, CSS box model, pseudo selectors in CSS, map v/s forEach, map v/s filter, objects, arrow functions, shallow copy v/s deep copy difference, hoisting, promises

Q1. React Hooks, functional components
Add your answer
Q2. What are promises? React hooks-based questions like useState, useEffect, useMemo? Asked to create a form in react with various type of inputs
Add your answer

Q1. Spark archicture and cluster configurations explanation
Ans. 
Spark architecture involves master-slave setup with driver and executor nodes. Cluster configurations include memory allocation, cores allocation, and parallelism settings.
• Spark architecture consists of a master node (driver) and multiple worker nodes (executors)

• Cluster configurations involve setting memory allocation for driver and executors, specifying number of cores per executor, and adjusting parallelism settings

• E...read more
Answered by AI
Add your answer
Q2. Python code, basic to intermediate
Add your answer
Q3. Sql question basic to intermediate
Add your answer

Q1. Cluster conf and scenerio based question
Add your answer
Q2. Sql and python scenerio based questions
Add your answer

Q1. Arrange the list item in python
Ans. 
Use the sort() method to arrange list items in Python.
• Use the sort() method to arrange list items in ascending order: list_name.sort()

• Use the sort() method with reverse=True parameter to arrange list items in descending order: list_name.sort(reverse=True)

• Use the sorted() function to return a new sorted list without modifying the original list: sorted_list = sorted(list_name)
Answered by AI
Add your answer

Q1. Will you ready to work from anywhere
Add your answer

Q1. Questions were about Ansible, Linux, A bit about Cloud (AWS, Azure)
Add your answer
Q2. Second round person was not aware if which position is this and were clueless of questions so he asked any random question from any irrelevant topic
Add your answer
Q3. At last hR dint get back to me and i had to call them just to hear a no
Add your answer

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...read more
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...read more
Answered by AI
Add your answer
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
Add your answer
Q3. Python List based questions Python Dictionaries based questions
Add your answer

Q1. Same Kind of questions and the same level of difficulty but another technical person took the interview
Add your answer

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...read more
Add your answer