Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Cognizant Team. If you also belong to the team, you can get access from here

Cognizant Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Cognizant Senior Consultant Interview Questions and Answers

Updated 19 Mar 2025

15 Interview questions

A Senior Consultant was asked 11mo ago
Q. What is content projection?
Ans. 

Content Projection is a technique used in Angular to insert dynamic content into a component template.

  • Content Projection allows for the insertion of HTML elements or components into a component's template from the outside.

  • It is commonly used in Angular for creating reusable components with dynamic content.

  • ng-content directive is used to define insertion points within a component's template.

  • Example: read more

A Senior Consultant was asked 12mo ago
Q. What is the difference between value type and reference type?
Ans. 

Value types store data directly, while reference types store a reference to the data's memory location.

  • Value types are stored on the stack, while reference types are stored on the heap.

  • Value types include simple types like int, float, and struct, while reference types include classes, interfaces, and arrays.

  • When passing a value type to a method, a copy of the data is passed, while passing a reference type passes a...

Senior Consultant Interview Questions Asked at Other Companies

asked in Capgemini
Q1. 1. What's the use of update sets and how do you move update set f ... read more
Q2. 1. What is Virtual DOM? How does it work & Its algorithm? 2. ... read more
asked in Capgemini
Q3. 1. If MAM is there then why do we need MDM? 2. What are the diffe ... read more
asked in Birlasoft
Q4. What is the difference between the cursors declared in procedures ... read more
asked in Capgemini
Q5. JCL 1. Ways in which the you can paas on data from.jcl to cobol.: ... read more
A Senior Consultant was asked
Q. What is the difference between a business requirement and a functional requirement?
Ans. 

Business requirements define the overall goals and objectives of a project, while functional requirements specify the specific features and functionalities that the system must have to meet those goals.

  • Business requirements focus on the 'what' and 'why' of a project, while functional requirements focus on the 'how'.

  • Business requirements are high-level and non-technical, while functional requirements are detailed a...

🔥 Asked by recruiter 3 times
A Senior Consultant was asked
Q. What is the difference between delete and truncate?
Ans. 

Delete removes specific rows while truncate removes all rows from a table.

  • Delete is a DML operation while truncate is a DDL operation.

  • Delete can be rolled back while truncate cannot be rolled back.

  • Delete operation is slower than truncate operation.

  • Delete operation frees up space in the transaction log while truncate does not.

  • Example: DELETE FROM table_name WHERE condition; TRUNCATE TABLE table_name;

What people are saying about Cognizant

View All
schedule2
Verified Icon
1w
works at
Cognizant
Salary expectation
I have 5+ years of experience in springboot microservices, currently working in CTS and having 10L CTC , wanted to switch in Infosys or Accenture like companies, how much should I ask for 15L-18L ? Just worried if I ask more they can reject my application, please help me with some numbers
Got a question about Cognizant?
Ask anonymously on communities.
A Senior Consultant was asked
Q. How many ways are there to resolve loops during universe building?
Ans. 

There are multiple ways to resolve loops during universe building.

  • One way is to use aggregate awareness to avoid loops.

  • Another way is to use aliases to create a self-join.

  • A third way is to use contexts to define the scope of the query.

  • It is also important to ensure that the join paths are correct and optimized.

  • Testing and debugging can help identify and resolve any remaining loops.

A Senior Consultant was asked
Q. Suppose a train is arriving at a constant speed of 124 km/hr and you are sitting under the train. What is your speed?
Ans. 

The speed of the person sitting under the train is zero.

  • The person sitting under the train is stationary.

  • The speed of the train does not affect the speed of the person.

  • The person's speed is relative to the ground, not the train.

A Senior Consultant was asked
Q. How do you create stored procedures in a complex manner for reporting purposes?
Ans. 

Creating a stored procedure for complex reporting involves defining parameters, writing SQL logic, and optimizing performance.

  • Define the purpose of the report and the data needed.

  • Use CREATE PROCEDURE syntax to start defining the stored procedure.

  • Include input parameters for dynamic filtering, e.g., @StartDate, @EndDate.

  • Write SQL queries within the procedure to fetch and manipulate data.

  • Utilize temporary tables or ...

