CityMall Senior Product Analyst Interview Questions and Answers

Q1. Difference between SQL /NON SQL
Ans. 
SQL is a structured query language used for relational databases, while NoSQL is a non-relational database management system.
• SQL is used for structured data with predefined schema, while NoSQL is used for unstructured or semi-structured data.

• SQL databases are vertically scalable, while NoSQL databases are horizontally scalable.

• SQL databases are ACID compliant, ensuring data integrity, while NoSQL databases sacrifice so...read more
Answered by AI
Add your answer

Q1. HR why chenge the job yor are comfortable for you
Ans. Becouse chenge job good for new challenged iam comfotable
Answered Anonymously
Add your answer
Q2. What is your last Ctc
Add your answer
Q3. You can chenge place within days
Add your answer

Q1. What is current job experience What is your current salary
Add your answer
Q2. What's is salary expectations
Add your answer
Q3. What is role of responsibility
Add your answer

Product knowledge and display standard

Q1. Retails math and KPI
Add your answer

Q1. Tell me about your projects
Ans. 
I have worked on various projects involving data analysis, process improvement, and system implementation.
• Implemented a new CRM system to streamline customer data management

• Conducted data analysis to identify trends and opportunities for cost savings

• Led a cross-functional team to improve inventory management processes

• Developed KPI dashboards to track project performance and ROI
Answered by AI
Add your answer
Q2. What are your day to day activities
Ans. 
As a Business Analyst, my day to day activities include gathering and analyzing data, creating reports, identifying business trends, and collaborating with stakeholders.
• Gathering and analyzing data to identify business opportunities and trends

• Creating reports and presentations to communicate findings to stakeholders

• Collaborating with stakeholders to understand business needs and requirements

• Conducting meetings and inte...read more
Answered by AI
Add your answer

Asked me to prepare a PPT on reliance retail

Q1. We can give only 30% hike.. why would I hire you?
Ans. 
I bring a unique combination of skills, experience, and passion for the role that will drive value beyond just the salary increase.
• My track record of delivering successful projects on time and within budget showcases my ability to add significant value to the organization.

• I possess a diverse skill set including data analysis, problem-solving, and stakeholder management which are crucial for a Business Analyst role.

• My p...read more
Answered by AI
Add your answer

Q1. What are your strengths and weaknesses?
Add your answer
Q2. Share details of your previous job.
Add your answer
Q3. Why are you looking for a change?
Add your answer
Q4. Tell me about yourself.
Add your answer

Q1. One on One Round
Add your answer
Q2. Yes One on One Round
Add your answer

Q1. One on one Round
Add your answer
Q2. One on One Round yes
Add your answer

Q1. One on One Round
Add your answer
Q2. One on one Round yes
Add your answer

Q1. One On One Round
Add your answer
Q2. Yea One on one Round
Add your answer

English, Logic, Quantitative Analysis, Situation.

Q1. Can you provide an introduction and describe your past experience?
Ans. 
Experienced business analyst with a strong background in data analysis and process improvement.
• Over 5 years of experience in analyzing business processes and identifying areas for improvement

• Proficient in data analysis tools such as Excel, SQL, and Tableau

• Led cross-functional teams to implement process improvements resulting in cost savings of 10%

• Developed KPIs to track project performance and ensure alignment with bus
Answered by AI
Add your answer
Q2. What attracts you to this company, and what are your goals and areas of focus?
Ans. 
I am attracted to this company's innovative approach to problem-solving and collaborative work environment. My goal is to leverage my analytical skills to drive business growth and efficiency.
• Attracted to company's innovative approach to problem-solving

• Excited about collaborative work environment

• Goal is to leverage analytical skills for business growth and efficiency
Answered by AI
Add your answer