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

Exusia Interview Questions, Process, and Tips

Updated 11 Feb 2025

Top Exusia Interview Questions and Answers

View all 10 questions

Exusia Interview Experiences

Popular Designations

20 interviews found

Consultant Interview Questions & Answers

user image Anonymous

posted on 9 Jan 2025

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Difference between OLAP, OLTP systems
  • Ans. 

    OLAP is for analyzing data, OLTP is for transaction processing.

    • OLAP stands for Online Analytical Processing, used for complex queries and data analysis.

    • OLTP stands for Online Transaction Processing, used for routine transactions like insert, update, delete.

    • OLAP systems are designed for read-heavy workloads, while OLTP systems are designed for write-heavy workloads.

    • OLAP systems typically have a denormalized schema for f...

  • Answered by AI
  • Q2. Difference between star and snowflake schema
  • Ans. 

    Star schema has a single centralized fact table with denormalized dimensions, while snowflake schema has normalized dimensions with multiple related tables.

    • Star schema is easier to understand and query due to denormalized structure.

    • Snowflake schema saves storage space by normalizing dimensions into separate tables.

    • Star schema is more suitable for data warehousing and reporting purposes.

    • Snowflake schema is more normaliz...

  • Answered by AI

Consultant Interview Questions asked at other Companies

Q1. How would you pass an entry for travel expenses incurred and paid by employee and was reimbursed? How would the end to end flow happens
View answer (8)

Rate your
company

🤫 100% anonymous

How was your last interview experience?

Share interview
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

Senior Analyst Interview Questions asked at other Companies

Q1. Explain 3 statement financial model Calculating discount rate Could you walk me through the DCF model? Other valuation methods. What PE is ideal? What is the other matrix to value the company? Difference between IRR and CAGR. What is Bond Y... read more
View answer (1)

Consultant Interview Questions & Answers

user image Anonymous

posted on 20 Sep 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Abinito components usage
  • Ans. 

    Abinito components are used in ETL processes for data integration and transformation.

    • Abinito components are used in ETL (Extract, Transform, Load) processes for data integration and transformation.

    • Some commonly used Abinito components include Input Table, Output Table, Join, Partition, Sort, Filter, and Lookup.

    • Abinito provides a graphical interface for designing ETL processes using these components.

    • Abinito components c...

  • Answered by AI
  • Q2. Air commands and Multi file system
Round 2 - Technical 

(2 Questions)

  • Q1. Project related details and questions
  • Q2. Experience related to background
Round 3 - HR 

(1 Question)

  • Q1. Salary expectations

Skills evaluated in this interview

Consultant Interview Questions asked at other Companies

Q1. How would you pass an entry for travel expenses incurred and paid by employee and was reimbursed? How would the end to end flow happens
View answer (8)
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I was interviewed in Oct 2024.

Round 1 - Coding Test 

Python coding, and sql

Round 2 - Technical 

(3 Questions)

  • Q1. Spark, python, sql
  • Q2. Spark architechture
  • Q3. Python rcoding question

Senior Data Engineer Interview Questions asked at other Companies

