Cognizant Associate Interview Questions, Process, and Tips

Q1. Nfr gathering details
Add your answer
Q2. What challenges did you face
Ans. 
I faced challenges in adapting to a new work environment and learning new processes.
• Adapting to a new work environment

• Learning new processes and systems

• Meeting deadlines under pressure
Answered by AI
Add your answer

Q1. How do you design workload
Ans. 
I design workload by assessing project requirements, setting priorities, allocating resources, and creating a timeline.
• Assess project requirements to determine scope and deliverables

• Set priorities based on deadlines, importance, and dependencies

• Allocate resources such as manpower, budget, and tools

• Create a timeline with milestones and deadlines

• Regularly review and adjust workload as needed
Answered by AI
Add your answer
Q2. How is the performance measured in your organisation
Ans. 
Performance is measured through a combination of KPIs, feedback from supervisors, and peer evaluations.
• Key Performance Indicators (KPIs) are set for each role and regularly reviewed

• Supervisors provide feedback on individual performance during regular check-ins and performance reviews

• Peer evaluations are conducted to gather feedback from colleagues on teamwork and collaboration

• Performance may also be measured through pr
Answered by AI
Add your answer

Q1. What is the expected CTC
Ans. 
The expected CTC is negotiable based on the candidate's experience, skills, and the company's budget.
• CTC is dependent on factors such as candidate's experience, skills, industry standards, and company's budget

• Candidates can research industry standards and company's reputation to gauge expected CTC

• Negotiation skills can play a key role in determining the final CTC offer
Answered by AI
Add your answer
Q2. What is total work experience
Ans. 
Total work experience refers to the cumulative number of years a person has worked in various roles and positions.
• Total work experience includes all paid and unpaid work, internships, and volunteer positions.

• It is important to mention the total number of years of work experience on your resume or job application.

• Employers often look for candidates with a certain amount of total work experience in a specific field or in...read more
Answered by AI
Add your answer

Write sql query to find nth rank

Q1. Write a query to find the duplicate rows
Ans. 
Query to find duplicate rows in a database table
• Use GROUP BY clause to group rows with same values

• Use HAVING clause to filter out groups with count greater than 1

• Select columns to display duplicate rows
Answered by AI
Add your answer
Q2. Write a query to find the unique records
Ans. 
Query to find unique records
• Use SELECT DISTINCT to retrieve only unique records

• Specify the columns you want to check for uniqueness

• Consider using GROUP BY if you need to find unique records based on specific criteria
Answered by AI
Add your answer

Q1. Tell me about agile methodology
Ans. 
Agile methodology is a project management approach that emphasizes flexibility, collaboration, and iterative development.
• Agile focuses on delivering value to customers through continuous planning, feedback, and adaptation.

• It involves breaking down projects into smaller, manageable tasks called sprints.

• Teams work closely together and with stakeholders to prioritize tasks and make quick decisions.

• Common agile frameworks ...read more
Answered by AI
Add your answer