Bigtel IT Solutions Interview Questions and Answers

Aptitude can be considered "talent", or "skill". Aptitude is inborn potential to perform certain kinds of activities, whether physical or mental, and whether developed or undeveloped.

Coding tests are typically programming challenges that help technical recruiters test programming skills and competencies of a developer or programmer. A good coding test will measure a candidate's capacity for problem-solving skills and understanding of coding

Group discussion (GD) is a comprehensive technique to judge the suitability of an individual and his appropriateness for admission, scholarship, job, etc.

Assessment is the systematic basis for making inferences about the learning and development of students. It is the process of defining, selecting, designing, collecting, analyzing,

Case study, detailed description and assessment of a specific situation in the real world created for the purpose of deriving generalizations and other insights from it.

Q1. What is technical?
Ans. 
Technical refers to anything related to technology, machinery, or scientific knowledge.
• Relating to technology or machinery

• Involving scientific knowledge or skills

• Concerned with practical application of knowledge

• Examples: coding, testing software, troubleshooting hardware
Answered by AI
Add your answer
Q2. What are technical missings ?
Ans. 
Technical missings refer to bugs or defects in the software code that cause unexpected behavior or errors.
• Technical missings are issues in the code that lead to incorrect functionality.

• They can include syntax errors, logic errors, or missing error handling.

• Examples of technical missings include null pointer exceptions, infinite loops, and memory leaks.
Answered by AI
Add your answer

Q1. How HR use? What is the full form of HR
Ans. 
HR stands for Human Resources. HR is responsible for managing employee relations, recruitment, training, and other personnel-related tasks.
• HR is used by organizations to manage their workforce and ensure compliance with labor laws.

• HR departments handle tasks such as recruitment, onboarding, training, performance evaluations, and employee relations.

• HR professionals also play a key role in developing and implementing com...read more
Answered by AI
Add your answer
Q2. What was HR can do ?
Ans. 
HR can play a crucial role in recruitment, employee relations, training, and development.
• Recruitment - HR can source, screen, and interview candidates for open positions.

• Employee relations - HR can handle conflicts, provide support, and ensure a positive work environment.

• Training and development - HR can organize training programs, workshops, and career development opportunities.

• Policy implementation - HR can ensure co...read more
Answered by AI
Add your answer

Q1. How was system requirements r use?
Ans. 
System requirements are used to define the functionalities, constraints, and quality attributes of a software system.
• System requirements help in understanding what the software should do and how it should behave.

• They serve as a basis for design, development, testing, and validation of the software.

• Examples of system requirements include performance metrics, security features, user interface specifications, and compatib
Answered by AI
Add your answer
Q2. What is system requirements?
Ans. 
System requirements are a detailed description of the functions and capabilities a system must have in order to meet the needs of its users.
• System requirements outline the necessary features, functions, and capabilities of a software system.

• They are typically documented in a requirements specification document.

• System requirements help ensure that the software meets the needs and expectations of its users.

• Examples of sy...read more
Answered by AI
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. How can we do Integrations in Salesforce
Ans. 
Integrations in Salesforce involve connecting Salesforce with external systems to exchange data and automate processes.
• Use Salesforce APIs like REST and SOAP for integrating with external systems

• Utilize middleware tools like MuleSoft or Informatica for seamless integrations

• Leverage Salesforce Connect to access data from external sources in real-time

• Implement custom integrations using Apex code and web services
Answered by AI
Add your answer
Q2. What are frameworks or Trigger frameworks in Salesforce?
Ans. 
Frameworks or Trigger frameworks in Salesforce are design patterns that help developers organize and structure their code for triggers.
• Frameworks provide a set of best practices and guidelines for writing trigger logic.

• They help in separating concerns, making code more modular and maintainable.

• Examples include Trigger Handler Framework, Trigger Factory Framework, and Trigger Pattern Framework.
Answered by AI
Add your answer
Q3. Explain your GitHub project.
Ans. 
My GitHub project is a web application for tracking personal fitness goals and progress.
• Developed using HTML, CSS, JavaScript, and Salesforce Lightning Web Components

• Utilizes Salesforce platform for data storage and user authentication

• Includes features such as goal setting, progress tracking, and personalized workout plans
Answered by AI
Add your answer

Q1. What motivates you?
Add your answer
Q2. What are you most proud of?
Add your answer
Q3. What is one thing you think where there is room for improvement?
Ans. 
One area for improvement is the integration of AI and machine learning capabilities in Salesforce.
• Enhancing predictive analytics for better decision-making

• Automating repetitive tasks to increase efficiency

• Improving personalized customer experiences through AI-driven insights
Answered by AI
Add your answer

Q1. Do you currently have any offers : )
Ans. 
No, I do not currently have any offers.
• I am actively searching for opportunities in the Salesforce development field.

• I have been applying to various companies and attending interviews.

• I am eager to start my career as a Junior Salesforce Developer.
Answered by AI
Add your answer

Q1. Discuss with all KPI with manpower
Add your answer
Q2. Required to manage all fields work with vendor
Add your answer

Q1. Good communication skills with costomer
Add your answer
Q2. Need to do Hard work
Add your answer

Q1. What are the different optimization techniques used in your project
Add your answer
Q2. SQl logic question regarding joins
Add your answer