Tredence
10+ AJMS Global Interview Questions and Answers
Q1. Puzzle: Given two hour glass, one measuring 4 mins and the other 7 mins, how to measure 9 mins
To measure 9 minutes using two hourglasses of 4 and 7 minutes, start both hourglasses simultaneously. When the 4-minute hourglass runs out, flip it again. When the 7-minute hourglass runs out, flip it again. When the 4-minute hourglass runs out for the third time, 9 minutes will have passed.
Start both hourglasses simultaneously
When the 4-minute hourglass runs out, flip it again
When the 7-minute hourglass runs out, flip it again
When the 4-minute hourglass runs out for the thir...read more
How to change the data type and push the data into a database?
Guesstimate on how many people uses mobile phones in India
Medium level SQL queries were asked on joins, pivot.
Q5. How you reduce error in model Which kind of matrix used in your model How you map data
To reduce error in a model, I use techniques like cross-validation, regularization, and feature selection. I use matrices like confusion matrix and correlation matrix. Data is mapped using techniques like normalization and encoding.
Reduce error in model by using techniques like cross-validation, regularization, and feature selection
Use matrices like confusion matrix to evaluate classification models and correlation matrix to analyze relationships between variables
Map data usi...read more
Q6. 1.) Case Study: How Many people will drink tea on a certain day?
The number of people who will drink tea on a certain day can vary based on factors like weather, cultural preferences, and individual habits.
Consider factors like weather - more people may drink tea on a cold day.
Take into account cultural preferences - some cultures have a strong tea-drinking tradition.
Individual habits play a role - regular tea drinkers are more likely to consume tea daily.
Survey data or sales figures can provide insights into tea consumption patterns.
Event...read more
Q7. What are different optimisation techniques you have used so far in databricks
I have used techniques like hyperparameter tuning, feature engineering, and model selection in Databricks for optimization.
Hyperparameter tuning using GridSearchCV or RandomizedSearchCV
Feature engineering to create new features or transform existing ones
Model selection using techniques like cross-validation or ensemble methods
Q8. Applications of data science in other industries. 1 guestimate and puzzel
Data science is used in various industries like finance, marketing, healthcare, and transportation to analyze trends, make predictions, and optimize processes.
Finance: Predictive analytics for stock market trends and risk assessment.
Marketing: Customer segmentation and targeted advertising campaigns.
Healthcare: Predictive modeling for disease diagnosis and treatment.
Transportation: Route optimization and demand forecasting for ride-sharing services.
Q9. Describe any over Forecasting Methodology
Over Forecasting Methodology involves predicting higher values than the actual outcome.
Over forecasting can lead to excess inventory and increased costs.
It can also result in missed sales opportunities due to inaccurate predictions.
Common causes of over forecasting include relying on outdated data or not considering external factors.
For example, a company may over forecast demand for a product leading to excess stock that needs to be discounted or disposed of.
Implementing reg...read more
Q10. Brief overview of implementations in Salesforce
Salesforce is a CRM platform used for various implementations like sales, marketing, customer service, etc.
Sales Cloud for sales automation
Service Cloud for customer service management
Marketing Cloud for marketing automation
Community Cloud for building online communities
Einstein Analytics for data analysis
Q11. Rate yourself in sql and python
I rate myself highly in SQL and Python.
I have extensive experience in writing complex SQL queries and optimizing database performance.
I am proficient in Python and have used it for data analysis, automation, and web scraping.
I have worked on various projects where I utilized both SQL and Python together to extract, transform, and load data.
I am familiar with popular SQL databases like MySQL, PostgreSQL, and Oracle, as well as Python libraries like pandas and SQLAlchemy.
Q12. Explaining company's expectations
Company's expectations should be clearly communicated to employees to ensure alignment and success.
Clearly outline job responsibilities and performance metrics
Provide regular feedback and opportunities for growth
Encourage open communication and collaboration within teams
Q13. Custom reports in Salesforce
Custom reports in Salesforce allow users to create personalized reports based on specific criteria.
Custom reports can be created by selecting the desired fields, filters, and grouping criteria.
Users can also add charts, graphs, and tables to visualize the data in the report.
Custom reports can be scheduled to run at specific times and be shared with other users.
Examples of custom reports include sales performance by region, lead conversion rates, and customer satisfaction scor...read more
Q14. Predict sofas sold in a city
To predict sofas sold in a city, analyze historical sales data, consider population size, income levels, housing trends, and competitor activity.
Analyze historical sales data to identify trends and patterns
Consider the population size of the city as a potential market
Take into account income levels of residents to determine purchasing power
Analyze housing trends to understand demand for furniture
Consider competitor activity and market saturation in the city
Top HR Questions asked in AJMS Global
Interview Process at AJMS Global
Top Analyst Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month