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

Technical Business Analyst

Company
Company Google
Type
Opportunity Type Internship
Salary
Stipend / Salary 3.5 LPA
Location
Location Chennai, Tamil Nadu
Posted Date
Posted Date Today
Programming fundamentals SQL Requirement gathering Requirement analysis Business process understanding Technical documentation Analytical thinking Attention to detail Communication skills Team collaboration Problem solving Basic API knowledge Debugging
πŸ“–
Placement Papers for Top Tech Companies Open Resource β†—
Provides a collection of previous placement questions that help candidates practice the type of logical and analytical problems asked at Google.
πŸ“–
Interview Experiences and Process Overview Open Resource β†—
Shares detailed candidate experiences and outlines the interview stages, useful for preparing for Google's recruitment rounds.
πŸ“–
Comprehensive Guide to Google Recruitment Open Resource β†—
Offers tips, sample questions and preparation strategies tailored for Google’s selection process.
πŸ“–
Algorithm Practice Problems Open Resource β†—
A vast repository of coding problems to sharpen problem‑solving skills required for technical interviews at Google.

Graduates of the 2026 batch only. Freshers with no prior work experience. BE/B.Tech in Computer Science, Information Technology or related disciplines, or MCA/equivalent qualification. Minimum 70% aggregate throughout academics. No active backlogs at the time of application. Candidate must be a Chennai native or permanently settled in Chennai.

1
Round 1: Online aptitude test (logical reasoning, quantitative & basic programming)
2
Round 2: Technical interview (SQL, requirement analysis, problem‑solving)
3
Round 3: HR interview (fitment, communication, career aspirations)
ZakApps Software Pvt Ltd is an emerging product‑centric software house based in Chennai. Founded by a group of technology enthusiasts, the company focuses on building end‑to‑end solutions for retail, logistics and fintech domains. Over the past few years ZakApps has delivered several SaaS platforms that help businesses automate their core processes, improve data visibility and accelerate decision‑making. The firm prides itself on a collaborative culture where fresh talent is given real responsibility early in their career, enabling rapid skill growth and exposure to the full software lifecycle. The Technical Business Analyst – Fresher role sits at the intersection of technology and business. As a bridge between product owners, developers and quality teams, the analyst will translate high‑level business problems into clear, actionable technical specifications. The position is ideal for candidates who have a solid grounding in programming fundamentals and a curiosity for how software can solve real‑world challenges. You will work on live projects, attend requirement‑gathering workshops, draft functional documents, and assist developers in building features that align with business goals. Key Responsibilities: 1. Gather, clarify and document business requirements from stakeholders. 2. Analyse technical feasibility and propose practical solutions. 3. Create functional specifications, user stories and process flow diagrams. 4. Collaborate with development teams to ensure accurate implementation of requirements. 5. Perform SQL queries to extract and validate data for requirement verification. 6. Identify gaps, dependencies and potential risks in the requirement set. 7. Support the QA team by preparing test scenarios and reviewing test results. 8. Maintain up‑to‑date documentation in the project repository. 9. Participate in product brainstorming sessions and contribute ideas for improvement. 10. Communicate progress and blockers effectively to both technical and non‑technical audiences. Tech Stack & Tools: Basic programming (Java/Python), SQL, relational databases (MySQL/PostgreSQL), requirement‑management tools (Jira/Confluence), version control (Git) and a working knowledge of REST APIs. While deep expertise is not expected, familiarity with these technologies will help you hit the ground running. Growth Path: Starting as a Technical Business Analyst, you can progress to Senior Analyst, Product Owner, or move into specialised roles such as Data Analyst, Solution Architect or Project Manager, depending on your interests and performance. ZakApps encourages continuous learning through internal workshops, certifications and mentorship programs. Why Join ZakApps? You will be part of a fast‑growing startup that values innovation, offers hands‑on experience with real customers, and provides a clear roadmap for career advancement. The role gives you a unique blend of technical exposure and business acumen, setting a strong foundation for a versatile career in technology consulting or product development.

Google β€” 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 🎯
Google Interview Preparation Corner

Comprehensive guide covering typical interview formats, common questions, and preparation tips for Google 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 (Programming fundamentals, SQL, Requirement gathering, Requirement analysis, Business process understanding, Technical documentation, Analytical thinking, Attention to detail, Communication skills, Team collaboration, Problem solving, Basic API knowledge, Debugging) & 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
Google 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 Google as a Technical Business Analyst?
Preparation Tip: Highlight Google's market reputation, recent tech innovations, and how your skills in Programming fundamentals 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 Engineering

View Category Feed β†—
Google
Technical Business Analyst
Apply Apply Now β†—
Chat Chat with Kashii