Mindbare IT Solutions LLP Interview Questions and Answers

Q1. Tell me about yourself, and project architecture. What are your day-to-day responsibilities?
Ans. 
I am a Data Engineer with experience in designing and implementing project architectures. My day-to-day responsibilities include data processing, ETL tasks, and ensuring data quality.
• Designing and implementing project architectures for data processing

• Performing ETL tasks to extract, transform, and load data into the system

• Ensuring data quality and integrity through data validation and cleansing

• Collaborating with cross-...read more
Answered by AI
Add your answer
Q2. SQL: To calculate the difference in marks for each student ID and marks across different years?
Ans. 
Use SQL to calculate the difference in marks for each student ID across different years.
• Use a self join on the table to compare marks for the same student ID across different years.

• Calculate the difference in marks by subtracting the marks from different years.

• Group the results by student ID to get the difference in marks for each student.
Answered by AI
Add your answer
Q3. SQL: Statewise which gender purchase is the most?
Ans. 
The answer to the question is that in which state which gender makes the most purchases.
• Aggregate the data by state and gender to calculate the total purchases made by each gender in each state.

• Identify the gender with the highest total purchases in each state.

• Present the results in a table or chart for easy visualization.
Answered by AI
Add your answer
Q4. What is ADF ??
Ans. 
ADF stands for Azure Data Factory, a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.
• ADF is used for building, scheduling, and monitoring data pipelines to move and transform data from various sources to destinations.

• It supports data integration between various data stores such as Azure SQL Database, Azure Blob Storage, and on-premises data sources.

• ADF provides a visu...read more
Answered by AI
Add your answer
Q5. Pysaprk Coding Question?
Add your answer
Q6. What is DAG ??
Ans. 
DAG stands for Directed Acyclic Graph, a data structure used to represent dependencies between tasks in a workflow.
• DAG is a collection of nodes connected by edges, where each edge has a direction and there are no cycles.

• It is commonly used in data engineering for representing data pipelines and workflows.

• DAGs help in visualizing and optimizing the order of tasks to be executed in a workflow.

• Popular tools like Apache Ai...read more
Answered by AI
Add your answer
Q7. What is Lineage ??
Ans. 
Lineage refers to the history and origin of data, including its source, transformations, and dependencies.
• Lineage helps in understanding how data is generated, processed, and transformed throughout its lifecycle.

• It tracks the flow of data from its source to its destination, including any intermediate steps or transformations.

• Lineage is important for data governance, data quality, and troubleshooting data issues.

• Example...read more
Answered by AI
Add your answer
Q8. How does Spark handle fault tolerance?
Ans. 
Spark handles fault tolerance through resilient distributed datasets (RDDs) and lineage tracking.
• Spark achieves fault tolerance through RDDs, which are immutable distributed collections of objects that can be rebuilt if a partition is lost.

• RDDs track the lineage of transformations applied to the data, allowing lost partitions to be recomputed based on the original data and transformations.

• Spark also replicates data par...read more
Answered by AI
Add your answer
Q9. There are four cores and four worker nodes in Spark. How many jobs will run in parallel?
Ans. 
Only one job will run in parallel in Spark with four cores and four worker nodes.
• In Spark, each core can only run one task at a time, so with four cores, only four tasks can run concurrently.

• Since there are four worker nodes, each with four cores, a total of four tasks can run in parallel.

• Therefore, only one job will run in parallel in this scenario.
Answered by AI
Add your answer
Q10. What are the optimisation techniques you have used in your project ?
Ans. 
I have used techniques like indexing, query optimization, and parallel processing in my projects.
• Indexing: Used to improve the speed of data retrieval by creating indexes on columns frequently used in queries.

• Query optimization: Rewriting queries to improve efficiency and reduce execution time.

• Parallel processing: Distributing tasks across multiple processors to speed up data processing.

• Caching: Storing frequently acce...read more
Answered by AI
Add your answer

Q1. I am interested but I am fasher
Add your answer
Q2. I am interested but I am fasher
Add your answer

Q1. What is your work experience in gaming
Ans. 
I have 5 years of experience working as a Game Artist in the gaming industry.
• Worked on creating 2D and 3D assets for various game projects

• Collaborated with game designers and developers to ensure visual consistency

• Experience with game engines like Unity and Unreal Engine

• Created concept art, character designs, and environment assets

• Knowledge of animation and visual effects for games
Answered by AI
Add your answer
Q2. What is your salary expectation
Ans. 
My salary expectation is based on industry standards, my experience, and the responsibilities of the role.
• Research industry standards for Game Artists salaries

• Consider my level of experience and skills

• Factor in the responsibilities and requirements of the specific role

• Be open to negotiation based on benefits and other perks offered
Answered by AI
Add your answer

Design a character and Royal symbol (fully rendered in realistic style) and one Mid Pay concept sketch for slot game.

Q1. About yourself and experience
Add your answer
Q2. About assignment related questions
Add your answer
Q3. Some unprofessional questions
Add your answer

There were basic questions asked related to the profile

There were some questions and an ER diagram to create.

Q1. Tell me about yourself
Add your answer
Q2. They started asking about the projects
Add your answer

Q1. Describe about yourself
Add your answer
Q2. What is your role in your current project and explain the roles and responsibilities
Add your answer
Q3. Why would you like to explore other opportunities
Add your answer

Q1. Explain about the swift payment flows. Explain any one end to end payment flows
Ans. 
Swift payment flows refer to the process of transferring funds quickly and securely between financial institutions globally.
• Swift payment flows involve the sender initiating a payment instruction through their bank.

• The instruction is then sent to the recipient's bank via the SWIFT network.

• The recipient's bank verifies the payment details and credits the recipient's account.

• An example of an end-to-end payment flow is wh...read more
Answered by AI
Add your answer
Q2. What is your current test environment management tool and how does this help in your daily activities
Ans. 
Our current test environment management tool is Jenkins, which helps automate our testing processes and streamline our daily activities.
• Jenkins allows us to schedule and run automated tests, saving time and effort.

• It provides detailed reports on test results, helping us identify and fix issues quickly.

• We can integrate Jenkins with other tools like Jira for seamless workflow management.
Answered by AI
Add your answer
Q3. Are you aware of JIRA or any ticketing tools
Ans. 
Yes, I am aware of JIRA and have experience using ticketing tools in previous projects.
• Yes, I have used JIRA extensively in previous projects for tracking tasks and issues.

• I am familiar with creating, assigning, and tracking tickets in JIRA.

• I have also used other ticketing tools like Trello and Asana for project management.
Answered by AI
Add your answer
Q4. Explain yourself in just two words
Add your answer
Q5. What are your expectations from the team if we are releasing you the offer
Add your answer
Q6. Are you willing to work in US shift
Add your answer

Q1. Explain about yourself
Add your answer
Q2. Projects roles and responsibilities
Add your answer
Q3. Salary discussions
Add your answer

Q1. JavaScript concepts
Add your answer
Q2. JavaScript coding
Add your answer
Q3. Angular questions
Add your answer

Q1. Angular questions
Add your answer
Q2. Angular implementation explanation
Ans. 
Angular implementation explanation
• Angular is a popular front-end framework for building web applications

• Uses TypeScript for development

• Components, services, modules, and directives are key concepts in Angular

• Data binding, dependency injection, and routing are important features

• Example: Creating a new component in Angular - ng generate component my-component
Answered by AI
Add your answer

Q1. Casual questions and discussion
Add your answer

Q1. Salary discussion and casual discussion
Add your answer

Q1. Multi module maven project
Add your answer
Q2. Selenium project structure
Ans. 
Selenium project structure includes organizing test cases, page objects, utilities, and configuration files.
• Test cases should be organized in a separate folder

• Page objects should be stored in a separate package

• Utilities like helper classes, constants, and drivers should be in a separate package

• Configuration files like properties files should be stored in a separate folder

• Follow a modular approach for easy maintenance a
Answered by AI
Add your answer

Q1. How will you create a test plan ?
Ans. 
A test plan is created by defining objectives, scope, resources, schedule, and approach for testing.
• Define objectives and scope of testing

• Identify resources needed for testing

• Establish a schedule for testing activities

• Outline the approach and methodologies for testing

• Include risk assessment and mitigation strategies

• Document test scenarios, test cases, and test data

• Define roles and responsibilities of team members
Answered by AI
Add your answer
Q2. Scenario based questions
Add your answer

Q1. What are different KPI's
Ans. 
Key Performance Indicators (KPIs) are measurable values that demonstrate how effectively a company is achieving key business objectives.
• KPIs are specific, measurable, achievable, relevant, and time-bound metrics used to evaluate the success of an organization or a particular activity.

• Examples of KPIs include revenue growth rate, customer acquisition cost, customer retention rate, website traffic, conversion rate, and e
Answered by AI
Add your answer
Q2. Differentiate loc and iloc in pandas
Ans. 
loc is label-based indexing while iloc is integer-based indexing in pandas.
• loc is used to access a group of rows and columns by labels

• iloc is used to access a group of rows and columns by integer position

• Example: df.loc['row_label', 'column_label'] vs df.iloc[0, 1]
Answered by AI
Add your answer