Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by TCS Team. If you also belong to the team, you can get access from here

TCS Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

TCS Ethical Hacking Trainer Interview Questions and Answers

Updated 4 May 2024

TCS Ethical Hacking Trainer Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I applied via campus placement at Cochin University of Science and Technology (CUST)

Round 1 - Coding Test 

1.5hrs 5 questions to be solved

Interview questions from similar companies

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

I was interviewed in Sep 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. Olap oltp difference
  • Q2. How many tables in project

ETL Developer Interview Questions & Answers

Tech Mahindra user image RAMAVATHULA CHANDRA NAIK

posted on 4 Feb 2025

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. They were asking very logical and technical questions on interview time
  • Q2. They were test our skills and time punctuation
Round 2 - HR 

(1 Question)

  • Q1. They were discussed with some technical questions and based on knowledge

Interview Preparation Tips

Interview preparation tips for other job seekers - They were asking technical questions and based on our resume mentioned questions
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
-
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Technical 

(4 Questions)

  • Q1. What is the Difference Between Drop and Truncate Command ?
  • Ans. 

    Drop command deletes the table structure along with data, while truncate command deletes only the data.

    • Drop command removes the table structure and all its data, while truncate command only removes the data but keeps the table structure intact.

    • Drop command is a DDL (Data Definition Language) command, while truncate command is a DML (Data Manipulation Language) command.

    • Drop command is slower than truncate command as it ...

  • Answered by AI
  • Q2. What are the Validations you Perform in your Project ?
  • Ans. 

    In my project, I perform validations such as data completeness, data accuracy, data transformation, and data integrity checks.

    • Data completeness checks to ensure all required fields are populated

    • Data accuracy checks to verify the correctness of data

    • Data transformation checks to validate the transformation rules are applied correctly

    • Data integrity checks to maintain data consistency and reliability

  • Answered by AI
  • Q3. What is Star Schema and Snow flake schema ?
  • Ans. 

    Star Schema is a type of database schema where a central fact table is connected to multiple dimension tables. Snowflake Schema is a normalized form of Star Schema where dimension tables are further normalized into sub-dimension tables.

    • Star Schema has a central fact table connected to multiple dimension tables

    • Snowflake Schema is a normalized form of Star Schema with sub-dimension tables

    • Star Schema is denormalized for b...

  • Answered by AI
  • Q4. What is Fact and Dimension Tables
  • Ans. 

    Fact tables contain quantitative data while dimension tables contain descriptive attributes.

    • Fact tables store measurable, quantitative data such as sales revenue or quantity sold

    • Dimension tables store descriptive attributes related to the data in the fact table, such as product name or customer details

    • Fact tables are typically normalized while dimension tables are denormalized for easier querying

    • Example: In a sales dat...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be Clear on Basics in First Round then go more Deeper in SQL Part for ETL Testers in Round 2

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Nov 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. Append a item in tuple
  • Q2. How to validate response body in api in restapi
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

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

Round 1 - Technical 

(4 Questions)

  • Q1. Explain project architecture?
  • Ans. 

    Project architecture refers to the overall structure of a software project, including components, modules, and their interactions.

    • Project architecture defines how different components of a software project are organized and interact with each other.

    • It includes the high-level design of the system, such as the database structure, data flow, and integration points.

    • Project architecture also involves decisions on technologi...

  • Answered by AI
  • Q2. Explain challenges you faced in etl testing?
  • Ans. 

    Challenges in ETL testing include data quality issues, complex transformations, and handling large volumes of data.

    • Data quality issues such as missing or incorrect data can impact testing results

    • Complex transformations can be difficult to validate and may lead to errors in the ETL process

    • Handling large volumes of data can slow down testing processes and require efficient testing strategies

  • Answered by AI
  • Q3. What are roles and responsibilities?
  • Ans. 

    Roles and responsibilities refer to the tasks and duties assigned to an individual within a specific job or position.

    • Roles define the position or job title of an individual within an organization.

    • Responsibilities outline the specific tasks, duties, and expectations associated with that role.

    • Roles and responsibilities help clarify expectations, define boundaries, and ensure accountability.

    • Examples include testing data e...

  • Answered by AI
  • Q4. How to find duplicate values in python?
  • Ans. 

    Use a dictionary to find duplicate values in an array of strings in Python.

    • Create an empty dictionary to store the count of each string in the array.

    • Iterate through the array and for each string, check if it exists in the dictionary. If it does, increment the count. If not, add it to the dictionary with a count of 1.

    • After iterating through the array, check the dictionary for any strings with a count greater than 1. The

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - ETL Concepts, Datawarehouse concepts and Python also must required

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via LinkedIn and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. What is deferred bug
  • Ans. 

    A deferred bug is a bug that is not fixed immediately but is scheduled to be fixed in a future release.

    • Deferred bugs are usually lower priority bugs that do not impact the core functionality of the system.

    • These bugs are documented and tracked for resolution in a later release.

    • Examples of deferred bugs include cosmetic issues, minor usability problems, or non-critical functionality issues.

  • Answered by AI
  • Q2. Query to get 4th highest row based on a column
  • Ans. 

    Use SQL query with ORDER BY and LIMIT to get 4th highest row based on a column

    • Use ORDER BY clause to sort the column in descending order

    • Use LIMIT 1 OFFSET 3 to get the 4th highest row

    • Example: SELECT * FROM table_name ORDER BY column_name DESC LIMIT 1 OFFSET 3

  • Answered by AI
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Technical 

(2 Questions)

  • Q1. Explainyour job role
  • Ans. 

    ETL Developers are responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into a data warehouse.

    • Designing ETL processes to extract data from multiple sources

    • Transforming data to meet business requirements

    • Loading data into a data warehouse or other target systems

    • Developing and maintaining ETL jobs using tools like Informatica, Talend, or SSIS

  • Answered by AI
  • Q2. Explain implementation of SCD 1 in IICS
  • Ans. 

    SCD Type 1 in IICS involves overwriting existing data with new data without maintaining historical changes.

    • In IICS, use the Mapping Designer to create a mapping that loads data from source to target.

    • Use a Lookup transformation to check if the record already exists in the target table.

    • If the record exists, update the existing record with new data using an Update Strategy transformation.

    • If the record does not exist, inse...

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(3 Questions)

  • Q1. Sql Quires related question.
  • Q2. Data ware house related question
  • Q3. What is entry criteria & exit criteria
  • Ans. 

    Entry criteria and exit criteria are conditions that must be met before and after testing, respectively.

    • Entry criteria are the conditions that must be fulfilled before testing can begin

    • Exit criteria are the conditions that must be fulfilled before testing can be considered complete

    • Entry criteria can include having test data ready, test environment set up, and test cases prepared

    • Exit criteria can include all test cases ...

  • Answered by AI
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Introduce yourself
  • Ans. 

    I am an experienced ETL Developer with a strong background in data integration and transformation.

    • Over 5 years of experience in ETL development

    • Proficient in using tools like Informatica, Talend, and SSIS

    • Strong SQL skills for data querying and manipulation

    • Experience in designing and implementing data warehouses

    • Familiar with data modeling and ETL best practices

  • Answered by AI
  • Q2. What is SCD type2
Contribute & help others!
anonymous
You can choose to be anonymous

TCS Interview FAQs

How many rounds are there in TCS Ethical Hacking Trainer interview?
TCS interview process usually has 1 rounds. The most common rounds in the TCS interview process are Coding Test.

Recently Viewed

INTERVIEWS

Invenics

No Interviews

INTERVIEWS

Performics.Convonix

No Interviews

INTERVIEWS

Amazon

No Interviews

INTERVIEWS

Progressive Infrastructure

No Interviews

INTERVIEWS

JSW Cement

No Interviews

INTERVIEWS

Carwale

No Interviews

INTERVIEWS

Techcanopy Software Labs

No Interviews

INTERVIEWS

Bharti Airtel

No Interviews

INTERVIEWS

SOTI

No Interviews

INTERVIEWS

Cadence - Cosmic Circuits

No Interviews

Tell us how to improve this page.

TCS Ethical Hacking Trainer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

HCLTech

Workplace transformation starts with you

Interview Questions from Similar Companies

Accenture Interview Questions
3.8
 • 8.1k Interviews
Infosys Interview Questions
3.6
 • 7.5k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Cognizant Interview Questions
3.8
 • 5.6k Interviews
Capgemini Interview Questions
3.7
 • 4.7k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
Genpact Interview Questions
3.8
 • 3.1k Interviews
LTIMindtree Interview Questions
3.8
 • 2.9k Interviews
IBM Interview Questions
4.0
 • 2.3k Interviews
View all
System Engineer
1.1L salaries
unlock blur

₹1 L/yr - ₹9 L/yr

IT Analyst
66.6k salaries
unlock blur

₹5.1 L/yr - ₹16 L/yr

AST Consultant
51.5k salaries
unlock blur

₹8 L/yr - ₹25.1 L/yr

Assistant System Engineer
29.8k salaries
unlock blur

₹2.2 L/yr - ₹8.6 L/yr

Associate Consultant
29.5k salaries
unlock blur

₹9 L/yr - ₹32 L/yr

Explore more salaries
Compare TCS with

Amazon

4.1
Compare

Wipro

3.7
Compare

Infosys

3.6
Compare

Accenture

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent