PubMatic Big Data Engineer Interview Questions, Process, and Tips

Q1. Components of Databricks
Add your answer
Q2. How to read a json file
Add your answer
Q3. Second highest salary SQL
Add your answer
Q4. How to configure the spark while creating the cluster
Add your answer

Medium level of coding questions.

Q1. About azure data factory
Add your answer
Q2. How to copy multiple csv into single file
Ans. 
Use a command line tool like cat to concatenate multiple CSV files into a single file
• Use the cat command in the terminal to concatenate multiple CSV files into a single file

• Navigate to the directory where the CSV files are located

• Run the command 'cat file1.csv file2.csv > combined.csv' to merge file1.csv and file2.csv into a new file named combined.csv
Answered by AI
Add your answer

Q1. What is hdinsights in azure data factory
Ans. 
HDInsight is a cloud-based service in Azure that makes it easy to process big data using Apache Hadoop, Spark, and other tools.
• HDInsight is a fully managed cloud service that makes it easy to process big data using open-source frameworks like Apache Hadoop, Spark, and more.

• It allows you to create, scale, and monitor Hadoop clusters in Azure.

• HDInsight integrates with Azure Data Factory to provide data orchestration and ...read more
Answered by AI
Add your answer
Q2. How to perform data copy in azure
Ans. 
Data copy in Azure can be performed using Azure Data Factory or Azure Storage Explorer.
• Use Azure Data Factory to create data pipelines for copying data between various sources and destinations.

• Use Azure Storage Explorer to manually copy data between Azure storage accounts.

• Utilize Azure Blob Storage for storing the data to be copied.
Answered by AI
Add your answer

Q1. Expectations in the company
Add your answer
Q2. Ctc and relevant stuff
Add your answer

Q1. What is RAG ?
Ans. 
RAG stands for Red, Amber, Green and is a color coding system used to indicate the status of a project or task.
• RAG is commonly used in project management to quickly communicate the status of different tasks or projects.

• Red typically indicates that a task or project is behind schedule or facing significant issues.

• Amber signifies that there are some concerns or risks that need to be addressed.

• Green means that a task or p...read more
Answered by AI
Add your answer
Q2. How you trainined LLM model?
Ans. 
I trained the LLM model using a combination of labeled data, feature engineering, and iterative model tuning.
• Collected and preprocessed labeled data for training

• Performed feature engineering to extract relevant features

• Used iterative model tuning to optimize performance

• Evaluated model performance using metrics like accuracy, precision, and recall
Answered by AI
Add your answer

Q1. Can you tell me about yourself?
Add your answer

Basic aptitude question

Q1. Basic analysis and ML questions , more focused on approach instead of coding
Add your answer

Q1. As like other HR rounds
Add your answer

Online aptitude test have been coundected

Q1. About the data procesig and projects on data science
Add your answer

Q1. Fresher or experienced
Add your answer

In this test they asked about basic internet knowledge like what is domain and co domain. And how to get the details of a company and cross check them. And basic ms office knowledge to work on given files.

Q1. Why do you wanna work here.
Ans. To achieve my goals while helping the company to grow.
Answered Anonymously
View 2 more answers
Q2. What you see yourself after 2 years.
Ans. To be at higher position in this company.
Answered Anonymously
Add your answer
Q3. Why do you want to work in this field.
Ans. Because it's an great opportunity to earn while learning and growing.
Answered Anonymously
Add your answer