TEKsystems Senior Data Engineer Interview Questions and Answers

Q1. Create spark dataframe
Ans. 
To create a Spark DataFrame, use the createDataFrame() method.
• Import the necessary libraries

• Create a list of tuples or a dictionary containing the data

• Create a schema for the DataFrame

• Use the createDataFrame() method to create the DataFrame
Answered by AI
Add your answer

Coding test conducted in virtual session - you need share the entire screen (google meet). Interviewer share about 12 questions, in 10 are theory based questions and 2 coding questions.
while writing theory try to answer with real time example from your project.
1. Solid principles 2 design patterns used 3 diff between .net core vs .net 4. garbage collection 5. global exception handling in core 5. performance / monitoring related questions

coding questions: 1. Nth max value without sorting. 2. sum of max sub array in a integer array

Q1. Skills, project explanation, unit testing, code review
Add your answer
Q2. Usage of dependency injection in core along with types
Ans. 
Dependency injection in core with types is a common practice in software engineering.
• Dependency injection is a design pattern where components are given their dependencies rather than creating them internally.

• Using dependency injection in core allows for easier testing and maintenance of the codebase.

• Types in dependency injection help ensure that the correct dependencies are injected into components.

• Examples include us...read more
Answered by AI
Add your answer
Q3. Usage of Middleware along with custom middleware
Ans. 
Middleware is used to handle requests and responses in web applications. Custom middleware can be created to add specific functionality.
• Middleware is software that acts as a bridge between an operating system or database and applications, allowing them to communicate with each other.

• Middleware can be used to handle tasks such as authentication, logging, error handling, and more.

• Custom middleware can be created to add s...read more
Answered by AI
Add your answer
Q4. Authentication and authorization in web api core
Ans. 
Authentication and authorization are essential for securing web APIs in ASP.NET Core.
• Use authentication to verify the identity of the user accessing the API.

• Use authorization to determine what actions the authenticated user is allowed to perform.

• In ASP.NET Core, authentication can be implemented using various schemes like JWT, OAuth, or Identity.

• Authorization can be achieved through policies, roles, or claims.

• Always va...read more
Answered by AI
Add your answer

Q1. What are joins and its type
Add your answer
Q2. Tell me about Dax query
Add your answer

Occurrence of the elements in descending order.

Q1. Design question on projects
Add your answer

Q1. Offer discussion
Add your answer

Q1. Linux , puzzle, simple programs l
Add your answer

Q1. About me and about my previous work
Add your answer

Q1. Basic questions on opps, c#, asp. Net and angular, sql
Add your answer

Q1. Deep discussion on oops, angular, c# and sql. Like writing some queries and oops concepts syntax writing on notepad
Add your answer

Q1. Basic discussion on my projects and they explain their projects and methodology they follows. Their day to day tasks
Add your answer

Basics of Statics and also verbal

Data structures and algorithms trees

Q1. Tell me about yourself
Add your answer
Q2. Previous experience questions
Add your answer

Q1. General java, android and basic kotlin questions
Add your answer

Q1. Same and details about projects you did
Add your answer

Q1. Salary discussion
Add your answer