Upload Button Icon Add office photos

Filter interviews by

Insigma Senior Data Architect Interview Questions, Process, and Tips for Experienced

Updated 3 Mar 2022

Insigma Senior Data Architect Interview Experiences for Experienced

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
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
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
3
Average
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 - One-on-one 

(3 Questions)

  • Q1. Explain Drupal best practices
  • Ans. 

    Drupal best practices involve following coding standards, using modules wisely, optimizing performance, and maintaining security.

    • Follow Drupal coding standards to ensure consistency and readability of code

    • Use contributed modules from trusted sources and avoid unnecessary custom code

    • Optimize performance by caching content, enabling compression, and minimizing database queries

    • Maintain security by keeping Drupal core and ...

  • Answered by AI
  • Q2. Explain Drupal Cache Mechanism
  • Ans. 

    Drupal Cache Mechanism stores and retrieves data to improve website performance.

    • Drupal has multiple cache bins like page cache, block cache, and dynamic page cache.

    • Cache tags are used to invalidate specific cache items when content is updated.

    • Cache contexts allow different versions of a page to be served based on user roles or languages.

    • Cache max-age sets the time for which a cached item is considered valid before it n

  • Answered by AI
  • Q3. Explain Drupal custom module you developed
  • Ans. 

    Developed a custom Drupal module for creating a custom content type with specific fields and functionality.

    • Created a custom module folder within the Drupal installation

    • Defined the custom content type and its fields in the module's .info file

    • Implemented hook functions to handle data processing and display logic

    • Used Drupal's Form API to create custom forms for data input and editing

    • Integrated with other Drupal modules or

  • Answered by AI
Round 3 - Behavioral 

(2 Questions)

  • Q1. How to tackle non performers in your team
  • Q2. Are you ready to work on weekends?
Round 4 - HR 

(2 Questions)

  • Q1. Are you willing to relocate?
  • Q2. Why should we hire you?

Skills evaluated in this interview

Architect Interview Questions & Answers

Nagarro user image sandeep sharma

posted on 28 Feb 2024

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

I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Dependency Injection
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Mar 2023. There were 4 interview rounds.

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. Automation Framework design Download and upload a file through automation Identfying elements dynamically program to find duplicate elements in a list
Round 3 - Technical 

(1 Question)

  • Q1. Framework related questions Testng related questions Reporting Framework Parallel execution String programs Listeners Latest Selenium upgrade
Round 4 - HR 

(1 Question)

  • Q1. Behavioural questions-easy
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Explain 3 layer api arch. Mule
  • Ans. 

    The 3-layer API architecture in Mule is a design pattern that separates the presentation, business logic, and data access layers.

    • Presentation Layer: Handles the user interface and interaction with the API

    • Business Logic Layer: Implements the core functionality and processes the requests

    • Data Access Layer: Manages the interaction with the underlying data sources

    • Example: In Mule, the presentation layer can be implemented u...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Good tech evaluation
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Feb 2023. There were 2 interview rounds.

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

(3 Questions)

  • Q1. Asked about roles and responsibilities
  • Q2. Designing MakeMyTrip application
  • Ans. 

    Designing MakeMyTrip application

    • Identify user requirements and create a user-friendly interface

    • Integrate APIs for flight, hotel, and cab bookings

    • Implement secure payment gateway and user authentication

    • Ensure scalability and performance optimization

    • Provide personalized recommendations based on user history

  • Answered by AI
  • Q3. Question On AWS services

Interview Preparation Tips

Interview preparation tips for other job seekers - They were looking for enterprise level architect.the discussion didt go well.

Skills evaluated in this interview

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

I applied via Naukri.com and was interviewed before Mar 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. No questions as such
  • Q2. No questions as such, don't remember

Interview Preparation Tips

Topics to prepare for Virtusa Consulting Services Associate Architect interview:
  • Data Warehousing
Interview preparation tips for other job seekers - Just keep trying by upscaling yourself. There is no hard and fast rule for cracking an interview.
You should work hard to learn new things. Most of the cases we don't want to put in efforts to learn and just want to switch jobs.

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

Round 1 - HR 

(2 Questions)

  • Q1. Does the resume match JD skills?
  • Q2. Availability and CTC
Round 2 - Technical 

(4 Questions)

  • Q1. Oops questions (interface, SOLID principles, Singleton and other patterns), calling static methods and classes
  • Q2. Web dev - caching, sliding expiration, coding best practices, Restful services, javascript knowledge, closures, js frameworks
  • Q3. Dot net core, garbage collection, anonymous functions, repository pattern / orm, bridge and router patterns, multithreading, signalling
  • Q4. Security, authentication and authorisation, PKI, oauth Performance and scalability, connection pooling, dh tuning Extensibility, reliability, maintainability Coding best practices for good architecture, mi...
Round 3 - Technical 

(2 Questions)

  • Q1. Similar to round 2 by senior person and less questions. Scenario based Sometimes
  • Q2. Team work, conflict management, client management,
Round 4 - HR 

(1 Question)

  • Q1. Strengths and weaknesses Visas, travel history CTC negotiation Joining dates

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on fundamentals and concepts
Be polite and sincere
Technically strong interviewers

Insigma Interview FAQs

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

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

  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
Did you find this page helpful?
Yes No
write
Share an Interview