AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Motifworks
Compare
Filter interviews by
Motifworks Data Engineer Interview Questions and Answers
Motifworks Data Engineer Interview Experiences
1 interview found
Anonymous
I applied via campus placement at Centre for Development of Advanced Computing (CDAC) and was interviewed in Aug 2023. There were 5 interview rounds.
Coding Test based on Machine Learning and SQL Queries
(3 Questions)
- Q1. Technical Questions on SQL, Azure
- Q2. What is Normalization in SQL
- Ans.
Normalization in SQL is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down a table into smaller tables and defining relationships between them.
It helps in reducing data redundancy by storing data in a structured and organized manner.
Normalization ensures data integrity by preventing anomalies such as insertion, update, and deletion anomalies...
- Q3. Can we insert a record in View
- Ans.
No, you cannot insert a record in a view.
Views are virtual tables generated from a query, so they do not store data directly.
Any attempt to insert a record into a view will result in an error.
To insert a record, you need to insert it into the underlying base table of the view.
(1 Question)
- Q1. SQL Queries and Data Warehouse
(1 Question)
- Q1. SQL Queies and Managerial Questions
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
1st round was Aptitude, which is average difficultly level.
2nd round was Group Discussions, here they only check our communication.
(5 Questions)
- Q1. Techincal Round, here the technical questions about our bachgroud were asked. They will ask questions based on our resume.
- Q2. What is Artificial Intelligence?
- Ans.
Artificial Intelligence is the simulation of human intelligence processes by machines, especially computer systems.
AI involves machines performing tasks that typically require human intelligence, such as visual perception, speech recognition, decision-making, and language translation.
Machine learning is a subset of AI that enables machines to learn from data and improve their performance over time.
Examples of AI applic...
- Q3. What is Power BI?
- Ans.
Power BI is a business analytics tool by Microsoft that provides interactive visualizations and business intelligence capabilities.
Power BI is a data visualization tool used to create interactive reports and dashboards.
It allows users to connect to various data sources, clean and transform data, and create visually appealing reports.
Power BI offers a wide range of visualization options such as charts, graphs, maps, and...
- Q4. How to load Data in Power BI?
- Ans.
Data can be loaded in Power BI by connecting to various data sources like Excel, SQL databases, online services, etc.
Connect to data sources by clicking on 'Get Data' in Power BI
Select the desired data source (e.g. Excel, SQL Server, SharePoint, etc.)
Choose the specific data tables or queries to import into Power BI
Transform and clean the data using Power Query Editor if needed
Load the data into Power BI model for visu
- Q5. Explain about your final year project?
- Ans.
Developed a predictive analytics model for predicting customer churn in a telecom company.
Used machine learning algorithms like logistic regression and random forest for analysis.
Performed data preprocessing, feature engineering, and model evaluation.
Achieved an accuracy of 85% in predicting customer churn.
Presented findings and recommendations to the telecom company's management team.
Skills evaluated in this interview
Gaurav Pirthani
(3 Questions)
- Q1. Python - find max from array without using built in function
- Ans.
Find max from array in Python without using built-in function.
Iterate through the array and compare each element with a variable storing the current maximum value.
If the element is greater than the current maximum, update the variable.
Return the variable after iterating through the entire array.
- Q2. Spark cluster configuration
- Q3. Python split data interview question
Interview Preparation Tips
Skills evaluated in this interview
I applied via Campus Placement and was interviewed in Jul 2024. There were 3 interview rounds.
Full c concept MCQ with IQ and Computaional Thinking
(2 Questions)
- Q1. Number system convertion in c
- Ans.
Number system conversion in C involves converting numbers between different bases, such as decimal to binary or hexadecimal.
Use functions like itoa() to convert integers to strings in different bases
Use strtol() to convert strings to integers in different bases
Remember to specify the base when converting numbers
- Q2. Pointers, struct, Data Structure
(2 Questions)
- Q1. Decimal to Binary Convertion
- Q2. Hexa Decimal to Binary convertion
Skills evaluated in this interview
(1 Question)
- Q1. What is jdk, string related questions, basic java oops questions?
Manav Koli
(1 Question)
- Q1. OOP questions SQL Questions Programming structure
(1 Question)
- Q1. SQL questions MVC and C# related questions
I applied via Campus Placement and was interviewed in Apr 2024. There were 2 interview rounds.
Pen and paper test
C and C++ output questions
Basic flowchart question
Only 3 out of 60 students were selected
(1 Question)
- Q1. After writing about your project CFO will take interview my tech stack didn't meet companies requirement hence all three students were rejected.
I applied via LinkedIn and was interviewed in Aug 2024. There was 1 interview round.
1 hr test on HackerEarth platform, DSA questions
I applied via LinkedIn and was interviewed in Apr 2024. There were 3 interview rounds.
Aptitude test, basic maths and LR
SQL and Visualisation related
(1 Question)
- Q1. Asked for details after qualifying in test
Interview Preparation Tips
I applied via Job Portal
C related coding questions, recursion, arrays, networking
Interview Preparation Tips
Motifworks Interview FAQs
Tell us how to improve this page.
Motifworks Interviews By Designations
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Motifworks Data Engineer Interview Process
based on 1 interview
Interview experience
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
Motifworks Data Engineer Reviews and Ratings
based on 1 review
Rating in categories
|
Software Developer
38
salaries
|  ₹5 L/yr - ₹17 L/yr |
|
Developer Associate
22
salaries
| ₹5 L/yr - ₹10 L/yr |
|
Developer
18
salaries
| ₹5 L/yr - ₹9.1 L/yr |
|
Software Engineer
16
salaries
| ₹2 L/yr - ₹9.5 L/yr |
|
Technical Lead
13
salaries
| ₹14 L/yr - ₹32 L/yr |
Trianz
TO THE NEW
Nitor Infotech, an Ascendion company
Srijan Technologies
- Home >
- Interviews >
- Motifworks Interview Questions >
- Motifworks Data Engineer Interview Questions
