Skoruz Interview Questions and Answers

Q1. How you do effort estimation
Add your answer
Q2. Documents required for solution architecture
Add your answer

Q1. How will you find loyal customers for a store like DMart , SmartBazar
Ans. 
Utilize customer transaction data and behavior analysis to identify loyal customers for DMart and SmartBazar.
• Use customer transaction history to identify frequent shoppers

• Analyze customer behavior patterns such as repeat purchases and average spend

• Implement loyalty programs to incentivize repeat purchases

• Utilize customer feedback and reviews to gauge loyalty

• Segment customers based on their shopping habits and preferenc
Answered by AI
Add your answer
Q2. Who is more valuable a customer who is making small transactions everyday or the customer who makes big transactions in a month
Ans. 
It depends on the business model and goals of the company.
• Small transactions everyday can lead to consistent revenue streams and customer engagement.

• Big transactions in a month can indicate high purchasing power and potential for larger profits.

• Consider customer lifetime value, retention rates, and overall business strategy when determining value.
Answered by AI
Add your answer
Q3. What will you do as a data scientist if the sales of a store is declining
Ans. 
I would conduct a thorough analysis of the sales data to identify trends and potential causes of the decline.
• Review historical sales data to identify patterns or seasonality

• Conduct customer surveys or interviews to gather feedback

• Analyze competitor data to understand market dynamics

• Implement predictive modeling to forecast future sales

• Collaborate with marketing team to develop targeted strategies
Answered by AI
Add your answer
Q4. We have to bundle the items together in the units of 2-3 as a single units like chips of 3 packets together. how to identify which items to bundle and number of units. Create a machine learning model for i...read more
Add your answer
Q5. You are working in a project, where your approach towards problem is more innovative while the rest of the team is following conventional approach. how will you convince them to follow your approach.
Ans. 
I would showcase the potential benefits and results of my innovative approach to convince the team.
• Highlight the advantages of the innovative approach such as improved efficiency, accuracy, or cost-effectiveness.

• Provide real-world examples or case studies where similar innovative approaches have led to successful outcomes.

• Encourage open discussion and collaboration within the team to explore the potential of combining ...read more
Answered by AI
Add your answer

1. A store has promotional offers how will you analyse that offers are working in their favour.
2. What data will you require if you want to predict the sales of the chocolate in a store.
3. Why data is distributed normally in linear regression.
4. Difference between linear and logistic regression
5. A person who is senior to you and you are working on the same project. But that person has very bad reputation of misbehaving and being rude to people. And he is doing same with you. What will you do?

Q1. How do you resolve critical issues?
Add your answer
Q2. How do to handle stakeholder's interests?
Ans. 
Handle stakeholder's interests by understanding their needs, communicating effectively, and delivering results.
• Understand the stakeholders' needs and priorities

• Communicate regularly and effectively with stakeholders

• Involve stakeholders in decision-making processes

• Deliver results that align with stakeholders' interests

• Manage expectations and address concerns promptly
Answered by AI
Add your answer

SQL Rank functions.
Python easy to medium DSA programs.
Pyspark Concepts and questions.

Q1. Explain one of your projects in End to End
Add your answer

Q1. What are some of the analytical functions available in SQL?
Ans. 
Analytical functions in SQL are used to perform calculations on sets of rows.
• Aggregate functions like SUM, AVG, COUNT, MIN, MAX

• Window functions like ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD

• Ranking functions like NTILE, PERCENT_RANK, CUME_DIST

• Statistical functions like STDDEV, VARIANCE

• String functions like CONCAT, SUBSTRING, TRIM
Answered by AI
Add your answer

Q1. Median of 2 sorted array
Add your answer
Q2. Linux commands for chmod
Add your answer
Q3. Features of python
Add your answer
Q4. Deepcopy and shallowcopy
Add your answer

Market Research Questions

Q1. What is market research
Add your answer

Q1. Why do you want to join our company?
Add your answer

Q1. What are Covenants in Commercial Lending
Ans. 
Covenants in commercial lending are conditions set by lenders that borrowers must meet to maintain the loan agreement.
• Covenants are financial ratios or performance metrics that borrowers must adhere to

• They are designed to protect the lender by ensuring the borrower remains financially stable

• Examples include debt-to-equity ratio, interest coverage ratio, and minimum liquidity requirements
Answered by AI
Add your answer
Q2. What is the difference between Bank Guarantee and Letter of Credit
Ans. 
Bank Guarantee is a guarantee from a bank that a borrower will fulfill their financial obligations, while Letter of Credit is a payment method where the bank guarantees payment to the seller.
• Bank Guarantee is a guarantee provided by a bank to a beneficiary in case the applicant fails to fulfill their obligations.

• Letter of Credit is a payment method where the bank guarantees payment to the seller upon presentation of sp...read more
Answered by AI
Add your answer
Q3. What is Collateral in Commercial Lending
Ans. 
Collateral in commercial lending refers to assets that a borrower pledges to a lender as security for a loan.
• Collateral can include real estate, equipment, inventory, accounts receivable, or other valuable assets.

• The lender can seize and sell the collateral if the borrower defaults on the loan.

• Collateral helps reduce the lender's risk and allows borrowers to access financing at lower interest rates.

• The value of the col...read more
Answered by AI
Add your answer

Q1. Self Introduction
Add your answer
Q2. Situation based questions like Conflict of interest amongst team members, How to handle in case of high volumes, Any new updates on Secondary Loan Trading
Add your answer
Q3. What is a Credit Agreement
Ans. 
A Credit Agreement is a contract between a borrower and a lender outlining the terms and conditions for a loan.
• It specifies the amount of the loan, interest rate, repayment schedule, and any collateral required.

• The agreement also includes provisions for default, late payments, and other consequences.

• Credit agreements can be for various types of loans, such as mortgages, car loans, or personal loans.
Answered by AI
Add your answer

Aptitude test conducted with normal logical reasoning, verbal ability and quantitative type aptitude problems were asked.

Case study round scheduled with Practice Director:
Started with normal greetings and basic introduction followed by deep dive into the resume and some questions based on what was in my resume. Then started with the case study.
Case : Your client is a totally offline bank ( think of SBI) and wants to undergo a digital transformation (somewhat like HDFC wherein all services are online as well) . How would you create a framework to do so ?

Q1. Estimate the number of viewers who watched 2024 T20 World Cup.
Ans. 
Estimating the number of viewers for the 2024 T20 World Cup.
• Consider past viewership trends for T20 World Cup events.

• Analyze the popularity of cricket in the host country and globally.

• Take into account the impact of digital streaming platforms on viewership.

• Factor in potential growth in viewership due to increased interest in T20 cricket.

• Consult experts in sports broadcasting and market research for insights.
Answered by AI
Add your answer
Q2. Estimate the number of Gyms in Delhi
Ans. 
Estimating the number of Gyms in Delhi based on population density, urbanization, and market demand.
• Consider the population density of Delhi

• Analyze the urbanization level in different areas of Delhi

• Research on the market demand for fitness centers in Delhi

• Consult with local authorities or fitness industry experts for insights

• Use data from online directories or platforms listing Gyms in Delhi
Answered by AI
Add your answer

Q1. It was a cultural fit/HR round taken by the Partner/Managing Partner in the firm. Questions around personality likes/dislikes future goals, MBA aspirations etc were asked
Add your answer

30 easy aptitude questions.

Q1. Video analysis. Summarize the video in bullet points.
Ans. 
Video analysis involves summarizing the content of a video in bullet points.
• Identify key themes or topics discussed in the video

• Highlight important events or moments

• Note any key statistics or data presented

• Summarize the main conclusions or takeaways

• Include any notable visuals or graphics shown
Answered by AI
Add your answer
Q2. Summarize all the examples you saw in the video.
Ans. 
The video showcased various examples of data analysis and visualization techniques.
• Exploratory data analysis using histograms and scatter plots

• Predictive modeling using regression and classification algorithms

• Time series analysis for forecasting future trends

• Text mining for sentiment analysis

• Clustering techniques for customer segmentation
Answered by AI
Add your answer
Q3. Tell me about yourself
Ans. 
I am a recent graduate with a degree in Computer Science and a passion for data analysis and machine learning.
• Recent graduate with a degree in Computer Science

• Passionate about data analysis and machine learning

• Experience with programming languages like Python and R

• Completed projects involving data visualization and predictive modeling
Answered by AI
Add your answer
Q4. Discussion on projects.
Add your answer
Q5. What do you know about mu Sigma?
Ans. 
Mu Sigma is a data analytics and decision sciences company that helps organizations make data-driven decisions.
• Mu Sigma was founded in 2004 and is headquartered in Chicago, Illinois.

• They provide services in areas such as marketing analytics, supply chain analytics, and risk analytics.

• Mu Sigma has worked with Fortune 500 companies across various industries to help them leverage data for better decision-making.

• The compan...read more
Answered by AI
Add your answer
Q6. Why do you want to join Mu Sigma?
Ans. 
I want to join Mu Sigma because of their reputation for providing challenging and impactful data science projects.
• Mu Sigma is known for working on cutting-edge data science projects with top clients

• I am excited about the opportunity to work with a diverse team of data scientists and learn from their expertise

• I believe Mu Sigma's focus on innovation and problem-solving aligns with my own career goals
Answered by AI
Add your answer
Q7. SQL and technical questions based on your projects or tech stack.
Add your answer
Q8. What challenges you faced during your projects?
Ans. 
I faced challenges in data cleaning, feature engineering, and model optimization during my projects.
• Data cleaning: Dealing with missing values, outliers, and inconsistencies in the data.

• Feature engineering: Creating new features from existing data to improve model performance.

• Model optimization: Tuning hyperparameters and selecting the best algorithm for the problem.

• Example: In a project predicting customer churn, I ha...read more
Answered by AI
Add your answer

Q1. What is difference between function and stored procedure
Ans. 
Functions return a single value, while stored procedures can perform multiple operations and return multiple values.
• Functions return a single value, while stored procedures can return multiple values.

• Functions are called in SQL statements, while stored procedures are called using EXECUTE statement.

• Functions cannot have output parameters, while stored procedures can have output parameters.

• Functions cannot modify server ...read more
Answered by AI
Add your answer
Q2. How to implement custom exception in MVC
Ans. 
Custom exceptions can be implemented in MVC by creating a new class that inherits from Exception class.
• Create a new class that inherits from Exception class

• Override the constructor to pass a custom message to the base Exception class

• Throw the custom exception in the MVC controller or service layer
Answered by AI
Add your answer