Upload Button Icon Add office photos

Filter interviews by

Sonata Software Data Analyst Interview Questions and Answers

Updated 11 Nov 2024

Sonata Software Data Analyst Interview Experiences

2 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 11 Nov 2024

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

I applied via Naukri.com and was interviewed before Nov 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Mostly Dax and sql related questions
  • Q2. ETL related questions

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 25 Aug 2021

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

I was interviewed in Mar 2022.

Interview Questionnaire 

2 Questions

  • Q1. It's more about package discussion
  • Q2. Well structured questions asked by Interviewer. 1.More into theory on Informatica Power centre how the process will go 2. SQL functions and queries related to functions.

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
Q4. Sliding Window Maximum Problem Statement You are given an array/l ... read more
asked in Tredence
Q5. Find First Repeated Character in a String Given a string 'STR' co ... read more

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Sql regarding question was there
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Coding test for all the student attending the first round, give your best practice every day all the best in your interview

Round 2 - One-on-one 

(2 Questions)

  • Q1. What are your interest
  • Ans. 

    My interests include data analysis, problem-solving, and continuous learning.

    • Data analysis

    • Problem-solving

    • Continuous learning

  • Answered by AI
  • Q2. Java related question

Interview Preparation Tips

Interview preparation tips for other job seekers - Give your best
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
More than 8 weeks
Result
No response

I applied via Approached by Company and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Assignment 

SQL and python questions are very easy.

Interview Preparation Tips

Interview preparation tips for other job seekers - Ghost interview they will not respond after completing infact i also submitted pre joining form also.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via Job Portal

Round 1 - Case Study 

Provided sales case study, asked to analyse the same ans provide insights

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

I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Azure Scenario based questions
  • Q2. Pyspark Coding based questions
Round 2 - One-on-one 

(2 Questions)

  • Q1. ADF, Databricks related question
  • Q2. Spark Performance problem and scenarios
  • Ans. 

    Spark performance problems can arise due to inefficient code, data skew, resource constraints, and improper configuration.

    • Inefficient code can lead to slow performance, such as using collect() on large datasets.

    • Data skew can cause uneven distribution of data across partitions, impacting processing time.

    • Resource constraints like insufficient memory or CPU can result in slow Spark jobs.

    • Improper configuration settings, su...

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
6-8 weeks
Result
Selected Selected
Round 1 - Technical 

(1 Question)

  • Q1. More on Technical area
Round 2 - Technical 

(1 Question)

  • Q1. More on Technical area
Round 3 - One-on-one 

(1 Question)

  • Q1. Technical + Behaviour
Round 4 - One-on-one 

(1 Question)

  • Q1. Technical + Behaviour
Round 5 - HR 

(1 Question)

  • Q1. Expectation and Genaral
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(5 Questions)

  • Q1. Data warehousing related questions
  • Q2. SQL scenario based questions
  • Q3. Project experience
  • Ans. 

    I have experience working on projects involving data pipeline development, ETL processes, and data warehousing.

    • Developed ETL processes to extract, transform, and load data from various sources into a data warehouse

    • Built data pipelines to automate the flow of data between systems and ensure data quality and consistency

    • Optimized database performance and implemented data modeling best practices

    • Worked on real-time data pro...

  • Answered by AI
  • Q4. Python Based questions
  • Q5. AWS features and questions
Round 2 - Technical 

(2 Questions)

  • Q1. Similar to first round but in depth questions relatively
  • Q2. Asked about career goals and stuff
Round 3 - HR 

(2 Questions)

  • Q1. General work related conversation
  • Q2. Salary discussion
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Diff between Coalesce and repatriation

Sonata Software Interview FAQs

How many rounds are there in Sonata Software Data Analyst interview?
Sonata Software interview process usually has 1 rounds. The most common rounds in the Sonata Software interview process are Technical.
How to prepare for Sonata Software Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Sonata Software. The most common topics and skills that interviewers at Sonata Software expect are Apache, Cosmos, Customer Interaction, Data Analysis and Data Conversion.
What are the top questions asked in Sonata Software Data Analyst interview?

Some of the top questions asked at the Sonata Software Data Analyst interview -

  1. Well structured questions asked by Interviewer. 1.More into theory on Informat...read more
  2. Mostly Dax and sql related questi...read more
  3. It's more about package discuss...read more

Tell us how to improve this page.

Sonata Software Data Analyst Interview Process

based on 2 interviews

Interview experience

4
  
Good
View more
Sonata Software Data Analyst Salary
based on 50 salaries
₹3 L/yr - ₹9.6 L/yr
7% less than the average Data Analyst Salary in India
View more details

Sonata Software Data Analyst Reviews and Ratings

based on 10 reviews

4.2/5

Rating in categories

4.4

Skill development

4.3

Work-life balance

3.6

Salary

4.3

Job security

4.0

Company culture

3.4

Promotions

4.2

Work satisfaction

Explore 10 Reviews and Ratings
Consultant
657 salaries
unlock blur

₹6.3 L/yr - ₹19 L/yr

Senior System Analyst
578 salaries
unlock blur

₹4.1 L/yr - ₹16.1 L/yr

Software Engineer
408 salaries
unlock blur

₹3 L/yr - ₹12.8 L/yr

Technical Lead
307 salaries
unlock blur

₹10 L/yr - ₹34 L/yr

Digital Engineer
298 salaries
unlock blur

₹2.6 L/yr - ₹9.1 L/yr

Explore more salaries
Compare Sonata Software with

LTIMindtree

3.8
Compare

Persistent Systems

3.5
Compare

TCS

3.7
Compare

Wipro

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