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 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
Top trending discussions
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
(2 Questions)
- Q1. Tell me about yourself
- Ans.
Experienced Lead Consultant with a background in project management and client relations.
Over 5 years of experience in consulting roles
Strong project management skills, able to lead teams to successful outcomes
Excellent communication and relationship-building abilities
Proven track record of delivering results for clients
Certified in relevant consulting methodologies
- Q2. Brief me about your experience
- Ans.
I have over 10 years of experience in consulting, specializing in project management and client relations.
10+ years of consulting experience
Specialize in project management
Strong client relations skills
(1 Question)
- Q1. Share past challenges
- Ans.
Overcoming challenges in previous roles through problem-solving and perseverance.
Successfully managed a project with a tight deadline by prioritizing tasks and delegating responsibilities
Resolved conflicts within a team by facilitating open communication and finding common ground
Adapted to a new software system by seeking out training resources and practicing regularly
(1 Question)
- Q1. Explain the gaps in your CV
- Ans.
Career breaks for personal development and family commitments
Took a year off to travel and gain new perspectives
Took a break to care for a sick family member
Attended a professional development program to enhance skills
(1 Question)
- Q1. Why should we hire you
- Ans.
I have a proven track record of successfully leading teams and delivering results in complex consulting projects.
Extensive experience in consulting industry
Strong leadership skills demonstrated through successful project delivery
Ability to effectively communicate and collaborate with clients and team members
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed before Mar 2023. There was 1 interview round.
(2 Questions)
- Q1. What languages do you know? Asked about the project I did and various clarification questions on that.
- Q2. What are various assumption you made while implementing this project.
Selected
I applied via Walk-in and was interviewed before Aug 2022. There were 4 interview rounds.
Test of SQL, Tableau and other skills based on your resume on Skillate
(1 Question)
- Q1. SQL and other skills technical questions
(1 Question)
- Q1. Manager round / 2nd technical round
I applied via Walk-in and was interviewed before Oct 2021. There were 3 interview rounds.
(1 Question)
- Q1. Interduce your self, Your professional detsils
(1 Question)
- Q1. Related to technogy, what is that, When it we will use and example
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed before Feb 2022. There were 3 interview rounds.
(1 Question)
- Q1. Expected Ctc ,current ctc,experience etc,etc
(1 Question)
- Q1. System knowledge ,they see if your experience is usable.It’s a long round but if you are skilled and experience d enough ,it will be a breeze
Interview Preparation Tips
Neha Verma
Selected
I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.
(1 Question)
- Q1. Spring Springboot Microservices Java 8
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 Consultant Interview Questions
- Senior Associate Consultant Interview Questions
- Lead Consultant Interview Questions
- Technical Consultant Interview Questions
- Consultant Interview Questions
- Associate Technical Consultant Interview Questions
- Principal Consultant Interview Questions
- Technology 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
31
salaries
| ₹6.4 L/yr - ₹27.4 L/yr |
|
Senior BI Consultant
29
salaries
| ₹7.2 L/yr - ₹24.8 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- Nice Software Solutions Interview Questions >
- Nice Software Solutions Associate Consultant Interview Questions
