i
TCS
Filter interviews by
Clear (1)
I applied via campus placement at Cochin University of Science and Technology (CUST)
1.5hrs 5 questions to be solved
I was interviewed in Sep 2024.
posted on 4 Feb 2025
I applied via Recruitment Consulltant and was interviewed in Sep 2024. There was 1 interview round.
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 ...
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
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...
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...
I was interviewed in Nov 2024.
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
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...
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
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...
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
I applied via LinkedIn and was interviewed in Nov 2024. There was 1 interview round.
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.
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
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
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
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...
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 ...
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
based on 1 interview
Interview experience
System Engineer
1.1L
salaries
| ₹1 L/yr - ₹9 L/yr |
IT Analyst
66.6k
salaries
| ₹5.1 L/yr - ₹16 L/yr |
AST Consultant
51.5k
salaries
| ₹8 L/yr - ₹25.1 L/yr |
Assistant System Engineer
29.8k
salaries
| ₹2.2 L/yr - ₹8.6 L/yr |
Associate Consultant
29.5k
salaries
| ₹9 L/yr - ₹32 L/yr |
Amazon
Wipro
Infosys
Accenture