Senior Technical Specialist
Mumbai, MH, India4w ago
Key details
- Location
- Mumbai, MH, India
- Work style
- Hybrid
- Level
- Senior
- Job type
- Full-time
- Experience
- 12–15 yrs
- Function
- Operations & Strategy
- Focus area
- other
- Posted
- 4w ago
Skills
About the role
Title: Senior Azure Data Engineer
Location: India Mumbai/ Bengaluru (Hybrid )
Education: Bachelor’s Degree
Experience Level: 12+
Senior Data Engineer – Azure Data Factory, Microsoft Fabric & Databricks (Tier 3)
Location: Mumbai and Bengaluru
Datavail is hiring a Senior Data Engineer to join our high-performing team building and supporting modern data platforms across a wide range of clients and industries. This is not a pipeline-only role, we are looking for a forward-looking engineer who designs reusable, metadata-driven solutions instead of one-off jobs, treats Microsoft Fabric and Databricks lakehouse architectures as the default rather than the exception, and builds monitoring and automation that catch problems before they become a ticket. As a leading managed services provider, we consistently meet and exceed client SLAs.
We are looking for a senior-level data engineer who operates as a trusted technical advisor, someone who goes beyond building pipelines to turn business requirements into sound technical designs, lead platform migrations, and set engineering standards for the team. The ideal candidate will bring hands-on depth across Azure Data Factory, Microsoft Fabric and Databricks, mentor junior engineers, and own production support for client workloads with a blend of engineering rigor and consultative guidance. This is a full-time position with full medical benefits.
Travel: NA
Azure Data Factory, Microsoft Fabric & Databricks Expertise (Core Focus)
This is a defining requirement for the role, not a secondary skill:
- Metadata-driven ADF pipelines — designing reusable, parameterized pipelines for batch and incremental loads using dynamic content, Lookup/For Each/Until activities and control-flow logic, with Mapping Data Flows for code-free transformations where they fit
- Hybrid ingestion & integration runtimes — ingesting from on-prem databases, files, REST APIs, SaaS applications and cloud storage through linked services and datasets, and configuring Self-hosted and Azure Integration Runtimes for secure hybrid connectivity
- ADF orchestration & monitoring — schedule, tumbling window and event-based triggers with cross-pipeline dependencies; orchestrating Databricks notebooks and jobs, stored procedures and Azure Functions; building error-handling, retry, alerting and logging frameworks monitored through Azure Monitor and Log Analytics
- Fabric Lakehouse & Warehouse design — medallion (Bronze/Silver/Gold) architecture on OneLake; Warehouse objects in T-SQL (tables, views, stored procedures, cross-database queries); OneLake shortcuts and mirroring to integrate ADLS Gen2, Databricks, Snowflake and Azure SQL data without duplicating it
- Fabric data engineering — Data Pipelines and Dataflows Gen2 for ingestion and transformation; PySpark and Spark SQL in Fabric notebooks scheduled with Spark job definitions; Delta table tuning with V-Order, OPTIMIZE and VACUUM
- Semantic modeling & capacity management — star-schema and Direct Lake semantic models for high-performance Power BI reporting; managing workspaces, roles, capacity sizing and CU consumption with the Fabric Capacity Metrics app
- Databricks development — scalable processing in PySpark, Spark SQL and Python; Databricks Workflows/Jobs with task dependencies, retries and alerts; incremental and streaming pipelines with Auto Loader, Structured Streaming and Delta Live Tables
- Delta Lake design & Spark performance tuning — MERGE/upsert, SCD Type 1 and Type 2, schema evolution and Time Travel; tuning through partitioning, Z-Ordering, liquid clustering, caching, broadcast joins and handling data skew
- Unity Catalog & platform configuration — catalogs, schemas, access controls, lineage and external locations; clusters, cluster policies, SQL Warehouses and Photon, balancing performance against cost; integration with ADLS Gen2, Key Vault (secret scopes), ADF and Fabric
- CI/CD across platforms — ADF source control with Git and promotion through ARM templates and Azure DevOps; Fabric Git integration and deployment pipelines (Dev → Test → Prod); Databricks Asset Bundles, Repos and Azure DevOps or GitHub Actions
In this role, you will:
- Serve as a trusted technical advisor to clients, turning business requirements into technical designs and recommending the right platform patterns
- Lead migrations from legacy ETL (SSIS, Informatica, on-prem SQL) and from Azure Synapse, ADF and legacy data warehouses to Microsoft Fabric and Databricks
- Design, develop and implement scalable data pipelines using Microsoft Fabric Data Factory, Azure Data Factory and Azure Databricks
- Set up security across all platforms using Key Vault, managed identities, RBAC, and row- and column-level security
- Build ETL/ELT workflows to ingest data from databases, ERP and CRM systems (e.g., SAP, Dynamics 365, Salesforce), REST APIs, SaaS applications and flat files
- Develop and maintain enterprise data warehouses and subject-area data marts to support reporting and analytics
- Provide production support for Azure, Fabric and Databricks workloads, including incident and change management, root-cause analysis, and SLA-driven fixes
- Collaborate directly with client technical teams and stakeholders, translating technical findings into business-relevant recommendations
- Participate in the on-call rotation to support critical production issues and ensure high availability around the clock
- Design and implement data quality, validation and reconciliation checks so issues are caught before they reach downstream reports
- Proactively monitor pipeline performance and platform costs (Fabric capacity, Databricks compute), recommending optimizations to clients
- Build reusable frameworks and templates for ingestion, logging and auditing that accelerate delivery across clients
- Run discovery and onboarding for new client environments, assessing existing data platforms and documenting current-state architecture
- Lead data platform modernization roadmaps, including capacity planning and adoption of new Fabric and Databricks features
- Partner with BI developers and analysts to deliver reliable, well-modeled data for Power BI reporting
- Coordinate with offshore and onshore team members on handoffs, prioritization and delivery of fixes and enhancements
Required Qualifications:
12+ years of overall experience, including 6+ years of hands-on experience with Azure Data Factory and Databricks, and 2+ years of experience delivering production workloads using Microsoft Fabric.
- Deep, hands-on experience across all areas listed under Azure Data Factory, Microsoft Fabric & Databricks Expertise above this is a required, non-negotiable core competency
- Expert-level PySpark and Spark SQL writing and optimizing large-scale transformations, reading Spark UI/query plans, and resolving shuffle, spill, skew and small-file issues
- Advanced SQL/T-SQL complex joins, window functions, CTEs, MERGE logic, stored procedures, and query tuning on Azure SQL, Fabric Warehouse and Databricks SQL
- Strong Python for data engineering modular, testable code, reusable libraries, REST API ingestion (pagination, auth, throttling), and unit testing with pytest
- Built and supported metadata/config-driven ADF frameworks in production — control tables, watermark-based incremental loads, CDC patterns, and Self-hosted Integration Runtime setup and troubleshooting
- Hands-on Delta Lake implementation, MERGE/upsert, SCD Type 1 and Type 2, schema enforcement and evolution, OPTIMIZE, Z-Ordering/liquid clustering, VACUUM and Time Travel
- Production experience with Auto Loader, Structured Streaming or Delta Live Tables, including checkpointing, late-arriving data.
- Hands-on Unity Catalog administration — metastore, catalogs/schemas, grants, external locations, storage credentials, and lineage
- Built Fabric Lakehouses/Warehouses end to end — OneLake shortcuts, mirroring, notebooks, Dataflows Gen2, Direct Lake semantic models, and capacity/CU troubleshooting
- Dimensional data modeling like star and snowflake schemas, fact and dimension design, surrogate keys, and medallion (Bronze/Silver/Gold) layering
- Azure platform skills like ADLS Gen2 (hierarchical namespace, ACLs), Azure SQL, Key Vault, managed identities, service principals, private endpoints and VNet integration
- CI/CD implementation — Git branching strategies, Azure DevOps YAML pipelines or GitHub Actions, ARM/Bicep templates, Databricks Asset Bundles, and Fabric deployment pipelines
- Infrastructure as Code with Terraform or Bicep for provisioning Azure data services and Databricks workspaces
- Data quality and observability — implementing validation rules, reconciliation, and alerting (e.g., DLT expectations, Great Expectations), with monitoring through Azure Monitor and Log Analytics
- Proven track record migrating SSIS, Informatica or Synapse workloads to ADF, Fabric or Databricks, including code conversion, data validation and cutover
- Hands-on production support — debugging failed pipelines and Spark jobs, performing root-cause analysis, and working incidents and changes through ITSM tools such as ServiceNow
- Clear verbal and written communication, with the ability to explain technical designs and issues to client stakeholders
- Snowflake (Snowpipe, Streams and Tasks, Time Travel, RBAC, performance tuning)
- SSIS and SSRS: package development, report design, and migration to Azure/Fabric
- Streaming technologies: Fabric Real-Time Intelligence, Event Hubs, Kafka
- Power BI and DAX
- Experience in a managed services model with onshore and offshore teams
Good to Have:
Certifications:
- Preferred: Microsoft Certified: Fabric Data Engineer Associate (DP-700), Fabric Analytics Engineer Associate (DP-600), Azure Data Engineer Associate (DP-203, legacy), Databricks Certified Data Engineer Professional, or SnowPro Core
How well do you match this job?
Free account needed to apply or save. It takes a minute, and we'll bring you right back to this job.