Cognizant Data Manager Interview Questions and Answers

It was good,Who will pass the test they will get into interview otherwise they are not selected for next round.
I cleared my Aptitude test.

Q1. Just the introduction of ours and background
Add your answer

Forecasting problem - Predict daily sku level sales

Q1. What is difference between bias and variance
Ans. 
Bias is error due to overly simplistic assumptions, variance is error due to overly complex models.
• Bias is the error introduced by approximating a real-world problem, leading to underfitting.

• Variance is the error introduced by modeling the noise in the training data, leading to overfitting.

• High bias can cause a model to miss relevant relationships between features and target variable.

• High variance can cause a model to ...read more
Answered by AI
Add your answer
Q2. Parametric vs non parametruc model
Ans. 
Parametric models make strong assumptions about the form of the underlying data distribution, while non-parametric models do not.
• Parametric models have a fixed number of parameters, while non-parametric models have a flexible number of parameters.

• Parametric models are simpler and easier to interpret, while non-parametric models are more flexible and can capture complex patterns in data.

• Examples of parametric models inc...read more
Answered by AI
Add your answer

Q1. What is scd type 2?
Ans. 
SCD type 2 is a method used in data warehousing to track historical changes by creating a new record for each change.
• SCD type 2 stands for Slowly Changing Dimension type 2

• It involves creating a new record in the dimension table whenever there is a change in the data

• The old record is marked as inactive and the new record is marked as current

• It allows for historical tracking of changes in data over time

• Example: If a cust...read more
Answered by AI
Add your answer
Q2. Pyspark question read CSV from folder and add column in each csv file and write it to different location.
Add your answer

1. Questions on spark basica
2. Sql coding questions
3. Java or scala basics

Q1. Tell me your self
Ans. 
I am a detail-oriented individual with strong data entry skills and experience in various industries.
• I have worked as a data entry operator for 2 years at XYZ company

• I am proficient in Microsoft Excel and have experience in data analysis

• I have excellent typing speed and accuracy

• I am a quick learner and can adapt to new software and systems easily
Answered by AI
View 1 more answer
Q2. About your family members
Add your answer
Q3. About our company
Add your answer
Q4. Freshers or experienced
Add your answer

Q1. How tfidf works in NLP
Ans. 
TF-IDF is a statistical measure used to evaluate the importance of a word in a document.
• TF-IDF stands for Term Frequency-Inverse Document Frequency

• It is used to weigh a word's importance in a document by considering its frequency in the document and across all documents

• The formula for TF-IDF is: TF-IDF = TF * IDF

• TF (Term Frequency) measures how frequently a term appears in a document

• IDF (Inverse Document Frequency) mea...read more
Answered by AI
Add your answer
Q2. What is the difference between group by and window function in sql
Ans. 
Group by is used to group data based on a column while window function is used to perform calculations on a specific window of data.
• Group by is used to aggregate data based on a specific column

• Window function is used to perform calculations on a specific window of data

• Group by is used with aggregate functions like sum, count, avg, etc.

• Window function is used with analytical functions like rank, lead, lag, etc.

• Group by ...read more
Answered by AI
Add your answer

Q1. Tell me about the project you worked on 4 years back
Ans. 
Developed a predictive model to forecast customer churn for a telecom company.
• Used machine learning algorithms like logistic regression and random forest.

• Preprocessed and cleaned the dataset by handling missing values and outliers.

• Performed feature engineering to create new variables for better model performance.

• Evaluated model performance using metrics like accuracy, precision, and recall.

• Implemented the model in prod
Answered by AI
Add your answer
Q2. Why are you leaving your current company
Ans. 
Seeking new challenges and opportunities for growth.
• Looking for a more challenging role that aligns with my career goals.

• Seeking a company that values innovation and encourages professional development.

• Want to work in a more collaborative and diverse team environment.

• Desire to explore new technologies and industries.

• Current company lacks opportunities for advancement or career growth.
Answered by AI
Add your answer

Q1. 1)Tell me about your self 2) Your educational background
Add your answer
Q2. 3) why it field 4) which certification you have
Add your answer

Quants, logic and English including puzzles and some gk based puzzles as well

The test will be conducted in a interview process

Group discussion is a communicate in a people

Q1. Hr face to face commutation
Add your answer
Q2. Self introduction and
Add your answer

Q1. It is the individual interview
Add your answer
Q2. Personal questions only
Add your answer