AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Mindsprint
Compare
Filter interviews by
Mindsprint Senior Data Analytics Analyst Interview Questions and Answers
Mindsprint Senior Data Analytics Analyst Interview Experiences
1 interview found
Anonymous
I applied via Naukri.com and was interviewed in Jul 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Raw vault data modeling
- Q2. CDC in snowflake
- Ans.
CDC in Snowflake refers to Change Data Capture, a feature that captures and replicates changes made to data in real-time.
CDC in Snowflake allows for tracking and replicating changes made to data in real-time
It helps in maintaining data consistency across different systems
CDC can be used for data integration, data warehousing, and real-time analytics
(2 Questions)
- Q1. Why are you leaving your current company?
- Ans.
Seeking new challenges and opportunities for growth.
Looking for a new challenge to further develop my skills and expertise.
Interested in exploring new opportunities for career advancement.
Seeking a company with a stronger focus on data analytics and innovation.
- Q2. Why do you want to join our company.
- Ans.
I am impressed by your company's innovative approach to data analytics and want to be a part of a team that values cutting-edge technology and solutions.
Your company's reputation for utilizing advanced data analytics techniques
Opportunity to work with a talented team of data analysts
Exciting projects and challenges that align with my skills and interests
Interview Preparation Tips
Skills evaluated in this interview
Interview questions from similar companies
G Akhil
Interview Questionnaire
7 Questions
- Q1. You have 10 boxes of balls (each ball weighing exactly10 gm) with one box with defective balls (each one of the defective balls weigh 9 gm). You are given an electronic weighing machine and only one chance...
- Q2. Guesstimate- 1) Find the number of petrol bunks in India?
- Ans.
There are approximately 70,000 petrol bunks in India.
India has a population of over 1.3 billion people, and a large number of them own vehicles.
The number of petrol bunks varies from state to state, with some having more than others.
According to a report by the Petroleum Planning and Analysis Cell, there were 69,648 petrol bunks in India as of January 2021.
- Q3. Guesstimate- 2) Find the no of cricket balls sold in a year in India?(I told cricket is my hobby so interviewer asked question related to cricket)
- Ans.
Approximately 10 million cricket balls are sold in India every year.
Consider the number of cricket matches played in India each year
Take into account the number of cricket academies and schools in India
Factor in the popularity of cricket in India
Assume an average lifespan of a cricket ball
Approximately 10 million cricket balls are sold in India every year
- Q4. Basic Finance question: Put option, Call option, payoff diagrams etc.,
- Q5. Tell me about yourself?
- Ans.
I am a highly motivated and detail-oriented business analyst with experience in data analysis and project management.
Experienced in data analysis and project management
Highly motivated and detail-oriented
Strong communication and problem-solving skills
- Q6. Your short term goal and long term goal?
- Ans.
Short term goal is to gain experience and contribute to the company's success. Long term goal is to become a respected industry expert.
Short term goal: Gain experience and contribute to company's success
Long term goal: Become a respected industry expert
Examples: Attend industry conferences, take on challenging projects, seek mentorship
- Q7. Any issues working in Gurgaon?
- Ans.
No major issues working in Gurgaon.
Traffic congestion during peak hours
Limited public transportation options
High cost of living compared to other cities
Pollution levels can be high
Availability of skilled resources
Interview Preparation Tips
Experience: It was easy and try to practice daily, you can easily crack the test. I guess around 100 people has given the test and 65 got shortlisted for interviews.
Tips: Indiabix is a very good website, it helps in getting better and better by giving mock tests.
TIME materials
Duration: 60 minutes
Round: Technical Interview
Experience: Basically i thought of getting into a field of data analytics but they did not come here for data analyst. He asked me questions related to quantitative finance. Since i had financial engineering course in previous semester so it was bit easy and i didn't even prepare particularly for finance. Anyways finance knowledge is not mandatory, if you have it is an added advantage. I answered every question very confidently, so it created some good impression. All that matters is how confidently you are answering the questions (important questions are puzzles and guesstimates) with a smile on your face. The interviewer is so kind and that really boosted me up. Then he asked about coding, i told frankly that i'm not interested in coding but i know analytical languages like SAS, R etc., and in case if you want i can learn coding. Overall it was a great experience.
Tips: Heard on the street book and geeksforgeeks for puzzles
Have some idea on guesstimates(from Quora)
John C Hull book for finance
Round: HR Interview
Experience: It was basic HR questions and i know that i will surely get selected for this company after my technical interview so easily answered them. Finally as i hail from Visakhapatnam(South) so she asked me any issues working in Gurgaon? I told i don't have any problems and i'm pretty fine with that. And most important thing ask some questions after the completion of your interview. Thanks and good luck. Hence i got selected as Business Analyst in financial services. 9 people got offers from those 65 shortlisted people.
Tips: Do not get nervous & Put a smile on your face.
Be confident you will surely get selected.
Thanks
Akhil
General Tips: Stay calm and confident
Skill Tips: Tips are as mentioned above in interviews.
Skills: Logical Puzzles, Guesstimation Cases, Finance Basics, Analytical Skills
College Name: IIT Kharagpur
Motivation: Standard Company and basically profile is very good. Profile- Business Analyst in Financial services.
Funny Moments: I enjoyed each and every moment
I applied via Campus Placement and was interviewed before Jul 2020. There were 5 interview rounds.
Interview Questionnaire
9 Questions
- Q1. Telecom market in India
- Ans.
The telecom market in India is highly competitive and rapidly growing.
India has the second-largest telecom market in the world
The market is dominated by major players like Jio, Airtel, and Vodafone Idea
The introduction of 4G technology has led to a surge in data consumption and mobile internet usage
The government's Digital India initiative is driving growth in the sector
The market is expected to continue growing with t
- Q2. Multiple guesstimates were asked
- Q3. Working of GSM and CDMA technologies
- Ans.
GSM and CDMA are two different technologies used for mobile communication.
GSM stands for Global System for Mobile Communications and uses SIM cards for authentication.
CDMA stands for Code Division Multiple Access and uses spread spectrum technology for communication.
GSM uses time division multiplexing for sharing the frequency band while CDMA uses code division multiplexing.
GSM is widely used in Europe and Asia while C...
- Q4. Difference between 2G and 3G technologies
- Ans.
2G is a second-generation wireless technology while 3G is a third-generation wireless technology.
2G offers voice and text services while 3G offers voice, text, and data services.
3G has faster data transfer rates than 2G.
2G uses circuit-switched technology while 3G uses packet-switched technology.
3G allows for video calling and mobile internet access while 2G does not.
3G networks are more expensive to build and maintain
- Q5. A lot of questions based on my internship at Nokia Siemens Networks (now Nokia Networks) were asked
- Q6. Basic skills of creating presentation and excel
- Ans.
Basic skills of creating presentation and excel
For presentations, use a clear and concise structure with visual aids
For Excel, understand basic formulas and functions, and use formatting to make data easy to read
Practice using templates and experimenting with different design options
Learn keyboard shortcuts to save time and increase efficiency
Use charts and graphs to illustrate data in a visually appealing way
- Q7. How does GPS work?
- Ans.
GPS works by using a network of satellites to triangulate the position of a receiver on Earth.
GPS satellites orbit the Earth and transmit signals to GPS receivers on the ground.
The receiver uses the signals from multiple satellites to determine its location through a process called trilateration.
GPS can provide accurate location information, speed, and direction.
GPS is used in navigation systems, tracking devices, and ...
- Q8. Why should we hire you?
- Q9. Tell me something about yourself
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Sep 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Situation based questions
Interview Preparation Tips
I applied via Referral and was interviewed before May 2020. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Investment banking Questions I was asked
- Q2. How do you manage stress situations
Interview Preparation Tips
Interview Questionnaire
2 Questions
- Q1. What is your expertise as a BA
- Q2. Full expert
Selected
I applied via LinkedIn and was interviewed in Oct 2022. There were 3 interview rounds.
(1 Question)
- Q1. Basic ITSM ServiceNow QA
(1 Question)
- Q1. Basic situational discussion
Interview Preparation Tips
(1 Question)
- Q1. Tell me about yourself
- Ans.
I am a detail-oriented business analyst with a strong background in data analysis and problem-solving.
Experienced in gathering and analyzing business requirements
Skilled in creating data models and visualizations
Proficient in using tools like SQL, Excel, and Tableau
Strong communication and presentation skills
Ability to work collaboratively with cross-functional teams
Praveen Kumar
Selected
I applied via Referral and was interviewed before Jan 2023. There were 3 interview rounds.
General knowledge
English knowledge
(1 Question)
- Q1. Self and technical
Selected
I applied via Campus Placement and was interviewed before Mar 2023. There were 3 interview rounds.
Easy round with normal pattern matching ques
Topic was given than all are told to speak
(2 Questions)
- Q1. Normal ques related to offer
- Q2. Why do you want to join
Interview Preparation Tips
Mindsprint Interview FAQs
Tell us how to improve this page.
Mindsprint Interviews By Designations
- Mindsprint Specialist Interview Questions
- Mindsprint SAP SD Functional Consultant Interview Questions
- Mindsprint Senior Associate Interview Questions
- Mindsprint Lead Engineer Interview Questions
- Mindsprint Senior Consultant Interview Questions
- Mindsprint Financial Analyst Interview Questions
- Mindsprint Team Manager Interview Questions
- Mindsprint Business Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Analytics Manager Interview Questions
- Analytics Consultant Interview Questions
- Decision Analytics Associate Interview Questions
- Data Analytics Intern Interview Questions
- IT (Data Analytics) Interview Questions
- Analyst Interview Questions
- Analytics Engineer Interview Questions
- Senior Analytics Consultant Interview Questions
- Show more
Mindsprint Senior Data Analytics Analyst Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
|
Specialist
134
salaries
|  ₹4.6 L/yr - ₹11.2 L/yr |
|
Analyst
133
salaries
| ₹3.5 L/yr - ₹7.3 L/yr |
|
Deputy Manager
122
salaries
| ₹10 L/yr - ₹24 L/yr |
|
Senior Associate
108
salaries
| ₹2.5 L/yr - ₹5.2 L/yr |
|
Senior Specialist
69
salaries
| ₹7.2 L/yr - ₹13 L/yr |
Luxoft
ARCADIS
Photon Interactive
Trigent Software
- Home >
- Interviews >
- Mindsprint Interview Questions >
- Mindsprint Senior Data Analytics Analyst Interview Questions
