Upload Button Icon Add office photos

Filter interviews by

Shiash Info Solutions TAE Interview Questions and Answers

Updated 30 Jun 2021

Shiash Info Solutions TAE Interview Experiences

Interview questions from similar companies

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

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Should have strong knowledge in SQL, ETL & DWH concepts

Skills evaluated in this interview

I appeared for an interview in May 2022.

Round 1 - Coding Test 

(1 Question)

Round duration - 90 minutes
Round difficulty - Easy

It was just after the first round in the morning

  • Q1. 

    Huffman Coding Challenge

    Given an array ARR of integers containing 'N' elements where each element denotes the frequency of a character in a message composed of 'N' alphabets of an alien language, your ta...

  • Ans. 

    Implement a function to generate Huffman codes for characters based on their frequencies in an alien language message.

    • Use a priority queue to build the Huffman tree efficiently.

    • Assign '0' and '1' to left and right branches of the tree respectively to generate unique binary codes.

    • Ensure that each code distinctly identifies its corresponding character and minimizes the total number of bits used for the message.

  • Answered by AI
Round 2 - Coding Test 

(1 Question)

Round duration - 90 Minutes
Round difficulty - Medium

1 hr after the second round got over and results were announced in the morning.

  • Q1. 

    Ways To Make Coin Change

    Given an infinite supply of coins of varying denominations, determine the total number of ways to make change for a specified value using these coins. If it's not possible to make...

  • Ans. 

    The task is to find the total number of ways to make change for a specified value using given denominations.

    • Create a dynamic programming table to store the number of ways to make change for each value up to the target value.

    • Iterate through each denomination and update the table accordingly based on the current denomination.

    • The final answer will be the value in the table at the target value.

    • Consider edge cases such as w...

  • Answered by AI
Round 3 - Face to Face 

(2 Questions)

Round duration - 90 Minutes
Round difficulty - Medium

10 A.M in the morning.
The interviewers were very knowledgeable and humble

  • Q1. 

    Unique Element In Sorted Array

    Nobita wants to impress Shizuka by correctly guessing her lucky number. Shizuka provides a sorted list where every number appears twice, except for her lucky number, which a...

  • Ans. 

    Find the unique element in a sorted array where all other elements appear twice.

    • Iterate through the array and XOR all elements to find the unique element.

    • Use a hash set to keep track of elements and find the unique one.

    • Sort the array and check adjacent elements to find the unique one.

  • Answered by AI
  • Q2. 

    Find Nodes at Distance K in a Binary Tree

    Your task is to find all nodes that are exactly a distance K from a given node in an arbitrary binary tree. The distance is defined as the number of edges between ...

  • Ans. 

    Find all nodes at distance K from a given node in a binary tree.

    • Perform a depth-first search starting from the target node to find nodes at distance K.

    • Use a recursive function to traverse the tree and keep track of the distance from the target node.

    • Maintain a set to store visited nodes and avoid revisiting them.

    • Return the list of nodes found at distance K from the target node.

    • Example: For the given input tree, target n...

  • Answered by AI
Round 4 - Face to Face 

(2 Questions)

Round duration - 90 Minutes
Round difficulty - Medium

It was after the first technical interview round.
Got a mail for the second interview round .
Timings approx 12 AM

  • Q1. 

    Remove BST Keys Outside Given Range

    Given a Binary Search Tree (BST) and a specified range [min, max], your task is to remove all keys from the BST that fall outside this range. The BST should remain vali...

  • Ans. 

    Remove keys outside given range from a Binary Search Tree while keeping it valid.

    • Traverse the BST in inorder and remove nodes outside the specified range

    • Recursively check left and right subtrees for nodes to remove

    • Update pointers to maintain the validity of the BST

    • Return the inorder traversal of the adjusted BST

  • Answered by AI
  • Q2. 

    Inorder Successor in a Binary Tree

    Given an arbitrary binary tree and a specific node within that tree, determine the inorder successor of this node.

    Explanation:

    The inorder successor of a node in a bi...

  • Ans. 

    Given a binary tree and a specific node, find its inorder successor in the tree.

    • Perform an inorder traversal of the binary tree to find the successor node.

    • If the given node has a right child, the successor is the leftmost node in the right subtree.

    • If the given node does not have a right child, backtrack to find the ancestor whose left child is the given node.

  • Answered by AI
Round 5 - HR 

Round duration - 30 Minutes
Round difficulty - Easy

Got a call from Hr after clearance of the first 2 rounds.
Timing were 5:30 P.M

Interview Preparation Tips

