Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
Job description
Location: Mumbai, India
Location: UAE-based (Travel required)
Duration: 6-month assignment
Summary (Data Engineer)
Timely, reliable data pipelines are what turn a platform design into business value. The Data Engineer builds and operates the pipelines that move data from source systems into the lakehouse and on to analytics and AI consumers, ensuring that the pipelines are automated, performant, secure and governed. The role works alongside the data architect, data quality engineer, business analysts and AI engineers, delivering production-grade pipelines on Azure / Microsoft Fabric, with metadata and lineage captured in Microsoft Purview.
Responsibilities
Build batch, incremental, CDC and streaming ingestion pipelines from source systems into the Bronze layer, using Azure Data Factory and Fabric pipelines.
Develop Silver- and Gold-layer transformations in SQL, PySpark and Spark notebooks, including cleansing, conformance, enrichment and business-rule logic.
Implement dimensional models, SCDs, surrogate keys and data marts according to the architect's designs.
Integrate DQ checks, validation, quarantine and reconciliation into pipelines in partnership with the Senior Data Quality Engineer.
Ensure that pipelines publish metadata and lineage to Microsoft Purview.
Implement scheduling, dependency management, parameterization, error handling and alerting.
Optimize pipelines, partitioning, file formats (Delta/Parquet) and compute usage for performance and cost efficiency.
Apply access controls, masking, encryption and secure credential management in line with UAE PDPL, the Dubai Data Law and DESC ISR.
Maintain code in source control and deploy through CI/CD pipelines, with automated tests and environment promotion.
Support production operations, incident resolution and runbooks, and coach counterparts so that the pipelines can be sustained after handover.
Must Have
4+ years in data engineering, preferably within UAE government or regulated-sector environments.
Advanced SQL, Python and PySpark/Spark skills.
Hands-on experience with Azure Data Factory, Microsoft Fabric, Databricks or Synapse.
Strong understanding of Lakehouse/Medallion architecture, Delta/Parquet formats and dimensional modelling, including SCDs and surrogate keys.
Experience with CI/CD (Azure DevOps or GitHub), source control and DataOps practices.
Familiarity with Microsoft Purview metadata and lineage, and with DQ tooling.
Awareness of UAE data regulation, including UAE PDPL, the Dubai Data Law and DESC ISR.
Excellent English communication and documentation skills.
This guide is for freshers in India preparing for cloud and support roles, and for developers, administrators and cloud engineers with 1 to 10 years of experience facing Microsoft Azure interviews. It has 60 questions with answers in three levels: core concepts such as regions, resource groups, Microsoft Entra ID, VMs, storage and networking; day-to-day work with Bicep, App Service, Functions, AKS, Azure SQL, KQL and Azure Policy; and senior design questions on high availability, security and cost. Read each answer, then explain it aloud in your own words and take the mock test. The questions are written by CoreHRx for practice. CoreHRx is not affiliated with or endorsed by Microsoft, and these are not actual Azure certification exam questions. Azure changes often, so check the official documentation for current details.
Questions you may be asked
What is the difference between IaaS, PaaS and SaaS, with an Azure example of each?
What are Azure regions, availability zones and region pairs?
Explain the Azure resource hierarchy from management groups down to resources.