Expand My Business Data Engineer Interview Questions and Answers

Q1. Create pagination component using an api show the data for the pages
Ans. 
Create a pagination component using an API to display data for different pages.
• Use API to fetch data for each page

• Implement pagination logic to display data for each page

• Allow users to navigate between pages
Answered by AI
Add your answer

1 hr coding round required me to solve 2 leetcode medium questions

Q1. Design an online grocery store basically zepto.
Ans. 
Design an online grocery store similar to zepto.
• Implement user-friendly interface for easy navigation

• Include search functionality for quick product discovery

• Offer secure payment options for customer convenience

• Provide delivery options with tracking feature

• Include customer reviews and ratings for products

• Implement inventory management system for real-time updates
Answered by AI
Add your answer

Coding test has multiple choice questions based on basics of programming and 2 coding questions.

Q1. What are the details of Object-Oriented Programming (OOP) concepts?
Ans. 
OOP is a programming paradigm based on the concept of objects, which can contain data and code to manipulate that data.
• OOP focuses on creating objects that interact with each other to solve problems.

• Key concepts include classes, objects, inheritance, polymorphism, and encapsulation.

• Classes are blueprints for creating objects, defining their properties and behaviors.

• Inheritance allows new classes to be based on existing...read more
Answered by AI
Add your answer
Q2. DSA question to solve using any programming language ?
Add your answer
Q3. Some concepts of web development and binary tree related questions
Add your answer

Q1. What do you know about Digit insurance?
Ans. 
Digit Insurance is a technology-driven insurance company offering a range of general insurance products.
• Digit Insurance was founded in 2016 by Kamesh Goyal.

• It is known for its innovative and customer-centric approach to insurance.

• Digit offers various insurance products such as health insurance, motor insurance, travel insurance, and more.

• The company leverages technology to simplify the insurance process and provide a s
Answered by AI
Add your answer
Q2. Where do you see yourself after 5 years ?
Ans. 
In 5 years, I see myself as a senior software engineer leading a team of developers on innovative projects.
• Leading a team of developers on projects

• Continuing to learn and grow in my technical skills

• Contributing to the success and growth of the company

• Possibly pursuing further education or certifications

• Exploring opportunities for mentorship and leadership roles
Answered by AI
Add your answer

SQL and Python data analysis questions

Q1. How do you match the data in different columns.
Ans. 
Matching data in different columns involves comparing the values in the columns and identifying similarities or patterns.
• Use string matching techniques like exact match, partial match, or fuzzy matching.

• Apply data cleaning and preprocessing techniques to standardize the data before matching.

• Utilize advanced algorithms like Levenshtein distance or Jaccard similarity for more complex matching.

• Consider using database join...read more
Answered by AI
Add your answer

Q1. SQL base Question
Add your answer
Q2. About your projects
Add your answer

Q1. Joins, operations questions not data analysis questions
Add your answer
Q2. Customer retention case study
Add your answer
Q3. Cumulative sum for given table
Ans. 
To calculate cumulative sum for a given table
• Sort the table in ascending order based on the column you want to calculate the cumulative sum for

• Add a new column to the table to store the cumulative sum

• Iterate through each row of the table and calculate the cumulative sum by adding the current row's value to the previous row's cumulative sum

• Store the cumulative sum in the new column for each row
Answered by AI
Add your answer
Q4. Do you have experience in operations/data entry role
Ans. 
Yes, I have experience in both operations and data entry roles.
• I have worked as a data entry operator for a pharmaceutical company where I was responsible for entering patient data into the system.

• In my previous role as an operations analyst, I was responsible for analyzing data and creating reports for the management team.

• I have experience using various data entry software such as Microsoft Excel and Google Sheets.

• I a...read more
Answered by AI
Add your answer
Q5. As a data analyst can you do data entry work also?
Ans. 
Yes, I can do data entry work as a data analyst.
• Data entry work is a part of data analysis process.

• I have experience in data entry work and can perform it efficiently.

• Data entry work includes entering data into spreadsheets, databases, or other software.

• I understand the importance of accurate data entry for effective analysis.
Answered by AI
Add your answer
Q6. Normal excel statements like if, vlookup, xlookups etc.,
Add your answer

Q1. Screening questions
Add your answer
Q2. Name, age, qualification, prior experience etc
Add your answer

Operation questions like vlookups, Hlookups, xlookups etc,.

Reporting questions like pivot tables, typing speed, power pivots, pricing sheet preparation

SQL queries like joins, aggregation functions, filters etc,.

Q1. Advanced analytics and finding trends and patterns with MH - operations data
Add your answer
Q2. How fast can you prepare a bar chart with product operations data
Ans. 
I can prepare a bar chart with product operations data within a few minutes.
• I have experience using data visualization tools like Tableau, Power BI, or Excel to quickly create bar charts.

• I am proficient in organizing and cleaning data to ensure accurate representation in the chart.

• I can customize the chart with relevant labels, colors, and titles to make it visually appealing and easy to understand.
Answered by AI
Add your answer
Q3. How can I do merge multiple excel files together
Ans. 
You can merge multiple Excel files together using the 'Consolidate' feature in Excel.
• Open Excel and go to the 'Data' tab

• Click on 'Consolidate' in the 'Data Tools' group

• Select the files you want to merge and choose the desired options

• Click 'OK' to merge the files together
Answered by AI
Add your answer