i
Mastek
Filter interviews by
I applied via Approached by Company and was interviewed in May 2024. There was 1 interview round.
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
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
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
I appeared for an interview in Sep 2017.
posted on 3 Sep 2017
I appeared for an interview in Sep 2017.
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...
I have experience with various technologies including Java, Python, HTML/CSS, JavaScript, and SQL.
Java
Python
HTML/CSS
JavaScript
SQL
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
posted on 14 Nov 2021
I applied via Campus Placement and was interviewed before Nov 2020. There were 4 interview rounds.
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 ...
posted on 14 Sep 2021
I applied via Recruitment Consultant and was interviewed in Oct 2020. There were 3 interview rounds.
posted on 14 Jan 2022
I applied via Campus Placement and was interviewed before Jan 2021. There were 4 interview rounds.
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
posted on 2 Apr 2023
I applied via Referral and was interviewed before Apr 2022. There were 3 interview rounds.
Basic aptitude questions with problem solving, logical and reasoning questions
Explanation about oops concept with coding, loops and conditional statements.
I applied via Referral and was interviewed before Jul 2021. There was 1 interview round.
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...
I appeared for an interview in Oct 2020.
I applied via Campus Placement and was interviewed in May 2021. There was 1 interview round.
based on 1 interview
Interview experience
Senior Software Engineer
551
salaries
| ₹6.3 L/yr - ₹24 L/yr |
Software Engineer
400
salaries
| ₹3 L/yr - ₹7.5 L/yr |
Associate Consultant
292
salaries
| ₹2 L/yr - ₹9 L/yr |
Software Specialist
265
salaries
| ₹7.9 L/yr - ₹30 L/yr |
Consultant 1
192
salaries
| ₹3.4 L/yr - ₹9.6 L/yr |
ITC Infotech
3i Infotech
Sify Technologies
Microland