KMK Consulting Interview Questions, Process, and Tips

Q1. Project Experience and end to end architecture
Ans. 
I have experience working on projects with end-to-end architecture, including design, development, testing, and deployment.
• Designed and implemented scalable AWS architectures using services like EC2, S3, Lambda, API Gateway, etc.

• Developed applications using AWS SDKs and integrated with other AWS services.

• Performed testing and debugging of applications on AWS infrastructure.

• Deployed applications on AWS using CI/CD pipel...read more
Answered by AI
Add your answer
Q2. PySpark Coding question to Extract Transform & Load
Add your answer
Q3. Cost Optimization on Snowflake
Ans. 
Cost optimization on Snowflake involves utilizing features like virtual warehouses, auto-suspend, and resource monitoring.
• Utilize virtual warehouses efficiently based on workload requirements

• Enable auto-suspend to automatically pause warehouses when not in use

• Monitor resource usage and adjust configurations accordingly
Answered by AI
Add your answer

Q1. Project end to end
Add your answer
Q2. How to connect to a share point database
Ans. 
To connect to a SharePoint database, you can use SharePoint's REST API or Microsoft Graph API.
• Use SharePoint's REST API to interact with SharePoint data through standard HTTP requests.

• Authenticate using OAuth tokens to access SharePoint resources securely.

• Utilize Microsoft Graph API for a unified endpoint to access data across Microsoft services.

• Ensure proper permissions are set up for the application accessing the Sha
Answered by AI
Add your answer
Q3. Normalization & de normalization
Add your answer
Q4. Questions on SQL Joins
Add your answer
Q5. Question to find the 2nd highest salary using window function
Ans. 
Use window function to find 2nd highest salary in SQL
• Use the ROW_NUMBER() function to assign a unique row number to each row based on the salary in descending order

• Filter the results where the row number is 2 to get the 2nd highest salary
Answered by AI
Add your answer

Q1. Why are you looking for a job change
Add your answer
Q2. How was the experience at previous company
Add your answer
Q3. Expected CTC at Scatterpie
Ans. 
Expected CTC at Scatterpie
• Research industry standards for AWS Developer roles at Scatterpie

• Consider your experience, skills, and qualifications

• Factor in location, company size, and benefits package

• Negotiate based on market trends and personal value
Answered by AI
Add your answer

I have already added the questions.

Q1. Can you provide a description of your previous work experience?
Add your answer
Q2. What were the reasons for leaving your previous job?
Add your answer

Q1. What are your salary expectations?
Add your answer

Crafting a proposal for a potential client.

It is a test of total 150+ questions in which we have some java pseudocodes ,python ,aptitude reasoning questions as well and english questions.

Q1. Short inteoduction and project discussion.
Add your answer
Q2. Check the given sentence is palindrome or not by taking input by user.
Ans. 
The program checks if a given sentence is a palindrome or not.
• Prompt the user to input a sentence

• Remove all spaces and punctuation from the sentence

• Reverse the sentence and compare it with the original sentence to check for palindrome
Answered by AI
Add your answer
Q3. Final,Finally,finalize keywords
Add your answer

Q1. Introduce your self
Add your answer
Q2. Soft skills and other basic questions
Add your answer

Market Research Questions

Q1. What is market research
Ans. 
Market research is the process of gathering, analyzing, and interpreting information about a market, including customers, competitors, and industry trends.
• Involves collecting data on customer preferences, buying habits, and market trends

• Helps businesses make informed decisions about product development, pricing, and marketing strategies

• Includes techniques such as surveys, focus groups, and data analysis

• Examples: conduc...read more
Answered by AI
Add your answer

Q1. Why do you want to join our company?
Add your answer

Q1. About skills and experience
Add your answer
Q2. About knowledge
Add your answer

Submitted a case study

Q1. With senior and global management
Add your answer

Q1. What is coalesce
Ans. 
Coalesce is a function used to return the first non-null value in a list of expressions.
• Coalesce function is commonly used in SQL to handle null values.

• It takes multiple arguments and returns the first non-null value.

• Example: COALESCE(column1, column2, 'default') will return the value of column1 if not null, else column2, and if both are null, it will return 'default'.
Answered by AI
Add your answer
Q2. What is repartition
Ans. 
Repartition is the process of redistributing data across partitions in a distributed system.
• Repartitioning helps in balancing the workload and improving performance in distributed computing environments.

• It involves moving data between partitions based on certain criteria such as key values or hash functions.

• Repartitioning can be done in Spark using operations like repartition() or coalesce().
Answered by AI
Add your answer

Q1. Non repeatable character
Ans. 
A non repeatable character is a character that appears only once in a given string.
• Iterate through the string and count the frequency of each character

• Identify the characters that have a frequency of 1

• Return the first non repeatable character found
Answered by AI
Add your answer
Q2. Sort list without sort method
Ans. 
Sort list without using sort method
• Create a custom sorting function using loops

• Compare each element with every other element to determine the correct order

• Swap elements based on the comparison results
Answered by AI
Add your answer