TEKsystems SAS Programmer Analyst Interview Questions and Answers

100 chooses total in that 50 coding,25 aptitude,25english -round 1

Q1. General hr questions
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

The first was a mcq based coding round for campus placement

This was a pairing coding round

Q1. Explain different unsupervised algo
Ans. 
Unsupervised algorithms are used to find patterns in data without labeled outcomes.
• K-means clustering: partitions data into K clusters based on similarity

• Hierarchical clustering: creates a tree of clusters based on similarity

• Principal Component Analysis (PCA): reduces dimensionality by finding orthogonal components

• Association rule mining: discovers interesting relationships between variables in large datasets
Answered by AI
Add your answer

Q1. Data science related areas
Add your answer

Case study related to semantic search

Q1. Questions based on case study
Add your answer

Q1. Technicals based on case study
Add your answer

Q1. Cultural fit round one on one
Add your answer

Q1. Concepts and tools
Add your answer

Coding on the tools we use

Q1. Not cleared the round
Add your answer

English, Maths, Reasoning

Q1. Bssic C questions
Add your answer

Q1. Just formal discussion on the available role
Add your answer