Top 10 Infosys Azure Data Factory & Azure Databricks Interview Questions (2026)
Prepare for Infosys Azure Data Engineer interviews with the most frequently asked Azure Data Factory, Azure Databricks, ADLS Gen2, Delta Lake, PySpark, SQL and ETL interview questions.
Top 5 Infosys Azure Data Engineer Interview Questions
Infosys Azure Data Engineer interviews focus on Azure Data Factory, Azure Databricks, ADLS Gen2, Azure SQL Database, and production ETL scenarios. Candidates are expected to explain real-world implementations along with Azure best practices.
1. What is the difference between a Job Cluster and an Interactive Cluster in Azure Databricks?
A Job Cluster is created only when a job starts and is automatically terminated after completion, making it suitable for scheduled production workloads. An Interactive Cluster remains active until it is manually stopped and is mainly used for development, testing, debugging, and exploratory data analysis.
2. How do you copy multiple tables using metadata-driven pipelines in Azure Data Factory?
Store source and target table information in a metadata table or configuration file. Use a Lookup activity to read the metadata, iterate through each table using a ForEach activity, and execute a parameterized Copy Activity. Dynamic datasets and linked services make the pipeline reusable for multiple tables without creating separate pipelines.
3. How do you implement data encryption in Azure SQL Database?
Azure SQL Database uses Transparent Data Encryption (TDE) to protect data at rest and Transport Layer Security (TLS) to secure data in transit. Encryption keys can be managed using Azure Key Vault for enhanced security and key rotation.
4. Write a Python program to generate Fibonacci numbers.
def generate_fibonacci(n):
fib = [0, 1]
for i in range(2, n):
fib.append(fib[i - 1] + fib[i - 2])
return fib[:n]
print(generate_fibonacci(10))
# Output:
# [0, 1, 1, 2, 3, 5, 8, 13, 21, 34]5. What are the best practices for optimizing storage costs in ADLS Gen2?
Optimize storage costs by enabling lifecycle management policies to move inactive data to Cool or Archive tiers, storing data in compressed formats such as Parquet or Delta, partitioning data for efficient querying, removing obsolete files, and continuously monitoring storage usage using Azure Cost Management.
Interview Tip
Infosys interviewers often expect practical answers. Explain the business requirement, Azure services used, implementation approach, security measures, optimization techniques, and the business outcome whenever answering scenario-based questions.