Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
+ Contribute
notification
notification
Login
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
3.6

based on 754 Reviews

Filter interviews by

Mastek Associate Technical Consultant Interview Questions and Answers

Updated 4 Dec 2019

Mastek Associate Technical Consultant Interview Experiences

1 interview found

Associate Technical Consultant Interview Questions & Answers

user image Anonymous

posted on 4 Dec 2019

I applied via Naukri.com and was interviewed in Nov 2019. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. Sub queries and it's type, Set operators, Join and it's type, string functions, view and it's type. It's all about SQL..
    • Add your answer
  • Q2. Diff. Between Function and procedure, trigger, cursor and it's type, use of cursor in PL/SQL.
  • Ans. 

    Explanation of Function, Procedure, Trigger, Cursor and its types, and the use of Cursor in PL/SQL.

    • Function is a subprogram that returns a value while a Procedure is a subprogram that does not return a value.

    • Trigger is a special type of stored procedure that is automatically executed in response to certain events.

    • Cursor is a database object that allows you to manipulate data row by row.

    • There are two types of Cursor: Im...

    • Answered by AI
    Add your answer
  • Q3. Which is Faster subquery or Join? Or subquery or function? Why views are use in db?
  • Ans. 

    Join is faster than subquery. Views are used for data abstraction and security.

    • Join is faster than subquery as it involves less I/O operations

    • Subquery can be slower as it executes multiple times

    • Functions can be slower than subquery or join depending on the complexity

    • Views are used for data abstraction and security purposes

    • Views can simplify complex queries and provide controlled access to data

    • Answered by AI
    Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Questions are depends on job profile so it's better to prepare your skill in any particular subject or speciality. Don't be stressed out in interview. Answer only those questions which you know or partially know and don't try to make illogical answers if you don't know.

Skills evaluated in this interview

Top trending discussions

View All
Engineering - Software & QA
6d (edited)
unsurpassedalbert
Verified Icon
·
works at
TCS
Trying to switch after 8 years
I have been working in IT INDUSTRY for 8 years in the same Company I always thought about stability and a secure job that's the reason. I never tried to switch but now due to family expenses I need to change companies in any conditions. Please can anybody suggest the companies with the same stability and security of jobs in the IT sector Worked in the following domains till now Hitech domain Banking(BFSI) domain Telecom - Verizon
Got a question about Mastek?
Ask anonymously on communities.

Interview questions from similar companies

Associate Technical Consultant Interview Questions & Answers

Microland user image Anonymous

posted on 31 Jan 2024

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

I applied via Recruitment Consulltant and was interviewed before Jan 2023. There were 3 interview rounds.

Round 1 - HR 

(3 Questions)

  • Q1. Open For rotational Shift
    • Add your answer
  • Q2. Available for Virtual Interview.
    • Add your answer
  • Q3. AWS services, GIT, Ansible, Chef
    • Add your answer
Round 2 - Technical 

(2 Questions)

  • Q1. Project work experience
    • Add your answer
  • Q2. CICD setup Process
    • Add your answer
Round 3 - HR 

(1 Question)

  • Q1. Package Discussion
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Depending on the project work-life balance will be.
Rotational shifts will affect work-life balance.

Technical Lead Interview Questions & Answers

Sonata Software user image Harish Karer

posted on 23 Oct 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is microservice
  • Ans. 

    Microservices are a software development technique where an application is composed of small, independent services that communicate over well-defined APIs.

    • Microservices are small, independent services that work together to form an application

    • Each microservice is responsible for a specific function or feature

    • Microservices communicate with each other over well-defined APIs

    • Microservices can be developed, deployed, and sca...

    • Answered by AI
    Add your answer
  • Q2. Explain repository design pattern
  • Ans. 

    Repository design pattern is a structural design pattern that separates the data access logic from the business logic in an application.

    • It provides a way to access data from a data source without exposing the underlying data access code to the business logic.

    • It helps in achieving separation of concerns by keeping data access code in a separate layer.

    • Commonly used in applications where data needs to be accessed from mul

    • Answered by AI
    Add your answer

Skills evaluated in this interview

Technical Lead Interview Questions & Answers

Ugam Solution user image Pavan Kumar Patil

posted on 28 Nov 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Case Study 

Design a Distributed Cache

Technical Architect Interview Questions & Answers

Happiest Minds Technologies user image Anonymous

posted on 13 May 2024

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

I applied via Naukri.com and was interviewed in Apr 2024. There were 4 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Design Patterns, asynchronous programming
    • Add your answer
Round 2 - Technical 

(1 Question)

  • Q1. Oop basics, coding standards and architectural design
    • Add your answer
Round 3 - Technical 

(1 Question)

  • Q1. System design and cloud architecture
    • Add your answer
Round 4 - HR 

(1 Question)

  • Q1. Cultural fit, communication and interpersonal skills
    • Add your answer

Technical Project Manager Interview Questions & Answers

Newgen Software Technologies user image Anonymous

posted on 13 Aug 2023

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
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 - Coding Test 

Basic college practical programs

Round 3 - Technical 

(6 Questions)

  • Q1. Core Java in detail is must
    • Add your answer
  • Q2. JSP, database, sql, is must
    • Add your answer
  • Q3. Architecture understanding should be good
    • Add your answer
  • Q4. Able to work standalone
    • Add your answer
  • Q5. Weblogic, jboss, qebservicea
    • Add your answer
  • Q6. Good personal and logical skill
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Able to take responsibility of ongoing task

