Upload Button Icon Add office photos

TCS iON

Compare button icon Compare button icon Compare

Filter interviews by

TCS iON Senior Modeller Interview Questions and Answers

Updated 16 Aug 2024

TCS iON Senior Modeller Interview Experiences

1 interview found

Senior Modeller Interview Questions & Answers

user image Irene Diana

posted on 16 Aug 2024

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

(4 Questions)

  • Q1. SQL window function
  • Q2. About joins and explain
  • Q3. Performance optimization
  • Q4. Normalisation and denormalization
Round 2 - HR 

(2 Questions)

  • Q1. Why you need job change
  • Ans. 

    Seeking new challenges and growth opportunities in a more senior role.

    • Looking for career advancement

    • Seeking new challenges and projects

    • Interested in expanding skill set and knowledge

    • Want to take on more responsibilities and leadership roles

  • Answered by AI
  • Q2. Why tcs after a long gap
  • Ans. 

    TCS offers a challenging work environment and opportunities for growth after a long gap.

    • TCS is known for its diverse projects and cutting-edge technologies, providing a stimulating work environment.

    • After a long gap, I am eager to re-enter the workforce and TCS offers a platform for me to showcase my skills and expertise.

    • TCS has a strong reputation in the industry and I believe working here will help me enhance my caree

  • Answered by AI

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
-
Process Duration
2-4 weeks
Result
Not Selected

I appeared for an interview in May 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. What is top down approach
  • Ans. 

    Top down approach is a problem solving or design strategy that starts with the larger overview and breaks it down into smaller components.

    • Start with a broad overview of the problem or design

    • Break it down into smaller components or sub-problems

    • Address each component individually before integrating them back together

    • Commonly used in software development, project management, and system design

  • Answered by AI
  • Q2. Star vs snowflake schema
  • Ans. 

    Star schema is a denormalized schema with a single central fact table surrounded by dimension tables. Snowflake schema is a normalized schema with multiple interconnected dimension tables.

    • Star schema is easier to understand and query due to denormalization.

    • Snowflake schema saves storage space by normalizing data.

    • Star schema is better for data warehousing and reporting, while snowflake schema is better for OLAP systems.

    • ...

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. SQL queries were given
  • Q2. Design a data model
  • Ans. 

    Design a data model for a customer relationship management system

    • Identify entities such as customers, products, orders, and sales representatives

    • Establish relationships between entities (e.g. a customer can place multiple orders)

    • Define attributes for each entity (e.g. customer name, product price)

    • Consider normalization to reduce redundancy and improve data integrity

  • Answered by AI

Skills evaluated in this interview

I appeared for an interview in Sep 2017.

Interview Questionnaire 

4 Questions

  • Q1. Technical interview take by client technical person actually they are hiring for another client so they took total 3 technical round and final will HR round
  • Q2. Asking about life cycle of Dot net mvc contols entity frame work and SQL queries
  • Q3. Problem based on oops and SQL queries outputs
  • Q4. Basic questions about my self ,salary discussion basic formalities form I have to fill up

Interview Preparation Tips

Round: Test
Experience: There were around 15 objective question that includes mvc, c#.net and SQL server. It was very simple question like different types of filters,Acton results in mvc. Basic oops concept and dot net web page regarding

Round: Resume Shortlist
Experience: After completing test round another was technical round discussed maily for mvc and SQL server questions. Around 30 mint discussion. After qualify this round another round will start from client technical staff.

General Tips: It was for 2-3 year experience person very simple to crack but focus on you which profile you are looking for study interview questions from net
Skills: Dot net mve oops concept jQuery and SQL server

I appeared for an interview in Sep 2017.

Interview Questionnaire 

3 Questions

  • Q1. What is deadlock
  • Ans. 

    Deadlock is a situation where two or more processes are unable to proceed because each is waiting for the other to release a resource.

    • Deadlock occurs when two or more processes are stuck in a circular wait, where each process is waiting for a resource held by another process.

    • Four necessary conditions for deadlock are mutual exclusion, hold and wait, no preemption, and circular wait.

    • Example: Process A holds resource X a...

  • Answered by AI
  • Q2. Which technology you know and worked
  • Ans. 

    I have experience with various technologies including Java, Python, HTML/CSS, JavaScript, and SQL.

    • Java

    • Python

    • HTML/CSS

    • JavaScript

    • SQL

  • Answered by AI
  • Q3. Why you are looking for change and what is your notice period
  • Ans. 

    I am looking for a change to explore new opportunities and challenges. My notice period is 30 days.

    • Seeking new opportunities and challenges

    • Want to learn and grow in a different environment

    • Exploring better career prospects

    • Seeking a company with a better work-life balance

    • Notice period is 30 days

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: 25 objective ques from Java and 25 from English
Tips: should prepare with Java Technology
Duration: 1 hour
Total Questions: 50

Round: Technical Interview
Experience: describe clearly
Tips: should prepared

Round: Technical Interview
Experience: do you know about jsf
Tips: yes, I worked

Round: Technical + HR Interview
Experience: this is my dream company actually, and notice is 15 to 20 days.
Tips: be confident

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. Runtime pollymorphism

Interview Preparation Tips

Round: Test
Experience: I scored good.
Tips: Core java good knowledge.
Duration: 30 minutes
Total Questions: 25

Round: Technical Interview
Experience: like this many ques from core java and hibernate and sql also and I scored good.
Tips: Command over core java and sql also.

I appeared for an interview before Mar 2021.

Round 1 - Coding Test 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Medium

21 students were shortlisted from the 1st MCQ round and in this round we were asked to write the codes (function only) of 3 questions in 1 hour time.

  • Q1. 

    Rotting Oranges Problem Statement

    You are given a grid containing oranges where each cell of the grid can contain one of the three integer values:

    • 0 - representing an empty cell
    • 1 - representing a fre...
  • Ans. 

    Find the minimum time required to rot all fresh oranges in a grid.

    • Use Breadth First Search (BFS) to simulate the rotting process

    • Track the time taken to rot all oranges and return -1 if any fresh oranges remain

    • Handle edge cases like no fresh oranges or all oranges already rotten

    • Consider using a queue to efficiently process adjacent oranges

  • Answered by AI
  • Q2. 

    Majority Element Problem Statement

    Given an array/list 'ARR' consisting of 'N' integers, your task is to find the majority element in the array. If there is no majority element present, return -1.

    Exampl...

  • Ans. 

    Find the majority element in an array, return -1 if no majority element exists.

    • Iterate through the array and keep track of the count of each element using a hashmap.

    • Check if any element's count is greater than floor(N/2) to determine the majority element.

    • Return the majority element or -1 if no majority element exists.

  • Answered by AI
  • Q3. 

    Maximum Path Sum Between Two Leaves Problem Description

    You are provided with a non-empty binary tree in which each node contains a non-negative integer value. Your task is to find and return the maximum ...

  • Ans. 

    Find the maximum path sum between two leaf nodes in a binary tree.

    • Traverse the tree to find the maximum path sum between two leaf nodes.

    • Keep track of the maximum sum found so far.

    • Consider all possible paths between leaf nodes.

    • Handle cases where the tree has only a single leaf node.

    • Implement a recursive function to calculate the maximum path sum.

  • Answered by AI
Round 2 - Face to Face 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Medium

This was a technical round with DSA based questions.

  • Q1. 

    N-th Node From The End Problem Statement

    You are given a Singly Linked List of integers. The task is to find the N-th node from the end of the list.

    Example:

    Input:
    If the given list is (1 -> -2 -&g...
  • Ans. 

    Find the N-th node from the end of a Singly Linked List of integers.

    • Traverse the list to find the length L of the list.

    • Calculate the position of the N-th node from the beginning as L - N + 1.

    • Traverse the list again to reach the calculated position and return the node's value.

  • Answered by AI
  • Q2. 

    LCA of Binary Tree Problem Statement

    You are given a binary tree consisting of distinct integers and two nodes, X and Y. Your task is to find and return the Lowest Common Ancestor (LCA) of these two nodes...

  • Ans. 

    Find the Lowest Common Ancestor (LCA) of two nodes in a binary tree.

    • Traverse the binary tree to find the paths from the root to nodes X and Y.

    • Compare the paths to find the last common node, which is the LCA.

    • Handle cases where one node is an ancestor of the other or when one node is the LCA itself.

  • Answered by AI
  • Q3. 

    Reverse Words in a String: Problem Statement

    You are given a string of length N. Your task is to reverse the string word by word. The input may contain multiple spaces between words and may have leading o...

  • Ans. 

    Reverse words in a string while handling leading/trailing spaces and multiple spaces between words.

    • Split the input string by spaces to get individual words

    • Reverse the list of words

    • Join the reversed words with a single space in between

    • Handle leading/trailing spaces by stripping them before and after reversing

  • Answered by AI
Round 3 - Face to Face 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Easy

Technical Interview round with questions based on DSA

  • Q1. 

    Minimum Time To Solve The Problems

    Given 'N' subjects, each containing a certain number of problems, and 'K' friends, assign subjects to friends such that each subject goes to exactly one friend, maintain...

  • Ans. 

    Assign subjects to friends to minimize maximum workload, find minimum time for most loaded friend.

    • Sort subjects in descending order

    • Assign subjects to friends one by one until all subjects are assigned

    • The maximum workload will be the sum of problems assigned to the friend with the most problems

    • Return the maximum workload as the minimum time required

  • Answered by AI
  • Q2. What is grammar in the context of compiler design?
  • Ans. 

    Grammar in compiler design defines the syntax and structure of a programming language.

    • Grammar specifies the rules for forming valid statements in a programming language.

    • It consists of a set of production rules that define how valid programs can be constructed.

    • There are different types of grammars such as context-free grammar, regular grammar, etc.

    • Example: In C programming language, the grammar specifies that a for loop...

  • Answered by AI
  • Q3. What is a token in compiler design?
  • Ans. 

    A token in compiler design is a basic unit of syntax that the compiler can understand and process.

    • Tokens are the smallest units of a program that are meaningful to the compiler.

    • Examples of tokens include keywords, identifiers, operators, and punctuation symbols.

    • Tokens are generated by the lexical analysis phase of the compiler.

    • Tokens are used by the parser to build the abstract syntax tree of the program.

  • Answered by AI
Round 4 - Video Call 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Easy

Technical round with questions on DSA and Compiler Design mainly. He told me that you’ll be having your final HR round in some time. I knew that I was going well because he seemed to be quite satisfied with my answers.

  • Q1. 

    Sum Root to Leaf Numbers

    You are given an arbitrary binary tree consisting of N nodes, each associated with an integer value from 1 to 9. Each root-to-leaf path can be considered a number formed by concat...

  • Ans. 

    Find the total sum of all root to leaf paths in a binary tree formed by concatenating node values.

    • Traverse the binary tree from root to leaf nodes, keeping track of the current path sum

    • Add the current path sum to the total sum when reaching a leaf node

    • Use modulo (10^9 + 7) to handle large outputs

  • Answered by AI
  • Q2. What is a regular language?
  • Ans. 

    A regular language is a language that can be recognized by a finite automaton.

    • Regular languages can be described by regular expressions.

    • Regular languages are closed under union, concatenation, and Kleene star operations.

    • Examples of regular languages include the set of all strings over an alphabet that contain an even number of 'a's.

  • Answered by AI
  • Q3. What are NP and NP-Hard problems?
  • Ans. 

    NP problems are decision problems that can be verified in polynomial time, while NP-Hard problems are at least as hard as the hardest problems in NP.

    • NP problems can be verified in polynomial time but not necessarily solved in polynomial time.

    • NP-Hard problems are at least as hard as the hardest problems in NP, but may not be in NP themselves.

    • Examples of NP problems include the subset sum problem and the traveling salesm...

  • Answered by AI
Round 5 - HR 

Round duration - 30 minutes
Round difficulty - Easy

That was the round for which I’ve been waiting for hours 
She was very friendly and nice to talk to. It didn’t seem that I was talking to the HR. It was more like talking to a friend. Finally we discussed about the pay-scale and work culture in Accolite.

Interview Preparation Tips

Eligibility criteriaAbove 7 CGPAAccolite Digital Pvt Ltd interview preparation:Topics to prepare for the interview - Data Structures, Algorithms, System Design, Aptitude, OOPSTime required to prepare for the interview - 6 monthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewSelected

Skills evaluated in this interview

Interview Questionnaire 

2 Questions

  • Q1. Basics from all framework you have worked on.
  • Q2. There working all are non technical people's they don't know the projects here major people working in testing and non related work

I applied via Naukri.com and was interviewed before Nov 2019. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Servlet life cycle, bubble sort, quick sort, binary search, how can a software ensure GDPR rules being followed, SQL queries (second highest salary)

Interview Preparation Tips

Interview preparation tips for other job seekers - you will need to give a psychometric test, some beginner sometimes mediocre level programming test and final technical interview which may last till an hour. Do read about 1 or 2 Newgen products before going for the interview. They will definitely ask. Just be confident.Offer letter generally comes within 2 weeks. All the best !!

I applied via Walk-in and was interviewed before Jul 2021. There were 3 interview rounds.

Round 1 - Coding Test 

Data structures and algorithms

Round 2 - Coding Test 

Python etl,pandas, pyspark questions

Round 3 - HR 

(1 Question)

  • Q1. Salary negotiation , work culture

Interview Preparation Tips

Interview preparation tips for other job seekers - Be strong with the basics and practice common programming problems

I applied via Naukri.com and was interviewed before Mar 2020. There were 4 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Difference between Hashtable and hashmap?
  • Ans. 

    Hashtable is synchronized while hashmap is not.

    • Hashtable is thread-safe while hashmap is not.

    • Hashtable does not allow null keys or values while hashmap allows one null key and multiple null values.

    • Hashtable is slower than hashmap due to synchronization.

    • Hashtable is a legacy class while hashmap is a newer implementation.

  • Answered by AI
  • Q2. Difference between hashmap and concurrent hashmap?
  • Ans. 

    Hashmap is not thread-safe while Concurrent Hashmap is thread-safe.

    • Hashmap is not suitable for multi-threaded environments as it can lead to race conditions and data inconsistencies.

    • Concurrent Hashmap allows multiple threads to access and modify the map concurrently without any data inconsistencies.

    • Concurrent Hashmap uses a technique called lock striping to achieve thread-safety.

    • Concurrent Hashmap is slower than Hashma...

  • Answered by AI
  • Q3. Jdbc step
  • Q4. Spring ioc

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was average they asked questions from core java spring hibernate... And so on..

Skills evaluated in this interview

TCS iON Interview FAQs

How many rounds are there in TCS iON Senior Modeller interview?
TCS iON interview process usually has 2 rounds. The most common rounds in the TCS iON interview process are Technical and HR.
What are the top questions asked in TCS iON Senior Modeller interview?

Some of the top questions asked at the TCS iON Senior Modeller interview -

  1. Why tcs after a long ...read more
  2. Normalisation and denormalizat...read more
  3. Performance optimizat...read more

Tell us how to improve this page.

TCS iON Senior Modeller Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

ITC Infotech Interview Questions
3.6
 • 336 Interviews
CitiusTech Interview Questions
3.4
 • 270 Interviews
NeoSOFT Interview Questions
3.7
 • 263 Interviews
Tiger Analytics Interview Questions
3.7
 • 222 Interviews
Episource Interview Questions
3.9
 • 220 Interviews
Altimetrik Interview Questions
3.8
 • 217 Interviews
Incedo Interview Questions
3.1
 • 181 Interviews
View all
Operations Executive
271 salaries
unlock blur

₹1.2 L/yr - ₹4.5 L/yr

Software Developer
151 salaries
unlock blur

₹2.8 L/yr - ₹12 L/yr

Software Engineer
119 salaries
unlock blur

₹2.1 L/yr - ₹9 L/yr

System Engineer
103 salaries
unlock blur

₹2.2 L/yr - ₹9.2 L/yr

IT Manager
61 salaries
unlock blur

₹1 L/yr - ₹4.2 L/yr

Explore more salaries
Compare TCS iON with

Wipro

3.7
Compare

Amazon

4.1
Compare

TCS

3.7
Compare

ITC Infotech

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