Rohit Rawat
Azure Data Engineer
Ghaziabad
Summary
Dynamic data professional with extensive hands-on experience in data collection, mining, cleaning, processing, modeling, visualization, and forecasting across various platforms. Proven ability to manage and analyze large datasets while adeptly handling diverse file formats to generate insightful reports for clients. Proficient in a wide array of tools, including MS Power BI, Python, SQL Server, Fabric, Unity Catalog, Azure Data Factory, Azure Data Lake, Azure Databricks, and Azure SQL. Excels in collaborative environments and drives team success through strong problem-solving capabilities and a commitment to continuous learning and professional development.
Overview
10
10
years of professional experience
2
2
Languages
2
2
years of post-secondary education
Work History
Azure Cloud Data Engineer
C5i
Gurgaon, India
03.2023 - Current
- Participate in Designing and implementing scalable and efficient data architectures on the Azure platform along with Data Architect.
- Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
- Also Developed comprehensive data models to support business requirements and optimize data storage.
- Orchestrated complex data workflows, ensuring seamless data movement and transformation.
- Creating ADF pipeline to migration data from different On-Prem (sources) to cloud (destination).
- Data Transformation through Azure Databricks (PySpark/Spark SQL)
- Utilized PySpark and SparkSQL in Azure Databricks for processing large-scale datasets and performing advanced data transformations.
- Implemented data security measures, including encryption and key management using Azure Key Vault.
- Creating Pipeline for Full load, an Incremental load in a scheduled way.
- Established monitoring and logging processes for data pipelines, identifying and addressing performance bottlenecks.
- Conducted regular performance tuning to optimize data processing and resource utilization.
- Team handling and managing the Client requirements.
Technical Specialist
Mindforce Research
Noida, India
03.2018 - 02.2023
- Data Migration from one source to another source through ETL Services.
- Design data models to transform raw data into meaningful insights.
- Creating dimension table and fact table.
- Perform regular data cleansing activity, data corrections and regular audits.
- Extensive usage of MS Excel (Functions and Pivot Table).
- Managing the monthly, weekly & Daily Report.
- Managed multiple high-priority tasks simultaneously, consistently meeting deadlines while maintaining attention to detail.
Associate Analyst
GlobalLogic
Noida, India
05.2016 - 03.2018
- Designing surveys in Decipher.
- Checking data through sql queries.
- Processing the data through various medium i.e. Office report, sql pivots, ppt etc.
- Participated in regular training sessions to stay current on industry trends, improving personal expertise and job performance.
- Maintained organized documentation of completed work, ensuring easy access to historical records for future reference or audits.
Education
M.Tech - Information Technology
College Of Technology, GBPUAT
Pantnagar, India 07.2013 - 10.2015
B.Tech / Engineering - Computer Science And Engineering
North India Institute of Technology
Najibabad, India06-2013
12th - English
D.A.V. Public School(CBSE)
Kotdwara, India05-2009
10th - English
St. Mary's School (ICSE/ISC)
Najibabad06-2007
Skills
Experienced in Python programming
Data pipeline creation
Data pipeline design
Data migration expertise
Proficient in SQL
Azure Data Factory
Azure Data Lake
Azure Databricks
Azure Stream Analytics
Pyspark
SCALA
Timeline
Azure Cloud Data Engineer
C5i
03.2023 - Current
Technical Specialist
Mindforce Research
03.2018 - 02.2023
Associate Analyst
GlobalLogic
05.2016 - 03.2018
M.Tech - Information Technology
College Of Technology, GBPUAT
07.2013 - 10.2015
B.Tech / Engineering - Computer Science And Engineering
North India Institute of Technology
12th - English
D.A.V. Public School(CBSE)
10th - English
St. Mary's School (ICSE/ISC)