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. Myself and some skills
Add your answer
Q2. What is your long term and short term goals
Ans. Always give the practical answers so the recruiter found you very confident and motivated
Answered Anonymously
Add your answer

Q1. Basic details about previous experience, our expectations and educational details
Add your answer

Q1. Technical question on basic electrical engineering
Add your answer
Q2. Technical questions from previous employments
Add your answer
Q3. Technical questions on IoT project and college project
Add your answer

Given a regulation and asked to prepare a presentation and asked to present the ppt

Q1. Salary expectation
Add your answer
Q2. Comfortable about travelling
Ans. 
Yes, I am comfortable with traveling for work.
• I have previous experience traveling for work and am familiar with the demands of it.

• I am flexible and adaptable to different travel schedules and locations.

• I understand the importance of face-to-face interactions with stakeholders and clients, which may require travel.

• I am willing to travel as needed to ensure project success and meet business objectives.
Answered by AI
Add your answer
Q3. Comfortable relocated to job location
Ans. 
Yes, I am comfortable relocating to the job location.
• I am open to relocating for the right opportunity

• I have relocated for previous jobs and have had positive experiences

• I am flexible and adaptable to new environments
Answered by AI
Add your answer
Q4. Basic HR questions
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

Q1. Can you describe your previous work experience?
Ans. 
I have 5 years of experience as a Business Analyst in the finance industry.
• Led cross-functional teams to analyze market trends and develop strategic plans

• Conducted financial modeling and forecasting to support decision-making

• Collaborated with stakeholders to gather requirements and define project scope

• Implemented process improvements to increase efficiency and reduce costs
Answered by AI
Add your answer

Q1. Basic Details about yourself
Add your answer
Q2. Expectations Work Experience
Ans. Be as Truthful as possible don't make a Fake profile 🤥
Answered Anonymously
Add your answer

2 Test were there after HR Round
1hr Aptitude
15 min Knowledge

Q1. Manager asking your expertise
Add your answer
Q2. What is your expertise in
Add your answer

Q1. Manager asking you about your expertise
Add your answer

Q1. Head of learning and development
Add your answer

Q1. Previous experience tell all and how to achieve target
Add your answer
Q2. Please tell me how to territory devided
Ans. 
Territory can be divided based on various factors such as geography, demographics, and sales potential.
• Geographic boundaries such as state, county, or city lines can be used to divide territories.

• Demographic factors such as population density, income levels, and age groups can also be considered.

• Sales potential can be determined by analyzing past sales data and identifying areas with high demand.

• Territory division shou...read more
Answered by AI
Add your answer

Q1. Tell me about your self previously Responsebiility in Technically support.
Ans. 
I have extensive experience in providing technical support in previous roles.
• Managed a team of support specialists to troubleshoot and resolve technical issues

• Developed and implemented training programs for new support staff

• Collaborated with cross-functional teams to improve product functionality and user experience
Answered by AI
Add your answer
Q2. HR Round discuss about package Related.
Add your answer