Skoruz Interview Questions and Answers

Q1. Trail balance Corp chat
Add your answer
Q2. Team handling situations based question
Add your answer

Q1. What does S/4 HANA implementation involve?
Ans. 
S/4 HANA implementation involves migrating business processes to SAP's latest ERP system for improved efficiency and real-time analytics.
• Data migration from legacy systems to S/4 HANA

• Business process reengineering to align with S/4 HANA functionalities

• Customization and configuration of S/4 HANA modules

• Training employees on using the new system effectively

• Testing and validation of the implemented solution
Answered by AI
Add your answer
Q2. What is the process for setting up a master data set?
Ans. 
Setting up a master data set involves identifying data sources, cleansing data, defining data attributes, and establishing data governance.
• Identify all relevant data sources that will be included in the master data set

• Cleanse the data to ensure accuracy and consistency

• Define data attributes such as data types, formats, and relationships

• Establish data governance policies and procedures to maintain data quality and integ
Answered by AI
Add your answer

Q1. Royalty process
Add your answer
Q2. Intercompany pricing process
Add your answer

Q1. Team handing Experience and salary discussion
Add your answer

Q1. What's the CI/CD workflow that's followed in your team?
Ans. 
Our team follows a CI/CD workflow that includes automated testing, code reviews, and continuous integration.
• Automated testing is run on every code change to catch bugs early.

• Code reviews are conducted before merging changes to ensure code quality.

• Continuous integration is used to automatically build and test code changes in a shared repository.

• Deployment pipelines are set up to automate the release process.

• Version cont...read more
Answered by AI
Add your answer
Q2. Has there been any security incident and how have you handled those ?
Ans. 
Yes, there have been security incidents and I have handled them effectively.
• Implemented security protocols to prevent future incidents

• Conducted thorough investigation to identify the root cause

• Collaborated with IT team to strengthen security measures

• Communicated with stakeholders to ensure transparency and trust

• Provided training to employees on cybersecurity best practices
Answered by AI
Add your answer
Q3. Difference between authorization and authentication ?
Ans. 
Authentication verifies the identity of a user, while authorization determines what actions a user is allowed to perform.
• Authentication confirms the identity of a user through credentials like passwords or biometrics.

• Authorization determines the level of access or permissions a user has once their identity is confirmed.

• Authentication is the process of logging in, while authorization is the process of granting or denyin...read more
Answered by AI
Add your answer
Q4. LLD for an authentication and authorization system
Ans. 
LLD for an authentication and authorization system
• Separate modules for authentication and authorization

• Use of secure hashing algorithms for storing passwords

• Role-based access control implementation

• Audit logging for tracking user actions

• Integration with external identity providers
Answered by AI
Add your answer

Q1. Design a document managed storage like google drive as an E2E solution.
Ans. 
Design a document managed storage like Google Drive as an E2E solution.
• Implement user authentication and authorization for secure access.

• Create a user-friendly interface for uploading, organizing, and sharing documents.

• Include features like version control, file syncing, and search functionality.

• Utilize cloud storage for scalability and accessibility.

• Implement encryption for data security.

• Integrate with third-party app
Answered by AI
Add your answer

Q1. Qn on fin statements. Given a situation how it would impact three fin statements
Ans. 
Changes in a situation can impact financial statements differently
• Changes in revenue will impact income statement by affecting net income

• Changes in inventory levels will impact balance sheet by affecting assets

• Changes in debt levels will impact cash flow statement by affecting financing activities
Answered by AI
Add your answer
Q2. Qn on DCF
Ans. 
Discounted Cash Flow (DCF) is a valuation method used to estimate the value of an investment based on its future cash flows.
• DCF calculates the present value of expected future cash flows by discounting them back to their current value.

• It takes into account the time value of money, risk, and opportunity cost of capital.

• The formula for DCF is: DCF = CF1/(1+r)^1 + CF2/(1+r)^2 + ... + CFn/(1+r)^n, where CF is cash flow and...read more
Answered by AI
Add your answer

Q1. Case interview focused on calculating the financial aspects of a coffee shop, from fund sourcing to profit calculation,EDA (Excel or paper were not permitted for calculations). the interviewer aimed to a...read more
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. How you do effort estimation
Add your answer
Q2. Documents required for solution architecture
Add your answer

Market Research Questions

Q1. What is market research
Ans. 
Market research is the process of gathering, analyzing, and interpreting information about a market, including customers, competitors, and industry trends.
• Involves collecting data on customer preferences, buying habits, and market trends

• Helps businesses make informed decisions about product development, pricing, and marketing strategies

• Includes techniques such as surveys, focus groups, and data analysis

• Examples: conduc...read more
Answered by AI
Add your answer

Q1. Why do you want to join our company?
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

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