Atlassian MIS Executive Interview Questions and Answers

There is a test where you build data pipeline

Q1. Streaming use case with spark
Ans. 
Spark can be used for real-time data processing in streaming use cases.
• Spark Streaming allows for processing real-time data streams.

• It can handle high-throughput and fault-tolerant processing.

• Examples include real-time analytics, monitoring, and alerting.
Answered by AI
View 1 more answer

The group discussion (GD) round is expected to last 20 minutes. The topics were straightforward and easily comprehensible. The primary focus when participating in the GD should be on English fluency. It is not primarily about how content-rich or intellectually impressive your speech is, but rather about the level of fluency in communication.

Q1. Most of the questions will be based on our resume.
Add your answer

It was well designed

Q1. Basic Questions about data warehousing
Add your answer
Q2. Dbt Scenarios
Add your answer

Q1. Explain surrogate key
Ans. 
Surrogate key is a unique identifier used in databases to uniquely identify each record in a table.
• Surrogate keys are typically generated by the system and have no business meaning.

• They are used to simplify database operations and improve performance.

• Example: Using an auto-incrementing integer column as a surrogate key in a table.
Answered by AI
Add your answer

Basic Python, SQL, and Bash questions

Q1. SQL questions with operations that include changing from string to array. Tip: stick to RDBMS-specific dialects only (like Postgres), I used Spark SQL
Add your answer
Q2. Simple Python questions with a follow-up to optimise it
Add your answer
Q3. Bash script-based questions, are pretty basic.
Add your answer
Q4. Data pipeline design and best practices.
Ans. 
Data pipeline design involves creating a system to efficiently collect, process, and analyze data.
• Understand the data sources and requirements before designing the pipeline.

• Use tools like Apache Kafka, Apache NiFi, or AWS Glue for data ingestion and processing.

• Implement data validation and error handling mechanisms to ensure data quality.

• Consider scalability and performance optimization while designing the pipeline.

• Doc...read more
Answered by AI
Add your answer

Q1. Easy to medium Leetcode-based question. With moderate difficulty.
Add your answer
Q2. Simple Python-based question with optimisation.
Add your answer
Q3. Design specific questions based on Data pipelines.
Add your answer

Q1. SQL-based question with moderate difficulty.
Add your answer
Q2. Python-based questions, follow questions with some optimisations.
Add your answer
Q3. Bash-script based round.
Add your answer

Q1. What is bigadata
Ans. 
Big data refers to large and complex data sets that are difficult to process using traditional data processing applications.
• Big data involves large volumes of data

• It includes data from various sources such as social media, sensors, and business transactions

• Big data requires specialized tools and technologies for processing and analysis
Answered by AI
Add your answer
Q2. How spark works
Ans. 
Spark is a distributed computing framework that processes big data in memory and is known for its speed and ease of use.
• Spark is a distributed computing framework that can process data in memory for faster processing.

• It uses Resilient Distributed Datasets (RDDs) for fault-tolerant distributed data processing.

• Spark provides high-level APIs in Java, Scala, Python, and R for ease of use.

• It supports various data sources li...read more
Answered by AI
Add your answer
Q3. Explain your application
Ans. 
Our application is a data engineering platform that processes and analyzes large volumes of data to provide valuable insights.
• Our application uses various data processing techniques such as ETL (Extract, Transform, Load) to clean and transform raw data into usable formats.

• We utilize big data technologies like Hadoop, Spark, and Kafka to handle large datasets efficiently.

• The application also includes machine learning al...read more
Answered by AI
Add your answer

Factorial coding questions and SQL coding questions using group by

Q1. Java questions on oops concepts
Add your answer
Q2. SQL questions on having clause
Add your answer

Q1. Can you relocate
Add your answer
Q2. Brief info about amdocs
Ans. 
Amdocs is a software and services provider for communications, media, and entertainment industries.
• Founded in 1982 in Israel

• Headquartered in Chesterfield, Missouri

• Provides customer experience solutions for telecom companies

• Offers services such as billing, CRM, and data analytics
Answered by AI
Add your answer

Q1. Project discussion
Add your answer
Q2. SQL
Add your answer