Ramandeep Singh
Summary
Experienced Senior ETL Engineer & Data Architect with 15+ years of expertise in designing, building, and optimizing scalable data architectures. Proficient in Azure technologies like Azure Databricks, Azure Data Factory, and ETL pipelines. Skilled in architecting efficient data models, optimizing data processing and ensuring data security and collaborating with cross-functional teams to deliver enterprise-level data solutions.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Senior ETL Engineer, Data Architect
Tata Consultancy Services
06.2023 - Current
- Designed and implemented scalable data processing pipelines using Azure Databricks
- Optimized data storage and transformation workflows using Azure Data Factory and SSIS
- Developed ETL processes for structured and semi-structured data, ensuring high performance and reliability
- Improved query execution and indexing strategies, enhancing system efficiency by 20%
- Ensured data security and integrity by implementing robust governance policies
Senior Database Developer
AutoTrader Canada
07.2021 - 05.2023
- Improved Azure SQL database performance by 40% through indexing and query tuning
- Developed real-time data processing solutions using Azure Data Factory and SQL
- Created complex SQL business logic using Stored Procedure, Functions, Views and transformations
- Configured and maintained Azure database servers (IaaS & PaaS) to ensure high availability
- Automated CI/CD deployments using Azure DevOps
Senior BI Developer
Infosys Limited
08.2018 - 07.2021
- Designed scalable data warehouse solutions, integrating structured and semi-structured data
- Built high-performance ETL pipelines using Azure Data Factory and Synapse Analytics
- Collaborated with business and technical teams to develop efficient and scalable data solutions
BI Developer
Infosys Limited
06.2014 - 08.2018
- Developed SSIS-based ETL pipelines integrating multiple data sources
- Created complex T-SQL queries and stored procedures for optimized data transformation
- Built Power BI dashboards and SSRS reports to support business decision-making
Senior Software Engineer
Infosys Limited
04.2011 - 05.2014
- Led ETL development using SSIS, ensuring efficient data import/export and transformation
- Implemented disaster recovery and backup strategies for enterprise databases
Software Engineer
Infosys Limited
10.2009 - 03.2011
- Developed SQL Server objects (tables, functions, stored procedures, views) for business reporting.
- Created SSRS reports to display key financial figures for stakeholders.
Education
Bachelor of Engineering - Electronics And Communication - 2009
Punjab University
Skills
Azure SQL
Azure Databricks
Azure Data Lake
Azure Data Factory
Azure Synapse Analytics
Data pipelines
Data Modelling
Database Design
ETL Development
BI and Data warehousing
Data transformation
Query tuning and Indexing strategies
Data integrity
Python
SQL, T-SQL, PL-SQL
C#
DevOps
SSIS
Power BI
NoSQL (MySQL, MongoDB)
JSON, APIs, Git, TFS
Title
Senior ETL Engineer, Data Architect
Certification
Microsoft Certified: Azure Data Engineer Associate
Microsoft Certified: Azure Data Fundamentals
Microsoft Certified: Azure AI Fundamentals
Microsoft Certified: Azure Fundamentals
Querying Microsoft SQL Server 2012
TS Microsoft SQL Server 2008 Database Development
Timeline
Senior ETL Engineer, Data Architect
Tata Consultancy Services
06.2023 - Current
Senior Database Developer
AutoTrader Canada
07.2021 - 05.2023
Senior BI Developer
Infosys Limited
08.2018 - 07.2021
BI Developer
Infosys Limited
06.2014 - 08.2018
Senior Software Engineer
Infosys Limited
04.2011 - 05.2014
Software Engineer
Infosys Limited
10.2009 - 03.2011
Bachelor of Engineering - Electronics And Communication - 2009
Punjab University
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Sonalika PradhanSonalika Pradhan
Senior Data Engineer, ETL Developer at Infinite Computer SolutionsSenior Data Engineer, ETL Developer at Infinite Computer Solutions