Search

Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
  • Community
+ Contribute
notification
notification
Login
Upload Button Icon Add office photos
Employer? Claim Account for FREE

Insigma

Compare button icon Compare button icon Compare
3.0

based on 30 Reviews

Filter interviews by

Insigma Senior Data Architect Interview Questions, Process, and Tips

Updated 3 Mar 2022

Insigma Senior Data Architect Interview Experiences

1 interview found

Senior Data Architect Interview Questions & Answers

user image Anonymous

posted on 3 Mar 2022

I applied via Approached by Company and was interviewed before Mar 2021. There were 2 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. Do you have idea about Azure SQL db?
  • Ans. 

    Yes, Azure SQL db is a fully managed relational database service provided by Microsoft Azure.

    • Azure SQL db is a cloud-based database service that allows you to build, scale, and manage applications with ease.

    • It is based on Microsoft SQL Server engine and offers high availability, security, and performance.

    • You can use Azure SQL db to store and retrieve structured, semi-structured, and unstructured data.

    • It supports variou...

    • Answered by AI
    View 1 more answer
  • Q2. What are the steps to improve the performance of a sql query?
  • Ans. 

    Steps to improve SQL query performance

    • Optimize the query by using appropriate indexes

    • Minimize the use of functions and calculations in the query

    • Avoid unnecessary joins and subqueries

    • Retrieve only the required columns instead of selecting all

    • Use query hints or optimizer directives if necessary

    • Analyze and optimize the database schema and table structures

    • Consider partitioning large tables

    • Monitor and tune the database serv...

    • Answered by AI
    View 1 more answer
  • Q3. How to improve the performance of a data pipeline in Azure Data Factory?
  • Ans. 

    To improve the performance of a data pipeline in Azure Data Factory, you can optimize data flow, use parallel processing, and monitor resource utilization.

    • Optimize data flow by reducing unnecessary transformations and filtering

    • Use parallel processing by partitioning data and running multiple activities concurrently

    • Monitor resource utilization to identify bottlenecks and optimize resource allocation

    • Answered by AI
    View 1 more answer
Round 2 - One-on-one 

(2 Questions)

  • Q1. The interviewer showed a query in their qa server which was giving a lot of trouble in the production server. Then he asked about the ways to improve upon this query.
  • Ans. I checked the execution plan of the query and pointed out the lack of loop joins that could improve the query performance.
    • Answered by fastertea
    Add your answer
  • Q2. How to send emails on completing a job from sql server.
  • Ans. 

    To send emails on completing a job from SQL Server, you can use SQL Server Agent and Database Mail.

    • Configure SQL Server Agent to run the job

    • Enable Database Mail and configure an SMTP server

    • Create a SQL Server Agent job that sends an email on completion

    • Use the sp_send_dbmail stored procedure to send the email

    • Include the necessary details in the email, such as job status and execution duration

    • Answered by AI
    View 1 more answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Insigma is a very good company for people eager to work on new technology. Also the technical team is very friendly and supportive.

Skills evaluated in this interview

Top trending discussions

View All
Career Growth
2w (edited)
a technical lead
Help to Understand
I have below 2 offers. which one to join. Need some guidance. 1. Luxoft - 32 fixed lpa. WFH. 1 lac joining bonus. 2. TCS - 31 fixed . over all ctc - 36. no WFH. 2 lac joining bonus (temporarily hybrid 3 days in client location which is near to my place till the time assigned to same project)
Got a question about Insigma?
Ask anonymously on communities.

Interview questions from similar companies

Senior Manager Interview Questions & Answers

Cognizant user image Anonymous

posted on 10 Aug 2022

I applied via Referral and was interviewed before Aug 2021. There were 2 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 - HR 

(3 Questions)

  • Q1. Reason for job change
    • Add your answer
  • Q2. What is your CTC expectation?
    • Add your answer
  • Q3. Brief about your work experience
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Build high class resume and be confident.

Senior Manager Interview Questions & Answers

Cognizant user image Anonymous

posted on 25 Mar 2022

I applied via Referral and was interviewed before Mar 2021. There were 2 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. Share some of the challenges that you faced in your projects. And how did you overcome those.
    • Add your answer
Round 2 - HR 

(4 Questions)

  • Q1. What are your salary expectations?
    • Add your answer
  • Q2. Why should we hire you?
    • Add your answer
  • Q3. Why are you looking for a change?
    • Add your answer
  • Q4. Tell me about yourself.
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Stay honest with you answers, keeping them to the the point and never hesitate to say "do not know" for any question that you have no answer.

Technical Architect Interview Questions & Answers

Hexaware Technologies user image Anonymous

posted on 20 Apr 2021

I applied via Naukri.com and was interviewed in Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Technical Questions
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush-up skills to answer all Technical Questions. Scenario based questions will get. It is clear that , it is not practical that everyone will work on the same scenario but make sure that for that scenario tries and approaches that we can tell the answer by using best practices is required. All the very Best

Technical Architect Interview Questions & Answers

Hexaware Technologies user image Anonymous

posted on 12 Oct 2021

I applied via Recruitment Consultant and was interviewed in Apr 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Interview process
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - It was 2 rounds of technical interview.It will be for 30 mins. Standard questions on scenario based

Technical Architect Interview Questions & Answers

Hexaware Technologies user image Anonymous

posted on 29 Jun 2021

I applied via Recruitment Consultant and was interviewed in Jun 2021. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. . Net core related questions were most.
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Crack the online test. Rest all were easy to go

Associate Architect Interview Questions & Answers

Cognizant user image Anonymous

posted on 5 Jul 2021

I applied via Recruitment Consultant and was interviewed in Jan 2021. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. There were 2 round and both are video in my case. 1st round totally based on basics of documentum and inspitr that, what you want to tell them.
    • Add your answer
  • Q2. Basics and advance level
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - It was a good experience. Try to focus on basic and be confident.

Senior Architect Interview Questions & Answers

Cognizant user image Anonymous

posted on 8 Dec 2022

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

I appeared for an interview before Dec 2021.

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 - Technical 

(2 Questions)

  • Q1. Explain the architecture
  • Ans. 

    The architecture is the overall design and structure of a system or application.

    • It includes the components, their relationships, and how they interact with each other.

    • It determines the system's scalability, performance, and maintainability.

    • It can be divided into different layers such as presentation, business logic, and data access.

    • Examples include client-server architecture, microservices architecture, and event-drive

    • Answered by AI
    Add your answer
  • Q2. Why those technologies chosen
    • Add your answer
Round 3 - Case Study 

Scenario based questions with handson issues faced

Round 4 - HR 

(1 Question)

  • Q1. Why changing company
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep learning daily with the latest technology and trends

Senior Manager Interview Questions & Answers

Cognizant user image Anonymous

posted on 2 Nov 2022

I applied via Recruitment Consulltant and was interviewed before Nov 2021. There were 2 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 - Technical 

(2 Questions)

  • Q1. Describe a campaign executed
  • Ans. 

    Executed a social media campaign to promote a new product launch

    • Developed a creative concept and messaging strategy

    • Identified target audience and selected appropriate social media platforms

    • Created engaging content including videos, graphics, and influencer partnerships

    • Monitored and analyzed campaign performance using analytics tools

    • Adjusted strategy based on data insights to optimize results

    • Answered by AI
    Add your answer
  • Q2. Key challenge faced with a project and how you salt with it
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepares STP in advance - Situation - Task - Proposal

Technical Architect Interview Questions & Answers

Hexaware Technologies user image Arindam Ghosh

posted on 5 Dec 2023

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

I applied via Naukri.com and was interviewed in Jun 2023. 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 - Coding Test 

To crack Hexaware interview you need to have good technical knowledge and code writing ability is must.

Round 3 - One-on-one 

(1 Question)

  • Q1. Coding test and there was senario based questions , design pattern and architectural questions are also there.
    • Add your answer
Round 4 - HR 

(1 Question)

  • Q1. Normal questions
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Managerial approval, that's it.
More about working at Insigma

Insigma Interview FAQs

How many rounds are there in Insigma Senior Data Architect interview?
Insigma interview process usually has 2 rounds. The most common rounds in the Insigma interview process are Technical and One-on-one Round.
What are the top questions asked in Insigma Senior Data Architect interview?

Some of the top questions asked at the Insigma Senior Data Architect interview -

  1. How to improve the performance of a data pipeline in Azure Data Facto...read more
  2. What are the steps to improve the performance of a sql que...read more
  3. How to send emails on completing a job from sql serv...read more

Tell us how to improve this page.

Interview Questions for Popular Designations

Interview Questions from Similar Companies

Cognizant Interview Questions
3.7
 • 5.7k Interviews
Nagarro Interview Questions
4.0
 • 763 Interviews
EXL Service Interview Questions
3.7
 • 751 Interviews
Hexaware Technologies Interview Questions
3.5
 • 722 Interviews
Sutherland Global Services Interview Questions
3.6
 • 643 Interviews
Publicis Sapient Interview Questions
3.5
 • 620 Interviews
Optum Global Solutions Interview Questions
4.0
 • 617 Interviews
GlobalLogic Interview Questions
3.6
 • 592 Interviews
Virtusa Consulting Services Interview Questions
3.7
 • 587 Interviews
UST Interview Questions
3.8
 • 517 Interviews
View all
Insigma Salaries in India
Softwaretest Engineer
9 salaries
unlock blur

₹1.5 L/yr - ₹3.5 L/yr

Software Developer
8 salaries
unlock blur

₹2 L/yr - ₹4 L/yr

Delivery Manager
7 salaries
unlock blur

₹11 L/yr - ₹18.2 L/yr

Business Analyst
6 salaries
unlock blur

₹5 L/yr - ₹8.5 L/yr

IT Technical Recruiter
6 salaries
unlock blur

₹2 L/yr - ₹6 L/yr

Explore more salaries
Compare Insigma with

Cognizant

3.7
Compare

Sutherland Global Services

3.6
Compare

Optum Global Solutions

4.0
Compare

Hexaware Technologies

3.5
Compare
Popular Calculators
Are you paid fairly?
Monthly In-hand Salary Calculator
Gratuity Calculator
HRA Calculator
Salary Hike Calculator
Did you find this page helpful?
Yes No
write
Share an Interview