Technical Lead Interview Questions & Answers

Kellton user image Anonymous

posted on 20 Oct 2023

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

I was interviewed in Sep 2023.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Interview process was good.
    • Add your answer
Round 3 - Technical 

(1 Question)

  • Q1. This is more about previous projects and the interview is good.
    • Add your answer
Round 4 - HR 

(1 Question)

  • Q1. This is a general hr round.And the process was good.
    • Add your answer

Technical Lead Interview Questions & Answers

Comviva Technology user image k.s pandeya

posted on 30 Sep 2023

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

I was interviewed in Aug 2023.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Java, spring boot, Microservices
    • Add your answer
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion
    • Add your answer

Technical Lead Interview Questions & Answers

Prodapt user image Suma Poojari

posted on 26 Feb 2023

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

I was interviewed in Jan 2023.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. All questions related to real-time scenarios
    • Add your answer
Round 3 - Technical 

(2 Questions)

  • Q1. Realtime scenarios related to testing
    • Add your answer
  • Q2. Realtime scenarios testing
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - After preparing for interview technically, make sure you go through your resume and be capable of justifying what you have written in the resume coz the opposite person don't know you. Only thing he knows is your resume.

Senior Technical Consultant Interview Questions & Answers

Maveric Systems user image Anonymous

posted on 6 Mar 2023

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via Approached by Company and was interviewed in Sep 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Do not use an unprofessional email address such as cool_boy@email.com. It shows a lack of professionalism by the candidate.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. 1. How to do T24 installation 2. Jboss Installation 3. T24 Update Installation
  • Ans. 

    T24 and JBoss installation and T24 update installation process.

    • T24 installation requires setting up the database, application server, and T24 environment variables.

    • JBoss installation involves downloading and installing the JBoss application server, configuring the server, and deploying T24 on it.

    • T24 update installation involves applying the update package to the existing T24 installation.

    • Ensure that all prerequisites a...

    • Answered by AI
    Add your answer
Round 3 - Technical 

(1 Question)

  • Q1. 1. Azure Cloud Questions 2. Jboss Setup 3. Managerial Questions
    • Add your answer
Round 4 - Behavioral 

(1 Question)

  • Q1. 1. Asked some questions from resume
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Medium difficult level. Be confident and give answer properly.
More about working at Mastek

Mastek Interview FAQs

What are the top questions asked in Mastek Associate Technical Consultant interview?

Some of the top questions asked at the Mastek Associate Technical Consultant interview -

  1. which is Faster subquery or Join? Or subquery or function? Why views are use in...read more
  2. Diff. Between Function and procedure, trigger, cursor and it's type, use of cur...read more
  3. Sub queries and it's type, Set operators, Join and it's type, string functions,...read more

Tell us how to improve this page.

Mastek Interviews By Designations

Interview Questions for Popular Designations

People are getting interviews through

based on 1 Mastek interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.

Associate Technical Consultant Interview Questions from Similar Companies

TCS Associate Technical Consultant Interview Questions
3.7
 • 7 Interviews
HCLTech Associate Technical Consultant Interview Questions
3.5
 • 5 Interviews
Infosys Associate Technical Consultant Interview Questions
3.7
 • 3 Interviews
Wipro Associate Technical Consultant Interview Questions
3.7
 • 3 Interviews
Tech Mahindra Associate Technical Consultant Interview Questions
3.6
 • 2 Interviews
Microland Associate Technical Consultant Interview Questions
3.5
 • 1 Interview
View all

Fast track your campus placements

Parul Institute of Management and Research, Vadodara Placement Questions
4 Interviews
St Francis Institute of Technology, Mumbai Placement Questions
2 Interviews
Don Bosco Institute of Technology, Mumbai Placement Questions
1 Interview
Gandhi Institute of Technology and Management, Visakhapatnam Placement Questions
1 Interview
KJ Somaiya Institute of Engineering and Information Technology Placement Questions
1 Interview
Silicon Institute of Technology, Bhuvaneshwar Placement Questions
1 Interview
Xavier Institute of Engineering, Mumbai Placement Questions
1 Interview
View all
Mastek Associate Technical Consultant Salary
based on 47 salaries
₹2 L/yr - ₹6 L/yr
55% less than the average Associate Technical Consultant Salary in India
View more details

Mastek Associate Technical Consultant Reviews and Ratings

based on 4 reviews

2.3/5

Rating in categories

2.3

Skill development

2.3

Work-Life balance

2.0

Salary & Benefits

2.0

Job Security

2.3

Company culture

1.3

Promotions/Appraisal

2.3

Work Satisfaction

Explore 4 Reviews and Ratings
Mastek Salaries in India
Senior Software Engineer
573 salaries
unlock blur

₹6 L/yr - ₹21.4 L/yr

Software Engineer
397 salaries
unlock blur

₹2.7 L/yr - ₹8.5 L/yr

Software Specialist
290 salaries
unlock blur

₹8.5 L/yr - ₹30 L/yr

Associate Consultant
286 salaries
unlock blur

₹2 L/yr - ₹9 L/yr

Consultant 1
191 salaries
unlock blur

₹3.4 L/yr - ₹9.4 L/yr

Explore more salaries
Compare Mastek with

TCS

3.7
Compare

Infosys

3.7
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview