KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
JD #2414
Applications open Internship

Business Analyst with Automation

Citigroup

  • Gurugram, Haryana, India
  • β‚Ή12 LPA – β‚Ή15 LPA (industry‑standard for Analyst roles at Citi in India)
  • 2–4 Years
  • Posted Oct 27, 2026
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

Citi, a leading global financial services firm, operates in more than 160 countries, offering banking, payments, risk management, and investment solutions. In India, Citi has built a strong presence across major metros, fostering a culture of innovation, diversity, and continuous learning. Employees benefit from exposure to cutting‑edge financial technology, cross‑border collaboration, and a robust mentorship ecosystem that accelerates career growth. The Business Analyst with Automation role sits within Citi’s Decision Management and Business Analysis families, focusing on turning massive volumes of digital and retail data into actionable insights. Reporting to the Digital Analytics Lead, the analyst will blend data engineering, visualization, and business acumen to drive performance improvements for Citi’s consumer‑facing platforms. The position is hybrid, with a blend of on‑site collaboration in Gurugram and remote work, enabling flexibility while maintaining close ties with business stakeholders. Key Responsibilities: 1. Acquire, cleanse, and transform large‑scale datasets from multiple sources using Python, PySpark, and SQL. 2. Design, develop, and maintain automated data pipelines that feed daily and weekly reporting cycles. 3. Build interactive Tableau dashboards and visual reports that surface digital performance metrics and customer behaviour trends. 4. Conduct data quality audits, identify inconsistencies, and implement corrective actions to ensure reliable analytics. 5. Translate complex analytical findings into clear business recommendations for non‑technical stakeholders. 6. Collaborate with product, marketing, and risk teams to gather requirements and refine analytics frameworks. 7. Leverage big‑data technologies such as Hive and Impala to query and analyse petabyte‑scale data. 8. Explore Generative AI tools to prototype rapid insights and automate repetitive analytical tasks. 9. Document processes, maintain version‑controlled code repositories, and ensure compliance with Citi’s data governance policies. 10. Participate in continuous improvement initiatives, suggesting enhancements to reporting tools, automation scripts, and analytical methodologies. Tech Stack: Python, PySpark, SQL, Tableau, Hive, Impala, Git, Linux, and optional Generative AI platforms (e.g., ChatGPT, Claude). The role offers a clear growth pathβ€”from Analyst to Senior Analyst, then to Manager or Product Ownerβ€”supported by Citi’s internal learning platforms, certifications, and global mobility programs. Joining Citi provides exposure to world‑class financial data, a collaborative environment that values curiosity, and a compensation package that is competitive within the industry. The blend of technical depth, business impact, and global reach makes this an attractive opportunity for ambitious data professionals.

Eligibility & process

Who can apply

Degree: B.E., B.Tech., M.E., or M.Tech. in Computer Science, Information Technology, Electronics, or related engineering streams. Minimum aggregate: 60% (or CGPA 6.5/10). Batch: Graduates from 2020 onward (to satisfy 2–4 years of experience). No active backlogs at the time of application. Candidates must possess a valid work permit for India.

Skills & stack

Python Pyspark SQL Tableau Hive Impala Generative AI Data Visualization

Selection process

  1. Round 1: Online Assessment (aptitude, logical reasoning, and basic coding).
  2. Round 2: Technical Interview (Python, SQL, PySpark, Tableau, big‑data concepts).
  3. Round 3: HR Interview (fit, motivation, and cultural alignment).

Prep kit

20 resources
Study material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
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, Pyspark, SQL, Tableau, Hive, Impala, Generative AI, Data Visualization) & 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.
Technical questions 5
What is the difference between Implicit Wait, Explicit Wait, and Fluent Wait in Selenium? Answer
Model answer: Implicit Wait sets a global timeout for all element lookups. Explicit Wait pauses execution until a specific ExpectedCondition (e.g. elementToBeClickable) is met. Fluent Wait allows defining polling frequency and ignoring specific exceptions like NoSuchElementException.
Explain the Page Object Model (POM) and its advantages in Test Automation. Answer
Model answer: POM is a design pattern that creates an object repository for web UI elements. It separates test scripts from page locators, reducing code duplication and making maintenance easy when UI elements change.
How do you handle dynamic WebElements whose ID changes on page reload? Answer
Model answer: Use dynamic XPath methods like contains(), starts-with(), text(), or XPath axes (ancestor, following-sibling, parent) instead of brittle absolute paths.
What is the difference between @BeforeMethod and @BeforeClass in TestNG? Answer
Model answer: @BeforeClass runs once before the first test method in the current class, while @BeforeMethod executes before each individual test method.
How do you validate REST API response codes and JSON payload using Postman / RestAssured? Answer
Model answer: In RestAssured: given().when().get('/endpoint').then().assertThat().statusCode(200).body('status', equalTo('ACTIVE')).
Behavioural & HR questions 3
Why do you want to join Citigroup as a Business Analyst with Automation?
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.
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?
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.
Citigroup β‚Ή12 LPA – β‚Ή15 LPA (industry‑standard for Analyst roles at Citi in India)
Recruiter Resume Apply
Chat Chat with Kashii