Government of Sikkim Interview Questions and Answers

Q1. Give work freedom to employee
View 1 more answer
Q2. No need to search each and every transactions
Add your answer

Q1. Trust on employee
Add your answer
Q2. Maintain minimum job curtsy
Add your answer

Q1. Salary hike and position hike is Mandatory
Add your answer
Q2. Collect exact feedback from employee
Add your answer

Q1. Could you elaborate on your roles and responsibilities in your previous employment?
Add your answer
Q2. What was your role in the project, specifically related to data transformation and dashboard creation?
Add your answer
Q3. How do you optimize and manage large datasets, and what data sources do you utilize to obtain this data?
Add your answer
Q4. Guesstimates like how many traffic signals are there in Noida.
Add your answer
Q5. The interviewer asked SQL questions related to window functions, joins, and advanced aggregations, such as running sum and rolling sum.
Add your answer

Q1. Second round is also a technical round and similar to first round . Medium to high level sql questions and questions related to the project you're working on and Guesstimates will be asked by the interview...read more
Add your answer

Q1. Project manager will take the third round interview and inquire about your knowledge of the company, and some technical and scenario-based questions related to decision-making and problem-solving approach.
Add your answer

Q1. Final round will be an HR round.
Add your answer

Assignments in marketing and sales involve processes related to product development, technology, and service taxation, as well as the enhancement of listening skills and other developmental processes beyond the same assignments.

Q1. What is the marketing What is the tax What are good and service tax
Ans. 
Marketing tax is a tax imposed on goods and services to fund marketing activities.
• Marketing tax is a type of indirect tax that is levied on goods and services to fund marketing campaigns and activities.

• It is typically included in the price of the product or service and passed on to the consumer.

• Examples of marketing taxes include the Federal Excise Tax on cigarettes and alcohol, which are used to fund anti-smoking and
Answered by AI
Add your answer
Q2. What are good and service tax
Ans. 
Goods and Services Tax (GST) is a value-added tax levied on most goods and services sold for domestic consumption.
• GST is a consumption tax that is ultimately borne by the end consumer

• It is a single tax on the supply of goods and services, right from the manufacturer to the consumer

• GST eliminates the cascading effect of taxes, making the taxation system more efficient

• There are different GST rates for different goods and...read more
Answered by AI
Add your answer
Q3. What is theDeveploment skills
Ans. 
Development skills refer to the ability to continuously improve and grow in one's professional capabilities.
• Continuous learning and self-improvement

• Adaptability to new technologies and trends

• Ability to innovate and problem-solve

• Strong communication and collaboration skills

• Project management and leadership abilities
Answered by AI
Add your answer
Q4. How is skills and service
Ans. 
Skills and service are essential for a Sales Manager to effectively meet customer needs and drive sales.
• Skills such as communication, negotiation, and problem-solving are crucial for building relationships with clients.

• Providing excellent customer service can lead to repeat business and positive word-of-mouth referrals.

• Sales managers should be able to train and motivate their team to deliver exceptional service and ach
Answered by AI
Add your answer
Q5. What istha markating skills
Ans. 
Marketing skills are essential for a Sales Manager to effectively promote products or services and attract customers.
• Understanding target audience and market trends

• Creating compelling marketing campaigns

• Utilizing various marketing channels such as social media, email, and advertising

• Analyzing data to measure campaign effectiveness

• Building strong relationships with customers and partners
Answered by AI
Add your answer

Q1. Asked about Dotnet Core Questions about Program.cs file use case, DI, Services, Architectural patterns, and jumped to Linq complex queries and SQL queries. Before that Deep analysis of background work
Add your answer
Q2. Use of Program.cs
Add your answer
Q3. Middleware and Services
Add your answer
Q4. Dependency Injection
Add your answer
Q5. Authentication & Authorization
Add your answer

Q1. Basic techno managerial questions on tech you worked on work, interests, challenges you faced. Was fairly short.
Add your answer

