Cognizant Lead Consultant Interview Questions and Answers

Q1. OOPS, MVC, ANGULAR
Add your answer
Q2. Design Pattern Singleton, Procedures vs Function
Add your answer

Q1. Implementation Experience and technical logic used in it. Use of different transforms in ETL tool. Sql coding question on duplicate data, joins and rank functions
Ans. 
Implementation experience in ETL tools, SQL coding on duplicate data, joins, and rank functions.
• Experience in implementing ETL processes using tools like Informatica, Talend, or SSIS.

• Knowledge of various transforms such as Filter, Joiner, Lookup, and Aggregator in ETL tools.

• SQL coding proficiency in identifying and removing duplicate data using DISTINCT keyword.

• Understanding of different types of joins like INNER JOIN,...read more
Answered by AI
Add your answer

Q1. Overall experience, project and team management skills. Skill on handling different scenarios in projects
Add your answer

Q1. Explain about your existing role and responsibilities
Add your answer

Q1. Expected package
Add your answer

Q1. Architecture , basic concepts, scripting
Add your answer

Q1. Tell me about your self
Add your answer
Q2. How many company changed till date and why
Add your answer

Q1. Tell me your work experience
Add your answer

Q1. What are fsmo roles, how to identify
Add your answer
Q2. AD related questions
Add your answer

Q1. Your Domain technical questions based on your experience
Add your answer
Q2. Fundamentals should be strong
Add your answer

Q1. What challenges did you face in your last project?
Add your answer
Q2. When you see a problem what’s your first steps towards problem?
Add your answer

Analytical skills should be strong

Q1. SAP PP technical related
Add your answer
Q2. Willing to Travel and are you ok to work any kind of project?
Add your answer

Q1. Salary Expectation and location preference.
Add your answer