Real Interview Questions

Can a foreign key have NULL and duplicate values?

✅

Sql Foreign Key Database Constraints

🟢 Easy Conceptual Junior Asked 1× Jul 2026

In Amazon EKS, how do you ensure high availability of components, and what happens if a component crashes?

✅

Eks High Availability Kubernetes

🟡 Medium System Design Mid Asked 1× Jul 2026

Do you schedule end‑to‑end flows in Databricks, for example ingesting data through an API, performing cleansing and transformations all the way to the core layer? Are these runs scheduled to execute daily or at specific intervals? If failures occur, how do you receive notifications and troubleshoot the issue?

✅

Databricks Etl Scheduling Job Monitoring Failure Handling Data Pipeline

🟡 Medium Conceptual Mid Asked 1× Jul 2026

Shubhi, the question is simple: When a modeler is giving a proposal to someone, should they structure the table and approach with technical rationale? Which platform are you using? In Databricks, if you are giving someone a model that works on finance data and the requirement is to maintain history, from an implementation point of view, what is the underlying architecture of Databricks?

✅

Databricks Data Modeling Data Warehousing History Maintenance

🟡 Medium Conceptual Mid Asked 1× Jul 2026

When executing a Firetron job, if it fails due to a platform issue, what steps would you consider to recover the data?

✅

Data Recovery Job Failure Etl

🟡 Medium Conceptual Mid Asked 1× Jul 2026

In an automated data workflow, how would you handle scenarios where the job fails, data corruption occurs, or the process goes out of sync? What steps would you take to mitigate impact and ensure data loads continue correctly?

✅

Workflow Automation Failure Handling Data Integrity

🟡 Medium Debugging Mid Asked 1× Jul 2026

If a job fails in a production workflow, what recommendations would you make for manual intervention? How would you prevent disruption to the data in the tables, and what scenarios should you consider?

✅

Job Failure Production Data Manual Intervention

🟡 Medium Debugging Mid Asked 1× Jul 2026

Avinash, which domains or industries have you had experience in?

✅

Domain Experience Industry Experience

🟢 Easy Behavioral Mid Asked 1× Jul 2026

Can you tell me about DAGs in Airflow?

✅

Airflow Dag Workflow Orchestration

🟢 Easy Conceptual Fresher Asked 1× Jul 2026

What are the three terms in databases and data warehouses: consistency, availability, and partition tolerance?

✅

Cap Theorem Consistency Availability Partition Tolerance

🟢 Easy Conceptual Fresher Asked 1× Jun 2026

What is the project domain?

✅

Domain Knowledge Project Management

🟢 Easy Conceptual Fresher Asked 1× Jun 2026

Have you had any exposure to AirNode?

✅

Airnode

🟢 Easy Behavioral Junior Asked 1× Jun 2026

Were the data sources known? Was the data loaded? Which scheduling orchestration did you use, as mentioned Airflow?

✅

Airflow Data Orchestration Data Pipelines

🟡 Medium Conceptual Junior Asked 1× Jun 2026

Do you have experience working in the healthcare domain?

✅

Healthcare Domain Experience

🟢 Easy Behavioral Junior Asked 1× Jun 2026

Do you have knowledge about the banking domain?

✅

Banking Domain Knowledge

🟢 Easy Behavioral Junior Asked 1× Jun 2026

Did you handle pipeline failures?

✅

Devops Pipeline Failure Handling

🟡 Medium Behavioral Mid Asked 1× May 2026

What types of tasks are used in an Airflow DAG? Does a DAG completely depend on its tasks?

✅

Airflow Dag Task

🟡 Medium Conceptual Junior Asked 1× May 2026

How have you used Airflow to orchestrate end‑to‑end data pipelines, for example, extracting data from DMS and loading it into downstream systems?

✅

Airflow Data Pipeline Dms

🟡 Medium Other Mid Asked 1× May 2026

Explain job orchestration. In job orchestration, there are various methods such as Airflow, Glue, Lambda, Step Functions, etc. Can you explain when you would use each?

✅

Job Orchestration Airflow Aws Glue Aws Lambda Aws Step Functions

🟡 Medium Conceptual Junior Asked 1× May 2026

Were there any guidelines for Redshift maintenance, such as do's and don'ts? Are there recommended practices to reclaim space and reduce overhead?

✅

Redshift Database Maintenance Aws

🟡 Medium Conceptual Mid Asked 1× May 2026