Initially had a string based coding problem. Then was asked technical questions and then had a small break before doing system design with same interviewer for building book my show system and db schema.

Q1. Had a discussion with hiring manager on expectations, salary and growth.
Add your answer

It was basic coding to test the Python skills like reading data from local and uploading in cloud then some basic dag related questions

Q1. Clustering and partition difference in data warehousing solutions
Ans. 
Clustering involves grouping similar data together, while partitioning involves dividing data into smaller, manageable sections.
• Clustering is used to group similar data points together based on certain criteria, such as customer segments or product categories.

• Partitioning involves dividing a large dataset into smaller, more manageable sections for easier data retrieval and processing.

• Clustering is often used for data a...read more
Answered by AI
Add your answer
Q2. What are the different approaches to Optimising SQL
Ans. 
Different approaches to optimizing SQL include indexing, query optimization, and database design.
• Use indexing to improve query performance

• Optimize queries by avoiding unnecessary joins and using appropriate functions

• Design the database schema efficiently to reduce redundancy and improve data retrieval speed
Answered by AI
Add your answer
Q3. Spark and it’s architecture
Add your answer
Q4. Finding the count of Item bought by an customer from Flipkart during a year excluding February
Ans. 
To find the count of items bought by a customer from Flipkart during a year excluding February, you need to aggregate the data and filter out February transactions.
• Aggregate the data by customer and item purchased

• Filter out transactions from February

• Count the number of items bought by each customer
Answered by AI
Add your answer

Q1. What is Object-Oriented Programming (OOP), and can you explain its fundamental concepts?
Ans. 
OOP is a programming paradigm based on the concept of objects, which can contain data in the form of fields and code in the form of procedures.
• OOP focuses on creating objects that interact with each other to solve complex problems.

• Fundamental concepts include classes, objects, inheritance, encapsulation, and polymorphism.

• Classes are blueprints for creating objects, while objects are instances of classes.

• Inheritance all...read more
Answered by AI
Add your answer
Q2. What is the definition of an array, and what are the different types of arrays?
Ans. 
An array is a data structure that stores a collection of elements of the same type. There are different types of arrays such as one-dimensional, multi-dimensional, and associative arrays.
• One-dimensional array: Stores elements in a single row or column.

• Multi-dimensional array: Stores elements in multiple rows and columns.

• Associative array: Uses key-value pairs to store elements.

• Example: ['apple', 'banana', 'orange']
Answered by AI
Add your answer
Q3. What is the clr
Ans. 
CLR stands for Common Language Runtime, a virtual machine component of the .NET framework responsible for managing code execution.
• CLR provides services such as memory management, exception handling, and security.

• It compiles code into Intermediate Language (IL) and then translates it into machine code at runtime.

• CLR allows for language interoperability within the .NET framework, enabling different languages to work toge
Answered by AI
Add your answer

The content is based on HTML, Windows, and ADO.NET.

Q1. What motivates you to pursue this job?
Ans. 
I am motivated to pursue a career as a Customer Care Executive because I enjoy helping others and providing excellent service.
• I have a passion for assisting customers and resolving their issues

• I thrive in a fast-paced environment where I can use my communication skills effectively

• I find satisfaction in ensuring customer satisfaction and building positive relationships

• I believe in the importance of delivering exceptiona...read more
Answered by AI
Add your answer
Q2. What is your expected salary?
Ans. 
My expected salary is based on my experience, skills, and the market rate for web developers.
• I have researched the average salary for web developers in this location.

• I am open to negotiation based on the overall compensation package offered.

• I am looking for a salary that reflects my expertise and contributions to the team.
Answered by AI
Add your answer

Q1. It was more on the expertise on the service delivery implementation exposure in managing end to end delivery of Project.
Add your answer
Q2. Examples of similar or related Projects managed in Past.
Add your answer

Q1. On Technical expertise in Project Management and Service Delivery of Telecom Projects.
Add your answer