Tredence
10+ Ingram Micro India Ssc Interview Questions and Answers
You are given a string 'STR' of lowercase English alphabets. You need to find the repeated character present first in the string.
Example:
If the string is: “abccba”, then the first repe...read more
You are given an integer array 'ARR' of size 'N' and an integer 'S'. Your task is to return the list of all pairs of elements such that each sum of elements of each pair equals 'S'.
Note:
Each pair shou...read more
I was asked a guesstimate how much petrol is used in one day in your city.
How to find your name in table in SQL.
Select all the names starting with 'a' and city='Delhi'
10 coins given and one of the coin is having greater weight then others and we have a measuring device how much least comparison required for finding out the heavy coin
I was asked how to manage warehouse of a brand having Stores in various cities during high demand and low supply during times like covid.
Q7. what do you know about tredence youtube recommendation system - explain how it recommend videos ,factors it consider to do so mainly from resume & hobby as usual hr question
Tredence YouTube recommendation system uses algorithms to suggest videos based on user preferences and behavior.
Tredence YouTube recommendation system uses machine learning algorithms to analyze user data such as watch history, likes, and dislikes.
It considers factors like video content, user demographics, and engagement metrics to recommend relevant videos.
For example, if a user frequently watches cooking videos, the system may suggest more cooking-related content.
Tredence's...read more
Q8. Find the product_id that got returned more than 10 times in a month and more than 3 times in a year?
Identify product_id with more than 10 returns in a month and 3 returns in a year.
Filter the dataset by returns in a month and returns in a year
Group the data by product_id and count the number of returns
Identify product_id with counts exceeding the thresholds
Q9. Find the customer_id with maximum number of purchases consecutively?
Customer_id with maximum consecutive purchases
Identify consecutive purchases for each customer
Track the maximum consecutive purchases and corresponding customer_id
Consider edge cases like ties or no consecutive purchases
Q10. How to cut a cake in parts with 3 slices
Cut the cake into 3 equal parts using 2 straight cuts
Make the first cut horizontally through the middle of the cake
Make the second cut vertically through the middle of the cake, perpendicular to the first cut
Each slice will be a third of the cake
Q11. Find unique elements in an array
Use a set to find unique elements in an array of strings
Create a set from the array to automatically remove duplicates
Convert the set back to an array to get unique elements
Example: ['apple', 'banana', 'apple', 'orange'] -> ['apple', 'banana', 'orange']
Q12. What is joins and types?
Joins are used to combine rows from two or more tables based on a related column between them.
Types of joins include inner join, left join, right join, and full outer join
Inner join returns rows when there is at least one match in both tables
Left join returns all rows from the left table and the matched rows from the right table
Right join returns all rows from the right table and the matched rows from the left table
Full outer join returns all rows when there is a match in eit...read more
Q13. Guesstimate certain situations
Estimate the number of cars passing through a busy intersection in a day
Estimate the average number of cars passing through the intersection per hour
Consider peak traffic hours and adjust the estimate accordingly
Factor in any special events or holidays that may affect traffic flow
Top HR Questions asked in Ingram Micro India Ssc
Interview Process at Ingram Micro India Ssc
Top Data Analyst Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month