Rajat Aggarwal
Data Science Engineer Associate
Amritsar
Summary
Results-driven Associate Data Engineer at Cognizant Technologies Solutions, skilled in Python and Azure Data Factory. Achieved a 25% reduction in processing time through optimized ETL pipelines. Proven ability to automate workflows and ensure data quality, while collaborating effectively in Agile teams to deliver impactful solutions.
Overview
4
4
years of professional experience
Work History
Associate
Cognizant Technologies Solutions
07.2022 - Current
Cognizant Technology Solutions – Gurugram, India, June 2022 – Present.
- Developed and maintained scalable ETL pipelines using Python, PySpark, and Azure Data Factory.
- Optimized PySpark applications for performance, reducing processing time by 25%.
- Automated reporting workflows using Python save 30+ hours per month.
- Implemented data validation and quality checks using SQL and Python.
- Integrated Databricks notebooks into ADF pipelines with parameterization.
- Created Logic Apps for automated pipeline status notifications.
- Participated in design and code reviews to ensure best practices.
Azure Finance CBT Project – Johnson & Johnson.
- Migrated data from on-premises SQL Server and Teradata to Azure Cloud.
- Built ETL pipelines using ADF, ADLS Gen2, and Databricks (PySpark).
- Performed data transformations and loaded results into Delta Lake.
- Created reusable datasets, linked services, and integration runtimes.
- Used ARM templates for multi-environment deployment.
Program Analyst
Cognizant Technologies Solutions
06.2021 - 07.2022
- Wrote complex SQL queries for data analysis and transformation.
- Supported ETL development and gained hands-on experience with PySpark and Azure tools.
- Completed certifications in Azure Databricks and Data Factory via Udemy.
Education
Bachelor of Science - Mechatronics
University of Petroleum And Energy Studies
Dehradun, India 04.2001 -
Skills
Python & PySpark Development
ETL Design & Implementation
Distributed Computing with Apache Spark
SQL Query Optimization
Cloud Computing (Azure, AWS)
Data Warehousing (Star & Snowflake Schema)
Azure Data Factory & Databricks
Data Quality & Validation
Agile & Scrum Methodologies
Workflow Orchestration & Automation
Timeline
Associate
Cognizant Technologies Solutions
07.2022 - Current
Program Analyst
Cognizant Technologies Solutions
06.2021 - 07.2022
Bachelor of Science - Mechatronics
University of Petroleum And Energy Studies
04.2001 -