Free · takes a minute · your resume fills your profile
CoreHRx never asks candidates for money. If anyone does, .
Role at a glance
Education
Bachelor's degree (preferred)
Must-have skills
Inventory ManagementMS Excel
How well do your skills match this job?
Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
Job description
Location: Thiruvananthapuram, India
Merchandising Officer Location: Ambalathara Service Locations: Trivandrum & Kollam Experience: Relevant experience preferred Working Hours: 9:30 AM – 6:30 PM Job Summary We are looking for a proactive and organised Merchandising Officer to manage inventory monitoring, coordinate with client stores, track sales trends and collect purchase orders from existing customers. Key Responsibilities
Regularly visit client stores and monitor inventory levels.
Track product availability and stock movement at client locations.
Analyse sales trends and prepare regular sales reports.
Collect purchase orders from existing clients.
Coordinate with the internal team for order processing and fulfilment.
Follow up with clients regarding stock requirements and pending orders.
Identify fast-moving and slow-moving products.
Ensure proper product availability at client stores.
Maintain strong relationships with existing customers.
Provide regular updates on inventory and merchandising activities to management. Requirements Required Qualifications & Skills
Bachelor's degree in any discipline preferred.
Experience in merchandising, retail operations, sales coordination or inventory management will be an advantage.
Good communication and interpersonal skills.
Basic knowledge of inventory management and sales reporting.
Proficiency in MS Excel and basic computer applications.
Strong coordination and organisational skills.
Willingness to travel across Trivandrum and Kollam.
This guide is for freshers and experienced professionals in India preparing for the Excel round of MIS executive, accounts, operations, back-office and data analyst interviews, where a practical Excel test is common. It has 60 questions with answers in three levels: the basics every fresher must know (references, VLOOKUP, IF, SUMIFS, text and date functions, pivot tables), real work problems for 1-4 years of experience (lookup errors, dynamic arrays, slicers, Goal Seek), and senior topics such as Power Query, the Data Model, large-file performance and building a monthly MIS report. Sample data and formulas are shown as small tables with their results. Rebuild each example in Excel (Microsoft 365) as you read, then take the mock test.
Questions you may be asked
What is the difference between relative, absolute and mixed cell references?
How does VLOOKUP work, and why do you usually set its last argument to FALSE?