Capri Global Capital Senior Data Scientist Interview Questions and Answers for Experienced

Had three coding problems which was each

Q1. What are windows function in SQL
Ans. 
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
• Window functions are used to calculate values based on a set of rows related to the current row.

• They allow you to perform calculations without grouping the rows into a single output row.

• Examples of window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Answered by AI
Add your answer

Q1. What are different algorithm in clustering?
Ans. 
Different clustering algorithms include K-means, DBSCAN, Hierarchical clustering, and Gaussian Mixture Models.
• K-means: partitions data into K clusters based on centroids

• DBSCAN: density-based clustering algorithm

• Hierarchical clustering: builds a tree of clusters

• Gaussian Mixture Models: assumes data points are generated from a mixture of Gaussian distributions
Answered by AI
Add your answer

Asked questions of finance and aptitude

Q1. What is machine learning?
Ans. 
Machine learning is a branch of artificial intelligence that involves developing algorithms and models that enable computers to learn from and make predictions or decisions based on data.
• Machine learning is a subset of artificial intelligence that focuses on developing algorithms that can learn from and make predictions or decisions based on data.

• It involves training models on large datasets to recognize patterns and m...read more
Answered by AI
Add your answer
Q2. What do you know about SQL?
Ans. 
SQL is a programming language used for managing and manipulating relational databases.
• SQL stands for Structured Query Language

• It is used to retrieve and manipulate data in relational databases

• Common SQL commands include SELECT, INSERT, UPDATE, DELETE

• SQL can be used to create tables, indexes, and views

• Examples of SQL databases include MySQL, PostgreSQL, Oracle
Answered by AI
Add your answer
Q3. What you know about software Development?
Ans. 
Software development involves creating, designing, testing, and maintaining software applications.
• Software development includes coding, testing, debugging, and documenting software applications.

• Developers use programming languages like Java, Python, C++, etc. to write code.

• Agile and Waterfall are common software development methodologies.

• Version control systems like Git are used to manage code changes.

• Software developm...read more
Answered by AI
Add your answer

Q1. What are the algorithms you know in machine learning and their details ?
Ans. 
Various machine learning algorithms with brief details
• Supervised Learning: Linear Regression, Logistic Regression, Support Vector Machines (SVM), Decision Trees, Random Forest

• Unsupervised Learning: K-means Clustering, Hierarchical Clustering, Principal Component Analysis (PCA)

• Reinforcement Learning: Q-Learning, Deep Q-Networks (DQN)

• Neural Networks: Convolutional Neural Networks (CNN), Recurrent Neural Networks (RNN), L
Answered by AI
Add your answer
Q2. Python questions
Add your answer

Pen paper test with 5 mcq and 3 coding questions mostly on array sorting etc

Q1. Write a code for concatenation of two arrays without using Math function
Ans. 
Concatenate two arrays without using Math function
• Create a new array with the combined length of the two input arrays

• Iterate through the first array and copy elements to the new array

• Continue iterating through the second array and copy elements to the new array
Answered by AI
Add your answer

1 hour coding test on intermediate python programming

Any assignments so easily clear so please

Q1. Computer and company realative interview
Add your answer
Q2. Any questions any person
Add your answer
Q3. Ok good interview so please
Add your answer
Q4. No any questions so please
Add your answer

Q1. Basic statistics and ML questions.
Add your answer

Q1. Face to face interview round. Asked me to write codes on paper
Add your answer

Q1. Good HR, compensation was better
Add your answer

Q1. It was more related to my projects
Add your answer
Q2. Asked questions on PCA,KNN and Elbow method .
Add your answer

Q1. Asked SVM and Logistic regression, their applications and real life uses
Add your answer
Q2. Matrix formation of a knockout Tournament
Add your answer

Q1. What is your name
Ans. 
My name is John Smith.
• Full name is John Smith

• Common name in English-speaking countries

• Easy to remember and pronounce
Answered by AI
Add your answer
Q2. Tell me about your project experience
Ans. 
I have extensive project experience in implementing ERP systems for large corporations.
• Led a team in the successful implementation of SAP S/4HANA for a Fortune 500 company

• Managed the integration of Oracle ERP Cloud for a global manufacturing company

• Provided training and support for end-users during system go-live

• Worked closely with stakeholders to gather requirements and ensure project alignment
Answered by AI
Add your answer