Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Mastek Team. If you also belong to the team, you can get access from here

Mastek Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Mastek Data Engineer Interview Questions and Answers

Updated 23 Jun 2024

Mastek Data Engineer Interview Experiences

1 interview found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 23 Jun 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Approached by Company and was interviewed in May 2024. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. How to create DBT project
  • Ans. 

    To create a DBT project, you need to set up a project directory, create models, define sources, and run tests.

    • Set up a project directory with a dbt_project.yml file

    • Create models in the models directory using SQL files

    • Define sources in the sources.yml file

    • Run tests using dbt test command

  • Answered by AI
  • Q2. Explain materializations in dbt
  • Ans. 

    Materializations in dbt are pre-computed tables that store the results of dbt models for faster query performance.

    • Materializations are created using the 'materialized' parameter in dbt models.

    • Common types of materializations include 'view', 'table', and 'incremental'.

    • Materializations help improve query performance by reducing the need to recompute data on every query.

    • Materializations can be refreshed manually or automa

  • Answered by AI
  • Q3. What are dbt snapshots?
  • Ans. 

    dbt snapshots are a way to capture the state of your data model at a specific point in time.

    • dbt snapshots are used to create point-in-time snapshots of your data model

    • They allow you to track changes in your data over time

    • Snapshots can be used for auditing, debugging, or creating historical reports

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice a lot of complex SQL questions

Data Engineer Jobs at Mastek

View all

Interview questions from similar companies

I appeared for an interview in Sep 2017.

Interview Questionnaire 

4 Questions

  • Q1. Technical interview take by client technical person actually they are hiring for another client so they took total 3 technical round and final will HR round
  • Q2. Asking about life cycle of Dot net mvc contols entity frame work and SQL queries
  • Q3. Problem based on oops and SQL queries outputs
  • Q4. Basic questions about my self ,salary discussion basic formalities form I have to fill up

Interview Preparation Tips

Round: Test
Experience: There were around 15 objective question that includes mvc, c#.net and SQL server. It was very simple question like different types of filters,Acton results in mvc. Basic oops concept and dot net web page regarding

Round: Resume Shortlist
Experience: After completing test round another was technical round discussed maily for mvc and SQL server questions. Around 30 mint discussion. After qualify this round another round will start from client technical staff.

General Tips: It was for 2-3 year experience person very simple to crack but focus on you which profile you are looking for study interview questions from net
Skills: Dot net mve oops concept jQuery and SQL server

I appeared for an interview in Sep 2017.

Interview Questionnaire 

3 Questions

  • Q1. What is deadlock
  • Ans. 

    Deadlock is a situation where two or more processes are unable to proceed because each is waiting for the other to release a resource.

    • Deadlock occurs when two or more processes are stuck in a circular wait, where each process is waiting for a resource held by another process.

    • Four necessary conditions for deadlock are mutual exclusion, hold and wait, no preemption, and circular wait.

    • Example: Process A holds resource X a...

  • Answered by AI
  • Q2. Which technology you know and worked
  • Ans. 

    I have experience with various technologies including Java, Python, HTML/CSS, JavaScript, and SQL.

    • Java

    • Python

    • HTML/CSS

    • JavaScript

    • SQL

  • Answered by AI
  • Q3. Why you are looking for change and what is your notice period
  • Ans. 

    I am looking for a change to explore new opportunities and challenges. My notice period is 30 days.

    • Seeking new opportunities and challenges

    • Want to learn and grow in a different environment

    • Exploring better career prospects

    • Seeking a company with a better work-life balance

    • Notice period is 30 days

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: 25 objective ques from Java and 25 from English
Tips: should prepare with Java Technology
Duration: 1 hour
Total Questions: 50

Round: Technical Interview
Experience: describe clearly
Tips: should prepared

Round: Technical Interview
Experience: do you know about jsf
Tips: yes, I worked

Round: Technical + HR Interview
Experience: this is my dream company actually, and notice is 15 to 20 days.
Tips: be confident

Skills evaluated in this interview

I applied via Campus Placement and was interviewed before Nov 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Joins in SQL
  • Ans. 

    Joins are used in SQL to combine data from two or more tables based on a related column.

    • Types of joins include inner join, left join, right join, and full outer join.

    • Inner join returns only the matching rows from both tables.

    • Left join returns all rows from the left table and matching rows from the right table.

    • Right join returns all rows from the right table and matching rows from the left table.

    • Full outer join returns ...

  • Answered by AI
  • Q2. Web applications, mobile applications, Hybrid applications

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush up the basics of Java and Mysql

Skills evaluated in this interview

I applied via Recruitment Consultant and was interviewed in Oct 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions on SDLC & STLC , system testing, regression testing, diff between functional and non functional testing, Smoke testing, Adhoc testing. Some simple SQL questions .

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and try to answer each amd every question correctly.

I applied via Campus Placement and was interviewed before Jan 2021. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Concat two linked lists in alternative way
  • Ans. 

    Concatenate two linked lists alternatively

    • Create a new linked list

    • Traverse both linked lists simultaneously

    • Alternate between adding nodes from each list to the new list

    • If one list is longer than the other, add the remaining nodes to the end of the new list

  • Answered by AI
  • Q2. Java and oops

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare for Java and a certain of algo n ds

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Apr 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

Basic aptitude questions with problem solving, logical and reasoning questions

Round 3 - Coding Test 

Explanation about oops concept with coding, loops and conditional statements.

Interview Preparation Tips

Interview preparation tips for other job seekers - Oops concepts arw very important with coding examples

I applied via Referral and was interviewed before Jul 2021. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Explain datawindow in powerbuilder
  • Ans. 

    DataWindow is a GUI control in PowerBuilder used to display and manipulate data from a database.

    • DataWindow can be used to retrieve data from a database, display it in a tabular format, and allow users to edit the data.

    • It supports various data sources such as SQL, ODBC, and XML.

    • DataWindow can also be used to create reports and graphs.

    • It provides various features such as sorting, filtering, grouping, and computed columns...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - say basics concepts about the datawindow in powerbuilder. As datawindow is the base of powerbuilder candidate should prepare well

Skills evaluated in this interview

I appeared for an interview in Oct 2020.

Interview Questionnaire 

1 Question

  • Q1. OOP features and my understanding about them, Java, Spring and Hibernate. Analysis of problem solving skills

Interview Preparation Tips

Interview preparation tips for other job seekers - Dear Candidate,
as much as you are required to know the concepts, it is as important to know how why and where these concepts are built for.
You are required to know the process ideology involved in designing applications and the data structures, alogrithms and design patterns.

please go through what you know as if you are enthusiastic in working on your technology rather than just finding the job.

follow the excellence and success will follow you.

Thanks

I applied via Campus Placement and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. OOPs concept

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be yourself.

Mastek Interview FAQs

How many rounds are there in Mastek Data Engineer interview?
Mastek interview process usually has 1 rounds. The most common rounds in the Mastek interview process are Technical.
How to prepare for Mastek Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Mastek. The most common topics and skills that interviewers at Mastek expect are Python, AWS, SQL, Apache Nifi and Azure.
What are the top questions asked in Mastek Data Engineer interview?

Some of the top questions asked at the Mastek Data Engineer interview -

  1. What are dbt snapsho...read more
  2. How to create DBT proj...read more
  3. Explain materializations in ...read more

Tell us how to improve this page.

Mastek Data Engineer Interview Process

based on 1 interview

Interview experience

3
  
Average
View more
Mastek Data Engineer Salary
based on 4 salaries
₹5.6 L/yr - ₹17.1 L/yr
14% more than the average Data Engineer Salary in India
View more details
Data Engineer

Pune,

Chennai

+1

6-11 Yrs

₹ 18-32.5 LPA

Explore more jobs
Senior Software Engineer
551 salaries
unlock blur

₹6.3 L/yr - ₹24 L/yr

Software Engineer
400 salaries
unlock blur

₹3 L/yr - ₹7.5 L/yr

Associate Consultant
292 salaries
unlock blur

₹2 L/yr - ₹9 L/yr

Software Specialist
265 salaries
unlock blur

₹7.9 L/yr - ₹30 L/yr

Consultant 1
192 salaries
unlock blur

₹3.4 L/yr - ₹9.6 L/yr

Explore more salaries
Compare Mastek with

ITC Infotech

3.6
Compare

3i Infotech

3.4
Compare

Sify Technologies

3.8
Compare

Microland

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview