Upload Button Icon Add office photos

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

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
  • 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
  • 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
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 Anonymously
  • 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

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

Interview questions from similar companies

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Job Portal and was interviewed in Oct 2024. There were 4 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. It was technical questions in relevant area
  • Q2. The questions relevant to my skill set and experience
Round 2 - One-on-one 

(2 Questions)

  • Q1. The questions relevant to my skills and experience
  • Q2. The questions relevant to job requirements
Round 3 - HR 

(2 Questions)

  • Q1. General discussion about the profession and career
  • Q2. Discussed job location and client
Round 4 - Behavioral 

(2 Questions)

  • Q1. Discussed about client and company
  • Q2. Orientation related things discussed.

Interview Preparation Tips

Interview preparation tips for other job seekers - It is not Level-3 company. In reality, It is Level-1 Company
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Create scenario-based questions that challenge you to utilize all of your coding skills.

Round 2 - Technical 

(2 Questions)

  • Q1. Explain the architect of your current project Multi threaded based questions Collection based questions Design pattern based questions Microservice architect based questions AWS cloud based questions
  • Q2. How to handle security in api.
  • Ans. 

    Security in APIs is crucial for protecting sensitive data and preventing unauthorized access.

    • Use authentication methods such as OAuth or API keys to verify the identity of users accessing the API.

    • Implement encryption to secure data transmission between clients and servers.

    • Set up rate limiting to prevent abuse and protect against denial of service attacks.

    • Regularly update and patch the API to address security vulnerabil...

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
2-4 weeks
Result
Selected Selected
Round 1 - HR 

(2 Questions)

  • Q1. About my Skills
  • Q2. Why would you join Virtusa?
Round 2 - Technical 

(4 Questions)

  • Q1. Current Project related questions
  • Q2. Scenario based questions
  • Q3. Approach for a project from scratch
  • Q4. Insurance/Banking related questions
Round 3 - Technical 

(4 Questions)

  • Q1. Architectural related questions
  • Q2. Technology related questions
  • Q3. Differences between current and previous technologies
  • Ans. 

    Current technologies are more advanced, efficient, and user-friendly compared to previous technologies.

    • Current technologies have faster processing speeds and higher storage capacities.

    • Previous technologies often required manual input and were less intuitive for users.

    • Current technologies offer more connectivity options and seamless integration with other devices.

    • Examples: Smartphones vs. flip phones, cloud computing vs

  • Answered by AI
  • Q4. What's the future of current skill you are holding
Round 4 - Technical 

(2 Questions)

  • Q1. Functional related questions
  • Q2. Managerial questions
Round 5 - Technical 

(4 Questions)

  • Q1. Client round, current project
  • Q2. Current project scenario, what's your approach
  • Q3. How would you handle this scenario
  • Q4. Insurance related questions
Round 6 - Technical 

(4 Questions)

  • Q1. Client round, discuss multiple scenarios
  • Q2. Insurance domain related questions
  • Q3. Security related questions
  • Q4. Authentication related questions
Round 7 - One-on-one 

(3 Questions)

  • Q1. Salary discussion
  • Q2. Expected Joining date
  • Q3. What's the Notice period
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Jun 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Describe 5 non functional requirements
  • Ans. 

    Non functional requirements are criteria that specify how a system should behave, rather than what it should do.

    • Performance - system should respond within 2 seconds for all user interactions

    • Scalability - system should be able to handle 1000 concurrent users

    • Reliability - system should have a 99.99% uptime

    • Security - system should encrypt all sensitive data

    • Usability - system should have a user-friendly interface

  • Answered by AI
  • Q2. How will you improve performance of legacy app which has to work with your latest microservice.
  • Ans. 

    Improve legacy app performance by optimizing code, implementing caching, and scaling resources.

    • Optimize code by identifying and removing bottlenecks

    • Implement caching to reduce database calls and improve response time

    • Scale resources by using containers or serverless architecture

    • Use asynchronous processing for long-running tasks

    • Upgrade hardware or infrastructure if necessary

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Explain security in microservices
  • Ans. 

    Security in microservices involves implementing authentication, authorization, encryption, and monitoring to protect data and services.

    • Implement authentication and authorization mechanisms to control access to microservices.

    • Use encryption to secure communication between microservices and external clients.

    • Implement monitoring and logging to detect and respond to security incidents.

    • Consider using API gateways for central...

  • Answered by AI
  • Q2. Describe microservices architecture for a wealth management app
  • Ans. 

    Microservices architecture for a wealth management app involves breaking down the application into smaller, independent services.

    • Each microservice focuses on a specific business function, such as client onboarding, portfolio management, or reporting.

    • Services communicate through APIs, allowing for flexibility and scalability.

    • Each microservice can be developed, deployed, and scaled independently, leading to faster develo...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for GlobalLogic Technical Architect interview:
  • Java
  • Microservices

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I was interviewed in Sep 2024.

Round 1 - Technical 

(1 Question)

  • Q1. Any papers submitted
Round 2 - Technical 

(1 Question)

  • Q1. How to handle message related issues via Kubernetes!
  • Ans. 

    Message related issues in Kubernetes can be handled by troubleshooting network configurations, checking pod logs, and monitoring resource usage.

    • Troubleshoot network configurations to ensure proper communication between pods

    • Check pod logs for any error messages or issues related to message passing

    • Monitor resource usage to identify any bottlenecks or performance issues affecting message delivery

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Get clarity about the JD!

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Sep 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. Snowpipe scenario based question
  • Q2. Streams scenario based question

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well on the data architecture concepts
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(4 Questions)

  • Q1. Azure solution design case studies
  • Q2. Current project walkthrough
  • Q3. PySpark coding questions
  • Q4. DataModelling question

Interview Preparation Tips

Interview preparation tips for other job seekers - Should have thorough understanding about atleast one of your project.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - Technical 

(1 Question)

  • Q1. Basic of K8s concepts
Round 2 - Technical 

(1 Question)

  • Q1. Telecom infrastructure and containers
Round 3 - Technical 

(1 Question)

  • Q1. 5g , Telecom infra and containers
Round 4 - Technical 

(1 Question)

  • Q1. Telecom Infrastructure , data plane , security in k8s
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(3 Questions)

  • Q1. Solution architecture questions, patterns, explain solution architecture of one of the previous projects
  • Q2. Details of solution architecture
  • Ans. 

    Solution architecture involves designing and describing the structure, behavior, and views of a system.

    • Identifying key components and their interactions

    • Defining data flow and communication protocols

    • Ensuring scalability, performance, and security

    • Creating detailed diagrams and documentation

    • Collaborating with stakeholders to align with business goals

  • Answered by AI
  • Q3. Technical architecture

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 from Similar Companies

Cognizant Interview Questions
3.8
 • 5.5k Interviews
Nagarro Interview Questions
4.0
 • 769 Interviews
Publicis Sapient Interview Questions
3.5
 • 605 Interviews
GlobalLogic Interview Questions
3.7
 • 569 Interviews
UST Interview Questions
3.8
 • 502 Interviews
CGI Group Interview Questions
4.0
 • 481 Interviews
Synechron Interview Questions
3.6
 • 354 Interviews
View all
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.8
Compare

NTT Data Information Processing Services

4.0
Compare

Sutherland Global Services

3.7
Compare

Hexaware Technologies

3.6
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