AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Saksoft
Compare
Filter interviews by
Saksoft Senior Consultant Interview Questions, Process, and Tips
Top Saksoft Senior Consultant Interview Questions and Answers
- Q1. What are temp tables. Diff bet temp tables and CTE
- Q2. Peformance tunning in SQL store procedures
- Q3. Index optimization in sql server
Saksoft Senior Consultant Interview Experiences
3 interviews found
Anonymous
(2 Questions)
- Q1. SQL and Linux related questions
- Q2. Product to which being hired questions
Interview Preparation Tips
Shridhar Kamble
Selected
I applied via Referral and was interviewed before Dec 2023. There was 1 interview round.
(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
- 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...
- 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...
- 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...
Selected
I applied via Recruitment Consulltant and was interviewed before Jun 2023. There was 1 interview round.
(1 Question)
- Q1. Current project related questions
Interview questions from similar companies
Selected
I applied via Recruitment Consulltant and was interviewed in Mar 2024. There was 1 interview round.
(3 Questions)
- Q1. What is Pricing condition
- Ans.
Pricing condition is a rule or criteria used to determine the price of a product or service.
Pricing conditions can include factors such as quantity discounts, promotional offers, and contract terms.
They are typically set in pricing tables within a company's ERP system.
Pricing conditions are used to calculate the final price that a customer will pay for a product or service.
Examples of pricing conditions include discoun...
- Q2. What is structure of Order
- Ans.
The structure of an Order typically includes customer information, product details, quantity, price, and payment information.
Customer information (name, address, contact details)
Product details (name, description, SKU)
Quantity of each product ordered
Price of each product
Payment information (payment method, total amount)
Order status (pending, shipped, delivered)
- Q3. How plant will be determine in Sales order
- Ans.
Plants in a sales order are determined based on the customer's requirements, availability, pricing, and shipping logistics.
Plants are determined based on the customer's location and delivery preferences.
Availability of the product at different plant locations is considered.
Pricing and discounts may vary based on the plant from which the product is shipped.
Shipping logistics such as distance, transportation costs, and d...
Interview Preparation Tips
Skills evaluated in this interview
Navin P
Selected
I applied via LinkedIn and was interviewed in Mar 2024. There were 3 interview rounds.
Reverse a string without built in
Check whether string is palindrome
(1 Question)
- Q1. C++ virtual functions linked list
(1 Question)
- Q1. Brief youself, your role in current project
(1 Question)
- Q1. Salary negotiations, perfered location
Interview Preparation Tips
(1 Question)
- Q1. What are the challenges you face during implementation
- Ans.
The challenges during implementation include resistance to change, lack of resources, and communication issues.
Resistance to change from employees or stakeholders
Lack of resources such as time, budget, or personnel
Communication issues between team members or with clients
Technical difficulties or unforeseen obstacles
Ensuring the project stays within scope and meets deadlines
(1 Question)
- Q1. General discussion about profile and package
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed before Nov 2022. There were 3 interview rounds.
(1 Question)
- Q1. 1st round would be technical with coding test . Interview can give some code to write along with oops basic questions.
(1 Question)
- Q1. This round mostly techno managerial where the Interview might ask bit of a technical questions and some scenario based questions, mostly non technical.
(1 Question)
- Q1. Salary Discussion
Interview Preparation Tips
Selected
I applied via Job Fair and was interviewed in Jan 2024. There were 2 interview rounds.
(1 Question)
- Q1. What is ess jobs
- Ans.
ESS jobs refer to employment opportunities within the Employee Self-Service system.
ESS jobs are job openings that can be accessed and applied for through the Employee Self-Service system.
These jobs are typically available within an organization or company and are specifically advertised to employees who have access to the ESS system.
Employees can view job descriptions, requirements, and apply for these positions direct...
(1 Question)
- Q1. What is bursting
- Ans.
Bursting is the process of sending a large amount of data or information in a short period of time.
Bursting is commonly used in telecommunications to describe the transmission of a high volume of data in a short burst.
It can also refer to the sudden increase in network traffic or activity.
Bursting can be seen in cloud computing when a user's demand for resources exceeds their allocated capacity.
For example, a video str...
Skills evaluated in this interview
I applied via Referral and was interviewed in Oct 2021. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Implementation part, real time scenarios, challenges, typical situations
- Q2. Explained the existing project part, tried analyzing and provide solutions to complex cases, real time examples
Interview Preparation Tips
Saksoft Interview FAQs
Tell us how to improve this page.
Saksoft Interviews By Designations
- Saksoft Consultant Interview Questions
- Saksoft Senior Consultant Interview Questions
- Saksoft Analyst Interview Questions
- Saksoft Software Developer Interview Questions
- Saksoft Lead Consultant Interview Questions
- Saksoft Senior Engineer Interview Questions
- Saksoft Business Analyst Interview Questions
- Saksoft Associate Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
- Associate Consultant Interview Questions
- Senior Associate Consultant Interview Questions
- Lead Consultant Interview Questions
- Technical Consultant Interview Questions
- Consultant Interview Questions
- Associate Technical Consultant Interview Questions
- Principal Consultant Interview Questions
- Technology Consultant Interview Questions
- Show more
Saksoft Senior Consultant Interview Process
based on 5 interviews
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Saksoft Senior Consultant Reviews and Ratings
based on 49 reviews
Rating in categories
|
Senior Consultant
372
salaries
|  ₹5.2 L/yr - ₹20 L/yr |
|
Consultant
290
salaries
| ₹3 L/yr - ₹12.3 L/yr |
|
Lead Consultant
162
salaries
| ₹7.2 L/yr - ₹28 L/yr |
|
Associate Consultant
97
salaries
| ₹2 L/yr - ₹5.5 L/yr |
|
Software Engineer
61
salaries
| ₹3.4 L/yr - ₹14.6 L/yr |
3i Infotech
Microland
Newgen Software Technologies
NSE.IT
- Home >
- Interviews >
- Saksoft Interview Questions >
- Saksoft Senior Consultant Interview Questions
