WRITTEN TEST: 

Aptitude and Coding Test

• SQL and Python based questions
• Basic questions to check aptitude

GROUP DISCUSSION: NO

SKILLS REQUIRED

• SQL
• Python
• Machine Learning

INTERVIEW GUIDELINES

Round 1 : Technical Round

• SQL questions
• Academic Projects
• Basic Machine Learning Questions
• Excel based questions

Questions

• Explain logistic regression.
• What is Qlik QVD File?
• Which one is fastest Resident/ QVD Optimised / DB Load and Why?
• Mapping vs Joins. When and Why?
• What is the Canonical Master calendar?
• Different factors to consider during the dip in sales rate as compared to previous month?
• What is a correlated query and a nested query?
• Distinguish where clause and having by clause.
• What algorithm would you use for differentiating between two categories?
• How to change the major axis in a graph?
• Design a product that will help generate alerts to family members in case of road accidents
• Assumptions of Linear regression
• What is heteroscedasticity?
• Problems with multi-collinearity
• What is RMSE. Explain starting from Error to RMSE. Why Square and square root in RMSE
• What is hypothesis testing. How do you do?
• What is P-value?

Round 2 : Techno-managerial Round

• SQL questions
• Guesstimates
• Case Studies

Questions

• How many traffic lights are there in your area?
• How many domestic flights are there in India?
• How can you manage your inventory in your grocery shop?
• If you can travel back in time, What is one suggestion you will give to yourself ?
• You have a new client engagement starting after the weekend and your current client has changed the requirements for the recent sprint. How will you handle the situation?
• If you do not have experience in the CPG industry and your client has asked a specific question that you do not know the answer to. How will you handle this situation?
• Guess the number of uber rides on an average day in Delhi.
• What factors would a big bazaar consider while opening a new store?
• Estimate the amount of Detergent consumed in your city.
• Approach to optimize Inventory process for your client
• Find out which products are not selling on E-commerce shop.

Round 3 : HR Round

• Scenario based questions

Questions

• Explain your previous projects.
• Why Fractal?
• What can you change in yourself?
• What motivates you to be in advanced Analytics?
• What are your goals?
• Explain the kind of projects you would like to work on.
• Explain your corporate journey till now.
• Where do you see yourself 5 years down the line?
• Give us an instance when you worked in a team where you weren't the leader and how you contributed?

MPLOYEE.ME TIPS

• Make business sense out of everything.
• Communication is very important along with logical business acumen to convey your thought process.
• Go through the basic concepts,they focus a lot of basics
• Thorough knowledge of projects/ internships