AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
AltezzaSys
Compare
Filter interviews by
AltezzaSys Senior Analyst Interview Questions, Process, and Tips
AltezzaSys Senior Analyst Interview Experiences
1 interview found
Selected
I was interviewed in Dec 2024.
(6 Questions)
- Q1. What were your roles and responsibilities in your previous organization?
- Q2. What do you know about cloud computing?
- Q3. What is IBM WebSphere Application Server (WAS) and what are its key features?
- Q4. What are some important Linux commands and their usages?
- Q5. What is the process for renewing certificates?
- Q6. Could you provide details about your recent P1 ticket?
(2 Questions)
- Q1. What tools are you proficient in?
- Q2. Can you explain your experience with the client?
Top trending discussions
Interview questions from similar companies
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
Senior Analyst Interview Questions & Answers
Information Services Group
Anonymous
posted on 6 Jan 2022
I applied via Naukri.com and was interviewed in Jul 2021. There was 1 interview round.
Interview Questionnaire
4 Questions
- Q1. A good amount of Knowledge in Excel
- Q2. Knowledge on Visualization tool such as power BI
- Q3. Knowledge on SQL
- Q4. Basics of Machine learning
Interview Preparation Tips
I applied via Naukri.com and was interviewed before Dec 2021. There were 4 interview rounds.
Usual questions about self and experience
(1 Question)
- Q1. Windows and server related questions
(1 Question)
- Q1. The Final HR round where everything finalized
Interview Preparation Tips
Selected
A question that is both tricky and simple.
(1 Question)
- Q1. Questions about biochemistry
Questions based on both numerical data and case studies.
(2 Questions)
- Q1. Can you tell me about yourself?
- Q2. What interests you in working for this company?
- Ans.
I am interested in working for this company because of its innovative projects and strong reputation in the industry.
Innovative projects that challenge me to grow as a programmer
Strong reputation in the industry for quality work
Opportunities for career advancement and professional development
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
(3 Questions)
- Q1. Highlight the odd cells in excel
- Ans.
Use conditional formatting to highlight odd cells in Excel
Select the range of cells you want to highlight
Go to the 'Home' tab and click on 'Conditional Formatting'
Choose 'New Rule' and select 'Use a formula to determine which cells to format'
Enter the formula '=MOD(A1,2)=1' (assuming A1 is the top-left cell of your selected range)
Choose the formatting style you want for the odd cells
- Q2. What are Joins in SQL, explain different joins and their outputs
- Ans.
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
INNER JOIN returns rows when there is at least one match in both tables
LEFT JOIN returns all rows from the left table and the matched rows from the right table
RIGHT JOIN returns all rows from the right table and the matched rows from the left table
FU...
- Q3. Query to give running sum of salary
- Ans.
Use window function to calculate running sum of salary in SQL
Use window function like SUM() with OVER() clause
Partition the data by employee ID if needed
Order the data by date or any other relevant column
Interview Preparation Tips
Skills evaluated in this interview
I applied via Company Website and was interviewed in Jun 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Self Introduction
- Q2. Salary Expectation
(1 Question)
- Q1. 14 questions in excel formulas
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Jul 2023. There were 3 interview rounds.
(2 Questions)
- Q1. About your past experience
- Q2. Reason for leaving the last job
(1 Question)
- Q1. Process related and journal entries for the questions previously prepared kept by the interviewer.
Interview Preparation Tips
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
Senior Analyst Interview Questions & Answers
Information Services Group
Anonymous
posted on 16 Sep 2022
I applied via LinkedIn and was interviewed before Sep 2021. There were 4 interview rounds.
Powerpoint,Word,excel and Iconography
(1 Question)
- Q1. With Manager about technical skills and personal details as well
(1 Question)
- Q1. Salary discussion and probation period
Interview Preparation Tips
AltezzaSys Interview FAQs
Tell us how to improve this page.
AltezzaSys Interviews By Designations
- AltezzaSys Analyst Interview Questions
- AltezzaSys AWS Architect Interview Questions
- AltezzaSys Azure DevOps Engineer Interview Questions
- AltezzaSys Business Analyst Interview Questions
- AltezzaSys Delivery Head Interview Questions
- AltezzaSys HR Head Interview Questions
- AltezzaSys Senior Analyst Interview Questions
- AltezzaSys Senior Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
AltezzaSys Senior Analyst Interview Process
based on 1 interview
Interview experience
Senior Analyst Interview Questions from Similar Companies
AltezzaSys Senior Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Information Technology Recruiter
41
salaries
|  ₹1 L/yr - ₹4.4 L/yr |
|
Senior IT Recruiter
20
salaries
| ₹2.8 L/yr - ₹4.5 L/yr |
|
Team Lead
19
salaries
| ₹2.7 L/yr - ₹8.6 L/yr |
|
Senior Consultant
15
salaries
| ₹8.6 L/yr - ₹20 L/yr |
|
Talent Acquisition Executive
11
salaries
| ₹2 L/yr - ₹4.8 L/yr |
Infosys
TCS
Wipro
HCLTech
- Home >
- Interviews >
- AltezzaSys Interview Questions >
- AltezzaSys Senior Analyst Interview Questions
