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
Top trending discussions
Interview questions from similar companies
I applied via Company Website and was interviewed in Sep 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Specific to SAP HANA Architecture and troubleshooting
Interview Preparation Tips
I was interviewed before Jun 2016.
Interview Questionnaire
3 Questions
- Q1. I was given a case study of a business scenario and was asked to implement it technically as a functional consultant using SAP software
- Q2. Salary negotiation based on the experience
- Q3. Case study of a business scenario will be given to you based on the job profile
Interview Preparation Tips
Experience: Resume shortlisted based on the skill set what the Infosys was looking for and the profile I was offering.
Tips: Resume should be as per the requirement of the job profile you are applying for.
Round: Technical Interview
Experience: Panel of Project manager took my interview based on the requirement of the vacancy and skill set I have mentioned in my resume.
Tips: Resume should not be extravagant, it should be very precise
Round: HR Interview
Experience: Always do a pre-check of the organization hierarchy as it helps in negotiating the position.
Round: Case Study Interview
Experience: Try to give precise answer.
Skills: Entrepreneurial Skills
I was interviewed in Jun 2016.
Interview Questionnaire
2 Questions
- Q1. General questions related to Windows administration
- Q2. Questions about lack of past with experience.
Interview Preparation Tips
Experience: Some questions regarding active directory and file sharing
Tips: Keep it real and answer what you know. Donot argue unless interviewer demands discussion.
Round: HR Interview
Experience: Some questions regarding active directory and file sharing
Tips: Keep it real and answer what you know. Donot argue unless interviewer demands discussion.
Round: HR Interview
Experience: I didn't have work experience of a company.
Tips: Will if you have reached hr stage and don't have certain document tell the truth. And explain why you don't have it. If you can arrange the doc, great. If you can't clearly state the same. And tell about the references you can share.
Skills: Technical Analysis
Interview Questionnaire
6 Questions
- Q1. I was asked why Consulting,
- Q2. About the Company,
- Q3. What is the Current Exchange rate
- Ans.
The current exchange rate varies depending on the currency pair and market conditions.
Exchange rates are constantly fluctuating based on supply and demand
Factors such as political events, economic data, and central bank decisions can impact exchange rates
For example, as of August 2021, the exchange rate for USD to EUR is approximately 0.85
- Q4. Taking cue from an earlier answer I was asked basics of Corporate Hedging
- Q5. What is your view on the indian rupee vs dollar in the long run
- Ans.
The Indian rupee is expected to depreciate against the dollar in the long run.
The Indian economy is heavily dependent on imports, which puts pressure on the rupee.
The US economy is expected to grow faster than India's, which will strengthen the dollar.
Political and economic instability in India can also weaken the rupee.
However, global events such as trade wars and geopolitical tensions can also impact the exchange rat...
- Q6. A problem was given and I had to give the solution- the problem was “A company has corporate cellphone connection for its employees. How would you ensure that you achieve the same at the least cost?”
- Ans.
Negotiate with service providers for bulk discounts and limit data usage to essential business needs.
Negotiate with service providers for bulk discounts
Limit data usage to essential business needs
Consider implementing a BYOD (Bring Your Own Device) policy
Use mobile device management software to monitor and control usage
Encourage employees to use Wi-Fi instead of cellular data when possible
Interview Preparation Tips
Experience: I was able to explain Why Consulting and also showed a keen interest in Government Consulting which Wipro was heavily into.
General Tips: A non-fish-market GD goes a long way in helping your chances
Skills: case analysis, group discussion
College Name: NA
Interview Questionnaire
10 Questions
- Q1. Tell me about yourself
- Ans.
I am an experienced consultant with a strong background in problem-solving and client management.
Experienced consultant
Strong problem-solving skills
Client management expertise
- Q2. Why Consulting as a career
- Ans.
Consulting offers diverse challenges, continuous learning, and the opportunity to make a significant impact.
Consulting provides exposure to various industries and business problems.
It offers the chance to work with talented professionals and learn from their expertise.
Consultants have the opportunity to make a tangible difference by solving complex issues and driving positive change.
The work is dynamic and ever-evolvin...
- Q3. I had Strategy & Finance as specialization, justify your specializations
- Q4. I had 2 independent consulting assignments on CV, very detailed discussion of that
- Q5. What profiles are you looking for, I said BFSI sector, they said very few profiles on offer in BFSI, said we can give you Software Product Sectors
- Q6. Cases on market entry strategy
- Q7. What is Freescale’s (my previous employer) condition right now, I told them a lot about freescale and the global chip manufacturing segment, specific growth, industry concentration everything
- Q8. Asked whether I would be able to do such analysis in other sectors also if given opportunity. I had worked for e-commerce sector in projects gave specific numbers for that, he was very pleased with the ind...
- Q9. Asked me about how to enter new markets and new product lines
- Q10. Asked about how would a person decide whether to invest in particular market or not
Interview Preparation Tips
Experience: Industry analysis for 2 sectors in fair depth and numerical figures intact ( Global Semiconductor Industry & Indian E-commerce Industry)
Better to read the JDs and remember profiles they are offering
Tips: They asked about CGPA and marks in 10th and 12th.
Skills: case analysis, Economics
College Name: NA
Interview Questionnaire
8 Questions
- Q1. Why consulting?
- Ans.
Consulting offers diverse challenges, continuous learning, and the opportunity to make a significant impact.
Consulting provides exposure to various industries and business problems.
It offers the chance to work with talented professionals and learn from their expertise.
Consultants have the opportunity to solve complex problems and make a tangible difference.
The work is dynamic and ever-changing, ensuring continuous lear...
- Q2. How can you add value to our organisation
- Q3. Specifically why Wipro out of all the consulting firms. They were very keen on why wipro thing
- Q4. What do you know about the Wipro group as a whole?
- Ans.
Wipro is an Indian multinational corporation that provides information technology, consulting and business process services.
Founded in 1945 by M.H. Hasham Premji
Headquartered in Bangalore, India
Employs over 190,000 people worldwide
Provides services in various industries including healthcare, finance, retail, and more
Has a strong focus on sustainability and social responsibility
Acquired Appirio, a cloud services company
- Q5. Lengthy discussion on Work experience
- Q6. Lengthy discussion on Summer internship project
- Q7. The whole interview was based on operations and supply chain concepts
- Q8. What theoretical concepts did you used to execute your project?
Interview Preparation Tips
Experience: Convinced them very well that the role they are offering is very much in line with my previous work ex and summer internship.
General Tips: Try to hard sell yourself as much as you can. Try to steer the interview yourself and you need to talk a lot. They wanted numbers as in revenues, competitors and recent events about the company.
Skills: case analysis, Economics
College Name: NA
Interview Questionnaire
6 Questions
- Q1. I was asked basic questions like Tell me about yourself
- Q2. Why consulting,
- Q3. What do I know about Wipro Consulting
- Ans.
Wipro Consulting is a global management consulting firm.
Offers services in strategy, operations, technology, and transformation.
Has a presence in over 50 countries.
Works with clients across various industries such as healthcare, financial services, and retail.
Part of Wipro Limited, a leading global information technology, consulting, and business process services company.
- Q4. What are the different processes
- Q5. What is the strategy of Wipro Business Consulting
- Ans.
Wipro Business Consulting's strategy is to provide end-to-end consulting services to clients across various industries.
Offering a range of consulting services including strategy, operations, technology, and organization
Focusing on digital transformation and innovation
Collaborating with clients to develop customized solutions
Leveraging Wipro's global presence and expertise
Examples of clients include a leading US healthc...
- Q6. Then I was asked what is there in your CV which I won’t find in others?
Interview Preparation Tips
Experience: I was grilled about the Company
Skills: Group discussion, case analysis
College Name: NA
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
Senior Consultant Interview Questions from Similar Companies
Fast track your campus placements
Saksoft Senior Consultant Reviews and Ratings
based on 46 reviews
Rating in categories
|
Senior Consultant
389
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Consultant
291
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Lead Consultant
163
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Associate Consultant
97
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Software Engineer
52
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- Saksoft Interview Questions >
- Saksoft Senior Consultant Interview Questions
