KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
REQUIREMENT_ID_344 β€’ 3-DAY_ACTIVE_POLICY

Logistics Coordinator / Junior Supply Chain Assistant

Company
Company Gusti Leder
Type
Opportunity Type Internship
Salary
Stipend / Salary 2.5 LPA
Location
Location Remote
Posted Date
Posted Date Yesterday
Microsoft Excel VLOOKUP XLOOKUP Pivot Tables IF formulas data analysis communication email writing organization coordination attention to detail
πŸ“–
Aptitude Practice Questions Open Resource β†—
Helps you sharpen quantitative and logical reasoning skills commonly tested in the initial screening round.
πŸ“–
Company Interview Preparation Guide Open Resource β†—
Provides insights into typical interview formats and sample questions for logistics and supply‑chain roles.
πŸ“–
General Interview Preparation Open Resource β†—
Covers behavioural and HR interview strategies to help you present yourself confidently.

Graduates (any discipline). Strong command of English (written & verbal) is essential.

1
Round 1: Online aptitude & Excel proficiency test
2
Round 2: Technical interview focusing on logistics concepts and Excel scenarios
3
Round 3: HR interview assessing cultural fit and communication skills
Gusti Leder GmbH is an Indian‑based arm of the German brand that crafts natural leather products such as bags, backpacks, accessories and stationery. The company prides itself on slow fashion, sustainable sourcing and transparent production processes, partnering with local artisans to deliver high‑quality, durable goods. With a growing online presence and expanding export markets, Gusti Leder is building a robust logistics backbone to support its increasing order volume. The Logistics Coordinator / Junior Supply Chain Assistant role is an entry‑level position designed for fresh graduates who are eager to launch a career in logistics and supply chain management. Reporting to the Operations Manager, the associate will get hands‑on exposure to end‑to‑end shipment handling, documentation, and stakeholder coordination. The role is fully remote, allowing candidates from any part of India to work from home while collaborating with transport partners, warehouses and internal production teams. Key responsibilities include: 1. Coordinating with transporters, warehouses and production units to schedule pickups and deliveries. 2. Tracking shipments in real time and updating status sheets in Microsoft Excel. 3. Following up with logistics partners on delayed or pending consignments. 4. Maintaining shipping records, invoices, e‑way bills, delivery challans and other essential documents. 5. Monitoring movement of goods, flagging discrepancies and escalating issues to the reporting manager. 6. Preparing daily and weekly logistics performance reports. 7. Assisting with import/export documentation when required. 8. Communicating shipment updates to internal stakeholders through professional emails and calls. 9. Ensuring compliance with company logistics processes and documentation standards. 10. Continuously learning logistics best practices and suggesting process improvements. The technical stack revolves around advanced Microsoft Excel – VLOOKUP/XLOOKUP, Pivot Tables, IF formulas, data analysis and reporting. Familiarity with basic ERP or TMS tools is a plus but not mandatory. Over time, high‑performing associates can progress to Senior Logistics Analyst, Supply Chain Coordinator or Operations Manager roles, gaining exposure to strategic planning, vendor management and international trade compliance. Why join Gusti Leder? The company offers a supportive, remote‑first environment where fresh talent is mentored by seasoned professionals. You will work on real‑world logistics challenges, develop strong analytical and communication skills, and grow alongside a brand that values sustainability and ethical production. Immediate joiners are preferred, and the organization encourages ownership, continuous learning and career advancement.

Gusti Leder β€” Data Analytics & SQL Interview Guide

Previously asked questions, exam syllabus, coding benchmarks & round strategy.

APTITUDE & LOGIC πŸ“–
Aptitude Practice Questions & Online Mock Tests

Curated logical, quantitative, and verbal reasoning problems to sharpen reasoning skills required for the initial screening test.

Open Resource β†—
COMPANY GUIDE 🎯
Gusti Leder Interview Preparation Corner

Comprehensive guide covering typical interview formats, common questions, and preparation tips for Gusti Leder and off-campus tech roles.

Open Resource β†—
MOCK TESTS & PAPERS πŸ“
Comprehensive Interview Prep Resources & Syllabus

Collection of previous year questions, company-specific test patterns, and interview experiences for technical and HR rounds.

Open Resource β†—
CODING PRACTICE πŸ’»
Algorithm and Data Structure Problem Set

Practice problems to improve coding proficiency and algorithm problem-solving speed for technical rounds.

Open Resource β†—
Round 1: Online Assessment (OA)
Aptitude, Quantitative Logic & 2 Coding Problems
Focus on accuracy and speed. Practice arrays, strings, and standard arithmetic puzzles.
Round 2: Technical Interview 1
Core Tech Stack (Microsoft Excel, VLOOKUP, XLOOKUP, Pivot Tables, IF formulas, data analysis, communication, email writing, organization, coordination, attention to detail) & Live Code Tracing
Explain your thought process aloud. Analyze time & space complexities before coding.
Round 3: System Design & Problem Solving
Database Schemas, APIs & Architecture Basics
Clarify edge cases, diagram schemas cleanly, and discuss scalability trade-offs.
Round 4: HR & Cultural Fit Discussion
Gusti Leder Core Values, Learning Agility & Offer Terms
Demonstrate passion, strong communication, and readiness for full-time collaboration.
What is the difference between WHERE and HAVING clauses in SQL? Answer β–Ό
Model Answer: WHERE filters rows before any groupings are applied, while HAVING filters aggregated groups after GROUP BY has executed.
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer β–Ό
Model Answer: ROW_NUMBER() assigns unique sequential integers. RANK() assigns identical ranks to ties and skips ranks. DENSE_RANK() assigns identical ranks to ties without skipping rank numbers.
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer β–Ό
Model Answer: Use .isna().sum() to identify missing values. Impute with mean/median using .fillna() or remove with .dropna(subset=[...]) depending on variance impact.
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer β–Ό
Model Answer: Star Schema has denormalized dimension tables directly connected to the central Fact table. Snowflake Schema normalizes dimension tables into sub-dimensions to minimize redundancy.
How do you calculate MoM (Month-over-Month) growth in SQL? Answer β–Ό
Model Answer: Use LAG(revenue, 1) OVER (ORDER BY month) to fetch the previous month's revenue and compute (revenue - prev_revenue) / prev_revenue * 100.
Why do you want to join Gusti Leder as a Logistics Coordinator / Junior Supply Chain Assistant?
Preparation Tip: Highlight Gusti Leder's market reputation, recent tech innovations, and how your skills in Microsoft Excel directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
Preparation Tip: Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
How do you handle strict deadlines or sudden scope changes?
Preparation Tip: Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.

More Fresh Requirements in Software & Tech

View Category Feed β†—
Gusti Leder
Logistics Coordinator / Junior Supply Chain Assistant
Apply Apply Now β†—
Chat Chat with Kashii