AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Saras Analytics Senior Business Analyst Interview Questions, Process, and Tips
Top Saras Analytics Senior Business Analyst Interview Questions and Answers
- Q1. SQL: What is the difference between HAVING and WHERE? Can WHERE be replaced with HAVING?
- Q2. Aptitude: There are 2 jugs: one measures 7L and another measures 11L. How do you measure 15L?
- Q3. SQL: What is the difference between UNION and UNION ALL?
Saras Analytics Senior Business Analyst Interview Experiences
2 interviews found
Anonymous
(4 Questions)
- Q1. SQL: What is the difference between UNION and UNION ALL?
- Ans.
UNION combines and removes duplicates, UNION ALL combines without removing duplicates
UNION merges the result sets of two or more SELECT statements and removes duplicates
UNION ALL merges the result sets of two or more SELECT statements without removing duplicates
UNION is slower than UNION ALL as it involves removing duplicates
Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;
Example: SELECT column1 FR
- Q2. SQL: What is the difference between HAVING and WHERE? Can WHERE be replaced with HAVING?
- Ans.
HAVING is used with GROUP BY to filter grouped rows, WHERE is used to filter individual rows. WHERE cannot be replaced with HAVING.
WHERE is used to filter individual rows before grouping, HAVING is used to filter grouped rows after grouping
HAVING is used in conjunction with GROUP BY clause, WHERE is used independently
WHERE filters rows based on conditions, HAVING filters groups based on conditions
Example: SELECT depart...
- Q3. Aptitude: There are 2 jugs: one measures 7L and another measures 11L. How do you measure 15L?
- Q4. Guesstimate: How many ballons can fill in an aeroplane?
- Ans.
The number of balloons that can fill an airplane depends on the size of the airplane and the size of the balloons.
The size of the airplane (e.g. small private plane vs. commercial airliner) will greatly impact the number of balloons that can fit.
The size of the balloons (e.g. standard party balloons vs. large weather balloons) will also affect the total number that can be accommodated.
Consider the available space insid...
Interview Preparation Tips
Skills evaluated in this interview
I applied via LinkedIn and was interviewed in Jan 2024. There was 1 interview round.
The position is for SBA but they expect you to be as good as developer in coding. They want someone as good as developer but they don't call him/her as developer and give the designation as BA which I did not like. No questions regarding BA or PM or any Agile or waterfall methodologies 3 rounds every thing about coding (SQL, Python, ) and tools like Alteryx, AWS glue
Interview Preparation Tips
Senior Business Analyst Jobs at Saras Analytics
Top trending discussions
Interview questions from similar companies
Business Analyst Interview Questions & Answers
EXL Service
Poluri Jayaprakashreddy
posted on 2 Dec 2015
Interview Preparation Tips
Experience: First round is a online test containing 10 verbal, 10 logical ,20 numerical aptitude questions total 40 question and duration is for 45 minutes
Round: HR Interview
Experience: 39 people got shortlisted for round 2. Round 2 is like hr interview all u need to do is speak and be confident
Round: puzzles round
Experience: 25 got shortlisted for round 3. Round has puzzles and gestimation questions. You need to clearly explain Guestimation question.
Round: HR Interview
Experience: 13 got shortlisted for final round. Its again Hr interview by all the company members. Out of 13 few were asked puzzles. Finally 10 people were selected.
General Tips: Placement experience was amazing. Interviews were really good . They just wanna check whether your confident about what you speak or not. Those people were really friendly so no need to be tensed.
Don't freak out looking at the new puzzle try thing new to solve it. Be confident about your self and what ever you tell them.Which ever quote u make about your self be ready with example and what you have learned from that example
Skill Tips: No book preparation is required. U need to be good at solving puzzles and explain what ever your doing. During test last section i.e., numerical will have few lengthy questions so don't waste your time on one question.
For Guestimation u have to make appropriate guess and explain them why that guess , how does things change in different environments
Skills:
College Name: NIT Surathkal
Shubham Samdani
Interview Questionnaire
2 Questions
- Q1. Standard puzzles
- Q2. Standard HR questions -Tell me about yourself,Your family background.your future plans etc
Interview Preparation Tips
Experience: Standard CAT type questions but a level down from difficulty perspective.
Any standard CAT book will do for cracking the written test.
Tips: There is Sectional cutoff, so attempt each section giving equal weight.
Duration: 45 minutes
Total Questions: 40
Round: Technical Interview
Experience: The interviewer was a very chill guy.Before starting on to the puzzles he asked questions on the my resume , current affairs,sports,hobbies and then we had a long discussion on Arsenal (it was the club i supported).He also turned out to be an arsenal supporter,thus making the interview process ultra light.He just asked one puzzle and ended the interview process.
Tips: As i have a habit of daily reading a newspaper i was fairly acquainted with the current affairs and it helped me a lot.
Besides that, being a mechanical engineer i was questions about why not pursuing career in core engineering,so one should be prepared with all the answers.
Good communication skill will definitely help.
One should know one's resume inside out.
Round: HR Interview
Experience: The interview went out smoothly.He just want to check whether you are fit for the company.
Tips: Be confident and be yourself.Don't try to bluff.
Skill Tips: Don't worry about the placement process.Even if you fail don't loose your hope and carry on with your efforts,something bigger and better is waiting for you.
Skills: LOGICAL THINKING ABILITIES, Ability To Think, 1)communication, Ability To Analyse
College Name: NIT Surat
Motivation: After a year the company offers you the onsite project.
I appeared for an interview in Sep 2016.
Interview Questionnaire
2 Questions
- Q1. Number of guitars in n trichy
- Ans.
The question is unclear and lacks context. More information is needed to provide an accurate answer.
What is the context of the question? Is it related to a specific store or location?
What is the timeframe for the question? Is it asking for current inventory or historical data?
Are there any assumptions that can be made based on the information given?
Without additional information, it is impossible to provide an accurate
- Q2. About my experience as overall coordinator of festember
Interview Preparation Tips
Experience: Took parameters like college fests gana sabhas. And gave a figure
Round: HR Interview
Experience: Briefed abt the experience in detail which helped me win the trust
Adarsh Srivastava
I appeared for an interview in Aug 2016.
Interview Questionnaire
10 Questions
- Q1. Explain about ERP, it's advantages(a software which I worked upon during my internship)
- Ans.
ERP is a software that integrates various business processes and functions into a single system.
ERP stands for Enterprise Resource Planning.
It helps organizations streamline their operations and improve efficiency.
Advantages of ERP include centralized data management, improved collaboration, and better decision-making.
It automates processes like inventory management, financials, human resources, and customer relationsh...
- Q2. Explain DML, DDL, TCL(terms used in SQL)
- Ans.
DML, DDL, and TCL are terms used in SQL for manipulating and managing data.
DML (Data Manipulation Language) is used for inserting, updating, and deleting data in a database.
DDL (Data Definition Language) is used for creating, altering, and dropping database objects such as tables, indexes, and views.
TCL (Transaction Control Language) is used for managing transactions in a database, including committing or rolling back ...
- Q3. What are inner joins, outer joins, left join
- Ans.
Inner joins, outer joins, and left join are types of SQL joins used to combine data from multiple tables.
Inner join returns only the matching records from both tables.
Outer join returns all records from both tables, including non-matching records.
Left join returns all records from the left table and the matching records from the right table.
Example: INNER JOIN customers ON orders.customer_id = customers.customer_id
Exam...
- Q4. Some questions related to my branch I.e. Electronics but I don't remember
- Q5. Write an algorithm to optimize EXL interview process.
- Ans.
Algorithm to optimize EXL interview process
Identify key performance indicators (KPIs) for the interview process
Use data analytics to track and analyze the KPIs
Implement automation and AI to streamline the process
Incorporate feedback from candidates and interviewers to continuously improve the process
- Q6. My introduction
- Q7. Few questions on my hobbies
- Q8. What is big data
- Ans.
Big data refers to large and complex data sets that cannot be processed using traditional data processing methods.
Big data involves the collection, storage, and analysis of massive amounts of data
It requires advanced technologies and tools to process and make sense of the data
Examples of big data include social media data, sensor data, and financial market data
- Q9. Despite being ECE student, why business analytics post
- Q10. Why EXL
- Ans.
EXL offers a diverse range of projects and opportunities for growth, with a strong focus on innovation and technology.
EXL provides a wide variety of projects in different industries, allowing for diverse experience and skill development.
The company has a strong emphasis on innovation and technology, which aligns with my interests and career goals.
EXL has a reputation for providing excellent training and development pro...
Interview Preparation Tips
Experience: This round consisted of 40 questions and time limit was also 40 minutes. Since I was preparing for CAT, so I found this round quite easy, but since I was appearing for a job, hence pressure was there. Fortunately, I cleared this round with ease.
Tips: You can practice questions online. Indiabix.com is useful site for this. If you want to practice some advance questions, then refer to Arun sharma's books
Duration: 40 minutes
Total Questions: 40
Round: Puzzle Interview
Experience: I don't remember the exact questions which company officials asked, but this round was entirely based on puzzles. They asked 4-6 puzzles starting with easy ones and then level of difficulty increased. I solved first 4 puzzles. Last two puzzles were quite difficult and I remember I took 15-20 minutes to solve each. I was able to solve one but not other. Apart from this they also asked 1 guesstimate question. It was "how many litres of paint is required to paint the building of your college". I estimated the area of buildings and after 20 minutes gave a guesstimate answer. Impressed with my problem solving skills, I was eligible for the next round.
Tips: There are many online sites through which you can practice puzzles and IQ questions.
For guesstimate question you need to know certain details that might help you to solve the questions like
1. Population of india
2. Population of your state and city
3. Literacy rate
4. Sex ratio
5. Your college parameters
Round: Technical Interview
Experience: This round was technical round. I did internship on ERP software and Database management, so they asked a few questions on it. Then next was questions related to the subjects which I studied. Since I am not good at Electronics so I wasn't able to solve much questions. I feared that I might get eliminated now. Then they asked few questions from coding C, C++, Data structure. I solved them quickly. I guessed that saved me, and I got promoted for next round
Tips: One thing interviewers will definitely ask in this round is questions related to your subjects. So, if you good in your studies then you can easily clear this else you can prepare 2-3 subjects well. Rest technical questions will depend on your resume like apart from studies what additional knowledge you possess.
Round: HR Interview
Experience: The final round, "grand finale". I had given two interviews for internship and got rejected both times in final round. So, I was a bit tensed. I went there, the VP of the company was sitting there ready to fire questions upon me. But, I maintained my equanimity and gave appropriate answers and after 3 hours, my name was there among the list of selected students.
Tips: Prepare for the HR questions which is generally asked. And be ready for surprise questions they might ask from you. You have to be confident that's all and you can succeed with flying colours
Skills: Activeness Of Candidate, How Well Do You Speak When Your Mistakes And Weak Points Are Pointed Out, Clear Picture Of What You Want To Be In The Future, Big Data Analytics, Body Language In Interview, Electronics, Coding Skills And Knowledge On Data Structures, Puzzle Solving Capability
College Name: NIT Kurukshetra
Skills evaluated in this interview
Ashish Pal
I appeared for an interview in Aug 2016.
Interview Preparation Tips
Experience: Anyone preparing honestly for CAT or other exams should easily clear this round. Questions are not very much difficult, the main challenge is to do the questions in limited time. One should leave those questions which seem tricky or time consuming. In our college more than 350 gave the test but only 45 were shortlisted for the next round
Total Questions: 40
Round: Behavioural Interview
Experience: Anyone preparing honestly for CAT or other exams should easily clear this round. Questions are not very much difficult, the main challenge is to do the questions in limited time. One should leave those questions which seem tricky or time consuming. In our college more than 350 gave the test but only 45 were shortlisted for the next round
Round: Behavioural Interview
Experience: General questions were asked related to the college life, one should be prepared for what he/she has written in the resume. Two or three riddles will also be asked in this interview, it is important to keep your cool at this time and go through with your approach with the interview.
Round: HR Interview
Experience: General HR interview.
One should prepare for the general HR questions. Nothing extra ordinary required just be confident with your communication skills.
Skills: Aptitude, Reasoning Ability, Communication And Confidence
College Name: NIT Kurukshetra
Interview Preparation Tips
Experience: WE WERE SHORTLISTED ON THE BASIS OF OUR GGPA TILL SIX SEM. CRITERIA WAS 7.7 GGPA
Tips: DON'T PANIC .KEEP YOURSELF ATLEAST AVEARGE IN ACADEMICS
Round: Test
Experience: APTITUDE WAS ABOVE AVERAGE .LOGICAL REASONING AND ENGLISH WERE LITTLE TOUGH AND LENGTHY
Tips: PRACTICE DAILY FOR APTITUDE .ARUN SHARMA WILL BE MORE THAN ENOUGH.
Duration: 45 minutes
Total Questions: 40
College Name: NIT Bhopal
Interview Questionnaire
6 Questions
- Q1. Justification for the times of iteration required to check the number if it is prime number in c language
- Ans.
Iterating to check if a number is prime in C language requires justification.
Iterating through all numbers up to the square root of the number is necessary to check if it is prime.
The time complexity of this algorithm is O(sqrt(n)), which is efficient for small to medium-sized numbers.
For larger numbers, more efficient algorithms like the Miller-Rabin primality test can be used.
The number of iterations required depends...
- Q2. Find the triangle with max area whose sides are: 300,400,500 300,400,700 ? justification
- Ans.
Finding the triangle with max area given sides.
Use Heron's formula to calculate the area of each triangle.
Compare the areas and select the triangle with the maximum area.
For sides 300, 400, 500, area = 60000 sq. units.
For sides 300, 400, 700, area = 72000 sq. units.
- Q3. Simple puzzle and designing of basic gates
- Q4. How many persons are there at Jalandhar Railway Station?
- Q5. How many spherical ball of .5 inch can be placed in cube of 10 inch side and then the wastage percentage?
- Ans.
Approximately 8000 balls can be placed with 49% wastage.
Calculate the volume of the cube (10*10*10) and the volume of one ball (4/3*3.14*(0.5/2)^3)
Divide the volume of the cube by the volume of one ball to get the maximum number of balls that can fit
Calculate the volume of the placed balls and subtract it from the volume of the cube to get the wastage
Wastage percentage can be calculated by dividing the wastage volume b
- Q6. Why you want to be in EXL ?
- Ans.
I want to be a part of EXL because of its reputation for innovation and excellence in the field of business analytics.
EXL has a strong focus on innovation and technology, which aligns with my interests and skills.
I am impressed by the company's track record of delivering high-quality solutions to clients across various industries.
EXL's culture of collaboration and teamwork is something that I value and believe will hel...
Interview Preparation Tips
Experience: 45 minutes test organised by Cocubes including three sections :Verbal (10 ques) ,Reasoning (10 ques) and Quant (20 ques). it was easy but you have to clear section cutoff.
Tips: Be confident and fast.
Round: Technical Interview
Experience: this interview was not stressful and they was jus checking our dedication and Passion to solve problem no matters if you answer wrong .
Tips: Be careful and aware of what is there in your resume.they ask everything from your resume and it would be totally basic and need jutification
Round: HR Interview
Experience: As i was the first one to give my technical interview ,so i was called up by hr who took my both hr and technical interview to speed up the process.i was lucky that i fortunately missed the separate technical interview in which many of the applicants got rejected.
Tips: Don't try to listen to answer of your friends. they will ask you the same questions.
General Tips: They are fascinated by your academics ,so be prepared for it also if your score well in academics ,technical round can also stick to your stream .
Skills: aptitude, puzzles, comm skills
College Name: NIT JALANDHAR
Skills evaluated in this interview
Interview Questionnaire
17 Questions
- Q1. Make 8 using 3,1,3,6
- Q2. Sensex, Nifty values of that day
- Q3. Where do you see yourself in 5 years?
- Ans.
In 5 years, I see myself as a senior business analyst leading a team and contributing to the growth of the company.
Leading a team of business analysts
Contributing to the growth of the company through data-driven insights
Continuing to learn and develop new skills
Building strong relationships with stakeholders
Exploring opportunities for process improvement
- Q4. Why EXL?
- Ans.
EXL offers a unique blend of domain expertise, analytics and technology to help clients transform their businesses.
EXL has a strong focus on innovation and technology
EXL has a diverse range of clients across industries
EXL has a proven track record of delivering results for clients
EXL offers opportunities for career growth and development
- Q5. Why should we hire you?
- Ans.
I have the skills, experience, and passion to excel in this role and contribute to the success of the company.
I have a strong background in data analysis and problem-solving, which are essential skills for a business analyst.
I am a quick learner and can adapt to new technologies and processes easily.
I have excellent communication and interpersonal skills, which enable me to work effectively with stakeholders at all lev...
- Q6. Anything which you would like to ask about company
- Q7. Why business analyst when you are an engineer?
- Ans.
As an engineer, I have developed analytical and problem-solving skills that are transferable to the role of a business analyst.
Engineering and business analysis share similar skills such as critical thinking, data analysis, and project management.
I have experience working with cross-functional teams and stakeholders to identify and solve complex problems.
I am interested in the business side of technology and want to us...
- Q8. What do you know about exl?
- Ans.
EXL is a global provider of analytics, operations management, and technology services.
EXL offers services in industries such as healthcare, insurance, banking, and more.
They use advanced analytics and technology to help clients improve their business processes and decision-making.
EXL has over 31,000 employees across 30 countries.
Some of their clients include Allstate, Barclays, and UnitedHealth Group.
- Q9. Puzzle 1: Calculate the probability of a girl child when one of the two children is boy
- Q10. Puzzle 2: Mislabeled jar puzzle
- Q11. 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
Proficient in Microsoft Excel and SQL
Collaborative team player
- Q12. Why your CGPA is low? (<8)
- Ans.
My CGPA is low due to initial adjustment issues and lack of guidance.
I faced difficulty in adjusting to the new academic environment in the beginning.
I lacked proper guidance and mentorship to excel in my studies.
I have since taken steps to improve my grades and have shown consistent progress.
My practical skills and experience make up for my academic performance.
- Q13. Why you are not in any of the societies in your college?
- Ans.
I prioritized gaining practical experience through internships and part-time jobs over joining societies.
I focused on building my skills and gaining experience through internships and part-time jobs
I preferred to spend my free time on personal projects and self-learning
I did not find any societies that aligned with my interests and goals
I believe that my experiences outside of college have prepared me well for this rol
- Q14. Any plan to do MBA later on ?
- Ans.
Yes, I am considering pursuing an MBA in the future.
I believe an MBA would enhance my business acumen and provide me with a broader perspective on the industry.
I plan to gain some work experience first before pursuing an MBA.
I am researching different MBA programs and their requirements to ensure I am fully prepared.
I am also considering alternative options such as online MBA programs or executive MBA programs.
Ultimate...
- Q15. Cut cake into 8 pieces by slicing it just 3 times
- Q16. One numerical puzzle
- Q17. 9 coins you have, one of the coin has lesser weight, you have a weighing balance, how many times you will have to use that to pick out the lesser weighted coin?
Interview Preparation Tips
Experience: CGPA criteria of 7.5+ and 10th-12th criteria of 80% +
Round: Test
Experience: An online written test was conducted by cocubes in the campus. It was of 45 minutes and consisted of 40 questions (20 Quant, 10 LR, 10 Verbal). Quant had data interpretation questions, verbal consisted of reading comprehension.
Tips: Questions at the end of a segment were relatively easy. Try to leave the questions which are tough, and do them at the end. Do the easy ones first.
Round: Puzzle Interview
Experience: First they asked about me, and then started on my interests, which I told them finance and stock markets. Then they asked me about stocks, greece crisis, stock markets etc. One case study was also performed. It was easy and could be done right then.
Tips: Keep yourself calm, even if you cannot solve the puzzles tell them your approach.
Round: HR Interview
Experience: This was the toughest round. They asked me 2 puzzles and a guesstimate which was way too tough. They grilled me on technical things. They kept telling me that you are a technical mind, why you are joining a consultancy. Overall, they were nice.
Tips: Its good to read about the organisation and its work. You can correlate the questions then, like how your capabilities are matching with the job profile. You can ask them a good question. It proved handy to me in this interview.
Round: HR Interview
Experience: This was just a formality. They wanted to know whether finally you would join this company or not.
General Tips: Take the interview in the direction where you want. Tell them your interest right at the start, so that they can grill you on that only. There were no questions on minor training or projects. There was nothing on technical part as well. Throw in your AIEEE/JEE MAINS/Advanced rank, that was the time when you were at your best and it may escape you out of the problem. It did in my case. He started grilling me on my low CGPA (lowest out of selected candidates), low 12th%, I just threw my AIEEE rank and I was placed.
Skills: Aptitude, Verbal english, Guesstimation
College Name: MANIT Bhopal
Funny Moments: Well there were many.
During the first HR interview, they asked me why do you want to join a consultancy company when you are an engineer? I said, engineers can do anything and why do you visit our campus when you want consultants.
Saras Analytics Interview FAQs
Some of the top questions asked at the Saras Analytics Senior Business Analyst interview -
Tell us how to improve this page.
Saras Analytics Interviews By Designations
- Saras Analytics Data Analyst Interview Questions
- Saras Analytics Senior Business Analyst Interview Questions
- Saras Analytics Business Analyst Interview Questions
- Saras Analytics Data Scientist Interview Questions
- Saras Analytics Analyst Interview Questions
- Saras Analytics Software Engineer Interview Questions
- Saras Analytics Software Engineer Intern Interview Questions
- Saras Analytics Front end Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Business Analyst Interview Questions
- Business Development Executive Interview Questions
- Business Development Manager Interview Questions
- Business Development Associate Interview Questions
- Business Associate Interview Questions
- Business Development Interview Questions
- Business Executive Interview Questions
- Business Manager Interview Questions
- Show more
Saras Analytics Senior Business Analyst Interview Process
based on 2 interviews
Interview experience
Senior Business Analyst Interview Questions from Similar Companies
Saras Analytics Senior Business Analyst Reviews and Ratings
based on 2 reviews
Rating in categories
4-8 Yrs
Not Disclosed
4-8 Yrs
Not Disclosed
|
Business Analyst
47
salaries
|  ₹4.6 L/yr - ₹16.3 L/yr |
|
Senior Business Analyst
15
salaries
| ₹13 L/yr - ₹25 L/yr |
|
Data Analyst
11
salaries
| ₹4.4 L/yr - ₹13 L/yr |
|
Senior Data Analyst
9
salaries
| ₹16.8 L/yr - ₹20.9 L/yr |
|
Junior Business Analyst
8
salaries
| ₹6.5 L/yr - ₹8.3 L/yr |
EXL Service
Access Healthcare
S&P Global
AGS Health
- Home >
- Interviews >
- Saras Analytics Interview Questions >
- Saras Analytics Senior Business Analyst Interview Questions
