Upload Button Icon Add office photos

Filter interviews by

Sonata Software Mssql and Ssis Developer Interview Questions and Answers for Experienced

Updated 14 Jun 2022

Sonata Software Mssql and Ssis Developer Interview Experiences for Experienced

1 interview found

Round 1 - HR 

(7 Questions)

  • Q1. Query ,Procedure ,function
  • Q2. Temple table, view, cte
  • Q3. Operators, rank function
  • Q4. Setopertors, clauses
  • Q5. Stored procedure, merge
  • Q6. Table variable, scalar function
  • Q7. Date reports, create reports

Interview Preparation Tips

Interview preparation tips for other job seekers - Sqlsever question, query, simple query

Interview questions from similar companies

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

Prev job work and project details , roles and responsibility

Round 2 - Technical 

(2 Questions)

  • Q1. What is SDLC process
  • Ans. 

    SDLC process is a structured approach to software development that defines tasks performed at each stage of the software development life cycle.

    • SDLC stands for Software Development Life Cycle

    • It includes stages like planning, analysis, design, implementation, testing, and maintenance

    • Each stage has specific goals and deliverables to ensure the quality and success of the software project

  • Answered by AI
  • Q2. What is the ASp.net mean for ?
  • Ans. 

    ASP.NET stands for Active Server Pages .NET, a web application framework developed by Microsoft.

    • ASP.NET is a server-side web application framework used for building dynamic web pages and web applications.

    • It allows developers to create web applications using languages like C# or VB.NET.

    • ASP.NET provides tools and libraries for building web forms, MVC (Model-View-Controller) applications, and Web API services.

    • It is part o...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - focus on tech round

Skills evaluated in this interview

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

I applied via Job Portal and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. SOLID principles
  • Q2. Microservice Architecture and Kafka

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with core concepts.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

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

Round 1 - Coding Test 

Asked some basic level questions

Round 2 - Coding Test 

Asked little bit hard questions

Round 3 - Coding Test 

Asked depth questions and wrote some sample programs

Round 4 - Technical 

(1 Question)

  • Q1. Wrote some sample program
Round 5 - HR 

(1 Question)

  • Q1. Salary discussion
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Hackerrank coding round.

Round 2 - Technical 

(1 Question)

  • Q1. Questions and coding testing your OOPS knowledge
Round 3 - Technical 

(1 Question)

  • Q1. Every tech stack, SQL, OOPS, JAVA

Interview Preparation Tips

Interview preparation tips for other job seekers - Be familiar with designing and writing better code follwing OOPS, YAGNI,DRY principles.
Interview experience
3
Average
Difficulty level
Easy
Process Duration
-
Result
Selected Selected

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

Round 1 - Coding Test 

Java 8 web development, create basic crud operations microservice use routing,SQL queries join and indexing,what are annotation, Kafka.

Round 2 - HR 

(1 Question)

  • Q1. Salary expectation, notice period, relocation, work from office

Interview Preparation Tips

Interview preparation tips for other job seekers - Do not give answers if you don't know you can guess and explain only if required.
benifits are less they follow mostly TCS salary structure while giving.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via campus placement at Pranveer Singh Institute of Technology, Kanpur and was interviewed before Dec 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

My first round was an aptitude round that included topics from the aptitude syllabus (Quantitative, Reasoning, Verbal) along with some programming questions.

Round 2 - Technical 

(4 Questions)

  • Q1. Questions related to Python, DBMS, SQL, and some projects which were mentioned on my resume
  • Q2. He asked me some coding questions one of them to make a pattern related prime number triangle and give me query to write in SQL
  • Q3. He asked about technology which i used in my last year projects.
  • Q4. Some questions of data structure like linked list and so .
Round 3 - HR 

(2 Questions)

  • Q1. About myself and my hobbies .
  • Q2. Some questions related by mentioned projects which were mentioned on my resume

I applied via Approached by Company and was interviewed in May 2022. There were 2 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 - Technical 

(1 Question)

  • Q1. Polymorphism ..Pure virtual function ..oops concept ..Design pattern ..Smart printer STL

Interview Preparation Tips

Interview preparation tips for other job seekers - Always be patience and keep giving the interviews and never give up ..Clear your basics ..Will not advice you to read this or that .. Whatever is your domain and language have solid understanding on that

I applied via Naukri.com and was interviewed before Nov 2021. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Regular Basic questions, JSE related.
Round 2 - Technical 

(1 Question)

  • Q1. Project-related questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - No tips are required, Just a regular Interview, the same regular questions.

Interview Questionnaire 

4 Questions

  • Q1. Reverse a string without using any inbuilt method.
  • Ans. 

    Reverse a string without using any inbuilt method.

    • Iterate through the string from the last character to the first

    • Create a new string and append each character to it

    • Return the reversed string

  • Answered by AI
  • Q2. Convert a smallcased string to all capital case.
  • Ans. 

    Convert a smallcased string to all capital case.

    • Use the toUpperCase() method to convert the string to uppercase.

    • Assign the result to a new variable or overwrite the original string.

    • Make sure to handle any non-alphabetic characters appropriately.

  • Answered by AI
  • Q3. Internal working of Hashmap.
  • Ans. 

    Hashmap is a data structure that stores key-value pairs and uses hashing to retrieve values quickly.

    • Hashmap uses an array to store the key-value pairs

    • The keys are hashed to generate an index in the array

    • If two keys hash to the same index, a linked list is used to store the values

    • Retrieving a value involves hashing the key to find the index and then traversing the linked list if necessary

  • Answered by AI
  • Q4. Why to join Altimetrik?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be honest for behavioral questions. That's all. Have a great interview.

Skills evaluated in this interview

Sonata Software Interview FAQs

How many rounds are there in Sonata Software Mssql and Ssis Developer interview for experienced candidates?
Sonata Software interview process for experienced candidates usually has 1 rounds. The most common rounds in the Sonata Software interview process for experienced candidates are HR.
What are the top questions asked in Sonata Software Mssql and Ssis Developer interview for experienced candidates?

Some of the top questions asked at the Sonata Software Mssql and Ssis Developer interview for experienced candidates -

  1. Query ,Procedure ,funct...read more
  2. Table variable, scalar funct...read more
  3. Temple table, view, ...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.1k Interviews
Infosys Interview Questions
3.7
 • 7.4k Interviews
Wipro Interview Questions
3.7
 • 5.5k Interviews
Tech Mahindra Interview Questions
3.6
 • 3.7k Interviews
HCLTech Interview Questions
3.5
 • 3.7k Interviews
LTIMindtree Interview Questions
3.9
 • 2.8k Interviews
Mphasis Interview Questions
3.4
 • 781 Interviews
CitiusTech Interview Questions
3.4
 • 261 Interviews
View all
Consultant
618 salaries
unlock blur

₹7 L/yr - ₹22 L/yr

Senior System Analyst
593 salaries
unlock blur

₹5 L/yr - ₹16.1 L/yr

Software Engineer
395 salaries
unlock blur

₹2.8 L/yr - ₹13 L/yr

System Analyst
327 salaries
unlock blur

₹3 L/yr - ₹10 L/yr

Technical Lead
321 salaries
unlock blur

₹10 L/yr - ₹34 L/yr

Explore more salaries
Compare Sonata Software with

LTIMindtree

3.9
Compare

Persistent Systems

3.5
Compare

TCS

3.7
Compare

Wipro

3.7
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview