Presidio Solutions Pvt Ltd Data Engineer Interview Questions and Answers

Q1. What is Informatica tool
Ans. 
Informatica is a data integration tool used for ETL (Extract, Transform, Load) processes in data engineering.
• Informatica is used for extracting data from various sources like databases, flat files, etc.

• It can transform the data according to business rules and load it into a target data warehouse or database.

• Informatica provides a visual interface for designing ETL workflows and monitoring data integration processes.

• It ...read more
Answered by AI
Add your answer
Q2. What is Datastage tool
Ans. 
Datastage is an ETL tool used for extracting, transforming, and loading data from various sources to a target destination.
• Datastage is part of the IBM Information Server suite.

• It provides a graphical interface to design and run data integration jobs.

• Datastage supports parallel processing for high performance.

• It can connect to a variety of data sources such as databases, flat files, and web services.

• Datastage jobs can b...read more
Answered by AI
Add your answer

1hour,Time speed distance

1hour,sql,python,algebra,Average

General Aptitude test

Q1. On SQL functions
Add your answer
Q2. Python coding questions
Add your answer

Q1. Databricks compute and config
Add your answer
Q2. Dremio optimization process and.migration
Add your answer

Q1. Data Engineering and Data modelling
Add your answer

Q1. People management and salary
Add your answer

Q1. Project history
Add your answer
Q2. Tech stack used
Ans. 
Our tech stack includes Python, SQL, Apache Spark, Hadoop, AWS, and Docker.
• Python is used for data processing and analysis

• SQL is used for querying databases

• Apache Spark is used for big data processing

• Hadoop is used for distributed storage and processing

• AWS is used for cloud infrastructure

• Docker is used for containerization
Answered by AI
Add your answer

Q1. Handled team or not?
Add your answer
Q2. Project experience
Add your answer

Q1. Spark and airflow related questions
Add your answer
Q2. AWS services and it's related questions
Add your answer

Q1. Sql joins,dense rank and rank,window function
Add your answer

Coding round with a python question and SQL query

Q1. Technical question and a coding question in python, medium level
Add your answer