AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Exusia
Compare
Filter interviews by
Exusia Senior Analyst Interview Questions, Process, and Tips
Top Exusia Senior Analyst Interview Questions and Answers
- Q1. Why not to use lookup for join, where we can not use join. Disadvantage of using sort component.
- Q2. Delete files with 0KB size from a directory. (Unix)
- Q3. Full working of different partition components, multifiles, checkpoints and phases.
Exusia Senior Analyst Interview Experiences
3 interviews found
Anonymous
Selected
I applied via Approached by Company and was interviewed in May 2024. There were 4 interview rounds.
(5 Questions)
- Q1. Difference between Lookup and join, where we should use which one in Ab Initio.
- Q2. Ab Initio Scenerio Based questions.
- Q3. Delete files with 0KB size from a directory. (Unix)
- Ans.
Use find command to locate files with 0KB size and delete them using the rm command.
Use find command with -size 0 option to locate files with 0KB size in a directory
Pipe the output of find command to rm command to delete the files
Example: find /path/to/directory -type f -size 0 -exec rm {} \;
- Q4. Delete 10 days older files. (unix)
- Ans.
Use find command with -mtime option to delete files older than 10 days.
Use find command with -mtime option to search for files older than 10 days.
Combine find command with -delete option to delete the files found.
- Q5. Get the second highest salary. (SQL)
(4 Questions)
- Q1. Ab initio scenerio based questions. Question on the project.
- Q2. Questions based on different components like Roll up, scan, reformat, join, etc. (Ab Initio)
- Q3. Questions based on sed, awk, and grep commands. (UNIX)
- Q4. Questions on Window function. (SQL)
(4 Questions)
- Q1. In-depth discussion on project. Components used there and the process of the graph.
- Q2. Questions on Continuous Flow, conduct>IT.
- Q3. Full working of different partition components, multifiles, checkpoints and phases.
- Ans.
Partition components, multifiles, checkpoints, and phases in data processing.
Partition components refer to dividing data into smaller chunks for processing efficiency.
Multifiles are multiple files used to store data during processing.
Checkpoints are markers set during processing to save progress and enable restart from a specific point.
Phases represent different stages of data processing workflow.
Example: In a MapReduc...
- Q4. Why not to use lookup for join, where we can not use join. Disadvantage of using sort component.
- Ans.
Using lookup for join can be inefficient and lead to performance issues. Sort component can be slow and resource-intensive.
Lookup for join can be inefficient for large datasets as it requires scanning the entire dataset for each lookup value.
Join is more optimized for joining datasets based on a common key, while lookup is better suited for smaller reference tables.
Sort component can be slow and resource-intensive, esp...
(2 Questions)
- Q1. Why you want to join Exusia. Reason for the job change.
- Q2. Salary expectations and document submission.
Interview Preparation Tips
- Ab Initio
- Unix
- SQL
Skills evaluated in this interview
Selected
I applied via Job Portal and was interviewed before Oct 2022. There were 3 interview rounds.
(1 Question)
- Q1. Regarding SQl, My Projects
(1 Question)
- Q1. SQL, UNIX , Work Experience
Selected
I applied via LinkedIn and was interviewed before Feb 2022. There were 2 interview rounds.
(1 Question)
- Q1. Related to Abinitio Administration
Interview Preparation Tips
Interview questions from similar companies
Selected
I appeared for an interview in Aug 2024.
(2 Questions)
- Q1. Introduction about yourself
- Ans.
I am a highly experienced Senior Analyst with a strong background in data analysis and strategic planning.
Over 10 years of experience in analyzing complex data sets
Expertise in developing data-driven strategies to improve business performance
Proficient in using statistical software such as SPSS and SAS
Strong communication skills to present findings to stakeholders
Previous experience in leading cross-functional teams to
- Q2. English speaking skill
(1 Question)
- Q1. Technical questions
Interview Questionnaire
2 Questions
- Q1. Mostly puzzles and one case study
- Q2. They asked me questions about my interests and hobbies
Interview Preparation Tips
Experience: There were three sets of question paper. We were sitting according to our roll number then question paper with rough sheet were distributed and we were allowed 1 hour to finish that. There was no negative marking.
Tips: For aptitude practice data interpretation and data sufficiency
Duration: 1 hour
Total Questions: 30
Round: Group Discussion
Duration: 15 minutes
Round: Technical Interview
Tips: Practice puzzles and case study for this round
Round: HR Interview
Tips: Be yourself
College Name: NIT Rourkela
Interview Questionnaire
18 Questions
- Q1. Tell me about your yourself
- Ans.
I am a detail-oriented business analyst with experience in data analysis and process improvement.
I have a Bachelor's degree in Business Administration
I have worked with various stakeholders to identify business needs and requirements
I am proficient in SQL and Excel for data analysis
I have experience in process improvement and project management
I am a strong communicator and collaborator
- Q2. Tell us about your training and internships
- Ans.
I have completed a business analyst certification course and have interned at a software development company.
Completed a business analyst certification course from XYZ Institute
Interned at ABC Software Development Company for 6 months
Worked on requirement gathering, documentation and analysis for a project
Assisted senior business analysts in creating project plans and reports
- Q3. What is the role of Instrumentation Department? (my training)
- Ans.
The Instrumentation Department is responsible for designing, installing, and maintaining control systems and instruments used in industrial processes.
Designing and implementing control systems for industrial processes
Installing and maintaining instruments used in industrial processes
Ensuring accuracy and reliability of instruments and control systems
Collaborating with other departments to optimize processes and improve...
- Q4. Why do you want to join Affine Analytics?
- Ans.
I am excited to join Affine Analytics because of their reputation for delivering innovative solutions and their focus on employee growth.
Affine Analytics has a strong track record of delivering cutting-edge solutions to clients across industries.
I am impressed by the company's commitment to employee growth and development, as evidenced by their training and mentorship programs.
I am excited about the opportunity to work...
- Q5. Why Data anayltics? Why not a technical job in your field?
- Ans.
Data analytics allows me to use my technical skills to solve business problems and make data-driven decisions.
Data analytics helps me to identify patterns and trends in data that can be used to improve business processes.
It allows me to work with large datasets and use statistical methods to extract insights.
I can use my technical skills to develop and implement data models and algorithms.
Data analytics is a growing fi...
- Q6. If I keep two diodes in series will it work as a transistor? (EC branch)
- Ans.
No, two diodes in series cannot work as a transistor.
Transistors have three terminals while diodes have two.
Transistors can amplify signals while diodes cannot.
Transistors can be used as switches while diodes cannot.
Diodes in series will only increase the voltage drop.
Transistors have different modes of operation such as common emitter, common base, and common collector.
- Q7. What exactly have you accomplished with the drone? (my final year project)
- Ans.
I developed a drone that can detect and monitor forest fires.
Designed and built a drone with thermal imaging camera
Integrated machine learning algorithm to detect fire
Tested and validated the drone in a controlled forest environment
Presented the project at a national engineering conference
- Q8. How frequently do you play Badminton? (Hobby)
- Ans.
I play badminton twice a week as a hobby.
I enjoy playing badminton as a way to stay active and relieve stress.
I usually play with friends or family members at a local community center.
I have been playing badminton for several years and have improved my skills over time.
- Q9. Do you have any problem working in Bangalore?
- Ans.
No, I don't have any problem working in Bangalore.
I am familiar with the city and its culture
I have worked in Bangalore before and enjoyed my experience
I am open to new experiences and challenges
I am willing to adapt to the local environment and work culture
- Q10. Do you have any questions for us?
- Q11. Which football club do you follow? (My answer: Real Madrid) (Que based on hobby)
- Q12. Why is Real Madrid your favorite?
- Ans.
Real Madrid is my favorite because of their rich history, success, and style of play.
Real Madrid has won a record 13 Champions League titles, which is a testament to their success
Their style of play is attractive and entertaining to watch
The club has a rich history and has had some of the greatest players in football history, such as Cristiano Ronaldo and Zinedine Zidane
- Q13. Assume you are the CEO of Flipkart. Your board has decided to go App only. What factors would you consider before making your final decision. (You have the relevant data from your website of last 7 years ...
- Ans.
Factors to consider before going App only as CEO of Flipkart
Analyze the data from website and app to understand user behavior
Evaluate the impact on sales and revenue
Consider the potential loss of customers who prefer website over app
Assess the cost of developing and maintaining the app
Evaluate the competition and their strategies
Consider the impact on brand image and customer loyalty
Assess the feasibility of providing ...
- Q14. The Horse Puzzle
- Q15. 3 Ants triangle puzzle
- Q16. 3 Jars puzzle (Apple/Orange puzzle)
- Q17. I have two jars of 5 litres and 3 litres. How can I measure 4 litres? (Assume: Infinite supply of water and no third jar is present)
- Q18. A revolver with 2 bullets puzzle
Interview Preparation Tips
Experience: The first 10 questions were Data Interpretation type. There were around 4 to 5 logic questions. The rest were quantitative questions.
The questions were pretty basic.
Tips: The aim is to check the speed of your calculations.
Duration: 30 minutes
Total Questions: 23
Round: Group Discussion
Tips: Speak relevant points and you will be fine.
High proficiency in English is a must.
Duration: 10 minutes
Round: Puzzle Interview
Experience: The interview was great and lasted around 35-40 minutes. The interviewer gave ample amount of time to solve the questions.
To answer the questions was ofcourse important but approach to your final answer is very important as well. If you already know the answer but fail to explain the approach to the interviewer, you will get rejected.
Tips: Keep the interviewer in the loop and keep explaining him what you are thinking.
Fluent English is very important as well.
Round: HR Interview
Experience: The interviewers were very friendly and the interview lasted around 15 min.
Tips: Have one or two favorite subject/s from which you can answer any question thrown at you.
Be well versed about your final year project.
Do not put rubbish in your resume as they read the entire resume.
Skills: Enthusiasm, Projects, Proficiency In English, Logical Puzzles, Logical Thinking
College Name: NIT Surat
Funny Moments: As the HR interviewer is an alumni of my college, we had some chat about the college. This made the interview mood very light.
I applied via Referral and was interviewed in Jul 2023. There were 2 interview rounds.
(2 Questions)
- Q1. SQL and domain - Use case scenarios and real time examples
- Ans.
SQL is used in various domains for data analysis and reporting. Use cases include financial analysis, inventory management, and customer relationship management.
Financial analysis - using SQL to analyze revenue, expenses, and profitability
Inventory management - tracking stock levels, orders, and shipments
Customer relationship management - analyzing customer data, preferences, and interactions
- Q2. SQL questions and domain related questions.
Interview Preparation Tips
- SQL
If you are bit low in SQL and expert in your domain area, You will be eventually rejected.
Skills evaluated in this interview
Interview Preparation Tips
1st round included basic apt questions and essay writing
(2 Questions)
- Q1. General resume questions
- Q2. Aptitude questions
Selected
I appeared for an interview before Mar 2024.
(1 Question)
- Q1. Games to check for porboen solving skills
(1 Question)
- Q1. Drug discovery questions from coursera
(1 Question)
- Q1. Aptitude questions were asked to be solved on call
Interview Preparation Tips
Exusia Interview FAQs
Some of the top questions asked at the Exusia Senior Analyst interview -
Tell us how to improve this page.
Exusia Interviews By Designations
- Exusia Senior Analyst Interview Questions
- Exusia Consultant Interview Questions
- Exusia Data Analyst Interview Questions
- Exusia Senior Data Engineer Interview Questions
- Exusia Management Consultant Interview Questions
- Exusia Technical Lead Interview Questions
- Exusia Analyst Interview Questions
- Exusia Senior Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
Exusia Senior Analyst Interview Process
based on 3 interviews
1 Interview rounds
- Technical Round
Senior Analyst Interview Questions from Similar Companies
Exusia Senior Analyst Reviews and Ratings
based on 30 reviews
Rating in categories
|
Senior Consultant
118
salaries
|  ₹12.9 L/yr - ₹33.5 L/yr |
|
Senior Analyst
103
salaries
| ₹5.2 L/yr - ₹15.5 L/yr |
|
Consultant
83
salaries
| ₹9 L/yr - ₹22 L/yr |
|
Management Consultant
69
salaries
| ₹15.5 L/yr - ₹42 L/yr |
|
Analyst
36
salaries
| ₹3.5 L/yr - ₹5.5 L/yr |
Value Point Systems
JoulestoWatts Business Solutions
Saama Technologies
Systems Plus
- Home >
- Interviews >
- Exusia Interview Questions >
- Exusia Senior Analyst Interview Questions
