Nityo Infotech Data Engineer Interview Questions, Process, and Tips

Q1. What are joins and its type
Add your answer
Q2. Tell me about Dax query
Add your answer

Q1. Questions on Pyspark
Add your answer
Q2. Questions on SQL
Add your answer
Q3. Transformations
Add your answer
Q4. Questions on Sql optimizations
Add your answer
Q5. Questions About my current Project
Add your answer

Q1. SQL questions and partitioning
Add your answer
Q2. 3rd highest salary
Add your answer

Q1. Technical interview
Add your answer
Q2. SQL and data warehousing
Add your answer

Q1. What joins you used
Ans. 
I have used various types of joins including inner join, left join, right join, and full outer join.
• Used inner join to retrieve records that have matching values in both tables

• Utilized left join to retrieve all records from the left table and matching records from the right table

• Employed right join to retrieve all records from the right table and matching records from the left table

• Utilized full outer join to retrieve ...read more
Answered by AI
Add your answer
Q2. Write query for joins
Ans. 
Query for joins in SQL to combine data from multiple tables
• Use JOIN keyword to combine data from two or more tables based on a related column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id
Answered by AI
Add your answer

Just focus on the basics of pyspark.

There are one hour exam

Q1. Advance level of sql and python
Ans. 
Advanced level of SQL and Python skills are essential for a Data Engineer role.
• Strong understanding of SQL queries, joins, subqueries, and optimization techniques.

• Proficiency in writing complex Python scripts for data manipulation, analysis, and automation.

• Experience with data modeling, ETL processes, and working with large datasets.

• Knowledge of data warehousing concepts and tools like SQL Server, PostgreSQL, or Snowfl...read more
Answered by AI
Add your answer

Q1. Basic of SQL,some join condition
Add your answer
Q2. Basic of python
Add your answer

Q1. SQL, data modeling
Add your answer

Q1. Data pipeline and framework
Add your answer