Upload Button Icon Add office photos

Sterling

Compare button icon Compare button icon Compare

Filter interviews by

Sterling Data Analyst Interview Questions and Answers

Updated 6 Apr 2024

Sterling Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 4 Apr 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Apr 2023. There was 1 interview round.

Round 1 - One-on-one 

(3 Questions)

  • Q1. Tell me about yourself
  • Q2. What is partitioning
  • Ans. 

    Partitioning is the process of dividing a large dataset into smaller, more manageable parts based on certain criteria.

    • Partitioning helps in improving query performance by reducing the amount of data that needs to be processed.

    • It can be done based on ranges, hash values, or specific columns in the dataset.

    • For example, partitioning a sales dataset by date can help in quickly retrieving sales data for a specific time peri

  • Answered by AI
  • Q3. Your experience with cloud warehouse
  • Ans. 

    I have experience working with cloud warehouses such as Amazon Redshift and Google BigQuery.

    • Utilized Amazon Redshift to store and analyze large datasets for a retail company

    • Implemented ETL processes in Google BigQuery to transform and load data for a marketing campaign analysis

    • Optimized queries in Snowflake to improve performance for a financial services client

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Sterling Data Analyst interview:
  • ETL Testing
  • AWS
  • thoughtspot

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What time intelligence functions can be used for ytd and qtd analysis
  • Ans. 

    Time intelligence functions like YTD (Year-to-Date) and QTD (Quarter-to-Date) can be used for YTD and QTD analysis in data analytics.

    • YTD analysis can be done using functions like YTD() or TOTALYTD() to calculate values from the beginning of the year up to the selected date.

    • QTD analysis can be done using functions like QTD() or TOTALQTD() to calculate values from the beginning of the quarter up to the selected date.

    • Thes...

  • Answered by AI
  • Q2. Difference between import and direct query
  • Ans. 

    Import brings data into Power BI for further analysis, while direct query connects to data source in real-time.

    • Import: Data is loaded into Power BI for analysis, improving performance but requiring periodic refreshes.

    • Direct Query: Connects to data source in real-time, allowing for up-to-date information but potentially slower performance.

    • Import is suitable for smaller datasets, while direct query is better for large da

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(3 Questions)

  • Q1. Type of Filters in Tableau.
  • Ans. 

    Tableau offers various types of filters including quick filters, context filters, and data source filters.

    • Quick filters allow users to easily filter data by selecting values from a list.

    • Context filters are applied before other filters, affecting the data visible to subsequent filters.

    • Data source filters limit the data available to Tableau by filtering data at the data source level.

    • Other types of filters include extract...

  • Answered by AI
  • Q2. Types of refresh in Tableau
  • Ans. 

    There are two types of refresh in Tableau: Extract Refresh and Data Source Refresh.

    • Extract Refresh: Refreshes the data in Tableau extract, which is a snapshot of data from the original data source.

    • Data Source Refresh: Refreshes the data directly from the original data source.

    • Examples: Extract Refresh is useful when working with large datasets to improve performance, while Data Source Refresh ensures real-time data upda

  • Answered by AI
  • Q3. Difference in Extract and live connection.
  • Ans. 

    Extract connection imports data into Tableau workbook while live connection directly connects to data source.

    • Extract connection creates a static snapshot of data in Tableau workbook.

    • Live connection directly queries data from the source in real-time.

    • Extract connection is useful for large datasets or when offline access is needed.

    • Live connection is beneficial for real-time data analysis and dynamic updates.

    • Example: Extra...

  • Answered by AI

Skills evaluated in this interview

I applied via Campus Placement and was interviewed in Sep 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

Easy but time limit was the main issue to address

Round 3 - Coding Test 

Hard coding test on hacker earth platform no cameras and plagiarism tester will be on

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and precise ,so be yourself and consider good practice before test
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I appeared for an interview before Mar 2024, where I was asked the following questions.

  • Q1. Hr questions about my background with company
  • Q2. About my technical skills

Business Analyst Interview Questions & Answers

UnitedHealth user image Chandra Prakash Rathi

posted on 4 Feb 2017

I appeared for an interview before Feb 2016.

Interview Questionnaire 

6 Questions

  • Q1. Truth tribe, false tribe question
  • Q2. Guesstimate : India's Deodrant market
  • Ans. 

    The Indian deodorant market is a growing industry with a large consumer base and increasing demand for premium and natural products.

    • The deodorant market in India has been experiencing steady growth over the years.

    • The market is driven by factors such as increasing disposable income, urbanization, and changing lifestyles.

    • There is a growing awareness among consumers about personal hygiene and grooming, leading to higher d...

  • Answered by AI
  • Q3. Cheryl's birthday
  • Q4. Guesstimate : Number if tractors sold in haryana in a year.
  • Ans. 

    Approximately 50,000 tractors are sold in Haryana every year.

    • Consider the population of Haryana and the number of farmers in the state.

    • Look at the agricultural output of Haryana and the demand for tractors in the region.

    • Take into account the number of tractor dealerships in Haryana and their sales figures.

    • Research the sales figures of major tractor manufacturers in Haryana.

    • Assume a growth rate based on the previous yea...

  • Answered by AI
  • Q5. Family Background
  • Q6. Future Plans

