Highbar Technocrat Associate Consultant Interview Questions and Answers

Q1. Interview based on your programming language , how good you know like java or python or scala
Add your answer
Q2. Big data & Data science interview question like working of spark , Hive optimization of queries , what is graphx
Add your answer
Q3. Explain your recent project in detail
Add your answer

Q1. More deep dive in your expertise technologies like Spark DAG working explain
Add your answer
Q2. How you do data validation in hive
Ans. 
Data validation in Hive involves using built-in functions and custom scripts to ensure data accuracy and consistency.
• Use built-in functions like IS NULL, IS NOT NULL, and COALESCE to check for missing or null values

• Use regular expressions and pattern matching to validate data formats

• Write custom scripts to perform more complex data validation tasks

• Perform data profiling to identify potential data quality issues

• Use data...read more
Answered by AI
Add your answer

Q1. Salary , why changing job etc..
Add your answer
Q2. Your complete background of career
Add your answer

Round duration - 50 minutes
Round difficulty - Medium

Round duration - 20 minutes
Round difficulty - Medium

Q1. 
Pair Sum Problem Statement
You are given an integer array 'ARR' of size 'N' and an integer 'S'. Your task is to find and return a list of all pairs of elements where each sum of a pair equals 'S'.
Note:
...read more
Ans. 
Given an array and a target sum, find pairs of elements that add up to the target sum.
• Iterate through the array and for each element, check if the complement (target sum - current element) exists in a hash set.

• If the complement exists, add the pair to the result list. Otherwise, add the current element to the hash set.

• Sort the pairs based on the first element and then the second element to meet the required output form
Answered by AI
Add your answer

Round duration - 20 minutes
Round difficulty - Easy

Round duration - 40 minutes
Round difficulty - Hard

Q1. Can you provide an example of how to use pointers in C/C++ and discuss different concepts related to them?
Ans. 
Pointers in C/C++ are variables that store memory addresses. They are used to manipulate memory directly and improve performance.
• Pointers are declared using an asterisk (*) before the variable name.

• Pointers can be used to dynamically allocate memory using functions like malloc() and free().

• Pointers can be used to pass variables by reference to functions.
Answered by AI
Add your answer

Q1. Basics of python, project related questions
Add your answer
Q2. Basic SQL, few simple problem solving questions
Add your answer

Q1. Interests, hobbies ,general HR questions
Add your answer
Q2. Expected hike, salary, work timings preferred
Add your answer

Q1. Oops concepts, core java
Add your answer
Q2. Java 8 stream api and lambda
Add your answer

Round duration - 70 Minutes
Round difficulty - Hard

Q1. 
Candies Distribution Problem Statement
Prateek is a kindergarten teacher with a mission to distribute candies to students based on their performance. Each student must get at least one candy, and if two s...read more
Ans. 
The task is to distribute candies to students based on their performance while minimizing the total candies distributed.
• Create an array to store the minimum candies required for each student.

• Iterate through the students' ratings array to determine the minimum candies needed based on the adjacent ratings.

• Consider both left-to-right and right-to-left passes to ensure fair distribution.

• Keep track of the total candies dist
Answered by AI
Add your answer
Q2. 
Merge Sort Problem Statement
You are given a sequence of numbers, ARR. Your task is to return a sorted sequence of ARR in non-descending order using the Merge Sort algorithm.
Explanation:
The Merge Sort...read more
Ans. 
Implement Merge Sort algorithm to sort a sequence of numbers in non-descending order.
• Use Divide and Conquer approach to recursively divide the input array into two halves.

• Merge the sorted halves to produce a completely sorted array.

• Ensure the implementation handles the constraints specified in the problem statement.

• Example: For input [3, 1, 4, 1, 5], the output should be [1, 1, 3, 4, 5].
Answered by AI
Add your answer

Aptitude test

Current affairs

Q1. Puzzle , sql related questions
Add your answer