Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by SG Analytics Team. If you also belong to the team, you can get access from here

SG Analytics Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

SG Analytics Associate Consultant Interview Questions and Answers

Updated 17 May 2022

SG Analytics Associate Consultant Interview Experiences

1 interview found

I applied via Campus Placement and was interviewed in Apr 2022. There were 2 interview rounds.

Round 1 - Aptitude Test 

Very easy

Round 2 - One-on-one 

(1 Question)

  • Q1. Where do you see youself after 1 2 3 4 5 years
  • Ans. 

    In 1 year, I see myself learning and growing in my role. In 2-3 years, I hope to take on more responsibilities and contribute to the company's success. In 4-5 years, I aspire to be in a leadership position.

    • In 1 year, I plan to focus on learning and mastering my role

    • In 2-3 years, I hope to take on more responsibilities and contribute to the company's success

    • In 4-5 years, I aspire to be in a leadership position and help ...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for SG Analytics Associate Consultant interview:
  • English
Interview preparation tips for other job seekers - Great company to work......,.........

Interview questions from similar companies

I applied via Referral and was interviewed before Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic SQL questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through fundamental of SQL , how null behaves with all joins, Cte and other objects .

I applied via Recruitment Consultant and was interviewed in Sep 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Explain briefly the work and responsibilities in ur previous company
  • Ans. 

    In my previous company, I worked as a Consultant where I provided expert advice and solutions to clients.

    • Analyzed client's business processes and identified areas for improvement

    • Developed and implemented strategies to optimize client's operations

    • Conducted market research and competitor analysis to identify market trends

    • Provided recommendations and solutions to clients based on data analysis

    • Collaborated with cross-funct...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Stick to basics and dont fake about ur work

I applied via Recruitment Consultant and was interviewed in Aug 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Decision tree, random forest, regressions, classification metrics

Interview Preparation Tips

Interview preparation tips for other job seekers - Very nice experience, warm and welcoming people.

I applied via Naukri.com and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Sql

Interview Preparation Tips

Interview preparation tips for other job seekers - Good
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Oct 2023. There were 3 interview rounds.

Round 1 - Coding Test 

SQL and Python basic questions

Round 2 - Technical 

(2 Questions)

  • Q1. Problem solving questions
  • 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
Round 3 - HR 

(1 Question)

  • Q1. Culture fit questions

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed before May 2023. There were 2 interview rounds.

Round 1 - Coding Test 

It was decent round.

Round 2 - One-on-one 

(1 Question)

  • Q1. Good one on one round with details of past project
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I was interviewed before Mar 2023.

Round 1 - One-on-one 

(1 Question)

  • Q1. More about what you have been doing in past role
Round 2 - One-on-one 

(1 Question)

  • 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
Round 3 - HR 

(1 Question)

  • Q1. To check culture fit with the org
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Feb 2023. There were 4 interview rounds.

Round 1 - One-on-one 

(2 Questions)

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

6-8 questions on SQL and Python

Round 3 - One-on-one 

(1 Question)

  • Q1. An overview on all the projects I have worked on and my knowledge on domain
Round 4 - HR 

(3 Questions)

  • Q1. Strength and Weakness
  • 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
  • Q3. Negotiations on salary

Interview Preparation Tips

Topics to prepare for Fractal Analytics Consultant interview:
  • SQL
  • Python
  • Pandas
  • Pharma
Interview preparation tips for other job seekers - Please be thorough with the profile you are applying for and the domain in which you have relevant experience.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Aug 2023. There were 2 interview rounds.

Round 1 - Technical 

(3 Questions)

  • 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
  • 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
  • Q3. Test test test test?
Round 2 - One-on-one 

(2 Questions)

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

Interview Preparation Tips

Interview preparation tips for other job seekers - SQL very imp, python imp, any dashboarding tool knowledge required all in all

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

SG Analytics Interview FAQs

How many rounds are there in SG Analytics Associate Consultant interview?
SG Analytics interview process usually has 2 rounds. The most common rounds in the SG Analytics interview process are Aptitude Test and One-on-one Round.

Recently Viewed

INTERVIEWS

EVRY India

No Interviews

REVIEWS

Gennext Plm

No Reviews

INTERVIEWS

SG Analytics

No Interviews

SALARIES

Gennext Plm

INTERVIEWS

SG Analytics

No Interviews

INTERVIEWS

EVRY India

No Interviews

COMPANY BENEFITS

Gennext Plm

No Benefits

REVIEWS

Gennext Plm

No Reviews

SALARIES

Gennext Plm

No Salaries

INTERVIEWS

SG Analytics

No Interviews

Tell us how to improve this page.

Interview Questions from Similar Companies

Mu Sigma Interview Questions
2.6
 • 229 Interviews
Tiger Analytics Interview Questions
3.7
 • 222 Interviews
Fractal Analytics Interview Questions
4.0
 • 205 Interviews
Crisil Interview Questions
3.6
 • 188 Interviews
Indegene Interview Questions
3.4
 • 151 Interviews
Nielsen Interview Questions
3.6
 • 117 Interviews
Axtria Interview Questions
3.1
 • 115 Interviews
Netscribes Interview Questions
2.8
 • 83 Interviews
View all
SG Analytics Associate Consultant Salary
based on 4 salaries
₹3.3 L/yr - ₹4.8 L/yr
61% less than the average Associate Consultant Salary in India
View more details
Associate Analyst
415 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
313 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Analyst
246 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Consultant
186 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Research Analyst
79 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare SG Analytics with

Fractal Analytics

4.0
Compare

Mu Sigma

2.6
Compare

AbsolutData

3.6
Compare

LatentView Analytics

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent