Vidyarthi Vigyan Manthan Senior Data Analyst Interview Questions and Answers

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...read more
Answered by AI
Add your answer

The first round had 3 parts which had technical(code snippets,dbms etc), aptitude, english

Basic questions on arrays and strings

Q1. This is yet to happen
Add your answer

Q1. SQL window function
Add your answer
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
Answered by AI
Add your answer

Q1. Basic skill discussion
Add your answer
Q2. Basic work experience discussion
Add your answer

Q1. Behavioural questions
Add your answer
Q2. Questions to understand cultural fit
Add your answer

Q1. Complex sql question based on lead lag
Add your answer
Q2. Question based on data index
Add your answer
Q3. Question based on data engineer
Add your answer

Q1. About ETL performance and mapping
Add your answer
Q2. About SQL advanced Query
Add your answer

Hacker rank test mostly on sql

Q1. Focused on Statistical analysis and sql. More sql questions on window functions
Add your answer
Q2. Sql joins and aggregation functions
Add your answer

Q1. Sql question based on window functions
Add your answer