Srichid Technologies Software Engineer Trainee Interview Questions and Answers

Q1. What is ETL, and can you explain it in a structured manner?
Ans. 
ETL stands for Extract, Transform, Load. It is a process used to extract data from various sources, transform it into a consistent format, and load it into a target database or data warehouse.
• Extract: Involves extracting data from different sources such as databases, files, APIs, etc.

• Transform: Data is cleaned, validated, and transformed into a consistent format suitable for analysis.

• Load: The transformed data is loade...read more
Answered by AI
Add your answer
Q2. What is the correct structure of a DBMS diagram?
Ans. 
The correct structure of a DBMS diagram includes entities, attributes, relationships, and keys.
• Entities represent the main objects in the database (e.g. Customer, Product).

• Attributes are characteristics of entities (e.g. CustomerID, ProductName).

• Relationships show how entities are related to each other (e.g. one-to-many, many-to-many).

• Keys uniquely identify each record in a table (e.g. Primary Key, Foreign Key).
Answered by AI
Add your answer

Q1. Strengths,weakness,why do we hire you, what are your hobbies
Add your answer

In the coding test, there were 2 problems based on arrays and hashing (easy to medium level leetcode)

Q1. Several OOP questions were asked.... like, Can we have a class inside an interface? Can we have a static constructor? Can we have multiple main methods?
Add your answer
Q2. DBMS question: Normalization questions and keys concepts.
Add your answer

Q1. DSA question (stack based) You have a stack full of numbers, you have to arrange them in ascending order in the same stack without using any other data structure.
Add your answer
Q2. OS and DBMS questions(sharding, semaphores, etc.)
Add your answer

Q1. Questions based on Consultadd principles.
Add your answer

Q1. Pivot columns in sql
Ans. 
Pivoting columns in SQL involves transforming rows into columns to display data in a different format.
• Use the PIVOT keyword in SQL to pivot columns

• Specify the columns to pivot on and the values to display in the new columns

• Aggregate functions like SUM, AVG, COUNT can be used with PIVOT

• Example: SELECT * FROM table_name PIVOT (SUM(value_column) FOR pivot_column IN ('value1', 'value2', 'value3'))
Answered by AI
Add your answer
Q2. Slow changing dimensions
Add your answer
Q3. Dynamic rankx top 3
Add your answer
Q4. Field parameters
Add your answer
Q5. Stored procedures
Add your answer

Q1. How does consumer, producer work in kafka
Ans. 
Consumers read data from topics, while producers write data to topics in Kafka.
• Consumers subscribe to topics to read messages from them

• Producers publish messages to topics for consumers to read

• Consumers can be part of a consumer group to scale out consumption

• Producers can specify key for messages to control partitioning
Answered by AI
Add your answer

Q1. Role check
Add your answer
Q2. Tech stackP
Add your answer

Q1. Project based questions
Add your answer
Q2. AWS related questions
Add your answer

Q1. Question based on your experience. Mine was mostly design questions on AWS and how to use try and catch
Add your answer
Q2. Javascript using async/await with try catch block
Ans. 
Using async/await with try catch block in Javascript
• Use async keyword before the function declaration to make it asynchronous

• Use await keyword before the function call to wait for the promise to resolve

• Wrap the async/await code in a try catch block to handle errors
Answered by AI
Add your answer

Q1. Technical with design questions on web technology
Add your answer

Intermediate DSA questions on strings

It's bit about the case study related to continuos data and need to find the n highest number at any given time .