Q1. Write a query to get the customer with the highest total order value for each year, month. [Note: Order table is different and Customer table is different. Order_ID and Customer_ID are the PK of the table with Oid from Customer table being ... read more
View answer (2)

Exusia interview questions for popular designations

 Senior Analyst

 (3)

 Consultant

 (3)

 Data Analyst

 (2)

 Senior Data Engineer

 (2)

 Management Consultant

 (2)

 Technical Lead

 (1)

 Analyst

 (1)

 Senior Consultant

 (1)

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 23 Oct 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is Data Profiling
  • Ans. 

    Data profiling is the process of analyzing and summarizing data to gain insights into its quality, structure, and content.

    • Data profiling involves examining data to understand its characteristics, such as data types, patterns, and relationships.

    • It helps in identifying data quality issues, such as missing values, outliers, and inconsistencies.

    • Data profiling can also reveal data distribution, frequency of values, and data...

  • Answered by AI
  • Q2. What is data modeling and it's importance
  • Ans. 

    Data modeling is the process of creating a visual representation of data structures and relationships to help understand and analyze data.

    • Data modeling helps in organizing and structuring data in a way that is easy to understand and analyze.

    • It helps in identifying relationships between different data elements.

    • Data modeling is important for designing databases, developing data warehouses, and improving data quality.

    • Exam...

  • Answered by AI

Skills evaluated in this interview

Data Analyst Interview Questions asked at other Companies

Q1. Suppose there is a room in the office and X people enter room throughout the day, Y people leave throughout the day [continuously people are entering the room, some are staying there, and rest are going out] .. so tell me the code to calcul... read more
View answer (11)

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 13 Oct 2024

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

I was interviewed in Sep 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. Spark related question
  • Q2. Python coding questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Spark related questions

Data Engineer Interview Questions asked at other Companies

Q1. Optimal Strategy for a Coin Game You are playing a coin game with your friend Ninjax. There are N coins placed in a straight line. Here are the rules of the game: 1. Each coin has a value associated with it. 2. The game involves two players... read more
View answer (1)
Interview experience
4
Good
Difficulty level
Hard
Process Duration
More than 8 weeks
Result
No response

I applied via Recruitment Consulltant and was interviewed in Mar 2024. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Questions on the Technical Capabilities
Round 2 - Technical 

(1 Question)

  • Q1. TECHNICAL Features
Round 3 - Technical 

(1 Question)

  • Q1. Technical and Managerial Skills

Interview Preparation Tips

Interview preparation tips for other job seekers - The process lasted for couple of months. The HR made final offer ,however offer was later redacted citing that the requirement is closed.

Management Consultant Interview Questions asked at other Companies

Q1. Case study: Assuming you are the product manager for a warehousing module, how will you develop a warehouse inventory module
View answer (1)
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. How can you handle the task?
  • Ans. 

    I handle tasks by breaking them down into smaller steps, setting priorities, and utilizing time management techniques.

    • Break down the task into smaller steps

    • Set priorities based on deadlines and importance

    • Utilize time management techniques such as Pomodoro method or Eisenhower matrix

  • Answered by AI

Software Developer Interview Questions asked at other Companies

Q1. Maximum Subarray Sum Problem Statement Given an array of integers, determine the maximum possible sum of any contiguous subarray within the array. Example: Input: array = [34, -50, 42, 14, -5, 86] Output: 137 Explanation: The maximum sum is... read more
View answer (42)

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 7 Mar 2024

Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Feb 2024.

Round 1 - Technical 

(1 Question)

  • Q1. Related to ETL, Data model, data warehouse

Data Analyst Interview Questions asked at other Companies

Q1. Suppose there is a room in the office and X people enter room throughout the day, Y people leave throughout the day [continuously people are entering the room, some are staying there, and rest are going out] .. so tell me the code to calcul... read more
View answer (11)

Associate Interview Questions & Answers

user image Anonymous

posted on 10 Apr 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

UNIX concepts , express it , some data warehousing question

Round 2 - Technical 

(1 Question)

  • Q1. Explain SDCL, explain Reformate component , gave few scenarios

Interview Preparation Tips

Interview preparation tips for other job seekers - all the very best

Associate Interview Questions asked at other Companies

Q1. What is mean of TTR & why required for powder coating process ?
View answer (17)
Contribute & help others!
anonymous
You can choose to be anonymous

Exusia Interview FAQs

How many rounds are there in Exusia interview?
Exusia interview process usually has 2-3 rounds. The most common rounds in the Exusia interview process are Technical, Coding Test and Resume Shortlist.
How to prepare for Exusia 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, HTTP, Analytics, IT Services and Data Management.
What are the top questions asked in Exusia interview?

Some of the top questions asked at the Exusia 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

JOBS

Browse jobs

Discover jobs you love

COMPANY BENEFITS

KNR Constructions

20 benefits

COMPANY BENEFITS

IRB Infrastructure

60 benefits

COMPANY BENEFITS

Dilip Buildcon

304 benefits

COMPANY BENEFITS

Dilip Buildcon

304 benefits

COMPANY BENEFITS

Avalon Global Research

No Benefits

COMPANY BENEFITS

The Louis Berger Group

No Benefits

INTERVIEWS

Cotiviti

No Interviews

Tell us how to improve this page.

Exusia Interview Process

based on 15 interviews

Interview experience

3.4
  
Average
View more

Anonymously discuss salaries, work culture, and many more

Get Ambitionbox App

Interview Questions from Similar Companies

Mu Sigma Interview Questions
2.6
 • 229 Interviews
Tiger Analytics Interview Questions
3.6
 • 221 Interviews
Fractal Analytics Interview Questions
4.0
 • 207 Interviews
Tredence Interview Questions
3.6
 • 123 Interviews
AbsolutData Interview Questions
3.6
 • 9 Interviews
Algonomy Interview Questions
4.0
 • 9 Interviews
Crayon Data Interview Questions
3.6
 • 4 Interviews
View all

Exusia Reviews and Ratings

based on 222 reviews

4.0/5

Rating in categories

3.9

Skill development

4.0

Work-life balance

4.0

Salary

4.0

Job security

3.9

Company culture

3.9

Promotions

3.9

Work satisfaction

Explore 222 Reviews and Ratings
Senior Consultant
118 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Analyst
105 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Consultant
84 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Management Consultant
69 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
36 salaries
unlock blur

₹0 L/yr - ₹0 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
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent