Upload Button Icon Add office photos

Filter interviews by

Nice Software Solutions Data Engineer Interview Questions and Answers

Updated 25 May 2024

Nice Software Solutions Data Engineer Interview Experiences

1 interview found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 25 May 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
-

I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - One-on-one 

(4 Questions)

  • Q1. Tell me about SCD types with examples.
  • Ans. 

    SCD types refer to slowly changing dimensions in data warehousing, categorized into Type 1, Type 2, and Type 3.

    • Type 1 SCD: Overwrites existing data with new information, losing historical data.

    • Type 2 SCD: Maintains historical data by creating new records for changes, with a surrogate key for each version.

    • Type 3 SCD: Keeps both old and new values in the same record, with separate columns for each version.

  • Answered by AI
  • Q2. What is junk dimension?
  • Ans. 

    A junk dimension is a single dimension table that combines multiple low-cardinality attributes that are not related to the fact table.

    • Contains attributes that are not related to the fact table

    • Reduces the number of dimension tables in the data warehouse

    • Helps in simplifying the data model and improving query performance

  • Answered by AI
  • Q3. Snowflake Architecture
  • Q4. Snowflake Schema vs Star Schema
  • Ans. 

    Snowflake schema is a normalized form of star schema with multiple levels of dimension tables.

    • Snowflake schema has normalized dimension tables, leading to reduced redundancy and improved data integrity.

    • Star schema has denormalized dimension tables, which can lead to data redundancy but faster query performance.

    • Snowflake schema is more complex to query compared to star schema due to multiple levels of normalization.

    • Star...

  • Answered by AI

Interview questions from similar companies

I applied via LinkedIn and was interviewed before Nov 2021. 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 

There are basic aptitude questions for freshers level

Round 3 - Technical 

(2 Questions)

  • Q1. Oops concepts, basics of sql
  • Q2. Basics of programming language

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through basics interview questions for freshers level

Interview Questionnaire 

2 Questions

  • Q1. Fsmo roles
  • Q2. Office 365
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before May 2022. There were 5 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 - Coding Test 

It was a coding round with sql ,python questions , few aptitude questions

Round 3 - Technical 

(2 Questions)

  • Q1. They asked few questions sql and python and few questions - depending on the role
  • Q2. BASIC SQL WHAT YOU HAD WRITTEN IN THE CODE
Round 4 - Technical 

(2 Questions)

  • Q1. They asked me few questions related to sql
  • Q2. BASIC PYTHON QUESTIONS LIKE WHAT YOU HAVE WRITTEN IN THE CODE
Round 5 - HR 

(1 Question)

  • Q1. About yourself , your hobby etc

Interview Preparation Tips

Interview preparation tips for other job seekers - be confident and be able to explain the code you wrote in coding round
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in May 2024. There were 4 interview rounds.

Round 1 - Coding Test 

Python and SQL questions were asked

Round 2 - One-on-one 

(1 Question)

  • Q1. I was asked about the project
Round 3 - One-on-one 

(1 Question)

  • Q1. ACID properties of DBMS
  • Ans. 

    ACID properties ensure data integrity in DBMS: Atomicity, Consistency, Isolation, Durability.

    • Atomicity ensures that all operations in a transaction are completed successfully or none at all.

    • Consistency ensures that the database remains in a consistent state before and after the transaction.

    • Isolation ensures that multiple transactions can be executed concurrently without affecting each other.

    • Durability ensures that once...

  • Answered by AI
Round 4 - HR 

(1 Question)

  • Q1. HR question and family background

Interview Preparation Tips

Topics to prepare for Junglee Games Data Engineer interview:
  • SQL
  • Python
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

The test was in hackerrank platform, it was moderate level.

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Coding Test 

Dsa problems dp and tress problem

Round 2 - Technical 

(2 Questions)

  • Q1. Tell me about your self
  • Ans. 

    I am a passionate software engineer with 5 years of experience in developing web applications using various technologies.

    • 5 years of experience in software development

    • Proficient in developing web applications

    • Skilled in using various technologies

    • Passionate about software engineering

  • Answered by AI
  • Q2. Projects and intership

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn DSA

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

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Aptitude Test 

Includes basic aptitude question with additional questions based on coding languages fundamentals.....

Round 3 - Technical 

(2 Questions)

  • Q1. Question were based on oops concepts. My next question was write a code of binary search and explain it and lastly I was asked an aptitude question ...
  • Q2. Write a code of binary search and explain it
  • Ans. 

    Binary search is a search algorithm that finds the position of a target value within a sorted array.

    • Divide the array into two halves

    • Compare the target value with the middle element

    • If the target value matches the middle element, return its position

    • If the target value is less than the middle element, search the left half of the array

    • If the target value is greater than the middle element, search the right half of the arra...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Do work on your aptitude and practise Data structures and algorithms...

Skills evaluated in this interview

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

I applied via Campus Placement and was interviewed in Jun 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Coding Test 

Basic coding questions with some aptitude questions

Round 3 - Technical 

(2 Questions)

  • Q1. Object oriented programming
  • Q2. ArrayList deleting even numbers
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Dec 2022. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Be truthful in your resume. It is very easy to catch false or lies during the interview by asking basic questions.
View all tips
Round 2 - Aptitude Test 

General aptitude and reasoning

Round 3 - Coding Test 

General coding questions

Round 4 - One-on-one 

(1 Question)

  • Q1. 2 medium coding questions, oops concepts and CS fundamentals
Round 5 - One-on-one 

(1 Question)

  • Q1. Linux basics, coding questions

Nice Software Solutions Interview FAQs

How many rounds are there in Nice Software Solutions Data Engineer interview?
Nice Software Solutions interview process usually has 1 rounds. The most common rounds in the Nice Software Solutions interview process are One-on-one Round.
How to prepare for Nice Software Solutions Data Engineer 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 Nice Software Solutions. The most common topics and skills that interviewers at Nice Software Solutions expect are Big Data, SQL, Hive, Spark and AWS.
What are the top questions asked in Nice Software Solutions Data Engineer interview?

Some of the top questions asked at the Nice Software Solutions Data Engineer interview -

  1. Tell me about SCD types with exampl...read more
  2. What is junk dimensi...read more
  3. Snowflake Schema vs Star Sch...read more

Tell us how to improve this page.

Nice Software Solutions Data Engineer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Nice Software Solutions Data Engineer Salary
based on 10 salaries
₹10 L/yr - ₹24 L/yr
69% more than the average Data Engineer Salary in India
View more details

Nice Software Solutions Data Engineer Reviews and Ratings

based on 2 reviews

3.0/5

Rating in categories

3.5

Skill development

3.5

Work-life balance

3.0

Salary

2.5

Job security

3.0

Company culture

3.0

Promotions

3.0

Work satisfaction

Explore 2 Reviews and Ratings
BI Consultant
56 salaries
unlock blur

₹5.3 L/yr - ₹15 L/yr

Associate Consultant
51 salaries
unlock blur

₹4.2 L/yr - ₹12 L/yr

Consultant
33 salaries
unlock blur

₹6.4 L/yr - ₹26.4 L/yr

Associate BI Consultant
32 salaries
unlock blur

₹4 L/yr - ₹11 L/yr

Senior BI Consultant
29 salaries
unlock blur

₹7.2 L/yr - ₹24.8 L/yr

Explore more salaries
Compare Nice Software Solutions with

Maxgen Technologies

4.6
Compare

Value Point Systems

3.6
Compare

JoulestoWatts Business Solutions

2.9
Compare

F1 Info Solutions and Services

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