Senior DBA and Data Engineer

filter-iconFilter interviews by

Senior DBA and Data Engineer Interview Questions and Answers

Updated 3 May 2024

Popular Companies

Q1. How would you design an inhouse data catalogueing tool using avaialble open source technologies

Ans.

Designing an inhouse data cataloguing tool using open source technologies

  • Identify the data sources and types to be catalogued

  • Choose a metadata schema and define the attributes to be captured

  • Select an open source tool for metadata management, such as Apache Atlas or Metacat

  • Integrate the tool with the data sources and automate metadata capture

  • Implement a search and discovery interface for users to access the catalogued data

Q2. Design an Azure based Architecture for ingesting data from on prem sql servers to a azure generation 2 datalakes

Ans.

Design Azure architecture for ingesting data from on-prem SQL servers to Azure Gen 2 datalakes

  • Create a virtual network to connect on-premises SQL servers to Azure

  • Use Azure Data Factory to move data from on-premises SQL servers to Azure Data Lake Gen 2

  • Use Azure Data Factory to schedule data ingestion jobs

  • Use Azure Data Factory to transform data before ingestion

  • Use Azure Data Factory to monitor data ingestion jobs

  • Use Azure Data Factory to trigger alerts in case of job failures

Q3. Why dualtricks software?

Ans.

Dualtricks software offers cutting-edge technology solutions and a collaborative work environment.

  • Innovative technology solutions

  • Collaborative work environment

  • Opportunities for growth and learning

  • Strong company culture

Are these interview questions helpful?
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Interview experiences of popular companies

4.2
 • 201 Interviews
3.4
 • 17 Interviews
4.0
 • 6 Interviews
View all

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary

Recently Viewed
JOBS
Radisson Hotels
No Jobs
SALARIES
Barbeque Nation
SALARIES
Sterling Holiday Resort
JOBS
Hindustan Unilever
No Jobs
SALARIES
Jubilant Foods Works
SALARIES
Marriott International
JOBS
Veerya Attachments
No Jobs
SALARIES
Lemon Tree Hotels
DESIGNATION
SALARIES
Barbeque Nation
Senior DBA and Data Engineer Interview Questions
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+

Reviews

4 L+

Interviews

4 Cr+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter