i
Cognizant
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Program to manipulate an array of strings
Use string manipulation functions like substring, concat, etc.
Iterate through the array using loops
Consider sorting or searching algorithms if needed
I applied via Naukri.com and was interviewed in Sep 2023. There were 3 interview rounds.
Comparing tables without MINUS keyword
Use JOIN clause to combine the tables and compare the columns
Use UNION ALL to combine the tables and GROUP BY to compare the columns
Use EXISTS clause to check if a record exists in both tables
Use NOT EXISTS clause to check if a record exists in one table but not in the other
SCD stands for Slowly Changing Dimensions, which are used in data warehousing to track changes in data over time.
SCD is used to maintain historical data in a data warehouse
There are three types of SCD: Type 1, Type 2, and Type 3
Type 1 SCD overwrites old data with new data
Type 2 SCD creates a new record for each change and maintains a history of changes
Type 3 SCD adds new columns to the existing record to track changes
What people are saying about Cognizant
Cognizant interview questions for designations
I applied via Recruitment Consultant and was interviewed in Dec 2017. There were 3 interview rounds.
I applied via Referral and was interviewed before Jan 2021. There was 1 interview round.
I applied via Walk-in and was interviewed before Jul 2021. There was 1 interview round.
based on 2 interviews
Interview experience
based on 32 reviews
Rating in categories
Associate
72.2k
salaries
| ₹5.2 L/yr - ₹16 L/yr |
Programmer Analyst
55.6k
salaries
| ₹2.4 L/yr - ₹9.4 L/yr |
Senior Associate
49.5k
salaries
| ₹8.9 L/yr - ₹28 L/yr |
Senior Processing Executive
29k
salaries
| ₹1.8 L/yr - ₹9 L/yr |
Technical Lead
17.6k
salaries
| ₹5.9 L/yr - ₹25 L/yr |
TCS
Infosys
Wipro
Accenture