AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Insigma Interview Questions, Process, and Tips
Top Insigma Interview Questions and Answers
- Q1. How to improve the performance of a data pipeline in Azure Data Factory?asked in Senior Data Architect interview
- Q2. What are the steps to improve the performance of a sql query?asked in Senior Data Architect interview
- Q3. How to send emails on completing a job from sql server.asked in Senior Data Architect interview
Insigma Interview Experiences
2 interviews found
Selected
I applied via Naukri.com and was interviewed before Feb 2023. There was 1 interview round.
(1 Question)
- Q1. Work Experinceandroles and responbilities.
Interview Preparation Tips
I applied via Approached by Company and was interviewed before Mar 2021. There were 2 interview rounds.
(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...
- 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...
- 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
(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.
- 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
Interview Preparation Tips
Skills evaluated in this interview
Senior Data Architect Interview Questions asked at other Companies
Top trending discussions
Interview questions from similar companies
Quality Analyst Interview Questions & Answers
Optum Global Solutions
Anonymous
posted on 15 Jul 2020
Selected
I applied via Naukri.com and was interviewed before Jul 2019. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Explain about yourself
- Q2. Explain something
- Ans.
Explaining something involves breaking down a concept or process into simpler terms for better understanding.
Start by providing an overview of the topic
Break down the key components or steps involved
Use examples or analogies to clarify complex ideas
Conclude by summarizing the main points
Interview Preparation Tips
I applied via Recruitment Consultant
Interview Questionnaire
2 Questions
- Q1. Round 1: Fundamentals questions related to Javascript and React. In React questions were focused on react-hooks. lifecycle components and optimization techniques in react. Basic to intermediate questions r...
- Q2. Round 2: The interview panel will ask you to code some basic coding problem depending on your relevant experience and if you're not able to solve it they'll directly say they're done with the interview. In...
Interview Preparation Tips
Specialist SE Interview Questions & Answers
Societe Generale Global Solution Centre
Anonymous
posted on 19 Nov 2020
I applied via Referral and was interviewed in Oct 2020. There were 5 interview rounds.
Interview Questionnaire
3 Questions
- Q1. 1. Why am I looking for a job change?
- Q2. 2. Will I be interested in ups killing myself with new technologies?
- Q3. 3. How would I contribute to the corporate community?
Interview Preparation Tips
1. Understand the Job Description and be aware of the related questions. If the JD contains something that's not been your expertise, go through briefly on those subjects online and tell the interviewer that you never had exposure to this tool/app/technology/domain and would be willing to learn and tell them what you learnt about it.
2. Attention: Never show that you're too smart even if you are !! Humble nature and giving an impression that you are open for feedback creates a positive impression. The corporate world needs more of such people.
3. Throughout the interview process ask questions about their work and culture, show interest in the company you're attending interview for. They would not want to focus on what you did previously but they would definitely want to see if you're a good fit for their company and team.
4. Always have a long term plan with the organisation. Bigger companies look for such candidates. Your words should make them believe that you can stay there for a longer period of time.
5. Stay calm stay focused...it will be all okay !! Mantra for any interview.
Hope the above points help.
Thanks!
I applied via Naukri.com and was interviewed in Jan 2021. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Technical questions from basic and advanced C# for first round.
- Q2. In second round there was a man who wasted 1 hour just talking all unnecessary stuff.
Interview Preparation Tips
I applied via Naukri.com
Interview Questionnaire
1 Question
- Q1. Basic related Spark, Scala programming.
Interview Preparation Tips
Team Leader Quality Interview Questions & Answers
Hexaware Technologies
Anonymous
posted on 18 Aug 2020
Interview Questionnaire
4 Questions
- Q1. What is your weakness?
- Q2. Where do you see your self in upcoming years?
- Q3. How you will improve customer experience?
- Ans.
To improve customer experience, I will focus on personalization, efficient communication, and continuous improvement.
Implement personalized customer interactions based on their preferences and history.
Streamline communication channels to ensure prompt and effective responses.
Regularly gather customer feedback and use it to identify areas for improvement.
Train and empower team members to provide exceptional customer ser...
- Q4. What will the best way to keep team motivated?
I applied via Naukri.com and was interviewed before May 2017. There were 2 interview rounds.
Interview Questionnaire
1 Question
- Q1. Based on resume and simple technical questions
Interview Preparation Tips
Akshay Pujari
I applied via Recruitment Consultant and was interviewed in Feb 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. 1.If an URL is not reachable then what are all the possible reasons?
- Ans.
Possible reasons for an unreachable URL
Server is down
Incorrect URL
DNS resolution failure
Firewall or security settings
Network connectivity issues
Interview Preparation Tips
I was shocked as all the time and effort that I had invested in attending this interview had got wasted.The actual reason was that UST Global was not competent enough to pay my expected CTC so they shamelessly gave an excuse that the interview feedback was not positive.Such fraudulent practices must be checked.As this is Bangalore and UST Global is not the only company that is there, if my interview had not gone well I would have concentrated on other interviews rather than writing this review.The only intention behind writing this review is to expose what this company has done.Fraud should always be called out,ignoring it only serves as further encouragement. Hence ,I would urge people to exercise due caution while attending this company's interview.
Skills evaluated in this interview
Insigma Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
Interview Questions from Similar Companies
|
Softwaretest Engineer
9
salaries
|  ₹1.5 L/yr - ₹3.5 L/yr |
|
Software Developer
8
salaries
| ₹2 L/yr - ₹4 L/yr |
|
Delivery Manager
7
salaries
| ₹11 L/yr - ₹18.2 L/yr |
|
Business Analyst
6
salaries
| ₹5 L/yr - ₹8.5 L/yr |
|
IT Technical Recruiter
6
salaries
| ₹2 L/yr - ₹6 L/yr |
Cognizant
Sutherland Global Services
Hexaware Technologies
Virtusa Consulting Services
- Home >
- Interviews >
- Insigma Interview Questions
