Add office photos
Filter interviews by
Stellar Innovations Senior Analyst Interview Questions and Answers
Updated
15 Apr 2024
1 interview found
Sort by:
Popular
Anonymous
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Approached by Company and was interviewed in Apr 2022.
2 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
2
HR Round (1 Question)
- Q1. Basic Us mortgage questions like full search, Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Make sure to take test orders,
Interview questions from similar companies
Interview experience
Excellent
Difficulty level
Moderate
Duration
2-4 weeks
Result
Selected
I applied via Approached by Company and was interviewed in May 2024.
4 Interview Rounds
1
Technical Round (5 Questions)
- Q1. Difference between Lookup and join, where we should use which one in Ab Initio. Add Answer
- Q2. Ab Initio Scenerio Based questions. Add Answer
- Q3. Delete files with 0KB size from a directory. (Unix) View Answers (1)
- Q4. Delete 10 days older files. (unix) View Answers (1)
- Q5. Get the second highest salary. (SQL) Add Answer
2
Technical Round (4 Questions)
- Q1. Ab initio scenerio based questions. Question on the project. Add Answer
- Q2. Questions based on different components like Roll up, scan, reformat, join, etc. (Ab Initio) Add Answer
- Q3. Questions based on sed, awk, and grep commands. (UNIX) Add Answer
- Q4. Questions on Window function. (SQL) Add Answer
3
Behavioral Round (4 Questions)
- Q1. In-depth discussion on project. Components used there and the process of the graph. Add Answer
- Q2. Questions on Continuous Flow, conduct>IT. Add Answer
- Q3. Full working of different partition components, multifiles, checkpoints and phases. View Answers (1)
- Q4. Why not to use lookup for join, where we can not use join.
Disadvantage of using sort component. View Answers (1)
4
HR Round (2 Questions)
- Q1. Why you want to join Exusia. Reason for the job change. Add Answer
- Q2. Salary expectations and document submission. Add Answer
Interview Preparation Tips
Topics to prepare for Exusia Senior Analyst interview:
- Ab Initio
- Unix
- SQL
I applied via Naukri.com and was interviewed in Jul 2021.
1 Interview Round
Interview Questions
- Q1. A good amount of Knowledge in Excel
Add Answer
- Q2. Knowledge on Visualization tool such as power BI
Add Answer
- Q3. Knowledge on SQL
Add Answer
- Q4. Basics of Machine learning
Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Be Confident on your answers
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in May 2024.
1 Interview Round
1
Technical Round (3 Questions)
- Q1. Highlight the odd cells in excel View Answers (1)
- Q2. What are Joins in SQL, explain different joins and their outputs View Answers (1)
- Q3. Query to give running sum of salary View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Keep your SQL strong and practice joins with problem solving questions
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
I applied via Campus Placement
2 Interview Rounds
1
Aptitude Test Round
Its a sectional round. It has 4 sections. Quants, Logical, pseudo code, Reasoning, Gaming
2
One-on-one Round (2 Questions)
- Q1. Aptitude question solving Add Answer
- Q2. Resume related questions Add Answer
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in Jul 2023.
3 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
2
HR Round (2 Questions)
- Q1. About your past experience Add Answer
- Q2. Reason for leaving the last job Add Answer
3
Technical Round (1 Question)
- Q1. Process related and journal entries for the questions previously prepared kept by the interviewer. Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Refresh your accounting well. Anyway, they will ask the questions relevant to their process. so be cool and attend well.
Interview experience
Good
Difficulty level
Moderate
Duration
6-8 weeks
Result
Selected
I applied via Recruitment Consulltant and was interviewed before Mar 2022.
2 Interview Rounds
1
Aptitude Test Round
Very simple and can clear easily
2
One-on-one Round (3 Questions)
- Q1. I was looking job as a fresher and the interview questions were mostly on academic project, team handling and some personal questions. Add Answer
- Q2. What is your role in project? View Answers (1)
- Q3. Are there any disputes while working in team and how you handled it? View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - This department is no longer active.Dont waste your time working here.
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Job Portal and was interviewed before Oct 2022.
3 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
2
Technical Round (1 Question)
- Q1. Regarding SQl, My Projects Add Answer
3
Technical Round (1 Question)
- Q1. SQL, UNIX , Work Experience Add Answer
I applied via LinkedIn and was interviewed before Sep 2021.
4 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
2
Assignment Round
Powerpoint,Word,excel and Iconography
3
One-on-one Round (1 Question)
- Q1. With Manager about technical skills and personal details as well Add Answer
4
HR Round (1 Question)
- Q1. Salary discussion and probation period Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Best Place to work. Friendly team and helps to improve our skills
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Referral and was interviewed in Feb 2024.
3 Interview Rounds
1
Coding Test Round
The first round was a combination of MCQs and SQL Coding test. It consisted of 23 MCQs on SQL, 10 MCQs on Power BI and 5 SQL Coding questions.
2
Technical Round (1 Question)
- Q1. Simple questions on SQL were asked. Add Answer
3
One-on-one Round (5 Questions)
- Q1. What is pivot table in Excel? View Answers (1)
- Q2. What is 'Data Validation' in Excel? View Answers (1)
- Q3. What is the order of execution of an SQL query? View Answers (1)
- Q4. What is the difference between Tree Map and Heatmap in Tableau? View Answers (1)
- Q5. What is the difference between 'Extract Data' and 'Live Connection' in Tableau? View Answers (1)
Interview Preparation Tips
Topics to prepare for Affine Data Analyst interview:
- SQL
- Power Bi
- Tableau
- Excel
Skills evaluated in this interview
Stellar Innovations Interview FAQs
How many rounds are there in Stellar Innovations Senior Analyst interview?
Stellar Innovations interview process usually has 2 rounds. The most common rounds in the Stellar Innovations interview process are Resume Shortlist and HR.
Tell us how to improve this page.
Stellar Innovations Interviews By Designations
- Stellar Innovations Analyst Interview Questions
- Stellar Innovations Data Analyst Interview Questions
- Stellar Innovations Process Associate Interview Questions
- Stellar Innovations Trainee Process Associate Interview Questions
- Stellar Innovations Associate Trainee Interview Questions
- Stellar Innovations Associate Vice President Interview Questions
- Stellar Innovations BPO Analyst Interview Questions
- Stellar Innovations Junior Software Developer Interview Questions
- Show more
Interview Questions for Popular Designations
Senior Analyst Interview Questions from Similar Companies
60%
less
than the average Senior Analyst Salary in India
View more details
Stellar Innovations Senior Analyst Reviews and Ratings
based on 10 reviews
Rating in categories
|
Process Associate
299
salaries
|  ₹1.1 L/yr - ₹5.5 L/yr |
|
Senior Analyst
89
salaries
| ₹2 L/yr - ₹5.6 L/yr |
|
Senior Process Associate
78
salaries
| ₹2.2 L/yr - ₹4.5 L/yr |
|
Title Examiner
51
salaries
| ₹2.5 L/yr - ₹4.8 L/yr |
|
Software Engineer
48
salaries
| ₹2 L/yr - ₹8.5 L/yr |
Explore more salaries
Compare Stellar Innovations with
TCS
Compare
Infosys
Compare
Wipro
Compare
HCLTech
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- Stellar Innovations Interview Questions >
- Stellar Innovations Senior Analyst Interview Questions
Share an Interview