Miamin Systems Inc Interview Questions and Answers

Q1. All employees having same salary in the smae department sql and pysprk
Add your answer
Q2. How to create pipeline in databricks
Ans. 
To create a pipeline in Databricks, you can use Databricks Jobs or Apache Airflow for orchestration.
• Use Databricks Jobs to create a pipeline by scheduling notebooks or Spark jobs.

• Utilize Apache Airflow for more complex pipeline orchestration with dependencies and monitoring.

• Leverage Databricks Delta for managing data pipelines with ACID transactions and versioning.
Answered by AI
Add your answer
Q3. Palindrome, 2nd char in every word make is to upper case, sql rank and dense rank releated questions , given 2 tables country and city we need to calculate total population in each continent by joining the...read more
Add your answer
Q4. String manuplation questions inpython
Add your answer

Q1. What are Agile Values? Scrum Values? Scrum Ceremonies? Story Points?
Ans. 
Agile values include individuals and interactions over processes and tools, while Scrum values include commitment, courage, focus, openness, and respect.
• Agile values prioritize individuals and interactions over processes and tools

• Scrum values include commitment, courage, focus, openness, and respect

• Scrum ceremonies include Sprint Planning, Daily Standup, Sprint Review, and Sprint Retrospective

• Story points are a unit of...read more
Answered by AI
Add your answer
Q2. As project manager what docs do you prepare? How do you contribute as a PM?
Ans. 
As a project manager, I prepare various documents such as project plans, schedules, budgets, risk assessments, and progress reports. I contribute by leading the team, managing resources, and ensuring project success.
• Prepare project plans outlining scope, objectives, deliverables, and timelines

• Create schedules to allocate tasks and track progress

• Develop budgets to manage project costs effectively

• Conduct risk assessments...read more
Answered by AI
Add your answer
Q3. Capacity? Velocity? etc Agile/Scrum-based questions (bookish) this round was taken by Rajni
Add your answer

Q1. Megha took my final round and asked me questions about Agile/Scrum, Stroy Points (estimation).
Add your answer
Q2. Ques on explaining Sprint Planning, Retro, Review, using Doc/Excel (screen sharing)
Add your answer
Q3. Ques on Conflict and Resource Management, some scenario-based question.
Add your answer
Q4. How will you make a low-performing resource a high-performing one?
Ans. 
Provide clear expectations, offer support and training, provide feedback and recognition, set goals and milestones.
• Clearly communicate expectations and goals to the resource.

• Offer support and training to help the resource improve their skills and knowledge.

• Provide regular feedback and recognition for progress made.

• Set specific goals and milestones to track improvement.

• Create a development plan with the resource to addr...read more
Answered by AI
Add your answer
Q5. Megha did not hire me because she felt I had adequate knowledge and practical experience. (insecurities) Anyway, good luck with your interview.
Add your answer
Q6. What is Scrum of Scrums? What is PI planning?
Ans. 
Scrum of Scrums is a scaled agile framework where multiple Scrum teams coordinate their work. PI planning is a key event in SAFe where teams plan their work for the upcoming Program Increment.
• Scrum of Scrums involves representatives from each Scrum team meeting regularly to discuss dependencies and progress.

• PI planning is a two-day event where teams align on their objectives, dependencies, and priorities for the upcomi...read more
Answered by AI
Add your answer

They asked some general Quantitative and logical questions and code snippets.

Q1. String Reverse and Two Sum
Add your answer
Q2. Related to my projects and Tech Stacks
Add your answer

Q1. This is the Second technical round. The interviewer asked about everything from my project.
Add your answer
Q2. Asked some sql queries like joins and set operation
Add your answer

Code Snept question with 3-4 Reasoning question. Google form

Pen paper coding round. String , Array . Linkedlist , graph, questions

Q1. Maximum Spaning
Add your answer
Q2. Nearest Prime number
Ans. 
To find the nearest prime number, iterate from the given number in both directions until a prime number is found.
• Start iterating from the given number in both directions to find the nearest prime number.

• Check if a number is prime by dividing it by all numbers less than its square root.

• Keep track of the closest prime number found during the iteration.
Answered by AI
Add your answer
Q3. Second Maximum Number in Array
Ans. 
Find the second maximum number in an array of strings.
• Convert the array of strings to an array of integers.

• Sort the array in descending order.

• Return the second element in the sorted array.
Answered by AI
Add your answer

Q1. Project Question
Add your answer
Q2. Robot question of DSA
Add your answer
Q3. Stock Buy and sell - VI . Leetcode Hard
Add your answer
Q4. Leetcode Medium
Add your answer

Q1. Bias variance trade off
Add your answer
Q2. What is AB testing
Ans. 
AB testing is a method used to compare two versions of a webpage or app to determine which one performs better.
• AB testing involves creating two versions (A and B) of a webpage or app with one differing element

• Users are randomly assigned to either version A or B to measure performance metrics

• The version that performs better in terms of the desired outcome is selected for implementation

• Example: Testing two different call...read more
Answered by AI
Add your answer
Q3. Basic traditional ML question about ML metrics, bagging boosting etc.
Add your answer

It was a classification problem

Q1. Questions about assignment
Add your answer
Q2. Questions from resume.
Add your answer
Q3. Questions based on probability, statistics and loss functions
Add your answer

Assignment includes Aptitude, Reasoning, 1 Coding Question (Medium Level), 1 SQL Query based Q and an essay writing (3 essays in 15 minutes each of atleast 200 Words).

Q1. Introduction and why not Java?
Ans. 
Java is a popular programming language, but other languages may be more suitable for certain projects or preferences.
• Java is a statically typed language, which may lead to more verbose code compared to dynamically typed languages like Python or JavaScript.

• Some developers prefer languages like Python for data analysis and machine learning projects due to its extensive libraries and ease of use.

• For web development, JavaS...read more
Answered by AI
Add your answer
Q2. Tell about JDBC,JVM, JDK, JRE, Servlets etc. only a bit as i am not from java background.
Ans. 
JDBC, JVM, JDK, JRE, and Servlets are key components in Java development.
• JDBC (Java Database Connectivity) is used to connect Java applications to databases.

• JVM (Java Virtual Machine) is the runtime environment for Java programs.

• JDK (Java Development Kit) is a software development kit for developing Java applications.

• JRE (Java Runtime Environment) is required to run Java applications on a computer.

• Servlets are Java cla...read more
Answered by AI
Add your answer
Q3. Tell about OOPS in C++ (Static Keyword, 4 Pillars,Class vs Struct).
Add your answer
Q4. Code on online compiler for Overloading and overriding of functions.
Ans. 
Overloading and overriding are two important concepts in object-oriented programming that allow functions to have multiple definitions.
• Overloading: defining multiple functions with the same name but different parameters

• Example: int add(int a, int b) and int add(int a, int b, int c)

• Overriding: redefining a function in a subclass that is already defined in the superclass

• Example: superclass has a method display() and subc
Answered by AI
Add your answer
Q5. 4 SQL Queries based on simple concepts and Syntax based Q on View, Alter, Create Db etc.
Add your answer
Q6. Eager to learn Java and why choose MongoDb.
Ans. 
I am eager to learn Java because of its widespread use in software development. I choose MongoDB for its flexibility and scalability in handling large volumes of data.
• Java is a popular programming language used for developing a wide range of applications, from web to mobile.

• Learning Java will open up opportunities for me to work on various projects and collaborate with other developers.

• MongoDB is a NoSQL database known...read more
Answered by AI
Add your answer

Q1. Introduction about myself
Add your answer
Q2. What you know about the role
Add your answer
Q3. What you know about revature working and clients.
Add your answer
Q4. About salary structure and willing to relocate.
Add your answer
Q5. About siblings and fight with them
Add your answer
Q6. Will tell the results after 3 Weeks and that's it.
Add your answer

**1st Round: Online Assessment**
The first elimination round consisted of an online assessment focused on HTML, CSS, and JavaScript. The questions ranged from basic to advanced, with a significant emphasis on JavaScript concepts like promises and async operations. This round included negative marking, so accuracy was key.

**2nd Round: DSA Online Test**
The second elimination round tested Data Structures and Algorithms (DSA). It involved two compulsory problems: one focused on string manipulation and the other on array manipulation, both requiring solutions with O(1) space complexity.

**3rd Round: Personality Test**
This non-elimination round assessed grammar and communication skills. It included:
- Fill-in-the-blank questions focused on subject-verb agreement.
- Sentence repetition tasks where we had to listen and repeat the given sentences.
- Audio-based tasks requiring us to repeat sentences after listening to them.

**4th Round: Home Assignment**
In this elimination round, we were tasked with cloning a webpage using only HTML, CSS, and JavaScript. The goal was to create a pixel-perfect design without the use of frameworks or libraries like Bootstrap.

Candidates who cleared this round invited to the JTG campus for further process.

**5th Round: DSA **
This elimination round began with solving DSA problems focused on string and array manipulation.

**6th Round: Live Coding Assignment**
Round 5th was followed by a live coding task where we had to build a to-do application using only HTML, CSS, and JavaScript. The application needed to leverage local storage for data persistence. The technical interview in this round was based on the live coding task.

Q1. **6th and 7th Rounds: Technical Interviews** The next two elimination rounds were back-to-back technical interviews. They covered advanced concepts in HTML, CSS, and JavaScript, along with DSA problems.
Add your answer

Q1. **9th Round: HR Interview** The final round was an HR interview, where the focus was on personality traits, career aspirations, and alignment with the company’s values. **Verdict: Selected**
Add your answer