INCREFF Data Engineer Interview Questions and Answers

Q1. Advance Excel (Vlookup, Index, Countifs, sumifs and others)
Add your answer
Q2. Python Basics (data frame, data types, lamda, series etc)
Add your answer
Q3. SQL Functions (joins, limits, partitions, orders by and group by)
Add your answer
Q4. 3rd round was managerial round, where mostly non-technicial questions asked.
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. What is the job culture of zopsmart
Ans. 
The job culture at Zopsmart is collaborative, innovative, and fast-paced.
• Collaborative work environment where team members support and help each other

• Emphasis on innovation and creativity in problem-solving

• Fast-paced atmosphere with opportunities for growth and learning

• Open communication and feedback encouraged

• Diverse and inclusive workplace culture
Answered by AI
Add your answer

Medium level leetcode problem

Implement login with Google SSO, show emails in a single place

Q1. How to implement JWT
Ans. 
JWT can be implemented by generating a token with user information and a secret key, then verifying the token using the same secret key.
• Generate a JWT token with user information and a secret key

• Include necessary claims like expiration time, issuer, etc.

• Verify the JWT token using the same secret key

• Handle token expiration and refresh if needed
Answered by AI
Add your answer
Q2. Please read about it on the internet, do take care of public and private key use
Add your answer
Q3. Middleware in express, how to create one?
Ans. 
Middleware in Express is a function that has access to the request and response objects.
• Create a middleware function using app.use() method in Express.

• Middleware functions have access to the request object (req), the response object (res), and the next middleware function in the application's request-response cycle.

• Example: app.use((req, res, next) => { console.log('This is a middleware function'); next(); });
Answered by AI
Add your answer
Q4. Read about it on the internet
Add your answer

Q1. Discussed about guards in Angular
Add your answer
Q2. Read about it on the internet
Add your answer
Q3. How does lazy loading work in Angular
Ans. 
Lazy loading in Angular delays loading of modules until they are needed
• Lazy loading helps improve performance by only loading modules when they are required

• It is achieved by using the loadChildren property in the route configuration

• Lazy loaded modules are loaded asynchronously when the user navigates to the corresponding route
Answered by AI
Add your answer
Q4. Read about lazy loading in Angular
Add your answer
Q5. How to enable SSR in Angular
Ans. 
Server-side rendering (SSR) in Angular can be enabled by using Angular Universal.
• Install Angular Universal using Angular CLI

• Create a new Angular Universal project

• Update app.module.ts to include server-side rendering

• Build and run the Angular Universal project
Answered by AI
Add your answer
Q6. Read about Angular Universal for this
Add your answer

Implement phone directory search system

A general apti round

Data analysis assignment

Q1. Sql questions askes
Add your answer

Q1. Product sense round
Add your answer

Q1. Culture fit round
Add your answer

Questions can be found on Leetcode

Q1. Dsa question regarding linked list and hashmap
Add your answer

It was on hacker rank

It was a aptitude test taken by me of the new and all the response and the of new