Interview Preparation Tips

Round: Test
Experience: The Test was fairly simple, basic knowledge of quant would do. I could attempt 16 questions, and from what I am guessing was second highest scorer. You need to attempt atleast 10 questions correctly and it would do the job.
Tips: Speed matters in this test.
Duration: 30 minutes
Total Questions: 30

Round: Group Discussion
Experience: there was only one panelist, and a group of 12 students. We were each given individual time to conclude. The discussion was good, and lots of points were discussed.
Tips: More than language, the content mattered.
Duration: 15 minutes

Round: Technical Interview
Experience: Was basically asked questions from what was written in the resume. I had written about a website i created and was asked in detail about that. There a=were a few puzzles then.
Tips: Be true to your resume. Know what you have written

Round: Technical Interview
Experience: This was a tougher round. But the interviewers helped. They were interactive on how to solve. Which steps I was going through and were more focused on the approach
Tips: Be interactive, and think out loud

College Name: NIT Raipur

I appeared for an interview in Sep 2016.

Interview Preparation Tips

Round: Test
Experience: level of questions was similar to CAT
Tips: prepare for cat. since questions are tough, cutoff is around 50?
Duration: 20 minutes
Total Questions: 30

Round: Group Discussion
Duration: 10 minutes

Round: Stress Interview
Experience: Panel interview. C and algorithms

Skills: Analytics And Coding

I appeared for an interview in Jan 2017.

Interview Questionnaire 

8 Questions

  • Q1. Tell me about your family, What is good in Chhattisgarh, Where can I visit in Raipur and Bhilai, what do you not like about Raipur, every co-curricular activity from resume was interrogated. ETC
  • Ans. 

    I come from a close-knit family in Chhattisgarh. Raipur and Bhilai have beautiful attractions like Mahant Ghasidas Memorial Museum and Maitri Bagh. I enjoy participating in various co-curricular activities.

    • Close-knit family in Chhattisgarh

    • Attractions in Raipur and Bhilai like Mahant Ghasidas Memorial Museum and Maitri Bagh

    • Participation in co-curricular activities

  • Answered by AI
  • Q2. There are 100 people standing in a circle, the first person has a gun he starts shooting the person next to him and hands over the gun to the 3rd person and so on. Who will be the last person surviving?
  • Q3. There are 20 blue balls and 13 red balls in a container. I pick up randomly 2 balls from the container if the colour of the balls is same then I replace them with a blue ball and if otherwise then I replac...
  • Ans. 

    The last ball will be red.

    • If the first two balls are of different colors, they will be replaced with a red ball.

    • If the first two balls are of the same color, they will be replaced with a blue ball.

    • The number of balls in the container does not affect the outcome.

    • The last ball will be red because there are more red balls than blue balls in the container.

  • Answered by AI
  • Q4. How many facebook users are there in the world?
  • Ans. 

    The exact number of Facebook users worldwide is constantly changing, but as of October 2021, there are over 2.8 billion monthly active users.

    • As of October 2021, Facebook reported having over 2.8 billion monthly active users.

    • The number of Facebook users is constantly changing as new users join and others deactivate or delete their accounts.

    • Facebook's user base is spread across different countries and demographics.

    • The nu...

  • Answered by AI
  • Q5. Few questions to check mental calculation ability like 12% of 360, 11% of 56.
  • Q6. Cheryl’s birthday puzzle.
  • Q7. Two eggs hundred floors problem.
  • Q8. What is ‘vlookup’ in excel? Difference between vlookup and hlookup.
  • Ans. 

    VLOOKUP is a function in Excel used to search for a value in the first column of a range and return a corresponding value from another column.

    • VLOOKUP stands for vertical lookup.

    • It is commonly used to find specific data in large datasets.

    • The function takes four arguments: lookup value, table array, column index number, and range lookup.

    • VLOOKUP is case-insensitive and requires an exact match or an approximate match.

    • The f...

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: Pen and paper test was conducted. Level of questions was good. Only accuracy mattered as I was able to solve 12-13 questions. Out of 220 candidates, 45 cleared the round.
Tips: Don't guess the answers as negative marking is there and cut off does not go high.
Duration: 30 minutes
Total Questions: 30

Round: Group Discussion
Experience: 3-4 students were creating fish market but I didn

