Providence Global Center Data Engineer Interview Questions and Answers

Q1. 3rd largest salary from each department(window function)
Add your answer

Q1. Explain process in 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 allows you to create data-driven workflows for orchestrating and automating data movement and data transformation.

• You can use ADF to ingest data from various sources, process and transform the data, and then publish the data to different destinations.

• ADF supports a wide range of d...read more
Answered by AI
Add your answer

Q1. Related to data warehouse
Add your answer

Q1. Python, data warehouse, data modelling
Add your answer

Q1. Tell us about yourself?
Add your answer
Q2. What are joins in sql?
Ans. 
Joins in SQL are used to combine data from two or more tables based on a related column.
• Joins are used to retrieve data from multiple tables in a single query

• Common types of joins include inner join, left join, right join, and full outer join

• Join conditions are specified using the ON keyword and a related column in each table

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer
Q3. Have you done any SQL projects?
Ans. 
Yes, I have worked on several SQL projects.
• Developed a database for a retail company to manage inventory and sales data using SQL Server

• Created complex queries to extract data from multiple tables for a financial services firm

• Optimized database performance by indexing and partitioning tables for a healthcare organization
Answered by AI
Add your answer
Q4. How will you remove duplicates in SQL?
Ans. 
Duplicates can be removed in SQL using DISTINCT keyword or GROUP BY clause.
• Use DISTINCT keyword to select unique values from a single column.

• Use GROUP BY clause to group rows with same values and select unique values from multiple columns.

• Use HAVING clause to filter out groups with count greater than 1.

• Use INNER JOIN to join tables and select unique values from multiple tables.

• Use ROW_NUMBER() function to assign a uniq...read more
Answered by AI
Add your answer
Q5. Are you a team player or an individual contributor?
Add your answer

Q1. Would you be comfortable working from Bangalore office?
Add your answer

Q1. Join two tables in pyspark code and dataframe
Ans. 
Join two tables in PySpark code and DataFrame
• Create two DataFrames from the tables

• Specify the join condition using join() function

• Select the columns to be displayed using select() function

• Use show() function to display the result
Answered by AI
Add your answer

Q1. What is the best place you visisted in pune
Add your answer

Q1. How much salary you are expectin herein the saama technoligies
Add your answer

A combination of aptitude and coding

Q1. Some python related question
Add your answer
Q2. Some SQL related question
Add your answer

Q1. Some python problem to solve
Add your answer
Q2. Some puzzle to answer
Add your answer

Q1. Questions about the tech skills you have
Add your answer

Q1. Salary discussion .
Add your answer

2 hr duration test it was. It had the topics like reasoning, number system. Technical section was also there which has sql questions

Q1. Based on my final year project. Some questions based the programming language I added in my resume and other questions asked on sql queries on joins, union, union all difference.
Add your answer
Q2. Then HR round was there in which asked some behavioral questions and tested some decision making skills
Add your answer
Q3. Tell me about your final year project is a common question that every interviewer ask for fresher
Add your answer
Q4. What is inheritance and type of inheritance? if you mentioned c or Java as your skill
Add your answer
Q5. Tell me about yourself?
Add your answer
Q6. What are your hobbies?
Add your answer
Q7. What is your salary expectation.
Add your answer
Q8. Are you willing to relocate?
Add your answer
Q9. Are you ready to sign agreement if there is any?
Add your answer
Q10. Tell me about your family background
Add your answer
Q11. Is there any for future studies
Add your answer