Ajit Thombre

Results-driven Azure Data Engineer with proven expertise designing, developing, and maintaining scalable data pipelines for ingestion, transformation, and validation of large datasets. Proven expertise in Apache Spark, Azure Data Factory, Azure Synapse Analytics, and ADLS Gen2 for building high-performance ETL/ELT workflows. Skilled in data warehousing concepts (Medallion, star/snowflake schema, dimensional modelling), data quality and governance, and CI/CD automation.

Experienced collaborating with cross-functional teams to deliver secure, compliant, and analytics-ready data solutions on Azure.

Sr. Azure Data Engineer - Deqode

(2026-03)

• Designed and implemented scalable ADF pipelines for structured data ingestion from relational databases into ADLS Gen2, applying data quality checks and validation at each layer
• Built end-to-end ELT pipelines combining ADF orchestration with Databricks PySpark for large-scale transformation of structured and unstructured datasets
• Implemented Medallion Lakehouse (Bronze/Silver/Gold) architecture on Microsoft Fabric and OneLake, applying dimensional modelling and data warehousing concepts for analytics-ready outputs
• Engineered high-performance batch pipelines on Delta Lake using partitioning, Z-ORDER, OPTIMIZE, and VACUUM — improving query performance and storage efficiency
• Built scalable ingestion frameworks using Databricks Autoloader for incremental loads with schema evolution and fault-tolerant processing
• Developed real-time data pipelines using Structured Streaming with watermarking and stateful transformations for late-arriving data handling
• Implemented data validation and reconciliation routines using Azure SQL scripts, ensuring data quality and integrity across Bronze, Silver, and Gold layers
• Optimised Spark workloads through adaptive query execution, skew handling, shuffle partition tuning, and join optimisation for cost efficiency
• Enabled enterprise data governance using Unity Catalog with fine-grained access controls, ensuring compliance with data security policies
• Automated CI/CD deployments using Databricks Repos, Asset Bundles, and Azure DevOps pipelines with enforced branch policies for versioned, repeatable releases
• Delivered curated, analytics-ready datasets powering Databricks SQL dashboards and BI tools; collaborated with data analysts and business stakeholders to align outputs with KPIs

Azure Data Engineer - Tata Consultancy Services

(2023-01 - 2026-03)

• Architected Medallion Lakehouse (Bronze → Silver → Gold) on ADLS Gen2 using ADF for orchestration and Databricks Delta Live Tables (DLT) for declarative, auto-scaling transformation pipelines
• Designed and maintained scalable ETL/ELT workflows using ADF, Databricks Spark SQL/PySpark, and Azure Synapse Analytics — reducing pipeline processing time by 20%
• Applied data warehousing concepts including star/snowflake schema and dimensional modelling to build targeted data models in Azure Synapse Analytics for executive-level BI reporting
• Engineered data partitioning and indexing strategies in Databricks, cutting query processing time by 30% across large-scale datasets
• Authored modular, unit-tested PySpark code for advanced transformations — joins, window functions, type conversions, duplicate removal — profiled via Spark UI
• Implemented Unity Catalog for fine-grained access control, lineage tracking, and asset discovery; integrated Microsoft Purview for enterprise data classification and governance
• Configured Azure DevOps CI/CD pipelines for automated deployment of ADF ARM templates and Databricks notebooks with Git-based version control and branch policies
• Applied Delta Lake optimisations (Z-ordering, OPTIMIZE, VACUUM) to improve query performance and reduce storage costs on large-scale datasets
• Designed database schemas, tables, and relationships; wrote complex SQL queries for data retrieval, reporting, and optimisation using advanced indexing techniques
• Developed PL/SQL stored procedures, functions, and packages implementing business logic with robust error handling and data integrity enforcement
• Assisted in data migration processes ensuring data consistency; collaborated with analysts to deliver compliant, validated database solutions

PL/SQL Developer - Tata Consultancy Services

(2022-01 - 2022-12)

• Designed database schemas, tables, and relationships; wrote complex SQL queries for data retrieval, reporting, and optimisation using advanced indexing techniques
• Developed PL/SQL stored procedures, functions, and packages implementing business logic with robust error handling and data integrity enforcement
• Assisted in data migration processes ensuring data consistency; collaborated with analysts to deliver compliant, validated database solutions

B.E. - Electrical Engineering - Sandip Foundation, Nashik (2020)