Citi Hiring – Data/Information Management Analyst 2 (C10) – Bangalore

Technical Questions and Answers for Data/Information Management Analyst 2 Interview at Citi

1. What is your experience with data visualization tools like Tableau/Power BI?

Answer: I have hands-on experience with both Tableau and Power BI, primarily for building visual reports, dashboards, and data insights. I’ve used these tools to transform complex datasets into actionable visualizations, improving business intelligence and data-driven decision-making. I’m comfortable working with basic data visualizations like bar charts and more complex ones like heat maps and scatter plots.

2. How do you optimize SQL queries for performance?

Answer: To optimize SQL queries, I focus on writing efficient code by minimizing the number of joins, using indexed columns, and avoiding unnecessary subqueries. I also analyze execution plans to identify slow-running queries and apply techniques such as query refactoring, proper use of indexing, and query caching to improve performance.

3. How do you handle large datasets, and what techniques do you use for data aggregation and summarization?

Answer: When handling large datasets, I rely on aggregation functions like GROUP BY, SUM(), COUNT(), and window functions like ROW_NUMBER() in SQL. I also use tools like Tableau and Power BI to visualize summary statistics, using filters and hierarchies to simplify large volumes of data for better analysis.

4. What is the difference between a join and a union in SQL?

Answer: A join is used to combine rows from two or more tables based on a related column between them, while a union is used to combine the result sets of two or more SELECT queries, stacking the rows. Join results in more columns by combining data horizontally, and union results in more rows by combining data vertically.

5. How do you ensure data integrity and accuracy while working on dashboards?

Answer: I ensure data integrity by performing data validation checks at each step of the data pipeline, cleaning the data to remove inconsistencies, and verifying the results of the queries before visualizing them. In tools like Tableau/Power BI, I use filters, calculated fields, and parameter controls to provide accurate insights while keeping the data up to date.

6. How would you explain the process of creating a dynamic dashboard in Tableau/Power BI?

Answer: First, I connect to the appropriate data sources, clean and transform the data as needed. Then, I build visualizations by selecting charts or graphs that best represent the data. I use filters, parameters, and calculated fields to create a dynamic experience, allowing users to interact with the data. Finally, I optimize the dashboard by focusing on key performance indicators (KPIs) and ensuring it’s responsive and easy to interpret.

7. What are the most common functions you use in SQL for data analysis?

Answer: Common functions I use include:

• COUNT() to count rows,
• SUM() to calculate totals,
• AVG() for averages,
• MAX()/MIN() to find the largest and smallest values, and
• GROUP BY to aggregate data by categories. Additionally, I frequently use JOIN operations to combine data from different tables.

8. How would you approach debugging a dashboard that displays incorrect data?

Answer: First, I’d ensure the data source connections are correct. Then, I’d inspect the query or logic used to extract the data, checking for errors in calculations or filtering criteria. I’d verify that the data transformations are applied correctly and finally ensure that the visuals and calculated fields in the dashboard accurately reflect the data.

9. Can you explain your experience with handling data from different banking products such as loans, wealth management, and cards?

Answer: I have experience analyzing data from various banking products, including loans, wealth management, and cards. For each product, I focus on specific KPIs such as loan approval rates, customer acquisition in wealth management, and transaction volumes for cards. I use this data to create reports and dashboards that inform business strategy and improve product performance.

10. What challenges have you faced in automating reports using Power BI/Tableau, and how did you overcome them?

Answer: A common challenge is handling dynamic data sources or real-time data integration. To overcome this, I ensure the data pipelines are well-structured and use data refresh scheduling in Tableau/Power BI. I also optimize the performance of the dashboards by limiting the use of complex calculations and minimizing the amount of data visualized at once.

Join Us For More Technical Questions and Job Updates