Skills evaluated in this interview

I appeared for an interview in Jan 2017.

Interview Preparation Tips

Round: Resume Shortlist
Experience: It was basically not a resume shortlist round. We had sent our details like 10th , 12th and semester marks and shortlisting was based on those marks.

Round: Test
Experience: General Aptitude Test
Duration: 30 minutes
Total Questions: 30

Round: Technical Interview
Experience: It consisted of puzzles , guesstimates, questions on sql and java as I wrote that i have elementary knowledge of java.

Round: Technical Interview
Experience: It was a much longer interview, approximately 1.5 hrs. They thoroughly studied my resume and asked questions based on my resume, followed by puzzles , guesstimates and questions on sql.

Round: HR Interview
Experience: Basic HR questions like where is my hometown, if I would be comfortable to relocate and about my parents.

Skills: Soft Skills, SQL, Logical Puzzles, Guesstimate Skills
College Name: NIT Raipur

I appeared for an interview in Jan 2017.

Interview Questionnaire 

9 Questions

  • Q1. • Programming, Quick Maths, Guesstimates, Puzzles.
  • Q2. • programs : Bubble Sorting, prime number etc programs, reverse number, print hello without using main function.
  • Q3. • Output and error checking of sql queries.
  • Ans. 

    Output and error checking of SQL queries involves verifying the correctness of query results and handling any potential errors.

    • Verify the correctness of query results by comparing them with expected output

    • Check for syntax errors and correct them before executing the query

    • Handle runtime errors by using try-catch blocks or error handling mechanisms

    • Validate input parameters to prevent SQL injection attacks

    • Use appropriate ...

  • Answered by AI
  • Q4. • Estimate the % of smokers in institute
  • Ans. 

    Estimating the percentage of smokers in an institute.

    • Collect data on the number of smokers and the total population in the institute.

    • Calculate the ratio of smokers to the total population.

    • Multiply the ratio by 100 to get the percentage of smokers.

    • Consider conducting surveys or analyzing existing data to gather information.

    • Take into account any potential biases or limitations in the data collection process.

  • Answered by AI
  • Q5. • Puzzles: Horse race, egg to be dropped from which floor so that it will not break. 3 lit jug, 8 lit jug case. Many more puzzles.
  • Q6. In depth questions in programming were asked.
  • Q7. Questions related to project in software profile
  • Q8. Programs in languages you know, queries of mysql
  • Q9. About yourself. Vision of company Why UHG Strengths, weaknesses About projects, why mining and now into analytics Why don't you have projects in analytics related topics.

Interview Preparation Tips

Round: Test
Experience: 30 questions in 45 minutes. Questions were time taking and few from previous year CAT papers. Average cut-off was around 12-13 only. There was negative marking.
Tips: Manage your time. Speed and Accuracy are important. Practice daily for at least 1 hour and cover all models in various topics. CAT level exam.
Duration: 45 minutes
Total Questions: 30

Round: Group Discussion
Experience: There were 12 in a panel, 6 were selected finally. they want a team player. Have discussed the benefits and problems associated with the topic and its long term effects on Indian Economy.
Tips: Improve your communication skills, body language is also important. Quantity is not important, quality is important. Keep your content to the point. Do not drag it unnecessarily
Duration: 10 minutes

Round: Technical Interview
Experience: This was technical interview 1; shortlisted candidates had to go through another interview. Puzzles and guesstimates were also asked along with some programming related questions.
Tips:

Skills evaluated in this interview

Sterling Interview FAQs

How many rounds are there in Sterling Data Analyst interview?
Sterling interview process usually has 1 rounds. The most common rounds in the Sterling interview process are One-on-one Round.
What are the top questions asked in Sterling Data Analyst interview?

Some of the top questions asked at the Sterling Data Analyst interview -

  1. Your experience with cloud wareho...read more
  2. What is partition...read more

Tell us how to improve this page.

Sterling Data Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Specialist
161 salaries
unlock blur

₹2 L/yr - ₹4.5 L/yr

Verification Specialist
61 salaries
unlock blur

₹2.6 L/yr - ₹5 L/yr

Senior Verification Specialist
21 salaries
unlock blur

₹3 L/yr - ₹4 L/yr

Senior Associate
21 salaries
unlock blur

₹2 L/yr - ₹3.5 L/yr

Background Verification Specialist
19 salaries
unlock blur

₹2.8 L/yr - ₹3.9 L/yr

Explore more salaries
Compare Sterling with

GeBBS Healthcare Solutions

3.7
Compare

UnitedHealth

4.0
Compare

Sahrudaya Healthcare (Medicover Hospitals)

4.5
Compare

Paras Hospital

4.4
Compare
Did you find this page helpful?
Yes No
write
Share an Interview