Are these interview questions helpful?
A Senior Consultant was asked
Q. If a glass is filled with water beyond its capacity, why doesn't the water immediately fall out, and what is the reason for this?
Ans. 

Water does not fall from a filled glass because of surface tension and gravity.

  • Surface tension of water creates a force that holds it together and prevents it from overflowing.

  • Gravity pulls the water downwards, keeping it inside the glass.

  • The shape of the glass also plays a role in containing the water.

  • If the glass is filled beyond its capacity, the surface tension may break and water will overflow.

A Senior Consultant was asked
Q. How do you customize reports?
Ans. 

Report customisation can be done by using tools like Crystal Reports or SSRS to modify the layout and data displayed.

  • Identify the report to be customised

  • Determine the changes to be made

  • Use a report customisation tool like Crystal Reports or SSRS

  • Modify the layout and data displayed

  • Test the customised report to ensure accuracy

A Senior Consultant was asked
Q. How do you manage reports under CMC?
Ans. 

Report managing under CMC involves creating, scheduling, and distributing reports.

  • Create reports using CMC's report creation tools

  • Schedule reports to run at specific times or intervals

  • Distribute reports to specific users or groups

  • Monitor report usage and performance

  • Customize report templates and layouts

  • Examples: Sales reports, financial reports, inventory reports

Cognizant Senior Consultant Interview Experiences

21 interviews found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Critical thinking and analytical skills
  • Q2. Prompt answering skills

Senior Consultant Interview Questions & Answers

user image Sivasubramanian Gopalakrishnan

posted on 10 Aug 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. What is content Projection
  • Ans. 

    Content Projection is a technique used in Angular to insert dynamic content into a component template.

    • Content Projection allows for the insertion of HTML elements or components into a component's template from the outside.

    • It is commonly used in Angular for creating reusable components with dynamic content.

    • ng-content directive is used to define insertion points within a component's template.

    • Example: read more

  • Answered by AI
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. All are project Related
  • Q2. Difference between value type and reference type
  • Ans. 

    Value types store data directly, while reference types store a reference to the data's memory location.

    • Value types are stored on the stack, while reference types are stored on the heap.

    • Value types include simple types like int, float, and struct, while reference types include classes, interfaces, and arrays.

    • When passing a value type to a method, a copy of the data is passed, while passing a reference type passes a refe...

  • Answered by AI

Skills evaluated in this interview

Senior Consultant Interview Questions & Answers

user image Vinay Domala

posted on 13 May 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Nov 2023. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. What are the Performance tuning you have did in your project
Round 2 - Group Discussion 

How do you create api from scratch explain in detail

Round 3 - HR 

(1 Question)

  • Q1. Back gorund details and documents of proof

Interview Preparation Tips

Interview preparation tips for other job seekers - Good place to work, interview was good
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Jan 2024. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. 2 rounds more questions around scanning, tools integration and networking
Round 2 - HR 

(2 Questions)

  • Q1. Where do you want to see yourself. whats your leaning curve
  • Q2. Where do you want to see yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus more on the networking advanced
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Dec 2023. There were 4 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Job related specific questions related to experience.
  • Q2. Case studies
Round 2 - One-on-one 

(2 Questions)

  • Q1. Case studies on Manufacturing and Logistics
  • Q2. Smart factory initiative related questions.
Round 3 - One-on-one 

(1 Question)

  • Q1. Industry trends
Round 4 - HR 

(1 Question)

  • Q1. Salary & Role negotiation
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
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 

Create a video on your experience

Round 3 - One-on-one 

(2 Questions)

  • Q1. Why you want to join Cognizant ? Why Analytics Consulting ?
  • Q2. Introduce yourself ?

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through profile and the JD. Learn about cognizant and its culture.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
-

