Welcome to My Portfolio
Hello! I'm Iresh Agrawal, a results-driven Data Engineer with 3.9+ years of experience architecting and optimizing cloud-native data platforms on Azure, Databricks, and Snowflake. I specialize in building scalable ETL/ELT pipelines, implementing Data Vault 2.0 and Medallion Architecture, and driving successful enterprise data migrations.
My expertise spans modern data engineering technologies including PySpark, SQL, Azure Data Factory, and Jenkins CI/CD. I have a proven track record of delivering enterprise-scale solutions that achieve 60%+ performance improvements and 100% SLA compliance with zero production defects for Fortune 500 retail and insurance clients.
I'm passionate about transforming complex data challenges into elegant, scalable solutions that drive business value. Explore my portfolio to learn more about my experience, certifications, and accomplishments.
Core Technical Competencies
Cloud Platforms & Architecture
Big Data & Processing
Programming & Scripting
DevOps & Tools
Cover Letter
IRESH AGRAWAL
Data Engineer
Phone: 8707481550 | Email: iresh.agrawal23@gmail.com
LinkedIn: linkedin.com/in/iresh-agrawal23
Hiring Manager
[Company Name]
Re: Application for Data Engineer Position
Dear Hiring Manager,
I am writing to express my strong interest in the Data Engineer position at your organization. As a results-driven data engineer with 3.9+ years of experience architecting enterprise-scale cloud-native data platforms, I have a proven track record of delivering transformative data solutions that achieve measurable business impact—including 60%+ performance improvements, 100% SLA compliance, and zero production defects across Fortune 500 retail and insurance clients.
In my current role as Senior Executive – Software Engineer at EXL Services, I architect enterprise-grade Data Vault 2.0 models in Snowflake for a leading global insurance provider. I have successfully designed and implemented Raw Vault, Business Vault, and Clean Vault layers across multiple subject areas, establishing audit-compliant and analytics-ready data foundations that support regulatory reporting and business intelligence. Beyond data modeling, I have orchestrated 20+ database schema releases using Jenkins CI/CD and GitHub, implementing XML-based master changelogs for controlled, auditable database change management. I also engineered standardized data ingestion frameworks using Shell scripting, which eliminated environment-specific dependencies and improved deployment reliability by 100%.
Previously, as Associate Consultant at Capgemini, I spearheaded a Unity Catalog migration for a 50TB+ enterprise data platform on Azure Databricks for a global FMCG/retail giant. This initiative achieved a remarkable 62.5% reduction in pipeline execution time and a 98% decrease in production defects by implementing Medallion Architecture across Bronze-Silver-Gold layers. I also optimized complex data transformation pipelines processing 100+ Azure Data Factory sources using advanced PySpark and SQL techniques, increasing throughput by 40% and reducing data latency by 50% for time-sensitive retail analytics. My management of end-to-end CI/CD pipeline lifecycle for 10+ production releases resulted in 100% on-time delivery with zero rollback incidents.
My technical expertise spans the modern data engineering stack, including:
- Cloud Platforms & Architecture: Azure Databricks, Snowflake, Azure Data Factory, Unity Catalog, with deep expertise in Data Vault 2.0 and Medallion Architecture design patterns
- Big Data Engineering: Apache Spark, PySpark, distributed data processing, advanced SQL optimization, and scalable ETL/ELT pipeline development
- DevOps & Automation: Jenkins, Azure DevOps Pipelines, GitHub version control, CI/CD orchestration, and automated testing frameworks
- Data Governance & Quality: Implementation of comprehensive data quality frameworks, regression validation, and audit-compliant data modeling
I am Databricks Certified Data Engineer Professional and Microsoft Certified: Azure Data Engineer Associate (DP-203) and hold additional certifications in Azure Fundamentals and Databricks Generative AI. My commitment to excellence has been recognized through multiple awards, including the Exceeding Expectations Award at EXL Services and two Silver Star Awards at Capgemini for leading high-impact migrations and maintaining 100% SLA compliance.
I am excited about the opportunity to bring my blend of modern data architecture expertise, cloud-native engineering skills, and proven DevOps maturity to your team. I am confident that my track record of delivering scalable, high-performance data solutions that directly support critical business analytics aligns perfectly with your organization's goals. Thank you for considering my application. I look forward to discussing how I can contribute to your continued success in your data journey.
Sincerely,
Iresh Agrawal
Resume
📅 Last updated:
Professional Summary
Results-driven Data Engineer with 3.9+ years of experience architecting and optimizing cloud-native data platforms on Azure, Databricks, and Snowflake. Proven track record of delivering enterprise-scale data solutions that achieve 60%+ performance improvements and 100% SLA compliance with zero production defects. Expert in building scalable ETL/ELT pipelines using PySpark, implementing Data Vault 2.0 and Medallion Architecture, and driving successful Unity Catalog migrations for Fortune 500 retail and insurance clients. Databricks Certified Data Engineer Professional and Microsoft Certified Azure Data Engineer (DP-203) with strong DevOps and CI/CD automation capabilities.
Professional Experience
Senior Executive – Software Engineer
EXL Services (via Clairvoyant) | July 2025 – Present | Insurance
- Architected enterprise-grade Data Vault 2.0 models in Snowflake (Raw Vault, Business Vault, Clean Vault) across multiple insurance subject areas
- Orchestrated 20+ database schema releases across Dev, QA, and Production environments using Jenkins CI/CD and GitHub
- Engineered standardized data ingestion frameworks using Shell scripting, improving deployment reliability by 100%
- Led CI/CD implementation for two parallel development tracks, reducing validation cycles by 35%
- Mentored 3+ junior data engineers on Snowflake development and Data Vault 2.0 modeling patterns
Associate Consultant
Capgemini | November 2023 – June 2025 | FMCG/Retail
- Spearheaded Unity Catalog migration for 50TB+ enterprise data platform, achieving 62.5% reduction in pipeline execution time
- Optimized data transformation pipelines processing 100+ Azure Data Factory sources, increasing throughput by 40%
- Managed end-to-end CI/CD pipeline lifecycle for 10+ production releases with 100% on-time delivery
- Achieved 98% decrease in production defects through Medallion Architecture implementation
Senior Analyst
Capgemini | July 2022 – October 2023 | FMCG/Retail
- Resolved 95% of critical production incidents within SLA, maintaining 99.9% platform uptime
- Implemented regression validation frameworks, reducing post-release failures by 40%
- Developed Power BI dashboards and automated ETL workflows, reducing manual reporting effort by 40%
Data Engineering Intern
Capgemini | January 2022 – June 2022
- Developed Azure Data Factory pipelines for ingestion and transformation of structured and semi-structured datasets
- Conducted comprehensive SQL-based data quality validation across development and UAT environments
Education
Bachelor of Technology (B.Tech)
Electronics and Communication Engineering
Vellore Institute of Technology, Bhopal
July 2018 – September 2022
Certifications
-
Databricks Certified Data Engineer ProfessionalDP-203 -
Microsoft Certified: Azure Data Engineer AssociateDP-203 -
Microsoft Certified: Fabric Analytics EngineerAssociate -
Microsoft Certified: Azure FundamentalsAZ-900 -
Databricks: Generative AI FundamentalsDatabricks Academy
Awards & Recognition
Recognized for architecting Snowflake Data Vault 2.0 models and streamlining CI/CD release management for enterprise insurance portfolios
Awarded twice for leading high-impact Unity Catalog migration and consistently achieving 100% SLA compliance in production support operations
Additional Details
Email: iresh.agrawal23@gmail.com
Mobile: +91 8707481550
Name: Iresh Agrawal
Date of Birth: 23-02-2001
Highest Qualification: B.Tech (ECE)
Preferred Locations: Gurgaon/Noida/Hyderabad/Remote
Current Employer: EXL Services
Total Experience: 3.9+ Years
Location: Lucknow, Uttar Pradesh, India
Portfolio: iresh007.github.io/Portfolio/
Notice Period: 60 days (Can be reduced to 30 - 15 days)
Current CTC: ₹16,00,000 (Annual)
Expected CTC: ₹18,00,000 (Annual)
Skill Summary:
Data Vault 2.0, Snowflake, Azure Databricks, Medallion Architecture (Bronze-Silver-Gold), Unity Catalog, Jenkins, CI/CD, Azure DevOps, Shell Scripting, Python, PySpark, SQL, XML, Power BI, Data Governance, ETL/ELT Pipelines, Azure Data Factory, ADLS Gen2, AWS S3