Eligibility criteria7+ CGPAJosh Technology Group interview preparation:Topics to prepare for the interview - DBMS, OS, OOPS, Data Structure, Array, String, Bit manipulation, BInary Search, Sorting, Number Theory Linked List, Trees, Graph, DPTime required to prepare for the interview - 5 MonthsInterview preparation tips for other job seekers

Tip 1 : Focus the most on Data Structure topics and practice atleast 300 medium level ques (min 2 approaches for each qs)
Tip 2 : Have a strong grip on Core Subjects i.e OS, DBMS, OOPS, CN, System Design(for big mnc's)
Tip 3 : Learn any good development framework and make min 2 good projects with that and try to do any 1 or 2 min intern to put it in your resume.

Application resume tips for other job seekers

Tip 1 : Keep it short and to the point
Tip 2 : Have good knowledge of every single thing you mentioned there.

Final outcome of the interviewSelected

Skills evaluated in this interview

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

Basic aptitude questions, statics, probability etc

Round 2 - HR 

(2 Questions)

  • Q1. Where do you live in the USA
  • Ans. 

    I live in New York City, the bustling metropolis known for its iconic landmarks and diverse culture.

    • I reside in the heart of Manhattan, surrounded by towering skyscrapers.

    • New York City is home to famous attractions like Times Square, Central Park, and the Statue of Liberty.

    • The city offers a vibrant arts and entertainment scene, with Broadway shows and world-class museums.

    • I enjoy exploring the diverse neighborhoods and ...

  • Answered by AI
  • Q2. Where do you see yourself in 5 years
  • Ans. 

    In 5 years, I see myself as a senior data analyst leading a team, utilizing advanced analytics to drive strategic decision-making.

    • Leading a team of data analysts

    • Utilizing advanced analytics techniques

    • Driving strategic decision-making

    • Continuously learning and staying updated with the latest trends in data analysis

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Basic aptitude and math skills are the key to success in the field of psychology and psychology in the field and in the field in
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
-
Result
Not Selected

I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Difference between Primary Key and Unique Key ?
  • Ans. 

    Primary key uniquely identifies each record in a table, while Unique key allows only unique values but can have null values.

    • Primary key enforces uniqueness and not null constraint on a column

    • Primary key can consist of multiple columns

    • Unique key allows only unique values but can have null values

    • Unique key can be applied to multiple columns as well

  • Answered by AI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
Not Selected

I applied via Referral and was interviewed before Nov 2023. There was 1 interview round.

Round 1 - Aptitude Test 

Logical and aptitude test, game round

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on projects and logical questions
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

Common logical and reasoning questions and also has a pseudocode

Round 3 - Gamified and Essay writing 

(1 Question)

  • Q1. Gamified round with time limits and essay writing for the given picture
Round 4 - Technical 

(1 Question)

  • Q1. Asked about whatever you put in the resume and mainly focus on aptitude
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Aug 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

First round is gaming round with 13 levels
And the aptitude with science, technical and non technical questions

Round 2 - HR 

(4 Questions)

  • Q1. General questions were asked Tell me about yourself And then technical he round with puzzles and aptitude to solve
  • Q2. Long term and short term goals
  • Q3. Strength and weakness
  • Q4. Puzzles and aptitude questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare yourself with general aptitude and puzzles
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Well designed to test the aptitude competence of the candidate.

Round 2 - One-on-one 

(2 Questions)

  • Q1. Explanations for the answers given to the aptitude questions.
  • Q2. Questions from python.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare based on the JD.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Introduction and CV based

Tell us how to improve this page.

Interview Questions from Similar Companies

Affine Interview Questions
3.3
 • 49 Interviews
Cyfuture Interview Questions
3.0
 • 45 Interviews
Imark InfoTech Interview Questions
4.1
 • 41 Interviews
View all

Shiash Info Solutions TAE Reviews and Ratings

based on 3 reviews

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

5.0

Salary

5.0

Job security

5.0

Company culture

5.0

Promotions

5.0

Work satisfaction

Explore 3 Reviews and Ratings
Intern
17 salaries
unlock blur

₹1 L/yr - ₹5 L/yr

Talent Acquisition Executive
16 salaries
unlock blur

₹1 L/yr - ₹2.5 L/yr

Data Science Intern
11 salaries
unlock blur

₹1 L/yr - ₹5 L/yr

HR Recruiter
10 salaries
unlock blur

₹1 L/yr - ₹2.5 L/yr

Junior Software Developer
7 salaries
unlock blur

₹3 L/yr - ₹4 L/yr

Explore more salaries
Compare Shiash Info Solutions with

Maxgen Technologies

4.5
Compare

Cyfuture

3.0
Compare

Value Point Systems

3.7
Compare

JoulestoWatts Business Solutions

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