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
Pawan Tiwari
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
I applied via Naukri.com and was interviewed in Jan 2020. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. 1st Technical- Cucumber Framework , How to buid job in Jenkins, TestNG and its Annotations, Selenium Action Classes, Robot Class, Core Java
- Ans.
Answering technical questions on Cucumber, Jenkins, TestNG, Selenium, and Core Java.
To build a job in Jenkins, create a new job and configure it to run the test suite using Maven or Gradle.
TestNG annotations like @BeforeTest and @AfterTest can be used to set up and tear down test environments.
Selenium Action Classes like Actions and Select can be used to perform complex user interactions.
The Robot class can be used to ...
- Q2. 2nd Technical: Jenkins, TestNG and its Annotations, Selenium Basics ,Scenarios based question on Selenium, Core Java , Questions on Hashmap , Regular Expressions
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. Where did you work on the specific skill required for the job?
I applied via Naukri.com and was interviewed before Sep 2021. There was 1 interview round.
(1 Question)
- Q1. They asked on java and spring boot related questions then hr round after that got the offer
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Jun 2021. There were 3 interview rounds.
It was conducted in college.
(1 Question)
- Q1. Basic questions on engineering trade
(1 Question)
- Q1. Location preference was asked
Interview Preparation Tips
I appeared for an interview before Aug 2016.
Interview Questionnaire
1 Question
- Q1. Asked about Resume and family background
Interview Preparation Tips
Experience: Asked about the topic and was told to talk something different
Tips: Just be confident. Have trust in God!
Duration: 25 minutes
Round: Test
Experience: Simple questions were asked to test the skills!
Duration: 45 minutes
Total Questions: 25
Software Engineer Interview Questions & Answers
Hexaware Technologies
Aaditya Srivastava
posted on 16 Dec 2015
Interview Preparation Tips
Experience: The result were announced just after the session. The basis of selection was confidence & communication skill as usual.
It was mostly a nice & health discussion.
Tips: Talk short & precise.
Use your hands in explanations.
Dont argue just discuss
Duration: 15 min minutes
Round: Technical Interview
Experience: Questions from c programming, database management, c++, data structure were asked. The HR was trying to confuse and showing confidence was important.
Tips: Answer with confidence
Dont say directly NO to a question
Round: HR Interview
Experience: It was all about confidence and your ability to converse.
HR asked me about myself and why did i want to join the firm etc.
He was mostly looking for a positive attitude.
Tips: Keep a smile.
Converse well & again be confident.
Confidence is the key but overconfidence is bad.
General Tips: Keep your cool
Be confident
Have a positive approach
Skill Tips: Prepare well for Interview
Be confident about wat you know.
Skills: Programming, positive attitude, Confidence
College Name: Gandhi Institute Of Engineering And Technology
Motivation: It is a MNC.
Growth will be good
Future scopes are high
I applied via Referral
Interview Questionnaire
5 Questions
- Q1. You have knowledge of data structure? Tell me about it
- Ans.
Data structures are a way to organize and store data efficiently.
Data structures are used to store and manipulate data in a structured manner.
They provide different ways to access and perform operations on the data.
Examples include arrays, linked lists, stacks, queues, trees, and graphs.
- Q2. Tell me something about your major project
- Ans.
Developed a web-based project management tool for tracking tasks and deadlines
Used React.js for front-end development
Implemented RESTful APIs using Node.js and Express for back-end
Utilized MongoDB for database management
Incorporated user authentication and authorization features
Integrated real-time notifications using Socket.io
- Q3. What is your name ?
- Ans.
My name is John Smith.
Full name is John Smith
Common name in English-speaking countries
Easy to remember and pronounce
- Q4. What does my name mean?
- Ans.
The question is unrelated to the medical field and is not a puzzle or riddle.
The question is asking about the meaning of the interviewer's name.
You can ask the interviewer about the origin or cultural significance of their name.
You can also mention that names often have different meanings in different languages or cultures.
- Q5. What are your strenghts?
- Ans.
My strengths include problem-solving skills, attention to detail, and strong communication abilities.
Strong problem-solving skills - I enjoy tackling complex issues and finding creative solutions.
Attention to detail - I am meticulous in my work and strive for accuracy in all tasks.
Strong communication abilities - I can effectively convey ideas and collaborate with team members.
Interview Preparation Tips
Experience: The written test of hexaware was way more tough than i thought. Basically you will see on other website that hexaware written test is easy but it was not trust me. So talking more about my test there were 4 sections verbal, aptitude, analytical reasoning and technical also. I am a electronics and communication student so there were technical question from my field of study only but for IT and Computer Science there were programming questions. And there is 10 mins of essay writting also.
Tips: Be prepare for anything. Dont judge the written exam will be easy or tough anything can happen and prepare your best.
Duration: 60 minutes
Total Questions: 75
Round: Group Discussion
Experience: Well, i think my group discussion topic was easy but the only problem was that every person is fully aware of that topic so thought process has become very simple. But still somehow i manage to clear this round also.
Tips: Be calm and if you dont know about some topic so wait for few minutes and listen what others are saYing . The HR will only be checking your communication skills.
Duration: 10 mins minutes
Round: Technical Interview
Experience: I am an EC student so there were very basic question of c and data structure programming and from my field he only asked about my project work and keep asking question from it. I guess he was checking my patience.
Round: HR Interview
Experience: The HR round was quite good. The question was really very basic from my family and strengths and weakness. But i dont know why he asked me a question of c programming and he asked me to make a program generally i have never heard that in HR interview, the HR asking you a technical question but anything can happen .
Tips: Keep yourself calm . Keep wide knowledge of your field.
Skills: Basic C/C++, Communication, Ability To Deliver On A Project, Ability To Work In A Team, Ability To Deliver On A Project, Advance Communication, Confidence
College Name: IPS College of Technology & Management
Motivation: Hexaware is globally recognised company plus its an MNC.
Skills evaluated in this interview
Software Developer Interview Questions & Answers
Virtusa Consulting Services
avinash patnala
posted on 13 Jan 2015
Interview Preparation Tips
Experience: Quite easy..It contains mcq and one programming question. MCQ covers databases,sql,software testing,c++
Tips: You can easily pass the test,no need to worry
Round: Interview
Experience: Questions are among databases and java,they will ask u fav subj and asks questions in that
Tips: Through with ur fav subject..be confident, simple anad basic questions,try to solve secreening test question using java language
Round: Interview
Experience: Its better to say technical only,the hr also asks about test pattren.programming question.then normal HR questions
Tips: It better to do some research about the company,overall it's easy and cake walk for those who are strong in java and databases
General Tips: CSE guys can easily clear that test and interview..without any hesitattion
Skills: Java,databases, SQL, C, General Aptitude
College Name: NIT Warangal
Motivation: Virtusa is emerging company
Funny Moments: In interview they asked about my girl friend,her name andwhen ur are going to marry. answer them in a funny way with smile in your face
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
Optum Global Solutions
Hexaware Technologies
- Home >
- Interviews >
- Insigma Interview Questions
