Add office photos
Filter interviews by
Empor Marcom LLP Senior Data Analyst Interview Questions and Answers
Empor Marcom LLP Senior Data Analyst Interview Experiences
1 interview found
Anonymous
Selected
I was interviewed before Dec 2021.
10 questions of advance Excel .15 questions in 1 hour
(2 Questions)
- Q1. After successfully completed round 1 .go for face to face round .
- Q2. 1.Vlookup ? 2. Extract mail id from text entry ?
- Ans.
1. Vlookup is a function in Excel used to search for a specific value in a table and return a corresponding value. 2. To extract email id from text entry, we can use a combination of functions like LEFT, RIGHT, FIND, and LEN.
Vlookup is used to find a value in a table and return a corresponding value from the same row.
Syntax: VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
To extract email id from text ...
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Selected
I applied via Walk-in and was interviewed in Dec 2024. There were 5 interview rounds.
(1 Question)
- Q1. Resume screening Self introduction Roles and responsibilities
Given task Statics standard deviations Attrition Average of given table values and Given graph economi graph and poverty graph base on that need to gave answers 30 qustion and 60 min time duration
(2 Questions)
- Q1. Versant test should be need to attend Hirepro will have interview prosess in YouTube will check and prepare mid level hard
- Q2. We can goo for online prosess how it is
(1 Question)
- Q1. Manger Level round they will ask KPI NPS AHT standard deviations Service Level handling Root cause Analysis Weighted average Same product how will calculate Totall Swer % how will get Many of like bpi <20 ...
(1 Question)
- Q1. Salary discussion and update structure of our role and responsibilities
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
(5 Questions)
- Q1. What about your self?
- Q2. Family background
- Q3. Power BI test and advanced excel
- Q4. Microsoft access test
- Q5. Python test and One to one discussion with super boss
kanika jain
(1 Question)
- Q1. Tell me about Spark architecture
- Ans.
Spark architecture is a distributed computing framework that consists of a cluster manager and worker nodes.
Spark architecture includes a driver program, cluster manager, and worker nodes.
The driver program is responsible for dividing the Spark application into tasks and scheduling them on the worker nodes.
Worker nodes execute the tasks and return the results to the driver program.
Spark can run on various cluster manag...
I applied via campus placement at CMR Institute of Technology, Bangalore and was interviewed in Sep 2024. There were 3 interview rounds.
The first round had 3 parts which had technical(code snippets,dbms etc), aptitude, english
Basic questions on arrays and strings
(1 Question)
- Q1. This is yet to happen
Selected
I applied via Naukri.com and was interviewed in Mar 2024. There were 3 interview rounds.
(2 Questions)
- Q1. SQL window function
- Q2. Python data mining of unstructured data
- Ans.
Python data mining of unstructured data involves extracting valuable insights from text, images, videos, etc.
Use Python libraries like NLTK, spaCy, and scikit-learn for text mining
Utilize techniques like natural language processing (NLP) and machine learning for data extraction
Preprocess data by tokenizing, stemming, and removing stop words before analysis
(2 Questions)
- Q1. Basic skill discussion
- Q2. Basic work experience discussion
(2 Questions)
- Q1. Behavioural questions
- Q2. Questions to understand cultural fit
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
(2 Questions)
- Q1. About ETL performance and mapping
- Q2. About SQL advanced Query
Interview Preparation Tips
(2 Questions)
- Q1. What is clustering? And how do you check if a ML model is performing well?
- Ans.
Clustering is a machine learning technique used to group similar data points together. Model performance can be checked using evaluation metrics like silhouette score or inertia.
Clustering is the process of dividing a set of data points into groups based on their similarities.
Common clustering algorithms include K-means, hierarchical clustering, and DBSCAN.
To check if a ML model is performing well, evaluation metrics l...
- Q2. Explain the difference between Arithmetic mean, Harmonic mean and Geometric mean?
- Ans.
Arithmetic mean is the sum of all values divided by the number of values. Harmonic mean is the reciprocal of the arithmetic mean of the reciprocals of the values. Geometric mean is the nth root of the product of n values.
Arithmetic mean is most commonly used and is calculated by summing all values and dividing by the number of values.
Harmonic mean is used when dealing with rates or ratios, and is calculated by taking t...
Skills evaluated in this interview
manthena saivarma
Selected
I applied via Naukri.com and was interviewed in Mar 2024. There were 2 interview rounds.
Hacker rank test mostly on sql
(2 Questions)
- Q1. Focused on Statistical analysis and sql. More sql questions on window functions
- Q2. Sql joins and aggregation functions
I applied via Recruitment Consulltant and was interviewed in Jun 2024. There was 1 interview round.
(1 Question)
- Q1. Sql question based on window functions
Empor Marcom LLP Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Data Scientist Interview Questions
- Data Analyst Intern Interview Questions
- Senior Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Associate Data Analyst Interview Questions
- Jr. Data Scientist Interview Questions
- Data Analyst Interview Questions
- Associate Data Scientist Interview Questions
- Show more
Senior Data Analyst Interview Questions from Similar Companies
Empor Marcom LLP Senior Data Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Research Associate
14
salaries
|  ₹2 L/yr - ₹3 L/yr |
|
Assistant Manager
5
salaries
| ₹2.5 L/yr - ₹5.2 L/yr |
|
Research Analyst
5
salaries
| ₹2.3 L/yr - ₹4.5 L/yr |
|
HR Executive
4
salaries
| ₹2 L/yr - ₹4.6 L/yr |
|
Assistant Team Leader
3
salaries
| ₹3 L/yr - ₹3.5 L/yr |
TCS
Accenture
Wipro
Cognizant
- Home >
- Interviews >
- Empor Marcom LLP Interview Questions >
- Empor Marcom LLP Senior Data Analyst Interview Questions
