Genesis Data Engineer Interview Questions and Answers

Q1. Basic Technical Questions related to the domain, technology you have applied.
Add your answer

Q1. Scenario based & end to end process oriented questions related to the domain, technology you have applied, you can also expect some managerial questions as well.
Add your answer

Round duration - 60 minutes
Round difficulty - Medium

This was a technical Interview round with questions on C#, .NET and DBMS.

Q1. What is the difference between the Ref and Out keywords in C#?
Ans. 
Ref is used for passing arguments by reference, Out is used for returning multiple values.
• Ref keyword is used for passing arguments by reference, allowing the method to modify the original value.

• Out keyword is used for returning multiple values from a method, as it does not require the variable to be initialized before being passed.
Answered by AI
Add your answer
Q2. What is the difference between ViewData, ViewBag, and TempData in C#?
Ans. 
ViewData, ViewBag, and TempData are ways to pass data between controllers and views in ASP.NET MVC.
• ViewData is a dictionary object used to pass data from controller to view. It requires typecasting.

• ViewBag is a dynamic property used to pass data from controller to view. No typecasting is required.

• TempData is a dictionary object used to pass data from one controller to another or from one action to another.
Answered by AI
Add your answer
Q3. What is the difference between managed and unmanaged code in C#?
Ans. 
Managed code is executed by the CLR with memory management, while unmanaged code is executed directly by the operating system without memory management.
• Managed code is executed by the Common Language Runtime (CLR) in .NET framework.

• Unmanaged code is executed directly by the operating system without CLR.

• Managed code provides automatic memory management through garbage collection.

• Unmanaged code requires manual memory man...read more
Answered by AI
Add your answer
Q4. What are the different types of triggers in SQL Server?
Ans. 
Triggers in SQL Server are special types of stored procedures that are automatically executed when certain events occur in a database.
• Types of triggers include DML triggers (for INSERT, UPDATE, DELETE operations), DDL triggers (for CREATE, ALTER, DROP operations), and Logon triggers.

• Triggers can be set to fire before or after the triggering event.

• Examples of triggers include auditing changes to a table using an INSERT ...read more
Answered by AI
Add your answer
Q5. What are generic and non-generic collections in C#?
Ans. 
Generic collections in C# allow for type-safe collections, while non-generic collections do not enforce type safety.
• Generic collections use type parameters to specify the type of elements they can contain, ensuring type safety.

• Non-generic collections do not specify the type of elements they can contain, leading to potential runtime errors if incorrect types are used.

• Example of generic collection: List<string> nam...read more
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Easy

This was a typical managerial round.

Asked basic sorting and searching algorithms

Q1. Asked questions about sql and Java
Add your answer

Power bi assignment was given to solve

Q1. Optimization techniques in sql
Ans. 
Optimization techniques in SQL involve using indexes, query optimization, and proper database design.
• Use indexes on columns frequently used in WHERE clauses to speed up query performance

• Avoid using SELECT * and instead specify only the columns needed in the query

• Optimize queries by using appropriate join types and conditions

• Normalize database tables to reduce redundancy and improve query efficiency
Answered by AI
Add your answer
Q2. Sub queries in sql
Ans. 
Sub queries in SQL are queries nested within another query to retrieve data based on the result of the outer query.
• Sub queries can be used in SELECT, INSERT, UPDATE, and DELETE statements.

• They can be used to filter results, retrieve data from multiple tables, or perform calculations.

• Example: SELECT * FROM table1 WHERE column1 = (SELECT column2 FROM table2 WHERE condition);
Answered by AI
Add your answer
Q3. Types of Join in sql
Ans. 
Types of joins in SQL include inner join, left join, right join, and full outer join.
• Inner join: Returns rows when there is a match in both tables

• Left join: Returns all rows from the left table and the matched rows from the right table

• Right join: Returns all rows from the right table and the matched rows from the left table

• Full outer join: Returns all rows when there is a match in either table
Answered by AI
Add your answer
Q4. Time intelligence functions in power bi
Ans. 
Time intelligence functions in Power BI are used to analyze and compare data based on time periods.
• Time intelligence functions help in calculating year-to-date, month-to-date, and other time-based calculations.

• Functions like TOTALYTD, SAMEPERIODLASTYEAR, and PARALLELPERIOD are commonly used for time intelligence in Power BI.

• These functions allow for easy comparison of data across different time periods and help in tren
Answered by AI
Add your answer
Q5. Logical questions in aptitude
Add your answer
Q6. Row level security in power bi
Ans. 
Row level security in Power BI allows users to restrict access to specific rows of data based on their role or criteria.
• Row level security can be implemented by creating roles in Power BI and defining rules to filter data based on user roles.

• Users can be assigned to specific roles which determine the data they have access to.

• Row level security helps in ensuring data privacy and compliance with regulations.

• For example, ...read more
Answered by AI
Add your answer

Q1. Adf triggers and integration run time
Add your answer
Q2. How to copy data in add pipeline
Ans. 
To copy data in add pipeline, use a copy activity in Azure Data Factory.
• Use Azure Data Factory to create a copy activity in a pipeline.

• Specify the source dataset and sink dataset for the copy activity.

• Map the source and sink columns to ensure data is copied correctly.

• Run the pipeline to copy the data from source to sink.
Answered by AI
Add your answer