Meltek Infosystems 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. Questions related to Linux
Add your answer
Q2. SQL basic Queries
Add your answer
Q3. Troubleshooting Scenarios
Add your answer

Q1. Join Queries of Sql
Ans. 
Join queries in SQL are used to combine rows from two or more tables based on a related column between them.
• Use JOIN keyword to combine rows from two or more tables based on a related column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Specify the columns to join on using ON clause

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer
Q2. Project releted question
Add your answer

Q1. Client side discussion
Add your answer
Q2. Growth opportunities
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

Leetcode easy and medium questions. It was easy to clear

Q1. Dry run bubble and insertion sort
Add your answer
Q2. One SQL query easy level
Add your answer

Q1. Discussion about projects
Add your answer
Q2. Do you have any questions
Add your answer

Q1. Tell me about yourself?
Ans. 
Experienced finance professional with a strong background in financial analysis and strategic planning.
• Over 10 years of experience in finance roles

• Expertise in financial modeling and forecasting

• Proven track record of improving financial performance

• Strong analytical skills and attention to detail

• Effective communicator and team player
Answered by AI
Add your answer
Q2. Why did you left your last company
Ans. 
Seeking new challenges and growth opportunities in a larger organization.
• Desire for career advancement

• Limited growth opportunities in previous company

• Seeking new challenges and experiences
Answered by AI
Add your answer

Q1. What are different sections of TDS and rate?
Ans. 
Different sections of TDS include salary, interest on securities, dividends, etc. Rates vary based on the type of payment.
• Section 192: TDS on salary

• Section 194A: TDS on interest other than interest on securities

• Section 194B: TDS on winnings from lotteries, crossword puzzles, etc.

• Section 194C: TDS on payment to contractors and sub-contractors

• Section 194J: TDS on professional or technical services

• Rates vary from 1% to 30...read more
Answered by AI
Add your answer
Q2. Some related journal entries
Add your answer

Q1. Some related journal entries
Add your answer
Q2. What procedure you implemented in your previous organisation and specially any automation
Ans. 
Implemented automated financial reporting system to streamline processes and improve accuracy.
• Implemented automated financial reporting system using software like SAP or Oracle

• Developed custom scripts to automate data entry and reconciliation processes

• Integrated financial systems to eliminate manual data transfer errors

• Trained team members on new procedures and software usage for efficient implementation
Answered by AI
Add your answer

Q1. It was a online coding round with one question related to a medium hard binary search question..
Add your answer
Q2. The second question was bit ambiguous question involving a tree, where we were asked to add a tree child and subchild in the form a a directory and subdirectory
Add your answer

Q1. What is your experience with parallelizing transformers, and how do you approach splitting them across multiple devices to minimize latency?
Ans. 
I have experience parallelizing transformers by splitting them across multiple devices to minimize latency.
• I have utilized frameworks like TensorFlow and PyTorch to parallelize transformers.

• I approach splitting transformers by dividing the input data into chunks and distributing them across devices.

• I optimize communication overhead by minimizing data transfer between devices.

• I leverage techniques like data parallelism ...read more
Answered by AI
Add your answer

Html css syntax and properties, basic JavaScript , database queries

Q1. Salary expectation
Add your answer