Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Saksoft Team. If you also belong to the team, you can get access from here

Saksoft Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Saksoft Senior Consultant Interview Questions, Process, and Tips

Updated 19 Dec 2024

Top Saksoft Senior Consultant Interview Questions and Answers

Saksoft Senior Consultant Interview Experiences

3 interviews found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. SQL and Linux related questions
  • Q2. Product to which being hired questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through SQL, LINUX and other important topics

Senior Consultant Interview Questions & Answers

user image Shridhar Kamble

posted on 19 Dec 2024

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

I applied via Referral and was interviewed before Dec 2023. There was 1 interview round.

Round 1 - Technical 

(5 Questions)

  • Q1. Peformance tunning in SQL store procedures
  • Ans. 

    Performance tuning in SQL store procedures involves optimizing the code to improve execution speed and efficiency.

    • Identify and eliminate unnecessary code

    • Use appropriate indexing to speed up data retrieval

    • Avoid using cursors and loops whenever possible

    • Optimize query execution plan

    • Consider using stored procedures for frequently executed queries

  • Answered by AI
  • Q2. Index optimization in sql server
  • Ans. 

    Index optimization in SQL Server involves creating, maintaining, and optimizing indexes to improve query performance.

    • Identify and create indexes on columns frequently used in WHERE clauses

    • Regularly update statistics to ensure the query optimizer has accurate information

    • Consider using included columns to cover queries that require additional columns not in the index key columns

    • Avoid over-indexing as it can lead to decre...

  • Answered by AI
  • Q3. Sql Exexution Plan and Query Analyzer
  • Q4. Role of SQL Profiler
  • Ans. 

    SQL Profiler is a tool used to monitor and capture SQL Server events and performance data.

    • SQL Profiler helps in identifying and troubleshooting performance issues in SQL Server.

    • It captures events like queries, stored procedures, errors, and more.

    • Allows users to analyze the captured data to optimize database performance.

    • Can be used to trace and monitor specific activities in real-time.

    • Helps in identifying slow queries a...

  • Answered by AI
  • Q5. What are temp tables. Diff bet temp tables and CTE
  • Ans. 

    Temp tables are temporary tables used to store intermediate results, while CTEs are temporary result sets defined within a query.

    • Temp tables are physical tables that are created in the tempdb database and can be used multiple times within a session.

    • CTEs (Common Table Expressions) are temporary result sets that are defined within a query and can only be referenced within that query.

    • Temp tables persist until they are exp...

  • Answered by AI

Senior Consultant Interview Questions Asked at Other Companies

asked in Capgemini
Q1. 1. What's the use of update sets and how do you move update set f ... read more
Q2. 1. What is Virtual DOM? How does it work & Its algorithm? 2. ... read more
asked in Capgemini
Q3. 1. If MAM is there then why do we need MDM? 2. What are the diffe ... read more
asked in Birlasoft
Q4. What is the difference between the cursors declared in procedures ... read more
asked in Capgemini
Q5. JCL 1. Ways in which the you can paas on data from.jcl to cobol.: ... read more
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Jun 2023. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Current project related questions

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. Tell me about yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - just basic questions from my cv

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

Interview Questionnaire 

1 Question

  • Q1. Basics of ETL, questions regarding Azure Data Engineering.

Interview Preparation Tips

Interview preparation tips for other job seekers - Very detailed questions were asked. The interviewers were more into discuss, rather than asking questions. I had very positive experience.

I applied via Recruitment Consultant and was interviewed before Aug 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic technical questions, scenario based questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well technically.

I applied via Company Website and was interviewed in Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. - Steps to Create a Docker file - Types of firewall in AWS - How ELK Stack works.
  • Ans. 

    Answers to questions related to Docker, AWS firewall types, and ELK Stack

    • To create a Docker file, start with a base image and add necessary dependencies and configurations

    • AWS has two types of firewalls: Network ACLs and Security Groups

    • ELK Stack is a combination of Elasticsearch, Logstash, and Kibana used for log management and analysis

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep your basics strong. Overall interview was smooth.

I applied via Campus Placement and was interviewed before Jun 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 

Profit and losses, time

Round 2 - Coding Test 

C language

Round 3 - Technical 

(2 Questions)

  • Q1. On programming questions
  • Q2. On our Engineering project

Interview Preparation Tips

Interview preparation tips for other job seekers - Be polite and your English language should be perfect

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

Interview Questionnaire 

3 Questions

  • Q1. EDI inbound and outbound Flows
  • Q2. Basic mapping questions in sterling integrator
  • Q3. Basic X12 and EDIFACT transactions

Interview Preparation Tips

Interview preparation tips for other job seekers - Sharpen EDI mapping skills

Interview Questionnaire 

5 Questions

  • Q1. Tell me about your self?
  • Q2. Tell me about your weakness.?
  • Q3. Tell about how to spend your day of today?
  • Q4. Tell me something famous things about your city?
  • Q5. Why should I hire you?
Contribute & help others!
anonymous
You can choose to be anonymous

Saksoft Interview FAQs

How many rounds are there in Saksoft Senior Consultant interview?
Saksoft interview process usually has 1 rounds. The most common rounds in the Saksoft interview process are Technical and One-on-one Round.
How to prepare for Saksoft Senior Consultant interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Saksoft. The most common topics and skills that interviewers at Saksoft expect are Operations, Backend, Devops, Linux and MPLS.
What are the top questions asked in Saksoft Senior Consultant interview?

Some of the top questions asked at the Saksoft Senior Consultant interview -

  1. What are temp tables. Diff bet temp tables and ...read more
  2. Peformance tunning in SQL store procedu...read more
  3. Index optimization in sql ser...read more

Recently Viewed

INTERVIEWS

Saksoft

No Interviews

SALARIES

Junglee Games

INTERVIEWS

Saksoft

No Interviews

INTERVIEWS

Computacenter

No Interviews

SALARIES

Almonds Ai

SALARIES

Computacenter

INTERVIEWS

Saksoft

No Interviews

INTERVIEWS

Computacenter

No Interviews

INTERVIEWS

Saksoft

No Interviews

INTERVIEWS

Saksoft

10 top interview questions

Tell us how to improve this page.

Saksoft Senior Consultant Interview Process

based on 5 interviews

Interview experience

3.8
  
Good
View more
Saksoft Senior Consultant Salary
based on 341 salaries
₹5.5 L/yr - ₹23 L/yr
31% less than the average Senior Consultant Salary in India
View more details

Saksoft Senior Consultant Reviews and Ratings

based on 46 reviews

3.2/5

Rating in categories

2.8

Skill development

3.1

Work-life balance

3.1

Salary

2.7

Job security

3.1

Company culture

2.7

Promotions

2.9

Work satisfaction

Explore 46 Reviews and Ratings
Senior Consultant
374 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Consultant
289 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Lead Consultant
163 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Consultant
97 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
52 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Saksoft with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview