Head Digital Works Market Analyst Interview Questions and Answers

General coding questions

Q1. Related technical question
Add your answer

Q1. Write a sql query
Ans. 
SQL query to retrieve employee names and their salaries from a table
• Use SELECT statement to retrieve data

• Specify the columns you want to retrieve (employee names and salaries)

• Specify the table name where the data is stored
Answered by AI
Add your answer
Q2. Formula of vlookup
Ans. 
VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value.
• VLOOKUP searches for a value in the first column of a table and returns a value in the same row from a specified column.

• The formula syntax is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in cell A2 in the range B2:D10 and return the...read more
Answered by AI
Add your answer

Round duration - 90 Minutes
Round difficulty - Medium

The first round was scheduled in the evening time.
First of all interviewer introduced himself and after my introduction 
He directly shoot first DSA question. The question was easy but conceptual. I have solved some question with same concept and he ask me to share the screen and code in online compiler. Finally I was able to get correct output with all the use cases and I was like "Half work done!"
Then he asked me very core concepts of JavaScript along with that Some Output based questions.
Then finally he asked me theory questions on React along with my experience in React. 
The interviewer was very helpful as well as polite. I don't think if he will not help me during interview I could crack the interview

Q1. 
Is the Sentence a Pangram?
Ninja is relocating to a place called NinjaGram, and for school admission, he is required to identify if a given sentence is a pangram. Your task is to assist Ninja in determini...read more
Ans. 
Yes, the sentence is a pangram if it includes every letter of the English alphabet at least once.
• Check if the sentence contains all 26 letters of the English alphabet.

• Convert the sentence to lowercase to simplify the checking process.

• Use a set to keep track of the letters present in the sentence.

• Iterate through the sentence and add each unique letter to the set.

• After iterating, check if the set contains all 26 letters.
Answered by AI
Add your answer

Contained aptitude test with both numericals as well as coding questions

It was a one on one round

Q1. Final discussion
Add your answer
Q2. If ready to relocate
Ans. 
Yes, I am open to relocation for the right opportunity.
• I am willing to relocate for a job that aligns with my career goals and offers growth opportunities.

• I am open to exploring new cities and cultures.

• I understand that relocation may come with some challenges, but I am prepared to face them.

• I am excited about the prospect of working with a new team and contributing to the success of the company.
Answered by AI
Add your answer

Q1. 2 DSA questions was asked and Java Questions
Add your answer

Q1. Questions on Kafka, Scalability
Add your answer

Q1. Questions releated to past projects and Cassandra
Add your answer