I applied via Naukri.com and was interviewed before Jan 2023. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Difference between business requirement and functional requirement.
  • Ans. 

    Business requirements define the overall goals and objectives of a project, while functional requirements specify the specific features and functionalities that the system must have to meet those goals.

    • Business requirements focus on the 'what' and 'why' of a project, while functional requirements focus on the 'how'.

    • Business requirements are high-level and non-technical, while functional requirements are detailed and te...

  • Answered by AI
Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview before Mar 2024, where I was asked the following questions.

  • Q1. Pmoss related questions
  • Q2. About project management

Senior Consultant Interview Questions & Answers

user image SUNDARRAJAN.M.M.

posted on 28 Nov 2022

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 

(2 Questions)

  • Q1. What is the difference between delete and truncate
  • Ans. 

    Delete removes specific rows while truncate removes all rows from a table.

    • Delete is a DML operation while truncate is a DDL operation.

    • Delete can be rolled back while truncate cannot be rolled back.

    • Delete operation is slower than truncate operation.

    • Delete operation frees up space in the transaction log while truncate does not.

    • Example: DELETE FROM table_name WHERE condition; TRUNCATE TABLE table_name;

  • Answered by AI
  • Q2. Truncate is DDL and Delete is DML
  • Ans. 

    Truncate and Delete are SQL commands used to remove data from a table.

    • Truncate is a DDL (Data Definition Language) command used to remove all data from a table.

    • Delete is a DML (Data Manipulation Language) command used to remove specific rows from a table.

    • Truncate is faster than Delete as it does not log individual row deletions.

    • Truncate cannot be rolled back, while Delete can be rolled back using a transaction.

    • Truncate...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Technically be prepared, and learn basis of plsql. The technical interview process went for 40 min and it was a good interaction

Skills evaluated in this interview

Cognizant Interview FAQs

How many rounds are there in Cognizant Senior Consultant interview?
Cognizant interview process usually has 2 rounds. The most common rounds in the Cognizant interview process are Technical, One-on-one Round and HR.
How to prepare for Cognizant Senior Consultant 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 Cognizant. The most common topics and skills that interviewers at Cognizant expect are Consulting, Requirement Gathering, RFP, Business Development and Relationship Management.
What are the top questions asked in Cognizant Senior Consultant interview?

Some of the top questions asked at the Cognizant Senior Consultant interview -

  1. let us assume that a glass of water is fullfilled with exceeds its range so wh...read more
  2. suppose a train is arriving at a constant speed of 124 km/hr n u r sitting unde...read more
  3. WHAT ARE THE AVAILABLE FILTERS PRESENTS IN BI reports n what r they ?at report ...read more

Tell us how to improve this page.

Overall Interview Experience Rating

3.8/5

based on 12 interview experiences

Difficulty level

Easy 17%
Moderate 83%

Duration

Less than 2 weeks 67%
4-6 weeks 33%
View more
Cognizant Senior Consultant Salary
based on 2.7k salaries
₹11.9 L/yr - ₹27 L/yr
7% more than the average Senior Consultant Salary in India
View more details

Cognizant Senior Consultant Reviews and Ratings

based on 166 reviews

3.5/5

Rating in categories

3.5

Skill development

3.7

Work-life balance

3.2

Salary

3.5

Job security

3.3

Company culture

2.7

Promotions

3.2

Work satisfaction

Explore 166 Reviews and Ratings
Sr. Consultant

Bangalore / Bengaluru

4-8 Yrs

₹ 15.3-22 LPA

Sr. Consultant

Chennai

10-12 Yrs

₹ 10-36 LPA

Sr. Consultant

Chennai

8-10 Yrs

₹ 7-34 LPA

Explore more jobs
Associate
73.1k salaries
unlock blur

₹5.3 L/yr - ₹12.5 L/yr

Programmer Analyst
56.1k salaries
unlock blur

₹3.5 L/yr - ₹7.3 L/yr

Senior Associate
55.2k salaries
unlock blur

₹10 L/yr - ₹23.3 L/yr

Senior Processing Executive
29.8k salaries
unlock blur

₹2.3 L/yr - ₹6.5 L/yr

Technical Lead
19k salaries
unlock blur

₹6 L/yr - ₹21.2 L/yr

Explore more salaries
Compare Cognizant with

TCS

3.6
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

Accenture

3.7
Compare
write
Share an Interview