Interview Guide

Posts

Wells Fargo Data Analyst Interview and Answers

My Wells Fargo Data Analyst Interview Experience (1–3 Years) CTC: 16 LPA As a data enthusiast and SQL aficionado, I recently tackled some challenging SQL and Python questions in a Wells Fargo interview for a Data Analyst position. The experience was both rewarding and insightful. Here’s how I approached these questions. SQL Questions 1. Identify Inactive Accounts To identify accounts inactive for more than 12 months: sql SELECT AccountID, CustomerID, Balance FROM Accounts WHERE LastTransactionDate < DATEADD( YEAR , -1 , GETDATE()); This query filters accounts where the LastTransactionDate is older than one year. 2. Top 3 Accounts by Transaction Volume Per Month Using ROW_NUMBER() to rank accounts by total transaction volume for each month: sql WITH MonthlyVolume AS ( SELECT AccountID, SUM (Amount) AS TotalVolume, MONTH (TransactionDate) AS TransactionMonth, YEAR (TransactionDate) AS TransactionYear FROM Transactions GROUP...

SQL Questions Asked in an American Express Interview

How I Would Solve These Tricky SQL Questions Asked in American Express Interview SQL is a fundamental skill for any data analyst, and mastering complex queries is key to standing out in interviews. Below, I break down how I would approach solving the tricky SQL questions mentioned. Each of these challenges is designed to test both your technical proficiency and your problem-solving ability. Let’s dive into the solutions. 1. Find the Second-Highest Salary in a Table Without Using LIMIT or TOP This is a classic problem that requires creativity. My solution: sql SELECT MAX (salary) FROM employees WHERE salary < ( SELECT MAX (salary) FROM employees); Here, the subquery finds the maximum salary, and the outer query selects the highest salary below that. 2. Find All Employees Who Earn More Than Their Managers Joining the table to itself is the key here: sql SELECT e1.employee_name FROM employees e1 JOIN employees e2 ON e1.manager_id = e2.employee_id WHERE e1.salary > ...

How I Cracked the Data Analyst Role at Flipkart

How I Cracked the Data Analyst Role at Flipkart 🚀 The journey to securing a Data Analyst role at Flipkart was both challenging and rewarding. Here’s a detailed walkthrough of my experience, preparation strategy, and key takeaways. Application Process Applied Through: LinkedIn Total Number of Rounds: 5 HR Discussion: Focused on my past roles, experiences, and suitability for the position. 1st Technical Round: Covered foundational concepts in Excel, Power BI, and SQL. 2nd Technical Round: Delved into complex SQL queries and advanced Excel-based problem-solving. Managerial Round: Scenario-based questions to assess analytical thinking and problem-solving in real-world situations. Final HR Discussion: Discussed roles, responsibilities, and expectations from the role. My 3-Month Preparation Strategy 📆 Month 1: Advanced Excel, Power BI, and Data Visualization Source: Pavan Lalwani 🇮🇳 Excel for Data Analysis: Excel was the backbone of my initial preparation. I focused on the followi...

BlackRock Data Analyst Interview and Answer Bengaluru

BlackRock Data Analyst Interview and Answer BlackRock’s Data Analyst interview process is known for its intensity and focus on technical expertise, especially in SQL and Python. The questions were a mix of practical problems, theoretical knowledge, and real-world financial scenarios, reflecting BlackRock's emphasis on analytical rigor and financial acumen. Here’s a breakdown of the questions I encountered and my approach to solving them. SQL Questions 1️⃣ Identify customers who have invested in at least two funds with opposite performance trends over the last 6 months. Answer : sql WITH FundPerformance AS ( SELECT FundID, CASE WHEN AVG ( Return ) > 0 THEN 'Increasing' ELSE 'Decreasing' END AS Trend FROM FundReturns WHERE Date >= DATE_SUB(CURDATE(), INTERVAL 6 MONTH ) GROUP BY FundID ), CustomerInvestments AS ( SELECT CustomerID, FundID FROM Investments ) SELECT ci.CustomerID FR...

Shell Data Analyst Interview question and answer December 2024

Shell Data Analyst Interview Experience: CTC - 18 LPA Shell’s Data Analyst role demands strong SQL, Python, and Power BI skills alongside the ability to align technical insights with business strategy. Below, I’ve shared the questions asked during my interview process and how I would have answered them. SQL Questions 1️⃣ Write a query to calculate the cumulative revenue per customer for each month in the last year. Answer : sql SELECT CustomerID, DATE_FORMAT( Date , '%Y-%m' ) AS Month , SUM (Amount) OVER ( PARTITION BY CustomerID ORDER BY DATE_FORMAT( Date , '%Y-%m' )) AS CumulativeRevenue FROM Transactions WHERE Date >= DATE_SUB(CURDATE(), INTERVAL 1 YEAR ); 2️⃣ Identify plants that consistently exceeded their daily average output for at least 20 days in a given month. Answer : sql WITH DailyAvg AS ( SELECT PlantID, AVG (Output) AS AvgOutput FROM Production GROUP BY PlantID ), ExceedDay...

Flipkart Business Analyst Interview question and Answer asked in December 2024

Flipkart Business Analyst Interview Experience (1-3 Years) Recently, I appeared for an interview at Flipkart for the position of Business Analyst , and I’m excited to share the questions asked during the process along with how I would approach answering them. The interview covered various domains such as SQL, guesstimates, case studies, managerial scenarios, and Python. Here’s how I would have tackled each question: SQL Questions 1️⃣ What are window functions, and how do they differ from aggregate functions? Can you give a use case? Answer : Window functions perform calculations across a set of table rows related to the current row, without collapsing the result set into a single value like aggregate functions. Example: sql SELECT CustomerID, OrderID, OrderDate, ROW_NUMBER () OVER ( PARTITION BY CustomerID ORDER BY OrderDate DESC ) AS OrderRank FROM Orders; Use case: Finding the latest order per customer without grouping data. 2️⃣ Explain indexing. When could an i...