Mastek Interview Questions, Process, and Tips

Work from home vs Work from office

Q1. Have you heared about Payment slip ? tell me more on it.
Ans. 
A payment slip is a document provided by a creditor to a debtor, detailing the amount owed and payment instructions.
• Payment slips are commonly used in billing and invoicing processes.

• They typically include information such as the recipient's name, amount due, due date, and payment methods.

• Payment slips can be physical documents or electronic forms sent via email or online platforms.

• They serve as a record of the transac...read more
Answered by AI
Add your answer
Q2. What do you know about oracle ?
Ans. 
Oracle is a multinational computer technology corporation that specializes in developing and marketing database software and technology.
• Oracle offers a wide range of products and services including database management systems, cloud applications, and consulting services.

• Oracle's flagship product is the Oracle Database, a relational database management system.

• Oracle also provides enterprise software solutions for custom...read more
Answered by AI
Add your answer
Q3. Tell me about your current job ?
Add your answer

Q1. Basic interview questions related to jd
Add your answer
Q2. SQL queries related questions
Add your answer

Q1. Silly technical questions, very basic related to JD.
Add your answer

Q1. Salary expectation
Add your answer

Q1. What are dbt seeds?
Ans. 
dbt seeds are static data that can be used to populate tables in a dbt project.
• dbt seeds are used to provide initial data for tables in a dbt project

• They are typically used for reference data that doesn't change frequently

• Seeds are defined in YAML files and can be loaded into tables using dbt run command
Answered by AI
Add your answer
Q2. How do you test the connection of your dbt project
Ans. 
To test the connection of a dbt project, you can use the dbt CLI command 'dbt debug'.
• Use the dbt CLI command 'dbt debug' to test the connection of your dbt project.

• Check the connection settings in your dbt profiles.yml file.

• Ensure that the database credentials are correct and the database server is accessible.

• Verify that the dbt project is properly configured and the models can be built successfully.
Answered by AI
Add your answer
Q3. What are snapshots?
Ans. 
Snapshots are point-in-time copies of a database or data set, capturing the state of the data at a specific moment.
• Snapshots are read-only copies of the data at a specific point in time.

• They are useful for data recovery, auditing, and creating backups.

• Snapshots can be taken at regular intervals to track changes over time.

• Examples include AWS RDS snapshots, database snapshots in SQL Server, and ZFS snapshots in file sys
Answered by AI
Add your answer
Q4. What are dbt triggers?
Ans. 
dbt triggers are a way to automatically run dbt models based on specified conditions.
• dbt triggers allow you to schedule the execution of dbt models at specific times or intervals

• Triggers can be set up to run based on events like data loading or updates

• They can also be used to trigger the execution of dbt models in response to external events
Answered by AI
Add your answer

Aptitude test with aptitude based questions

Q1. What is variable hoisting.
Ans. 
Variable hoisting is a behavior in JavaScript where variable declarations are moved to the top of their scope during compilation.
• Variable declarations are hoisted to the top of their function or global scope.

• Only the declarations are hoisted, not the initializations.

• This can lead to unexpected behavior if variables are accessed before they are declared.
Answered by AI
Add your answer
Q2. What is closures in js
Ans. 
Closures in JavaScript allow functions to access variables from an outer function even after the outer function has finished executing.
• Closures are created whenever a function is defined within another function.

• Inner functions have access to the outer function's variables even after the outer function has returned.

• Closures are commonly used to create private variables and functions in JavaScript.

• Example: function outer...read more
Answered by AI
Add your answer

Was given online and the topic was cryptocurrency

Q1. SQL JAVA and basic HR QUESTIONS
Add your answer

Q1. Can we call a private class feom another class?
Add your answer

Very basic questions, if you want to score better marks than the rest - practice some easy level syllogism based questions

Trending and generic on spot topics were given. For Eg. Border issues

Q1. Whatever you put in your resume, they ask questions only from that
Add your answer
Q2. Very basic questions were asked, make sure you know every single thing about your project
Add your answer

Q1. For some , they conducted 2 technical rounds and for some they were directly asked to attend the HR round
Add your answer
Q2. It depends purely on what you put in your resume
Add your answer

Q1. They started the interview process at 8:00 AM in the morning and it was already 10.30 PM so they skipped the HR round and announced the results
Add your answer