Uni Cards Senior MIS Analyst Interview Questions and Answers

Q1. How to design data warehouse
Ans. 
Designing a data warehouse involves identifying data sources, defining data models, creating ETL processes, and implementing data governance.
• Identify data sources and determine what data needs to be stored

• Define data models to structure the data in a way that supports reporting and analysis

• Create ETL (Extract, Transform, Load) processes to move data from source systems to the data warehouse

• Implement data governance to ...read more
Answered by AI
Add your answer

Q1. Basic sql question were asked.
Add your answer

Round duration - 90 Minutes
Round difficulty - Easy

Problem solving using SQL questions

Round duration - 90 Minutes
Round difficulty - Easy

A marketing campaign is run, how will you decide metrics to be tracked. Techincaly a KPI round

Q1. In a marketing campaign, how would you decide which metrics to track?
Ans. 
Metrics selection based on campaign objectives, target audience, and key performance indicators.
• Identify campaign objectives and goals

• Consider target audience and their behavior

• Select key performance indicators (KPIs) relevant to the campaign

• Track metrics such as conversion rate, click-through rate, ROI, customer acquisition cost

• Analyze data to measure success and make data-driven decisions
Answered by AI
Add your answer

Round duration - 30 Minutes
Round difficulty - Easy

Social empathatic fit round

Q1. Basic SQL questions are asked in this round Some theory questions are asked as well
Add your answer

Q1. Types of Window Function
Ans. 
Window functions are used in SQL to perform calculations across a set of table rows related to the current row.
• Types include ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LAG(), LEAD(), FIRST_VALUE(), LAST_VALUE(), etc.

• They allow for calculations to be performed on a specific subset of rows within a query result set.

• Window functions are commonly used for running totals, moving averages, and ranking data.
Answered by AI
Add your answer
Q2. Difference between Joins with examples
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Inner Join: Returns rows when there is a match in both tables.

• Left Join: Returns all rows from the left table and the matched rows from the right table.

• Right Join: Returns all rows from the right table and the matched rows from the left table.

• Full Outer Join: Returns rows when there is a match in one of the tables.

• Cross Join:
Answered by AI
Add your answer

Hackerrank test mostly on python and sql

Q1. SQL based questions
Add your answer
Q2. Python based questions
Add your answer

Intermediate level coding round

Q1. Project explaination
Add your answer
Q2. Explain project ind detail
Ans. 
Developed a predictive analytics model to forecast customer churn for a telecommunications company.
• Collected and cleaned customer data from various sources

• Performed exploratory data analysis to identify patterns and trends

• Built a machine learning model using logistic regression to predict customer churn

• Evaluated the model's performance using metrics such as accuracy, precision, and recall
Answered by AI
Add your answer