SG Analytics Data Associate Interview Questions and Answers

Q1. How do you resolve critical issues?
Add your answer
Q2. How do to handle stakeholder's interests?
Ans. 
Handle stakeholder's interests by understanding their needs, communicating effectively, and delivering results.
• Understand the stakeholders' needs and priorities

• Communicate regularly and effectively with stakeholders

• Involve stakeholders in decision-making processes

• Deliver results that align with stakeholders' interests

• Manage expectations and address concerns promptly
Answered by AI
Add your answer

SQL Rank functions.
Python easy to medium DSA programs.
Pyspark Concepts and questions.

Q1. Explain one of your projects in End to End
Add your answer

Q1. What are some of the analytical functions available in SQL?
Ans. 
Analytical functions in SQL are used to perform calculations on sets of rows.
• Aggregate functions like SUM, AVG, COUNT, MIN, MAX

• Window functions like ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD

• Ranking functions like NTILE, PERCENT_RANK, CUME_DIST

• Statistical functions like STDDEV, VARIANCE

• String functions like CONCAT, SUBSTRING, TRIM
Answered by AI
Add your answer

Q1. About SQL basics such as difference between delete and truncate, and some basic definitions.
Add your answer
Q2. About Python basics such as list, tuple and all.
Add your answer
Q3. Basic questions about Excel.
Add your answer

Q1. Salary Negotiation
Add your answer
Q2. About Company Work Culture
Add your answer

I was asked to write SQL queries for 3rd highest salary of the employee, some name filtering, group by tasks.
Python code to find the index of the maximum number without using numpy.

Q1. Explain the Project undertaken during the research and follow-up questions
Add your answer

Q1. Write pandas query to separate the names as first and last name from the full name. Drop the duplicate columns and also the missing values. Write output for the Python code. Write SQL query to retrieve t...read more
Ans. 
Answering questions related to data science concepts and techniques.
• Recall is the ratio of correctly predicted positive observations to the total actual positives. Precision is the ratio of correctly predicted positive observations to the total predicted positives.

• To reduce variance in an ensemble model, techniques like bagging, boosting, and stacking can be used. Bagging involves training multiple models on different ...read more
Answered by AI
Add your answer

Q1. About data profiling
Add your answer
Q2. Data mapping questions
Add your answer

Q1. Problem solving questions
Add your answer
Q2. Scenario based questions
Add your answer

Q1. Yet to receive call
Add your answer
Q2. Yet to confirm the dates
Add your answer

1st round is aptitude test, not only aptitude English, SA writing, about excel total 50 marks...

Q1. Round 2 is interview talking more about our bio...
Add your answer
Q2. Tell me about yourself? Why did you choose this job? What are the abilities do you have? Some more questions....
Add your answer

Q1. Asking about company details and personal details...
Add your answer
Q2. What do you know about company? Do you know about job role?
Add your answer

The aptitude test was easy.just like usual aptitude questions like quants,verbal,reasoning etc....

Q1. Second round was all about one on one video call interview where they will ask to record a video and send it.(managerial questions). Like, why do you need to join mu sigma,why should we hire you....
Ans. Third round was online hr interview. Where there will ask questions based on your resumes.
Answered Anonymously
Add your answer

Q1. Self introduction research secondary research
Add your answer

Q1. Self introduction
Add your answer
Q2. Knowledge of data handling
Add your answer