GetMega Performance Marketing Manager Interview Questions and Answers

Q1. SQL on joins , partition, rank dense rank
Add your answer
Q2. Case study on guestimation
Add your answer

Q1. Experience in marketing and sales
Ans. 
I have over 5 years of experience in marketing and sales, including developing strategies, managing campaigns, and driving revenue growth.
• Developed and implemented marketing strategies to increase brand awareness and drive sales

• Managed advertising campaigns across various channels to reach target audiences

• Analyzed market trends and competitor activities to identify opportunities for growth

• Collaborated with sales teams ...read more
Answered by AI
Add your answer
Q2. Introduction and experience details
Add your answer

Q1. Question About Logistic
Add your answer
Q2. About previous co.
Add your answer

Q1. About the contribution in co.
Add your answer
Q2. Logistic and sales
Add your answer

Discussion with president of co.

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

Q1. SQL based questions
Add your answer
Q2. Guesstimate on estimating # users on the application
Ans. 
Estimate the number of users on the application based on market research, user demographics, and industry trends.
• Consider the total addressable market (TAM) for the application

• Analyze user demographics and behavior to estimate adoption rate

• Look at industry benchmarks and competitor data for reference

• Use surveys, focus groups, and user feedback to gather insights

• Consider factors like market saturation, growth potential,
Answered by AI
Add your answer

SQL based leetcode medium and hackerrank

Python take home EDA case study assessment

Easy coding questions

Tough level questions , needed high level of thinking