Shrewdify Technologies Interview Questions and Answers

The Aptitude Test session accesses mathematical and logical reasoning abilities

Q1. What is Vlookup
Ans. 
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
• Vlookup stands for 'Vertical Lookup'

• It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searc...read more
Answered by AI
Add your answer
Q2. Some IF else Question in Excel
Add your answer
Q3. What does your day in your previous organization look like?
Ans. 
My day in my previous organization involved analyzing large datasets, creating reports, and presenting findings to stakeholders.
• Reviewing and cleaning large datasets to ensure accuracy

• Creating visualizations and reports to communicate insights

• Collaborating with team members to identify trends and patterns

• Presenting findings to stakeholders in meetings or presentations
Answered by AI
Add your answer
Q4. Could you share the technical skills you possess?
Ans. 
I possess strong technical skills in data analysis, including proficiency in programming languages, statistical analysis, and data visualization tools.
• Proficient in programming languages such as Python, R, SQL

• Skilled in statistical analysis and data modeling techniques

• Experience with data visualization tools like Tableau, Power BI

• Knowledge of machine learning algorithms and techniques
Answered by AI
Add your answer
Q5. Can you explain what a Pivot Table is?
Ans. 
A Pivot Table is a data summarization tool used in spreadsheet programs to analyze, summarize, and present data in a tabular format.
• Pivot tables allow users to reorganize and summarize selected columns and rows of data to obtain desired insights.

• Users can easily group and filter data, perform calculations, and create visualizations using pivot tables.

• Pivot tables are commonly used in Excel and other spreadsheet program...read more
Answered by AI
Add your answer
Q6. Find the Highest-paid employee in each department along with their salary and department name.
Ans. 
To find the highest-paid employee in each department, we need to group employees by department and then select the employee with the highest salary in each group.
• Group employees by department

• Find the employee with the highest salary in each group

• Retrieve the employee's name, salary, and department name
Answered by AI
Add your answer

Q1. Basic ReactJs ,NodeJs questions with typescript
Add your answer
Q2. Prepare for javascript problems on , string , array , recursion, this.fn
Add your answer

Q1. Asked on Node.js event loop , libuv , AWS , Ci-Cid , authentication, middleware , design and problem solving questions
Add your answer
Q2. Recursion, array methods problem solving Js questions , es6 , array methods
Add your answer

Q1. Details about you and your family,. Location
Add your answer
Q2. Salary expectations
Add your answer

Q1. Myself and experience in english
Add your answer
Q2. Selected for the peocess
Add your answer
Q3. Last drawn salary why you are not another process
Add your answer
Q4. Why you left last job
Add your answer
Q5. Rate ur english 1 to 10 numbers
Add your answer
Q6. Introduce yourself as a employee
Add your answer
Q7. Season topic talk for two minutes
Add your answer
Q8. How is good english
Add your answer
Q9. Your favourite place on this topic
Add your answer

Q1. It was technical questions in relevant area
Add your answer
Q2. The questions relevant to my skill set and experience
Add your answer

Q1. The questions relevant to my skills and experience
Add your answer
Q2. The questions relevant to job requirements
Add your answer

Q1. General discussion about the profession and career
Add your answer
Q2. Discussed job location and client
Add your answer

Q1. Discussed about client and company
Add your answer
Q2. Orientation related things discussed.
Add your answer

Assessment via link MCQ

Q1. Microservices theory, Kafka
Add your answer
Q2. Singoloton design pattern, concurrent package, core java, collection questions, Java 8 related problem solving stream api questions
Add your answer

Q1. Same like round 1, little bit managerial
Add your answer
Q2. Producer consumer multithreading, Java 8 , core java, project
Add your answer

Q1. Behavioral questions
Add your answer
Q2. Situation based questions
Add your answer

Q1. Command to check disk utilisation and health in Hadoop
Ans. 
Use 'hdfs diskbalancer' command to check disk utilisation and health in Hadoop
• Run 'hdfs diskbalancer -report' to get a report on disk utilisation

• Use 'hdfs diskbalancer -plan <path>' to generate a plan for balancing disk usage

• Check the Hadoop logs for any disk health issues
Answered by AI
Add your answer
Q2. Spark Architecture & the significance of each member of spark Architecture
Ans. 
Spark Architecture consists of Driver, Cluster Manager, and Executors. Driver manages the execution of Spark jobs.
• Driver: Manages the execution of Spark jobs, converts user code into tasks, and coordinates with Cluster Manager.

• Cluster Manager: Manages resources across the cluster and allocates resources to Spark applications.

• Executors: Execute tasks assigned by the Driver and store data in memory or disk for further pr...read more
Answered by AI
Add your answer
Q3. Partitioning and bucketing
Add your answer
Q4. Spark optimization techniques
Ans. 
Optimization techniques in Spark improve performance and efficiency of data processing.
• Partitioning data to distribute workload evenly

• Caching frequently accessed data in memory

• Using broadcast variables for small lookup tables

• Avoiding shuffling operations whenever possible

