AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Mastech InfoTrellis
Compare
Filter interviews by
Mastech InfoTrellis Associate Interview Questions and Answers
Mastech InfoTrellis Associate Interview Experiences
1 interview found
I applied via Campus Placement
Work on the general aptitude questions and answers
Work on Java questions
Gave a topic and asked us to discuss on it
(1 Question)
- Q1. Asked about myself and what I am looking forward to
Top trending discussions
Interview questions from similar companies
I applied via Approached by Company
(2 Questions)
- Q1. Sql is the most important , Focus on Joins ,Sub query and Sql basics
- Q2. Joining tables with different joins
- Ans.
Joining tables with different joins in SQL
Use INNER JOIN to return rows when there is at least one match in both tables
Use LEFT JOIN to return all rows from the left table and the matched rows from the right table
Use RIGHT JOIN to return all rows from the right table and the matched rows from the left table
Use FULL JOIN to return rows when there is a match in one of the tables
Skills evaluated in this interview
I applied via Naukri.com and was interviewed before Apr 2021. There were 2 interview rounds.
(2 Questions)
- Q1. Basics of python, project related questions
- Q2. Basic SQL, few simple problem solving questions
(2 Questions)
- Q1. Interests, hobbies ,general HR questions
- Q2. Expected hike, salary, work timings preferred
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Jul 2021. There were 3 interview rounds.
Interview Questionnaire
5 Questions
- Q1. Given an input string "neeraj chopra" Write Python code to get output string as "jareen arpohc".
- Ans.
The Python code to get the output string as 'jareen arpohc' from the input string 'neeraj chopra' is provided.
Split the input string into individual words
Reverse each word
Join the reversed words with a space in between
- Q2. Given a list of 10 numbers. Write a code to list only even numbers out of the original list.
- Ans.
Code to list even numbers from a given list of 10 numbers.
Loop through the list of numbers
Check if each number is even using the modulo operator
If the number is even, add it to a new list of even numbers
Return the new list of even numbers
- Q3. SQL queries using Window Functions Rank() , Dense Rank() etc
- Q4. Reversal of string in python code
- Ans.
Reversing a string in Python code
Use slicing to reverse the string
Use the built-in function 'reversed()'
Convert the string to a list, reverse it, and then join it back to a string
- Q5. SQL queries in general.
Interview Preparation Tips
Basic Python , SQL knowledge is enough to crack the interviews.
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Mar 2021. There were 3 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Drill Down,Drill through
- Q2. Dax functions like date add,date diff,time Intelligence
- Q3. Import direct query
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Mar 2021. There were 3 interview rounds.
Interview Questionnaire
3 Questions
- Q1. SQL window functions
- Q2. Basic SQL queries
- Q3. Basic Power BI
Interview Preparation Tips
Selected
I applied via Walk-in and was interviewed before Aug 2022. There were 4 interview rounds.
Test of SQL, Tableau and other skills based on your resume on Skillate
(1 Question)
- Q1. SQL and other skills technical questions
(1 Question)
- Q1. Manager round / 2nd technical round
Associate Consultant Interview Questions & Answers
Saama Technologies
Anonymous
posted on 4 May 2019
I applied via Referral and was interviewed in Nov 2018. There was 1 interview round.
Interview Questionnaire
4 Questions
- Q1. Core informatica. Lot of scenario based questions.
- Q2. Very basic questions. Simple and easy.
- Q3. Third round was very difficult. Couldn't answer one question properly. But I gave efforts
- Q4. Get Fibonacci series in informatica
- Ans.
Fibonacci series can be generated in Informatica using a recursive function.
Create a mapping with a recursive function
Use a variable port to store the previous two values
Use an expression transformation to generate the series
Example: f(0) = 0, f(1) = 1, f(n) = f(n-1) + f(n-2)
Interview Preparation Tips
Skills: Communication, Body Language, Problem Solving, Analytical Skills, Presentation Skills
Duration: 1-3 Months
Skills evaluated in this interview
I applied via Referral and was interviewed in Oct 2021. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. SQL queries, joins, lead lag functions,
- Q2. Unix scripting, snowflake, cloud technology background, practical experience
Interview Preparation Tips
I appeared for an interview in Aug 2021.
(2 Questions)
Round duration - 60 minutes
Round difficulty - Medium
Online Coding Test on Calyxpod platform. There were 2 coding questions
- Q1.
Intersection of Linked List Problem
You are provided with two singly linked lists containing integers, where both lists converge at some node belonging to a third linked list.
Your task is to determine t...
- Ans.
Find the node where two linked lists merge.
Traverse both lists to find their lengths and the difference in lengths
Move the pointer of the longer list by the difference
Move both pointers simultaneously until they meet at the merging node
- Q2.
Most Frequent Non-Banned Word Problem Statement
Given a paragraph consisting of letters in both lowercase and uppercase, spaces, and punctuation, along with a list of banned words, your task is to find th...
- Ans.
Find the most frequent word in a paragraph that is not in a list of banned words.
Split the paragraph into words and convert them to uppercase for case-insensitivity.
Count the frequency of each word, excluding banned words.
Return the word with the highest frequency in uppercase.
(1 Question)
Round duration - 70 minutes
Round difficulty - Easy
Advance Subjective Round on Calyxpod platform: 5 questions. One question was related to data structures and algorithms. Other 4 were related to Html, CSS and Javascript.
- Q1.
Balanced Parentheses Combinations
Given an integer
Nrepresenting the number of pairs of parentheses, find all the possible combinations of balanced parentheses using the given number of pairs.Explanati...
- Ans.
Generate all possible combinations of balanced parentheses for a given number of pairs.
Use recursion to generate all possible combinations of balanced parentheses.
Keep track of the number of open and close parentheses used in each combination.
Return the valid combinations as an array of strings.
Interview Preparation Tips
Tip 1 : Be good in aptitude and data structures as it is the 1st/2nd round in most companies.
Tip 2 : Be prepared to explain your projects mentioned in the resume
Tip 3 : Do atleast 2 good projects.
Tip 1 : Do not write any false information on your resume.
Tip 2 : Keep your resume restricted to one page only.
Skills evaluated in this interview
Mastech InfoTrellis Interview FAQs
Tell us how to improve this page.
Mastech InfoTrellis Interviews By Designations
Interview Questions for Popular Designations
- Senior Associate Interview Questions
- Associate Software Engineer Interview Questions
- Associate Consultant Interview Questions
- Process Associate Interview Questions
- Associate Engineer Interview Questions
- Business Development Associate Interview Questions
- Research Associate Interview Questions
- Customer Service Associate Interview Questions
- Show more
Mastech InfoTrellis Associate Interview Process
based on 1 interview
Interview experience
Associate Interview Questions from Similar Companies
Mastech InfoTrellis Associate Reviews and Ratings
based on 4 reviews
Rating in categories
|
Associate
32
salaries
|  ₹4.5 L/yr - ₹11.6 L/yr |
|
Big Data Specialist
21
salaries
| ₹8.6 L/yr - ₹18 L/yr |
|
Quality Analyst
19
salaries
| ₹7.1 L/yr - ₹9 L/yr |
|
Mdm Specialist
17
salaries
| ₹6.5 L/yr - ₹16 L/yr |
|
Project Manager
13
salaries
| ₹10 L/yr - ₹16 L/yr |
Medcode
Maxgen Technologies
Cyfuture
Value Point Systems
- Home >
- Interviews >
- Mastech InfoTrellis Interview Questions >
- Mastech InfoTrellis Associate Interview Questions
