Dheerendra Pratap Singh
Bangalore
Summary
Results-oriented Data Engineer with over 14 years of experience in designing, building, and optimizing data pipelines, data models, and ETL processes. Collaborates effectively with multi-functional roles to identify and leverage areas for improvement in data systems. Expertise in working with large-scale data systems and cloud technologies, with a strong command of Azure, SQL, Python.
Overview
13
13
years of professional experience
Work History
Manager | Data Engineer
Capgemini Technology Services
Bangalore
03.2023 - Current
- Developed scalable ETL pipelines to handle large volumes of structured and unstructured data.
- Optimized query performance, reducing query execution time by 30%.
- Led the migration of the on-premise data warehouse to Azure Cloud, improving data availability and reducing costs.
- Designed data models and optimized database performance for high-traffic applications.
- Customer Behavior AnalysisLeveraged Azure Data Lake to store raw user interaction data and used Azure Databricks to clean and process the data. Integrated with Power BI for visualization and reporting.
Manager | Data Modeler (Cloud Migration)
Capgemini Technology Services
Bengaluru
08.2021 - 03.2025
- Data Pipeline AutomationDesigned and implemented end-to-end ETL pipelines using Azure Data Factory (ADF) to automate data ingestion from multiple on-premises and cloud data sources. The pipeline transformed data into a unified format and loaded it into Azure Data Lake Storage Gen2 for further analysis.
- Integrated ADF with Azure Databricks for advanced analytics and used Azure SQL Data Warehouse for reporting.
Senior Associate (ETL Lead)
Cognizant Technologies Solutions
Pune
07.2018 - 08.2021
- FATCA-ER Developed an ETL solution to load data from various transactional systems into a centralized data warehouse using Informatica PowerCenter. Designed complex transformations to cleanse and integrate data across multiple sources, enabling accurate reporting and business intelligence.
- Optimized the mapping logic for data transformation, reducing ETL job run times by 50%.
- Reviewed project requirements to identify customer expectations and resources needed to meet goals.
Senior ETL Developer
Cognizant Technologies Solutions
Pune
12.2011 - 07.2018
- Analysing existing data model and ETL design for performance tuning.
- Post load reconciliation checks and retention of data.
- Work as lead for some source system with 5 trainees in my team.
- Handling secured data of Barclays as it is a BFS client.
- Successfully developed the code and unit testing of Data marts of 2 source system and Extracts.
Education
B.Tech - Computer Engineering
Poornima College of Engineering
Jaipur, Rajasthan07-2011
Skills
- Databases
SQL Server, Oracle 10g, Teradata 130
- Cloud Services
Azure Data Factory, Azure Databricks,
Azure Data Lake Storage
- ETL Tool
Informatica Powercenter 100, IICS
- Scripting Languages
Python, PySpark, Unix Scripting
Timeline
Manager | Data Engineer
Capgemini Technology Services
03.2023 - Current
Manager | Data Modeler (Cloud Migration)
Capgemini Technology Services
08.2021 - 03.2025
Senior Associate (ETL Lead)
Cognizant Technologies Solutions
07.2018 - 08.2021
Senior ETL Developer
Cognizant Technologies Solutions
12.2011 - 07.2018
B.Tech - Computer Engineering
Poornima College of Engineering
Similar Profiles
NIKHIL CHITALENIKHIL CHITALE
Senior Manager at Capgemini Technology ServicesSenior Manager at Capgemini Technology Services
Eswari RajamanikkamEswari Rajamanikkam
Senior Associate - Accounts Payable at Capgemini Technology ServicesSenior Associate - Accounts Payable at Capgemini Technology Services
Nitesh FulzeleNitesh Fulzele
Manager at Capgemini Technology ServicesManager at Capgemini Technology Services