AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Nice Software Solutions Associate Consultant Interview Questions and Answers
Nice Software Solutions Associate Consultant Interview Experiences
2 interviews found
I applied via LinkedIn and was interviewed in Jun 2024. There were 2 interview rounds.
(1 Question)
- Q1. All questions are scenario based interviewed for sql
(1 Question)
- Q1. SQL related questions and perform practical queries
Interview Preparation Tips
I asked HR she just tried to explain me about company policy and all which is totally rubbish. They didnt take there mistakes and not even single apologies.
Also for this position they told to attained bootcamp clear exam And all then they will offer permanent job with including 1 yr bond + 6 working days (WFO) with 20% salary hike only.. i recommend people don't waste your time and being victim of frustration with such poor management
I applied via Approached by Company and was interviewed before Jun 2021. There was 1 interview round.
(3 Questions)
- Q1. SQL is a must. And good soft skills will be cherry on top of the cake.
- Q2. Different types of joins in SQL?
- Ans.
Different types of joins in SQL include inner join, left join, right join, and full outer join.
Inner join returns only the matching rows from both tables
Left join returns all rows from the left table and matching rows from the right table
Right join returns all rows from the right table and matching rows from the left table
Full outer join returns all rows from both tables, with NULL values for non-matching rows
- Q3. Difference between where and having clause.
- Ans.
WHERE clause filters rows before grouping, while HAVING clause filters groups after grouping.
WHERE clause is used to filter rows based on a condition before grouping.
HAVING clause is used to filter groups based on a condition after grouping.
WHERE clause is used with SELECT, UPDATE, DELETE statements.
HAVING clause is used with GROUP BY clause.
WHERE clause cannot contain aggregate functions.
HAVING clause can contain aggr...
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Associate Consultant Interview Questions & Answers
Saama Technologies
Anonymous
posted on 4 May 2019
I applied via Referral and was interviewed in Nov 2018. There was 1 interview round.
Interview Questionnaire
4 Questions
- Q1. Core informatica. Lot of scenario based questions.
- Q2. Very basic questions. Simple and easy.
- Q3. Third round was very difficult. Couldn't answer one question properly. But I gave efforts
- Q4. Get Fibonacci series in informatica
- Ans.
Fibonacci series can be generated in Informatica using a recursive function.
Create a mapping with a recursive function
Use a variable port to store the previous two values
Use an expression transformation to generate the series
Example: f(0) = 0, f(1) = 1, f(n) = f(n-1) + f(n-2)
Interview Preparation Tips
Skills: Communication, Body Language, Problem Solving, Analytical Skills, Presentation Skills
Duration: 1-3 Months
Skills evaluated in this interview
Selected
I applied via Company Website and was interviewed in Apr 2023. There were 2 interview rounds.
(2 Questions)
- Q1. What is zero coupon bond?
- Ans.
A zero coupon bond is a bond that pays no interest and is sold at a discount to its face value.
Zero coupon bonds are also known as discount bonds.
Investors buy these bonds at a price lower than their face value and receive the full face value at maturity.
The difference between the purchase price and the face value is the investor's return.
Zero coupon bonds are often used for long-term investments, such as retirement sa...
- Q2. What is corporate actions and how you record those in books?
- Ans.
Corporate actions are events initiated by a company that can affect its stock price and shareholders. They are recorded in books through various accounting entries.
Corporate actions include stock splits, dividends, mergers, acquisitions, and spin-offs.
These actions are recorded in books through journal entries and adjustments to accounts such as retained earnings and stockholders' equity.
For example, if a company decla...
Selected
I applied via Naukri.com and was interviewed before Nov 2021. There were 2 interview rounds.
(2 Questions)
- Q1. Oops concepts, core java
- Q2. Java 8 stream api and lambda
Interview Preparation Tips
I applied via Approached by Company
(2 Questions)
- Q1. Sql is the most important , Focus on Joins ,Sub query and Sql basics
- Q2. Joining tables with different joins
- Ans.
Joining tables with different joins in SQL
Use INNER JOIN to return rows when there is at least one match in both tables
Use LEFT JOIN to return all rows from the left table and the matched rows from the right table
Use RIGHT JOIN to return all rows from the right table and the matched rows from the left table
Use FULL JOIN to return rows when there is a match in one of the tables
Skills evaluated in this interview
I applied via Campus Placement and was interviewed in Aug 2024. There were 2 interview rounds.
(3 Questions)
- Q1. Question related to oops
- Q2. Question related to coding
- Q3. I was rejected after 2nd round
(2 Questions)
- Q1. Question related to advanced topic in oops
- Q2. Question related to coding
I applied via Walk-in and was interviewed before Mar 2021. There were 3 interview rounds.
Aptitude test
Current affairs
(1 Question)
- Q1. Puzzle , sql related questions
Interview Preparation Tips
Software Engineer Interview Questions & Answers
Amantya Technologies
Anonymous
posted on 30 Nov 2022
I applied via LinkedIn and was interviewed before Nov 2021. There were 3 interview rounds.
There are basic aptitude questions for freshers level
(2 Questions)
- Q1. Oops concepts, basics of sql
- Q2. Basics of programming language
Interview Preparation Tips
Interview Preparation Tips
Experience: this was a telephonic round : There I was asked basics of web development (e.g Session, hidden variable difference between POST and GET etc. ) and basics of PHP e.g global variables etc , little bit of mysql e.g joins , difference between left and right joins.
Round: Technical Interview
Experience: This was pretty much about interview rounds. I got the offer.
Skills: Core java, OOP, PHP
College Name: na
Nice Software Solutions Interview FAQs
Tell us how to improve this page.
Nice Software Solutions Interviews By Designations
- Nice Software Solutions Associate Consultant Interview Questions
- Nice Software Solutions Associate Interview Questions
- Nice Software Solutions Graphic Designer Interview Questions
- Nice Software Solutions Software Engineer Interview Questions
- Nice Software Solutions Ssis Developer Interview Questions
- Nice Software Solutions Software Trainee Interview Questions
- Nice Software Solutions Data Engineer Interview Questions
- Nice Software Solutions Tableau Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Associate Software Engineer Interview Questions
- Senior Associate Consultant Interview Questions
- Project Associate Interview Questions
- Associate Interview Questions
- Associate Systems Engineer Interview Questions
- Associate Technical Consultant Interview Questions
- Senior Associate Interview Questions
- Application Development Associate Interview Questions
- Show more
Nice Software Solutions Associate Consultant Interview Process
based on 2 interviews
Interview experience
Interview Questions from Similar Companies
Nice Software Solutions Associate Consultant Reviews and Ratings
based on 4 reviews
Rating in categories
|
BI Consultant
56
salaries
|  ₹5.3 L/yr - ₹15 L/yr |
|
Associate Consultant
51
salaries
| ₹4.2 L/yr - ₹12 L/yr |
|
Consultant
33
salaries
| ₹6.4 L/yr - ₹26.4 L/yr |
|
Associate BI Consultant
32
salaries
| ₹4 L/yr - ₹11 L/yr |
|
Senior BI Consultant
29
salaries
| ₹7.2 L/yr - ₹24.8 L/yr |
Maxgen Technologies
Value Point Systems
JoulestoWatts Business Solutions
F1 Info Solutions and Services
- Home >
- Interviews >
- Nice Software Solutions Interview Questions >
- Nice Software Solutions Associate Consultant Interview Questions
