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 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
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
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Mar 2021. There were 3 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Outlook troubleshooting.
- Q2. Basic knowledge of VPN
- Q3. Ticketing tool knowledge
Interview Preparation Tips
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
I applied via campus placement at Galgotias College of Engineering and Technology, Greater Noida 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
Associate Software Engineer Interview Questions & Answers
Indus Valley Partners
Anonymous
posted on 1 Aug 2024
I applied via campus placement at Jagan Institute of Management Studies (JIMS) and was interviewed in Jul 2024. There was 1 interview round.
(4 Questions)
- Q1. A Lot of OOPS and Virtual concept
- Q2. Basic SQL till joins
- Q3. Java script medium
- Q4. C# oops output based
Interview Preparation Tips
- OOPS
- C#
- Javascript
- SQL
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
Avinash kumar
Good maths, lcm,percentage, decimal, trigo, boat, pipes
Selected
I applied via Approached by Company and was interviewed in Mar 2023. There were 2 interview rounds.
(4 Questions)
- Q1. Tell about your previous company experience ?
- Ans.
I worked as a Process Associate at XYZ Pvt. Ltd.
Handled customer queries and complaints through email and phone calls
Maintained accurate records of customer interactions and transactions
Collaborated with cross-functional teams to resolve customer issues
Achieved 95% customer satisfaction rating
Trained new hires on company policies and procedures
- Q2. Technical Questions & some logical math questions were asked.
- Q3. Lot more questions were asked from my Resume ! so make sure you are strong enough in things that you mentioned in your resume.
- Q4. Some sensitive questions were asked like 1. How long will you be able to stay if I select you ? 2. What do you think of your previous company's weakness ?
Interview Preparation Tips
Prepare your resumes for the job you are applying for. Don't use the same resume for all the jobs.
Nitharsana Natarajan
Selected
I applied via Referral and was interviewed in Jul 2023. There were 2 interview rounds.
(1 Question)
- Q1. Tell about my self and experience
(1 Question)
- Q1. Telling about myself and my experience with my manager
Nice Software Solutions Interview FAQs
Tell us how to improve this page.
Nice Software Solutions Interviews By Designations
- Nice Software Solutions Associate Interview Questions
- Nice Software Solutions Associate Consultant Interview Questions
- Nice Software Solutions Data Engineer Interview Questions
- Nice Software Solutions Graphic Designer Interview Questions
- Nice Software Solutions Software Engineer Interview Questions
- Nice Software Solutions Software Trainee Interview Questions
- Nice Software Solutions Ssis Developer Interview Questions
- Nice Software Solutions Tableau Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Associate Consultant Interview Questions
- Senior Consultant Interview Questions
- Associate Technical Consultant Interview Questions
- Associate Software Engineer Interview Questions
- Associate Information Technology Consultant Interview Questions
- Lead Consultant Interview Questions
- Technical Consultant Interview Questions
- Principal Consultant Interview Questions
- Show more
Nice Software Solutions Associate Consultant Interview Process
based on 2 interviews
Interview experience
Associate Consultant Interview Questions from Similar Companies
Nice Software Solutions Associate Consultant Reviews and Ratings
based on 4 reviews
Rating in categories
|
BI Consultant
57
salaries
|  ₹5.3 L/yr - ₹15 L/yr |
|
Associate Consultant
48
salaries
| ₹4.2 L/yr - ₹12.4 L/yr |
|
Associate BI Consultant
32
salaries
| ₹4 L/yr - ₹11 L/yr |
|
Consultant
30
salaries
| ₹6.4 L/yr - ₹27.4 L/yr |
|
Senior BI Consultant
28
salaries
| ₹7.2 L/yr - ₹22.6 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- Nice Software Solutions Interview Questions >
- Nice Software Solutions Associate Consultant Interview Questions
