ITC Infotech Data Engineer Interview Questions and Answers

I have worked with Azure Data Factory, Azure Databricks, and Azure SQL Database.

• Azure Data Factory for data integration and orchestration

• Azure Databricks for big data processing and analytics

• Azure SQL Database for relational database management

Use SQL query to find the product with the second highest total price.

• Use the ORDER BY clause to sort the products by total price in descending order

• Use the LIMIT clause to select the second row after sorting

I have worked on various AWS services including S3, EC2, Lambda, Glue, and Redshift.

• S3 - Used for storing and retrieving data

• EC2 - Used for running virtual servers

• Lambda - Used for serverless computing

• Glue - Used for ETL (Extract, Transform, Load) processes

• Redshift - Used for data warehousing and analytics

Worked on ETL projects involving data extraction, transformation, and loading using SQL proficiency.

• Developed ETL pipelines to extract data from various sources such as databases, APIs, and flat files

• Transformed the extracted data using SQL queries to meet business requirements

• Loaded the transformed data into a data warehouse or other target systems

• Optimized SQL queries for performance and efficiency

• Collaborated with c...read more