Divesh Sadhwani
Delhi
Summary
Results-driven Data Architect with nearly 14 years of hands-on engineering expertise in designing, implementing, and managing complex data architectures. Proven track record in leveraging all major cloud platforms, including AWS, Azure, and Google Cloud, to deliver scalable and efficient data solutions. Adept at leading cross-functional teams, optimizing data workflows, and driving data strategy to align with business objectives. Skilled in modern data engineering practices, including ETL processes, data warehousing, and real-time data processing. Demonstrates a strong ability to translate business requirements into technical solutions, ensuring high performance and reliability of data systems. Committed to continuous improvement and staying abreast of emerging technologies to enhance data capabilities and drive innovation.
Overview
14
14
years of professional experience
Work History
Freelancer
Confidential
Delhi
06.2022 - Current
- Led end-to-end design and implementation of ETL/ELT pipelines across Azure Synapse, Snowflake, dbt, and Matillion, improving data integration, performance, and scalability by over 30%.
- Developed and maintained data warehouses using Synapse SQL and Delta Lake; transformed legacy Java modules into Python classes for seamless integration with Synapse notebooks.
- Built modular, version-controlled data transformation pipelines using dbt (Jinja, YAML), with automated testing, documentation, and CI/CD integration via GitHub Actions.
- Engineered secure, high-performance Snowflake environments leveraging Snowpipe, SQL scripting, materialized views, time travel, and role-based access for governed data sharing.
- Created scalable data architectures and ELT frameworks using Matillion to orchestrate ingestion from APIs, RDBMS, and files into Snowflake, with Git-enabled deployment pipelines.
- Managed cross-functional Agile projects using Jira, MS Project, and Asana—defining KPIs, tracking delivery, and ensuring alignment between business goals and technical solutions.
- Collaborated with stakeholders to define data strategies, streamline data operations, and deliver robust analytics and reporting platforms across multi-cloud environments (Azure & AWS).
Senior Data Engineer
Wieden+Kennedy
Delhi
04.2020 - 03.2025
- Migrated data pipelines and infrastructure from Azure to GCS, enhancing scalability.
- Implemented new architecture, achieving cost reductions of approximately 70%.
- Developed high-reliability pipelines by migrating old C# code to Python.
- Orchestrated end-to-end data pipelines by integrating Cloud Composer with BigQuery and Cloud Functions.
- Automated ETL/ELT processes using Python-based Airflow operators for modular architecture.
- Managed multiple projects while overseeing data pipelines in BigQuery and Spark clusters.
- Streamlined workflows through effective management of data infrastructure and project execution.
Senior Technical Lead
AbsolutData
Gurgaon
04.2018 - 04.2020
- Client facing role with responsibility of managing the account and ensuring deliverables.
- Working on an Analytics product and managing the Data Engineering part as an Individual Contributor.
- Implemented serverless architecture for ETL process leveraging Azure IaaS and PaaS services.
- Solutioning proposals for potential client, understanding the requirement and designing architecture.
- Managing team of developers, testers and cloud administrators.
Senior Analyst
Delhivery
Gurgaon
02.2015 - 04.2018
- Conduct data mining, data modeling, statistical analysis, business intelligence gathering, trending and benchmarking.
- Collaborated with business heads as data/product consultant to understand requirements and help them with data driven solutions.
- Experience in identifying new data sources, transforming unstructured raw data into structured format.
- Deriving actionable knowledge discovery to present data stories in visualization dashboards.
Programmer Analyst
Cognizant Technology Solutions
Chennai
11.2010 - 02.2015
- Collaborated with business analysts to understand project requirements, customer expectations and timelines.
- Troubleshot and resolved complex programming issues in a timely and effective manner.
- Troubleshooted technical issues related to .NET development.
- Tuned and optimized DB2 SQL queries for better performance in a mainframe environment.
- Monitored progress of each sprint through metrics tracking tools like JIRA.
Education
Bachelor of Engineering - Mechanical
LNCT
Bhopal06-2010
Skills
- Agile Methodology
- AWS
- Azure
- Bash/Shell
- CI/CD
- Databricks
- Data Engineer
- Delta Lake
- Docker
- ETL
- GCP
- GitHub
- JIRA
- NoSQL
- Power BI
- PySpark
- Python
- SQL
- Streamlit
- Technical documentation
- Cross-functional collaboration
- Project management
- Stakeholder engagement
- Agile methodologies
Timeline
Freelancer
Confidential
06.2022 - Current
Senior Data Engineer
Wieden+Kennedy
04.2020 - 03.2025
Senior Technical Lead
AbsolutData
04.2018 - 04.2020
Senior Analyst
Delhivery
02.2015 - 04.2018
Programmer Analyst
Cognizant Technology Solutions
11.2010 - 02.2015
Bachelor of Engineering - Mechanical
LNCT
Similar Profiles
Candice GermanyCandice Germany
RN Analyst at ConfidentialRN Analyst at Confidential
Shana TimmerShana Timmer
Project Manager at ConfidentialProject Manager at Confidential
Eman AlSayouhiEman AlSayouhi
Digital Transformation Specialist at ConfidentialDigital Transformation Specialist at Confidential
Raviteja KothagallaRaviteja Kothagalla
Senior Technical Lead at ConfidentialSenior Technical Lead at Confidential
Suraj SethSuraj Seth
Automation Test Engineer at Tata Consultancy Services LtdAutomation Test Engineer at Tata Consultancy Services Ltd