ElasticRun Senior Manager Interview Questions and Answers

Case study related to marketing

Q1. Window sum in sql
Ans. 
Window sum in SQL is a way to calculate the sum of a specific column over a specified window of rows.
• Use the OVER clause with the SUM function to calculate window sum.

• Specify the window frame using ROWS or RANGE keyword.

• Example: SELECT column_name, SUM(column_name) OVER (ORDER BY column_name ROWS BETWEEN 3 PRECEDING AND CURRENT ROW) AS window_sum FROM table_name;
Answered by AI
Add your answer
Q2. Tableau related questions
Add your answer

Q1. Expectations and general hr queries
Add your answer

Q1. Normal profile and industry related questions
Add your answer
Q2. Normal industry related questions
Add your answer

Q1. Can you provide a brief introduction about yourself?
Ans. 
Experienced Senior Executive with a proven track record in leading teams and driving business growth.
• Over 10 years of experience in senior leadership roles

• Strong strategic planning and decision-making skills

• Proven ability to drive revenue growth and increase profitability

• Effective team leader with a focus on collaboration and communication
Answered by AI
Add your answer
Q2. Work experience
Add your answer

Knowledge of Excel and participation in meetings.

Q1. What are your salary expectations?
Ans. 
I am looking for a competitive salary commensurate with my experience, skills, and the responsibilities of the role.
• Research industry standards and salary ranges for similar positions

• Consider the cost of living in the area where the job is located

• Factor in benefits, bonuses, and potential for growth within the company
Answered by AI
Add your answer
Q2. Hr policy
Add your answer

Q1. How to identify and solve race condition.
Ans. 
Identifying and solving race conditions involves understanding concurrent execution and implementing synchronization mechanisms.
• Understand the critical sections of code where race conditions can occur

• Use synchronization mechanisms like locks, semaphores, or atomic operations to control access to shared resources

• Implement thread-safe data structures or use thread-safe libraries to avoid race conditions

• Use tools like sta...read more
Answered by AI
Add your answer
Q2. Solve an array question on finding the third largest in an unsorted array.
Ans. 
Find the third largest element in an unsorted array of strings.
• Sort the array in descending order.

• Remove duplicates if necessary.

• Return the element at index 2 as the third largest.
Answered by AI
Add your answer

Q1. Only salf introduced
Add your answer
Q2. Have you reduced it before or not
Add your answer