Information Services Group Analyst Interview Questions and Answers

Virtual basic discussion, ques on basic programming only

1 hour major interview of first round only technical and core concepts on programming

Q1. General questions and introduction to company policy
Add your answer

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
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer
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
Answered by AI
Add your answer

Q1. Self Introduction
Add your answer
Q2. Salary Expectation
Add your answer

Q1. 14 questions in excel formulas
Add your answer

Q1. What were my grades in high school
Ans. 
My grades in high school were consistently high, with a GPA of 3.8.
• Consistently high grades throughout high school

• Achieved a GPA of 3.8

• Received honors and awards for academic performance
Answered by AI
Add your answer

Q1. About your past experience
Add your answer
Q2. Reason for leaving the last job
Add your answer

Q1. Process related and journal entries for the questions previously prepared kept by the interviewer.
Add your answer

First round is gamified aptitude that is playfull easy to crake.

That was a aptitude test easy to crake. major question are percentage,reasoning,average,ven diagram,number system, basic math question

Science base assessment (at the first they give certain amount of course and course source that we need to study) easy 10 mcq question we need to learn the course.

Q1. They test our problem solving skill so they give a bunch of aptitude question and explain to the hr.
Add your answer
Q2. About my family
Add your answer
Q3. Strength and weakness
Add your answer
Q4. Recent book you read
Add your answer
Q5. Project and internship
Add your answer

Q1. Difference between Lookup and join, where we should use which one in Ab Initio.
Add your answer
Q2. Ab Initio Scenerio Based questions.
Add your answer
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
Add your answer
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
Add your answer
Q5. Get the second highest salary. (SQL)
Add your answer

Q1. Ab initio scenerio based questions. Question on the project.
Add your answer
Q2. Questions based on different components like Roll up, scan, reformat, join, etc. (Ab Initio)
Add your answer
Q3. Questions based on sed, awk, and grep commands. (UNIX)
Add your answer
Q4. Questions on Window function. (SQL)
Add your answer

Q1. In-depth discussion on project. Components used there and the process of the graph.
Add your answer
Q2. Questions on Continuous Flow, conduct>IT.
Add your answer
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...read more
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer

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