Leadspire Interview Questions and Answers

Q1. What was your last projecy?
Add your answer

Q1. Questions based on project.
Add your answer

Q1. Managerial questions
Add your answer

Q1. About SQL and coding Experience
Add your answer

Q1. Accounting journal entries Advance outstanding rent Capital and drawing
Add your answer

Q1. Excel Vlookup Add sum with $
Ans. 
Vlookup is used in Excel to search for a value in a table and return a corresponding value. Adding sum with $ refers to using absolute references in formulas.
• Vlookup function searches for a value in the first column of a table and returns a value in the same row from a specified column.

• To add sum with $ in Excel, use absolute references by adding $ before the column letter and row number in a formula.

• Example: =VLOOKUP(...read more
Answered by AI
Add your answer

Q1. Questions on PHP MySQL, HTML CSS
Add your answer

Q1. Vendor Risk Management experience? Last project and related roles and responsibilities handled?
Ans. 
Yes
• Managed vendor risk management process for a large financial institution

• Developed and implemented vendor risk assessment framework

• Conducted due diligence on potential vendors

• Monitored and evaluated vendor performance and compliance

• Created and maintained vendor risk management policies and procedures
Answered by AI
Add your answer
Q2. Infosec audits and related standards and frameworks you’ve worked with.
Add your answer

Q1. Cloud security and audit standards? Audit and compliance frameworks you’ve worked with? Risk management and assessment understanding?
Ans. 
I have experience with various cloud security and audit standards, compliance frameworks, and risk management assessments.
• I have worked with ISO 27001, SOC 2, and HIPAA compliance frameworks.

• I am familiar with cloud security best practices such as encryption, access control, and monitoring.

• I have conducted risk assessments and developed risk management plans for various organizations.

• I have experience with security aud...read more
Answered by AI
Add your answer
Q2. Vendor risk management and related work experience?
Ans. 
I have extensive experience in vendor risk management, including identifying and assessing risks, developing mitigation strategies, and monitoring vendor performance.
• Developed and implemented a vendor risk management program for a large financial institution

• Conducted risk assessments of vendors and developed risk mitigation plans

• Monitored vendor performance and conducted regular audits to ensure compliance with contrac...read more
Answered by AI
View 1 more answer

Q1. Check my availability and the background/interests
Add your answer

Q1. Self Introduction
Add your answer

Q1. About technical background
Add your answer

It was easy and basic questions were asked

Q1. Knowledge of sql and other technical questions were asked based on resume
Add your answer
Q2. SQL joins and basics
Add your answer

Q1. Tell me about yourself ?
Ans. 
I am a Service Analyst with experience in analyzing and improving service delivery processes.
• I have a strong background in service management and process improvement.

• I have successfully implemented service improvement initiatives that resulted in increased customer satisfaction.

• I am skilled in analyzing data and identifying areas for improvement in service delivery.

• I have excellent communication and problem-solving ski...read more
Answered by AI
Add your answer
Q2. Tell me about the my family background
Ans. 
I don't have the available data
Answered by AI
Add your answer

Hacker rank test for 2 hours. Language of your choice and problem solving and sql and data structures

Q1. Handling different types of data. Sql functions Design considerations Performance optimization
Ans. 
Handling different types of data, SQL functions, design considerations, and performance optimization.
• Understand the data types and their limitations

• Use appropriate SQL functions for data manipulation

• Consider normalization and denormalization for database design

• Optimize queries and indexes for better performance

• Use caching and partitioning for large datasets

• Examples: DATE functions, JOINs, indexing, partitioning
Answered by AI
Add your answer
Q2. How to handle data skewness in spark. What are the different performance optimization techniques in hive
Ans. 
Handling data skewness in Spark and performance optimization techniques in Hive
• For data skewness in Spark, use techniques like partitioning, bucketing, and salting

• In Hive, use techniques like partitioning, bucketing, and indexing for performance optimization

• Other techniques include using appropriate data types, optimizing queries, and using compression

• Example: In Spark, partitioning can be done based on a column with h...read more
Answered by AI
Add your answer

Q1. Data skewness Stake holder Management Hands on capabilities
Add your answer

Q1. More about culture and compensation and company policy
Add your answer