Sigmoid Senior Data Engineer Interview Questions, Process, and Tips

Q1. Data modeling on website data
Add your answer
Q2. Spark performance tuning
Add your answer

General code testing and mcq

Q1. Technical discussion
Add your answer

Q1. Technical manager discussion.
Add your answer

Q1. Director round with behavioural questions and business commitments attitude check
Add your answer

Q1. HR round with compensations and company policies discussion
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?

They will ask aptitude, reasoning and other questions as an online test to know your problem solving skills.

They will give a topic where either we have to speak or write on that topic

Q1. Intro, questions related to python, guesstimate questions
Add your answer
Q2. Behavorial questions and other hr questions included
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

First round was on Hacker Earth

Q1. Technical round was on Spring Data Jpa, Pagination, SOLID principles
Add your answer

1 hr exam it is easy to crack