RAJAT JAIN
Agra
Summary
Data professional with 7+ years of expertise in Data Engineering, Data Analysis, and Data Governance. Adept at delivering timely analytics solutions by understanding business needs, resolving defects, and optimizing data pipelines. Skilled in advanced data analysis, data governance frameworks, and tools like SQL, Python, ETL, and cloud platforms (AWS, Azure). Strong analytical, problem-solving, and presentation skills, with a proven ability to collaborate across teams and deliver high-impact, data-driven solutions aligned with organizational goals.
Overview
7
7
years of professional experience
Work History
Associate Manager (Data Engineering)
Tredence Analytics
Gurugram
09.2023 - Current
- Managed enterprise-wide metadata governance through Microsoft Purview, ensuring comprehensive data cataloging and lineage tracking.
- Integrated Power BI with Purview to improve data discoverability and governance for reporting teams.
- Designed and executed automated metadata update processes utilizing Azure Databricks, reducing manual effort.
- Monitored data quality using Anomalo alerts to proactively resolve issues and ensure seamless downstream reporting.
- Collaborated with compliance teams to ensure data governance strategies align with industry regulations and internal policies.
- Led cross-functional teams in the development and deployment of scalable data pipelines to enhance data processing efficiency.
- Conducted regular training sessions on data governance and best practices for both technical and non-technical stakeholders.
Data Engineer
McKinsey & Company
Gurugram
03.2022 - 08.2023
- Designed and optimized data pipelines in Azure Data Factory, achieving a 60% reduction in execution time.
- Directed a team of three to enhance ETL processes.
- Lowered data integration costs by $1.5 million with optimized resource allocation.
- Designed and implemented ETL transformations using PySpark in Azure Databricks.
- Automated data workflows with Azure Data Factory enable real-time data updates and seamless integration.
- Utilized Git for version control, enabling seamless collaboration and code management across teams.
IT Analyst
Tata Consultancy Services
Noida
12.2017 - 03.2022
- Developed ETL processes using SSIS for data extraction, transformation, and loading.
- Improved query performance by 30% through advanced SQL scripting and indexing.
- Conducted text mining and clustering using Python libraries to enhance platform search functionality.
- Contributed to financial services projects as a Data Analyst, improving data quality metrics by 25%.
- Developed and maintained COBOL batch programs for enterprise applications, ensuring high-performance data processing.
- Wrote and optimized JCL scripts for job scheduling, execution, and monitoring.
- Managed DB2 databases, ensuring data integrity and efficient query execution.
Education
Bachelor of Technology -
Hindustan College of Science & Technology
Mathura04-2016
Skills
- SQL
- Pyspark
- Microsoft Azure services
- Azure Databricks
- Microsoft Purview
- Alteryx
- Anomalo
- Mainframe
Timeline
Associate Manager (Data Engineering)
Tredence Analytics
09.2023 - Current
Data Engineer
McKinsey & Company
03.2022 - 08.2023
IT Analyst
Tata Consultancy Services
12.2017 - 03.2022
Bachelor of Technology -
Hindustan College of Science & Technology
Similar Profiles
ADARSH MADARSH M
Consultant at Tredence Analytics SolutionsConsultant at Tredence Analytics Solutions
SAIMONTIKA MUKHERJEESAIMONTIKA MUKHERJEE
HR Analyst at TREDENCE ANALYTICSHR Analyst at TREDENCE ANALYTICS
Kopal ChaudharyKopal Chaudhary
Consultant at Tredence AnalyticsConsultant at Tredence Analytics