Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Exusia Team. If you also belong to the team, you can get access from here

Exusia Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Exusia Senior Analyst Interview Questions, Process, and Tips

Updated 25 Nov 2024

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

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in May 2024. There were 4 interview rounds.

Round 1 - Technical 

(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 {} \;

  • Answered by AI
  • 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.

  • Answered by AI
  • Q5. Get the second highest salary. (SQL)
Round 2 - Technical 

(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)
Round 3 - Behavioral 

(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...

  • Answered by AI
  • 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...

  • Answered by AI
Round 4 - HR 

(2 Questions)

  • Q1. Why you want to join Exusia. Reason for the job change.
  • Q2. Salary expectations and document submission.

Interview Preparation Tips

Topics to prepare for Exusia Senior Analyst interview:
  • Ab Initio
  • Unix
  • SQL
Interview preparation tips for other job seekers - Prepare Ab initio scenerio based questions, and know how and where to use a component considering its pros and cons. Prepare basic Unix commands and grep, awk, sed, and find commands. Prepare sql with window functions.

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed before Oct 2022. There were 3 interview rounds.

Senior Analyst Interview Questions Asked at Other Companies

Q1. Explain 3 statement financial model Calculating discount rate Cou ... read more
Q2. Tell me about your profile? What do you know about Transaction Mo ... read more
asked in Accenture
Q3. What do you understand by Budgeting and Forecasting?
Q4. Q4. What is the probability of getting 5 Sundays in 31 day month.
Q5. Q4. You are standing in a field. Chances of seeing atleast 1 plan ... read more
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Feb 2022. There were 2 interview rounds.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared for anything and everything.

Interview questions from similar companies

Interview Questionnaire 

3 Questions

  • Q1. On C++ coding,
  • Q2. Simulation
  • Q3. Data based case study like missing data questions.

Interview Preparation Tips

Round: Technical Interview
Experience: .

General Tips: Resume doesn’t really matter, but specific things in it can be looked at. CGPA does not matter as well. Build up your skills, engage with teams and startups in the institute.
Skills: Big Data Analytics, C++, Statistics , Regression
College Name: IIT MADRAS

I applied via Referral

Interview Preparation Tips

Round: Technical Interview
Tips: Brush up your quant and programming skills. Also, practice puzzles

Skills: Programming, Quantitative Aptitude
College Name: IIT Madras

I appeared for an interview before Mar 2021.

Interview Preparation Tips

Interview preparation tips for other job seekers - Good company to work and provide great opportunity to work with different projects

I applied via Naukri.com and was interviewed in Mar 2021. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. ML algorithms
  • Q2. Evaluation metrics

Interview Preparation Tips

Interview preparation tips for other job seekers - Simple yet descriptive
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I applied via Naukri.com and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Initial round for a test of very advanced complex 5 SQL questions to be completed with in one hour.

Interview Preparation Tips

Interview preparation tips for other job seekers - Understanding the question for SQL itself is very tough for moderate SQL knowledgeable persons.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
Not Selected

I applied via LinkedIn and was interviewed in Oct 2023. There was 1 interview round.

Contribute & help others!
anonymous
You can choose to be anonymous

Exusia Interview FAQs

How many rounds are there in Exusia Senior Analyst interview?
Exusia interview process usually has 3 rounds. The most common rounds in the Exusia interview process are Technical, Resume Shortlist and Behavioral.
How to prepare for Exusia Senior Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Exusia. The most common topics and skills that interviewers at Exusia expect are Healthcare, Data Analytics, Financial Statements, Payroll and TDS.
What are the top questions asked in Exusia Senior Analyst interview?

Some of the top questions asked at the Exusia Senior Analyst interview -

  1. Why not to use lookup for join, where we can not use join. Disadvantage of usi...read more
  2. Delete files with 0KB size from a directory. (Un...read more
  3. Full working of different partition components, multifiles, checkpoints and pha...read more

Recently Viewed

INTERVIEWS

Exusia

No Interviews

SALARIES

Absolute Markets Insights

No Salaries

INTERVIEWS

Exusia

10 top interview questions

REVIEWS

Avalon Global Research

No Reviews

REVIEWS

Avalon Global Research

No Reviews

JOBS

Avalon Global Research

No Jobs

REVIEWS

Avalon Global Research

No Reviews

REVIEWS

Avalon Global Research

No Reviews

REVIEWS

Avalon Global Research

No Reviews

REVIEWS

Avalon Global Research

No Reviews

Tell us how to improve this page.

Exusia Senior Analyst Interview Process

based on 3 interviews

1 Interview rounds

  • Technical Round
View more
Exusia Senior Analyst Salary
based on 105 salaries
₹5.2 L/yr - ₹15.5 L/yr
28% more than the average Senior Analyst Salary in India
View more details

Exusia Senior Analyst Reviews and Ratings

based on 30 reviews

4.6/5

Rating in categories

4.5

Skill development

4.5

Work-life balance

4.6

Salary

4.5

Job security

4.5

Company culture

4.5

Promotions

4.5

Work satisfaction

Explore 30 Reviews and Ratings
Senior Consultant
116 salaries
unlock blur

₹13 L/yr - ₹35 L/yr

Senior Analyst
105 salaries
unlock blur

₹5.2 L/yr - ₹15.5 L/yr

Consultant
84 salaries
unlock blur

₹9 L/yr - ₹22 L/yr

Management Consultant
69 salaries
unlock blur

₹15.5 L/yr - ₹42 L/yr

Analyst
36 salaries
unlock blur

₹3.5 L/yr - ₹5.5 L/yr

Explore more salaries
Compare Exusia with

Fractal Analytics

4.0
Compare

Mu Sigma

2.6
Compare

Tiger Analytics

3.7
Compare

LatentView Analytics

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview