Principal Global Services Data Analyst Interview Questions and Answers

Q1. What are your strengths and how do you contribute to guardian?
Add your answer

Q1. General - about you, work experience etc
Add your answer
Q2. Willingness to work in night shifts
Add your answer

Q1. They check your English basically
Add your answer
Q2. Ability to read and write English and articulate your thoughts
Add your answer

Questions on investments

Company valuation to submit

Q1. What you know about data pipelines in Azure
Ans. 
Data pipelines in Azure are used to automate the movement and transformation of data from various sources to destinations.
• Data pipelines in Azure can be created using Azure Data Factory, which allows users to create, schedule, and manage data pipelines.

• They can be used to ingest data from various sources such as databases, files, and streaming services, and load it into data warehouses or data lakes.

• Azure Data Factory ...read more
Answered by AI
Add your answer
Q2. Logic app in Azure
Ans. 
Logic Apps in Azure are a cloud service that helps you automate and orchestrate tasks, business processes, and workflows.
• Logic Apps are used to automate workflows and integrate apps, data, systems, and services across enterprises or organizations.

• They provide a visual designer to model and automate your process as a series of steps known as a workflow.

• Logic Apps can connect to a wide variety of services and application...read more
Answered by AI
Add your answer

Q1. Tell me about your self?
Add your answer
Q2. What is SQL and diffrent joins in SQL?
Ans. 
SQL is a programming language used for managing and manipulating relational databases. Different joins in SQL include inner join, outer join, left join, and right join.
• SQL is a standard programming language for managing and manipulating relational databases.

• Different types of joins in SQL include inner join, outer join, left join, and right join.

• Inner join returns rows when there is at least one match in both tables.

• Ou...read more
Answered by AI
Add your answer
Q3. How to separate portion before @ and after @ from mail using python?
Ans. 
Use Python to separate portion before and after @ in an email address.
• Use the split() method to separate the email address into two parts based on the @ symbol.

• Access the parts using index 0 for the portion before @ and index 1 for the portion after @.

• Example: email = 'example@email.com'; parts = email.split('@'); before = parts[0]; after = parts[1];
Answered by AI
Add your answer
Q4. What is the rank, Dense Rank and Row Number?
Ans. 
Rank, Dense Rank, and Row Number are functions used in SQL to assign a ranking to rows in a result set.
• Rank function assigns a unique rank to each row based on the specified column values.

• Dense Rank function assigns a unique rank to each row without any gaps.

• Row Number function assigns a sequential integer to each row in the result set.
Answered by AI
Add your answer

Basic 10 apti question

Basic 5 python question

Basic 5 SQL question

Q1. They asked two python program.
Add your answer

Q1. They asked one SQL question
Add your answer

Q1. Just question based on my resume.
Add your answer

Q1. Regularizaion, model improvemnts
Add your answer
Q2. Hyperparameter tuning
Add your answer