• Tuning memory settings and garbage collection parameters
Answered by AI
Add your answer
Q5. Second highest salary
Ans. 
I am unable to provide this information as it is confidential.
• Confidential information about salaries in previous organizations should not be disclosed.

• It is important to respect the privacy and confidentiality of past employers.

• Discussing specific salary details may not be appropriate in a professional setting.
Answered by AI
Add your answer
Q6. Pivot table creation in SQL from not pivot one
Ans. 
To create a pivot table in SQL from a non-pivot table, you can use the CASE statement with aggregate functions.
• Use the CASE statement to categorize data into columns

• Apply aggregate functions like SUM, COUNT, AVG, etc. to calculate values for each category

• Group the data by the columns you want to pivot on
Answered by AI
Add your answer
Q7. How to create triggers
Ans. 
Creating triggers in a database involves defining the trigger, specifying the event that will activate it, and writing the code to be executed.
• Define the trigger using the CREATE TRIGGER statement

• Specify the event that will activate the trigger (e.g. INSERT, UPDATE, DELETE)

• Write the code or actions to be executed when the trigger is activated

• Test the trigger to ensure it functions as intended
Answered by AI
Add your answer

Q1. Basic pipeline,python,some simple coding
Add your answer
Q2. More on resume and based on ur answers
Add your answer
Q3. Docker multistage
Add your answer

Q1. Write the k8s deployment ymal with rolling update for given docker image
Ans. 
Create a k8s deployment ymal with rolling update for a given docker image
• Define a Deployment object in the YAML file

• Specify the container image in the spec section

• Set the update strategy to RollingUpdate

• Define the number of replicas for the deployment
Answered by AI
Add your answer
Q2. Read json file and recursive way of geting value based on key
Add your answer

Q1. Tell me about yourself: Provide a snapshot of who you are, and how your background and skills align with the position. You can also highlight a key accomplishment that's relevant to the role.
Ans. 
I am a dedicated Junior Engineer with a strong background in production and a proven track record of successfully implementing process improvements.
• Bachelor's degree in Mechanical Engineering

• Experience in optimizing production processes to increase efficiency

• Proficient in CAD software for designing production layouts

• Implemented a new scheduling system that reduced production downtime by 20%
Answered by AI
Add your answer
Q2. How do you fix a mistake? Provide an example of how you handled a mistake in the workplace, and the actions you took to resolve it.
Ans. 
To fix a mistake, I analyze the root cause, take responsibility, communicate with stakeholders, and implement a solution.
• Analyze the root cause of the mistake to understand what went wrong

• Take responsibility for the mistake and acknowledge it to relevant parties

• Communicate with stakeholders to keep them informed about the situation

• Implement a solution to rectify the mistake and prevent it from happening again

• Example: I...read more
Answered by AI
Add your answer
Q3. Focus on highlighting your key strengths, accomplishments, and career goals.
Add your answer
Q4. Acknowledge your mistake: Take responsibility for your actions and explain what went wrong.
Ans. 
I take full responsibility for my mistake in not double-checking the production schedule, resulting in a delay in delivery.
• Acknowledge the mistake without making excuses

• Explain what went wrong and how it could have been prevented

• Discuss steps taken to rectify the mistake and prevent it from happening again
Answered by AI
Add your answer
Q5. Take care of yourself: Prioritize self-care and get some perspective.
Ans. 
Prioritizing self-care is essential for maintaining overall well-being and gaining perspective in life.
• Make time for activities that bring you joy and relaxation, such as reading, exercising, or spending time with loved ones.

• Practice mindfulness and self-reflection to understand your emotions and thoughts better.

• Set boundaries to protect your mental and physical health, such as saying no to additional work when you're ...read more
Answered by AI
Add your answer

Aptitude has general maths, English and Finance questions very easy and it was a online aptitude test.

Q1. Derivatives, Types of derivatives
Add your answer
Q2. What is indices
Ans. 
Indices are statistical measures used to track the performance of a specific group of assets or market.
• Indices are used to provide a snapshot of the overall market or a specific sector.

• They are often used as benchmarks for investment performance.

• Examples include the S&P 500, Dow Jones Industrial Average, and NASDAQ Composite.
Answered by AI
Add your answer
Q3. What is capital budgeting
Ans. 
Capital budgeting is the process of planning and managing a firm's long-term investments.
• Involves evaluating potential investments and deciding which ones to pursue

• Considers factors such as cash flows, risks, and returns

• Helps in determining the best allocation of resources for maximum profitability

• Examples include building a new factory, purchasing equipment, or launching a new product
Answered by AI
View 1 more amswer
Q4. About financial instruments
Add your answer
Q5. Tell me about yourself
Ans. 
I am a dedicated and detail-oriented analyst with a strong background in data analysis and problem-solving.
• I have a Bachelor's degree in Statistics and have completed multiple data analysis projects during my studies.

• I am proficient in using statistical software such as R and Python for data analysis.

• I have experience in conducting market research and creating reports to help businesses make informed decisions.
Answered by AI
Add your answer