SG Analytics Associate Consultant Interview Questions and Answers

SQL and Python basic questions

Q1. Problem solving questions
Add your answer
Q2. SQL query on 2nd largest
Ans. 
Use a subquery to find the 2nd largest value in a SQL table.
• Use a subquery to find the maximum value in the table

• Exclude the maximum value from the results to find the 2nd largest value
Answered by AI
Add your answer

Q1. Culture fit questions
Add your answer

It was decent round.

Q1. Good one on one round with details of past project
Add your answer

Q1. More about what you have been doing in past role
Add your answer

Q1. How much you know about fractal
Ans. 
Fractals are complex geometric shapes that can be split into parts, each of which is a reduced-scale copy of the whole.
• Fractals exhibit self-similarity, meaning they look similar at any scale or magnification.

• Examples of fractals include the Mandelbrot set, Koch snowflake, and Sierpinski triangle.

• Fractals are used in various fields such as mathematics, computer graphics, and art.
Answered by AI
Add your answer

Q1. To check culture fit with the org
Add your answer

Q1. Questions related to Pharma domain about patient/hcp activity table, HIT targeting project end to end implementation, raw data cleaning and filtering etc.
Add your answer
Q2. Basic SQL question based on a sample data given which will be used as a backend for a visualisation
Add your answer

6-8 questions on SQL and Python

Q1. An overview on all the projects I have worked on and my knowledge on domain
Add your answer

Q1. Strength and Weakness
Add your answer
Q2. Reason to switch
Ans. 
Seeking new challenges and opportunities for growth
• Desire to work on more diverse projects

• Opportunity for career advancement

• Seeking a better work-life balance

• Interested in learning new skills or technologies
Answered by AI
Add your answer
Q3. Negotiations on salary
Add your answer

Q1. Write SQL queries for given scenario
Ans. 
Writing SQL queries for a given scenario
• Use SELECT statement to retrieve data from tables

• Use WHERE clause to filter data based on specific conditions

• Use JOIN clause to combine data from multiple tables
Answered by AI
Add your answer
Q2. Simple queries initially, sub queries and CTEs will be touched in later part, window functions and extensive usage of joins will also be checked
Add your answer
Q3. Test test test test?
Add your answer

Q1. Engagement manager round will have a case study
Add your answer
Q2. Mostly case study related to some of the practice will be asked, mostly CPG
Add your answer