KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
REQUIREMENT_ID_189 • 3-DAY_ACTIVE_POLICY

Trainee Analyst

Company
Company Shift
Type
Opportunity Type Internship
Salary
Stipend / Salary ₹4.5 LPA
Location
Location Bangalore, Karnataka
Posted Date
Posted Date Today
Attention to detail MS Excel data reconciliation document verification basic SQL analytical thinking communication time management teamwork
📖
Aptitude Practice Questions Open Resource ↗
Curated quantitative and logical reasoning problems to sharpen the analytical skills needed for the online test.
📖
Company Interview Preparation Guide Open Resource ↗
General interview strategies and common fintech questions that help candidates feel confident during technical rounds.
📖
Shift Specific Interview Insights Open Resource ↗
Tailored resources covering Shift’s business model, culture and typical role‑based questions for Trainee Analyst applicants.
📖
Algorithm & Data Structure Problem Set Open Resource ↗
Practice problems to improve logical thinking and data handling, useful for the technical interview’s Excel‑SQL components.

Bachelor’s or Master’s degree in Commerce, Finance, Business Administration or related discipline; minimum 60% aggregate (or CGPA 6.0/10); graduating batch 2024‑2026; no active backlogs; fluent English communication; willingness to work early‑morning Australian shift timings.

1
Round 1: Online aptitude test (quantitative, logical reasoning, English)
2
Round 2: Technical interview (Excel, data handling, compliance basics)
3
Round 3: HR interview (cultural fit, motivation, shift timing suitability)
Shift is a fast‑growing fintech company that helps Australian small‑ and medium‑size enterprises manage cash‑flow, negotiate trade terms and access the right financial products. Founded with a mission to simplify credit and payment processes, Shift has already supported more than 30,000 businesses and facilitated over $6 billion in aggregate funding. The organisation blends deep financial expertise with cutting‑edge technology, creating a collaborative culture where every employee can influence product innovation and customer outcomes. With a head‑quarter in North Sydney and a strong presence in India, Shift offers a truly global perspective while maintaining a flat hierarchy that encourages learning from senior leaders. The Trainee Analyst role is based in Shift’s Bangalore office (JP Nagar) and is designed for fresh graduates who want to build a solid foundation in financial operations. You will be part of the Customer Support Operations department, working closely with loan settlement teams, compliance officers and product managers. The position provides exposure to end‑to‑end loan disbursal and collection processes, regulatory compliance (AML, CTF), and data‑driven reporting. It is an ideal launchpad for a career in fintech, banking or risk management. **Key Responsibilities** 1. Manage the disbursal and collection of loan documentation with precision and timeliness. 2. Review, verify and validate documents against banking and compliance standards. 3. Perform daily reconciliations and maintain accurate settlement records. 4. Update trackers, internal dashboards and loan management systems in real time. 5. Ensure strict adherence to AML, CTF, and internal risk‑compliance frameworks. 6. Meet defined Service Level Agreements (SLAs) and reporting timelines. 7. Collaborate with cross‑functional stakeholders to resolve documentation queries. 8. Prepare periodic compliance and performance reports for senior management. 9. Identify process gaps and suggest automation or workflow improvements. 10. Participate in shift‑timed operations (3:00–4:00 AM start, Mon–Fri) to align with Australian business hours. **Tech Stack & Tools**: MS Excel (advanced functions, pivot tables), SQL basics for data extraction, loan management software (internal), document management systems, and familiarity with compliance tools. **Growth Path**: Successful analysts can progress to Senior Analyst, Compliance Lead, or Product Operations Manager within 2‑3 years, with opportunities to move into data analytics, risk management or product development roles. **Why Join Shift?** The company offers a hybrid work model, a flat structure that accelerates learning, regular knowledge‑sharing sessions every 100 days, generous parental leave, purpose‑built collaborative spaces, and a suite of wellbeing benefits ranging from birthday offs to end‑of‑trip facilities. The exposure to international fintech operations and the chance to work on real‑world loan settlement cycles make this role a unique stepping stone for ambitious graduates.

Shift — 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 🎯
Shift Interview Preparation Corner

Comprehensive guide covering typical interview formats, common questions, and preparation tips for Shift 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 (Attention to detail, MS Excel, data reconciliation, document verification, basic SQL, analytical thinking, communication, time management, teamwork) & 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
Shift 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 Shift as a Trainee Analyst?
Preparation Tip: Highlight Shift's market reputation, recent tech innovations, and how your skills in Attention to detail 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 ↗
Shift
Trainee Analyst
Apply Apply Now ↗
Chat Chat with Kashii