Dharna Srivastava
Harrow,Middlesex
Summary
Experienced Azure data engineer with a demonstrated expertise in cloud technologies, adept at designing, implementing, and managing data solutions within the Microsoft Azure ecosystem.Skilled in building scalable data pipelines, optimising data storage, and ensuring data integrity . Adept at utilising a range of Azure services such as Azure Data Factory, Azure MongoDB, Azure SQL Database, Azure Blob and Azure Synapse Analytics to deliver robust and efficient data solutions.
Overview
10
10
years of professional experience
Work history
Data Engineer
Tata Consultancy Services-British American Tobacco
London
08.2019 - Current
- Created complex SQL queries to extract data from ADLS for downstream analysis
- Designed and developed ETL processes using Talend to extract data from various sources including Azure MsSQL and Azure MongoDB databases and transform it into a consistent format for loading into ADLS Blob, MongoDB
- Implemented data pipelines using Azure Data Factory to execute archiving strategies
- Deployed and managed Talend jobs on Azure Cloud
- Optimised Talend jobs for performance using partitioning and parallelisation techniques
- Have worked closely with data analysts, data scientists, and other stakeholders to understand their data needs, and design and develop data systems that meet business needs
- Also collaborated with other teams to ensure that data systems are integrated with other systems and applications
- Planned release & deployment for clients to ensure business meet legislative compliance for more than 15 markets (EU & non-EU)
- Actively took part in the post-release hyper care working with the manufacturing & logistics team to ensure smooth stock movement.
Data Engineer
Tata Consultancy Services, Anheuser Busch Inbev
Bangalore
09.2018 - 07.2019
- As a member of the Enterprise Data Hub capability platform, actively contributed to the establishment of reusable frameworks for incoming and ongoing projects
- Performed multiple product demonstrations for the client and stakeholders
- Designed and developed data models for MsSQL databases to ensure data accuracy and consistency
- Experience with Talend big data batch jobs, including connectivity to HDFS, ADLS, and Hive
- Designed and developed Talend jobs to extract data from various sources including databases and flat files and transform it into a consistent format for loading into a Hadoop cluster.
ETL Developer
Tata Consultancy Services, Best Buy
Pune
06.2014 - 04.2018
- Developed complex SQL queries,T-SQL to extract data from data warehouses
- Worked extensively in optimising the ETL process to meet the SLAs
- Designed and developed ETL processes using Microsoft SSIS to extract data from various sources including flat files and APIs and transform it into a consistent format for loading into a data warehouse
- Optimised Microsoft SSIS packages for performance using partitioning and parallelisation techniques.
Education
Bachelor of Science - Information Technology
Hindustan College of Science And Technology Farha
Skills
- ETL Tools: Talend Cloud Real-Time Bigdata Platform (R2023-02-731), Microsoft SQL server management studio, Microsoft Azure Data Factory, Azure log analytics, E2E log stash, SSIS (SQL Server Integration Services), SSAS 2012,2016, Visual Studio, Informatica Power Center 101
- Cloud Platforms: Azure Cloud
- Data Storage Technologies: Azure SQL Database, Azure Cosmos DB, Azure Data Lake Storage, Hadoop Distributed File System (HDFS), Azure storage account-Blob services
- Certification : Professional Srum Master 1
Timeline
Data Engineer
Tata Consultancy Services-British American Tobacco
08.2019 - Current
Data Engineer
Tata Consultancy Services, Anheuser Busch Inbev
09.2018 - 07.2019
ETL Developer
Tata Consultancy Services, Best Buy
06.2014 - 04.2018
Bachelor of Science - Information Technology
Hindustan College of Science And Technology Farha
Similar Profiles
Delroy TrowersDelroy Trowers
Territory Manager at Imperial Tobacco Canada - British American TobaccoTerritory Manager at Imperial Tobacco Canada - British American Tobacco
Aisha Parveen DudekulaAisha Parveen Dudekula
PL/SQL Developer at Tata Consultancy Services, Client: British TelecomPL/SQL Developer at Tata Consultancy Services, Client: British Telecom
Sarder Hasanul BannaSarder Hasanul Banna
Senior Travel Consultant / Head of Travel Desk at British American Tobacco Bangladesh (on behalf of Carlson Wagonlit Travel BD)Senior Travel Consultant / Head of Travel Desk at British American Tobacco Bangladesh (on behalf of Carlson Wagonlit Travel BD)
RAKHI PATELRAKHI PATEL
Director at First Contact OpticiansDirector at First Contact Opticians
Whitney KwartengWhitney Kwarteng
Sales assistant at IcelandSales assistant at Iceland