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

Machine Learning Analyst- Python and SQL

Company
Company Citigroup
Type
Opportunity Type Internship
Salary
Stipend / Salary 8-10 LPA
Location
Location Haryana, India
Posted Date
Posted Date Today
Python SQL Machine Learning PySpark NLP LLM/Gen AI Prompt Engineering Git Jenkins API Data Visualization Statistical Modeling Data Cleaning SDLC Agile/Sprints
πŸ“–
Data Analysis Fundamentals Open Resource β†—
Provides essential concepts for data cleaning, exploration, and visualization, crucial for building reliable ML models at Citi.
πŸ“–
Advanced Programming Techniques Open Resource β†—
Covers Python and SQL best practices, helping candidates write efficient, production‑ready code for Citi’s analytics pipelines.
πŸ“–
Interview Preparation for Analytics Roles Open Resource β†—
Offers mock interview questions and case studies tailored to analytics and data science positions, useful for Citi’s interview process.
πŸ“–
Algorithmic Problem Solving Open Resource β†—
Focuses on coding challenges that test algorithmic thinking, a key component of Citi’s technical interviews.

Bachelor’s degree in Computer Science, IT, or related field with at least 3 years of professional experience, or Master’s degree with 2 years of experience. Minimum 60% aggregate in the qualifying degree. Candidates must meet Citi’s backlog policy and be eligible for employment in India.

1
Round 1: Technical interview covering Python, SQL, and ML concepts
2
Round 2: Deep technical interview with case study and coding challenge
3
Round 3: HR interview focusing on cultural fit and career aspirations
Citi, one of the world’s largest financial institutions, has a rich legacy of 200 years in providing innovative banking solutions. With a global footprint spanning over 200 countries, Citi empowers millions of customers and businesses to achieve their financial goals. In India, Citi’s presence is strong across major metros, offering a blend of traditional banking services and cutting‑edge digital products. The company is known for its inclusive culture, emphasis on continuous learning, and a commitment to responsible growth. The Machine Learning Analyst role is situated within the Analytics and Information Management (AIM) team, specifically the North America Consumer Bank – Customer Experience (CX) Analytics function. This team focuses on understanding and enhancing customer interactions across all touchpoints. As a Machine Learning Analyst, you will work with large, complex data sets to uncover insights that drive customer satisfaction and business performance. Your work will directly influence product decisions, process improvements, and strategic initiatives. Key responsibilities include: 1. Collecting, cleaning, and preprocessing internal and external data using SQL and Python. 2. Building predictive models and statistical analyses to forecast customer behavior and identify pain points. 3. Developing and deploying machine learning pipelines, including PySpark and NLP models, to support real‑time decision making. 4. Creating data visualizations and dashboards to communicate findings to stakeholders. 5. Collaborating with cross‑functional teams (product, engineering, CX) to translate insights into actionable solutions. 6. Managing model lifecycle – from version control with Git to automated deployment via Jenkins. 7. Ensuring compliance with data governance, security, and regulatory requirements. 8. Participating in sprint cycles, providing technical guidance, and mentoring junior analysts. 9. Staying updated on emerging technologies such as Large Language Models and prompt engineering. 10. Documenting data requirements, processes, and best practices for future reference. Tech stack: Python, SQL, PySpark, NLP, LLM/Gen AI, Git, Jenkins, API integration, data visualization tools, statistical modeling libraries. Growth path: Starting as a data analyst, you can progress to senior analyst, lead data scientist, or product analytics manager. Citi’s global network offers opportunities to work on cross‑regional projects, pursue certifications, and attend leadership development programs. Why join Citi? The company offers competitive compensation, a collaborative environment, and a clear career trajectory. Employees benefit from extensive training resources, mentorship, and the chance to work on high‑impact projects that shape the future of banking.

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

Comprehensive guide covering typical interview formats, common questions, and preparation tips for Citigroup 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 (Python, SQL, Machine Learning, PySpark, NLP, LLM/Gen AI, Prompt Engineering, Git, Jenkins, API, Data Visualization, Statistical Modeling, Data Cleaning, SDLC, Agile/Sprints) & 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
Citigroup 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 Citigroup as a Machine Learning Analyst- Python and SQL?
Preparation Tip: Highlight Citigroup's market reputation, recent tech innovations, and how your skills in Python 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 β†—
Citigroup
Machine Learning Analyst- Python and SQL
Apply Apply Now β†—
Chat Chat with Kashii