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?
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 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 Recruitment Consulltant and was interviewed before Mar 2022. There were 2 interview rounds.
Very simple and can clear easily
(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.
- Q2. What is your role in project?
- Ans.
As a Quality Analyst, my role in the project is to ensure that the software meets the required quality standards.
Conducting quality assurance activities to identify and resolve defects
Creating and executing test cases to validate software functionality
Collaborating with developers and stakeholders to understand project requirements
Performing regression testing to ensure previous functionality is not affected
Documenting...
- Q3. Are there any disputes while working in team and how you handled it?
- Ans.
Yes
Yes, there have been disputes while working in a team.
I handled disputes by actively listening to all parties involved and understanding their perspectives.
I encouraged open communication and facilitated discussions to find common ground and resolve conflicts.
I promoted a collaborative environment where everyone's opinions were valued and respected.
For example, in a project where there was a disagreement about the p...
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. Aptitude questions similar to the ones from the first round
Interview Preparation Tips
I applied via Company Website and was interviewed in Jul 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Complex sql scenarios and their results
- Ans.
Complex SQL scenarios and their results
Using subqueries to filter data
Joining multiple tables with complex conditions
Using window functions to calculate running totals
Pivoting data to transform rows into columns
Using recursive queries to traverse hierarchical data
Interview Preparation Tips
Skills evaluated in this interview
Interview Preparation Tips
Interview Preparation Tips
Experience: It was nice set of mixed bag questions each challenging your brain to scratch more and find the trick.
Tips: Be calm in solving the questions, Practice few tricks to solve
work,time,distance,number series problem etc. quickly to help save the
time.
Duration: 20 minuntes minutes
Total Questions: 25
Round: Resume Shortlist
Experience: I think resume played a important role in selection processes.
Tips: Make it simple and HIGHLIGHT your good work and experiences.Interviewer don't have time to go through whole crap what we write so basically focus on highlighting your achievements and internships.
Round: Group Discussion
Experience: People are dying to take the opportunity and speak.You will be facing a fish market in few cases, rest it is calm and everyone is given a chance to put forward there point.
Tips: Generally u have to decide which side of the boat u want to be on.
Either go against the topic or in favor whichever you are more
comfortable with.
College Name: IIT ROORKEE
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 HR Head Interview Questions
- AltezzaSys Senior Analyst Interview Questions
- AltezzaSys Talent Acquisition and IT Recruiter Interview Questions
Interview Questions for Popular Designations
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 |
|
Team Lead
18
salaries
| ₹2.7 L/yr - ₹8.6 L/yr |
|
Senior IT Recruiter
18
salaries
| ₹2.8 L/yr - ₹4.5 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
Calculate your in-hand salary
- Home >
- Interviews >
- AltezzaSys Interview Questions >
- AltezzaSys Senior Analyst Interview Questions
