AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Ascendion
Compare
Filter interviews by
Ascendion Business Analyst Interview Questions and Answers
Ascendion Business Analyst Interview Experiences
1 interview found
Anonymous
Selected
I applied via Recruitment Consulltant and was interviewed in Oct 2023. There were 2 interview rounds.
(3 Questions)
- Q1. What was your responsibilities in your last job?
- Ans.
In my last role, I analyzed business processes, gathered requirements, and collaborated with stakeholders to drive project success.
Conducted detailed analysis of business processes to identify areas for improvement, resulting in a 15% increase in efficiency.
Facilitated workshops with stakeholders to gather requirements and ensure alignment on project goals, leading to successful project delivery.
Developed and maintaine...
- Q2. What do you think keeps you motivated to deliver your best?
- Q3. How did you manage the team during some crisis? Explain with an experience.
(3 Questions)
- Q1. What did you do in MySQL and Database management?
- Ans.
I have experience in MySQL and database management including data modeling, query optimization, and performance tuning.
Designed and implemented database schemas for various projects
Optimized complex queries for improved performance
Performed database maintenance tasks such as backups and indexing
Troubleshooted and resolved database issues
Implemented security measures to protect data integrity
- Q2. What was your achievement in process improvement?
- Ans.
Implemented a new data analysis tool that reduced processing time by 30%.
Identified bottlenecks in the current process
Analyzed data to understand root causes of inefficiencies
Collaborated with stakeholders to implement new tool
Trained team members on how to use the tool effectively
- Q3. How do you link APIs and data mapping?
- Ans.
APIs and data mapping are linked by defining the data structure in the API response and mapping it to the corresponding fields in the database.
Understand the data structure of the API response
Identify the relevant data fields in the API response
Map the API data fields to the corresponding fields in the database
Ensure data consistency and accuracy through proper mapping
Use tools like Postman for API testing and validati...
Skills evaluated in this interview
Interview questions from similar companies
I applied via Recruitment Consultant and was interviewed in Mar 2018. There was 1 interview round.
Interview Preparation Tips
EDI related questions were asked. All type of file conversion and Excel formulas been asked.
Prepare well with on the above areas. It takes around 30 minutes.
Skills: Problem Solving, Analytical Skills, Presentation Skills, Time Management
Duration: <1 week
Interview Questionnaire
2 Questions
- Q1. If you are fresher, good communication is only enough to crack all the levels.
- Q2. If you have experience, you need to explain the project and workflow with good communication without lag.
Interview Preparation Tips
muni munendra
I applied via Naukri.com and was interviewed in Jun 2022. There were 3 interview rounds.
Simple topics like present situations
Some basic mathematics and sql and python basic questions
(1 Question)
- Q1. Some sql functions,group by , window functions, some query based on lag and lead functions
Interview Preparation Tips
What people are saying about Ascendion
I applied via LinkedIn and was interviewed in Mar 2022. There were 6 interview rounds.
(1 Question)
- Q1. Basic questions about SQL, for ex, what are the various types of joins, what are the various window functions, difference between rank and dense rank, difference between union and union all
(1 Question)
- Q1. Introduction, followed by SQL questions, like what is the order of execution in SQL, and how do various joins work
(1 Question)
- Q1. Basic SQL questions, including the ones in the last round, also some query writing, with easy to medium difficulty
(2 Questions)
- Q1. Elaborate and in-depth discussion about your past experiences, followed by SQL questions, including the ones in the past rounds, and also writing a few queries based on the problem statement
- Q2. This round was taken by the Indium's client company, by your prospective manager there.
(1 Question)
- Q1. In this they'll decide on the offer to make.
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed in Mar 2022. There were 2 interview rounds.
Life Experience
(4 Questions)
- Q1. Machine Learning Questions like Regularization, Standardization,Supervised and Unsupervised ML
- Q2. SQL questions on Second Highest Salary,Case usage Difference between Delete and Truncate,Constraints
- Q3. Use of Pandas and Numpy, Gaussian Distribution
- Ans.
Pandas and Numpy are Python libraries used for data manipulation and analysis. Gaussian distribution is a probability distribution.
Pandas is used for data manipulation and analysis, including data cleaning, merging, and reshaping.
Numpy is used for numerical operations on arrays and matrices.
Gaussian distribution is a probability distribution that is commonly used in statistics and data analysis.
Numpy provides functions...
- Q4. Case Study Questions and Project Discussion
Interview Preparation Tips
Skills evaluated in this interview
(1 Question)
- Q1. Sql question and also some data engineer level questions
(1 Question)
- Q1. Explain about joins, window functions, puzzles.
Satyamshree Moharana
I applied via Approached by Company and was interviewed in Oct 2024. There were 2 interview rounds.
(1 Question)
- Q1. Briefing about my last job
(2 Questions)
- Q1. On python data manipulation(easy)
- Q2. Sql(intermediate)
vikram beerdalai
I applied via Walk-in and was interviewed in Aug 2023. There were 3 interview rounds.
They have asked for HackerRank test which has mix of aptitude and reasoning. And second part has SQL coding comprises of 2 moderate question and 1 has moderate difficult one. I have successfully submitted 2 questions and faced test case failed for the difficult one.
(1 Question)
- Q1. Questions - 1. Order of execution of query. 2. Join and types of join. 3. Group by query. 4. Having vs where. 5. Left join tricky question 6. Self join tricky question. 7. Window function and comparison to...
Interview Preparation Tips
Ascendion Interview FAQs
Tell us how to improve this page.
Ascendion Interviews By Designations
- Ascendion Talent Acquisition Specialist Interview Questions
- Ascendion Associate Software Engineer Interview Questions
- Ascendion Lead Engineer Interview Questions
- Ascendion Sdet Lead Interview Questions
- Ascendion Software Developer Interview Questions
- Ascendion Associate Engineer Interview Questions
- Ascendion Principal Engineer Interview Questions
- Ascendion Senior Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 1 interview experience
Difficulty level
Duration
Business Analyst Interview Questions from Similar Companies
Ascendion Business Analyst Reviews and Ratings
based on 1 review
Rating in categories
6-7 Yrs
Not Disclosed
|
Senior Software Engineer
122
salaries
|  ₹8.5 L/yr - ₹28 L/yr |
|
Lead Engineer
70
salaries
| ₹18 L/yr - ₹33.6 L/yr |
|
Software Engineer
68
salaries
| ₹4.4 L/yr - ₹17.8 L/yr |
|
Senior Engineer
66
salaries
| ₹6.5 L/yr - ₹21 L/yr |
|
Software Developer
53
salaries
| ₹4 L/yr - ₹12.3 L/yr |
ITC Infotech
CMS IT Services
KocharTech
3i Infotech
- Home >
- Interviews >
- Ascendion Interview Questions
