Gourav Dubey

Solution Architect with 14+ years of experience defining and delivering enterprise data platforms, lakehouse architectures, and governance frameworks across BFSI, Healthcare, Utilities, and Manufacturing. Expert in Talend, PySpark, and Microsoft Purview. Proven track record of owning architecture decisions, driving cloud modernization, ensuring data security/compliance, and influencing stakeholders to deliver scalable, cost-optimized, and high-performance solutions.

Solution Architect / Data Governance Architect - Exponentia.ai

(2025-04)

• Delivered Microsoft Purview Data Governance project for Emory Healthcare
• Defined and owned enterprise data governance architecture using Microsoft Purview
• Designed hybrid data platform (on-prem + Azure) ensuring secure and scalable integration
• Established SHIR-based secure connectivity aligned with enterprise security policies
• Onboarded 12+ enterprise data sources (Oracle, SQL Server, Snowflake, Azure)
• Defined data ownership, stewardship, and governance operating model
• Enabled classification of 30+ PHI/PII patterns ensuring regulatory compliance
• Reduced data discovery effort by ~60% through centralized catalog strategy
• Collaborated with business and security stakeholders to align governance with compliance needs

Lead Data Engineer / Solution Architect - YASH Technologies

(2023-05 - 2025-04)

• Defined target-state Lakehouse architecture on PySpark for enterprise-scale workloads
• Led modernization strategy from SSIS to cloud-native PySpark pipelines
• Architected reusable transformation, validation, and reconciliation frameworks
• Ensured scalability, cost optimization, and performance tuning across pipelines
• Migrated 50+ workflows with full functional and data parity
• Improved performance by 45% while reducing infrastructure cost
• Worked with stakeholders to define migration roadmap and architecture standards

Solution Architect - Abu Dhabi Distribution Company

(2022-12 - 2023-04)

• Architected Talend data platform from ground up including standards, frameworks, and governance
• Defined data migration strategy from Oracle to PostgreSQL
• Designed 100+ table data model with validation and reconciliation controls
• Established error handling, restartability, and monitoring frameworks
• Acted as primary technical decision-maker for architecture and delivery

Senior Data Engineer - L&T Infotech

(2021-05 - 2022-12)

• Designed multi-layer enterprise ETL architecture (T0–T3)
• Built reusable Talend frameworks enabling standardization across programs
• Delivered governed, audit-ready pipelines aligned with enterprise standards
• Collaborated with business teams for data validation and reporting requirements

Technical Lead - Tech Mahindra

(2020-12 - 2021-04)

• Led architecture and delivery of ETL migration (SQL Server → Oracle)
• Managed team and ensured adherence to architecture and quality standards
• Delivered 65 business-critical tables with validation and reconciliation

Data Engineer / ETL Lead - Saint Gobain

(2018-10 - 2020-11)

• Delivered 18+ enterprise ETL solutions across multiple programs
• Implemented Kafka-based ingestion pipelines for near real-time processing
• Led production support, RCA, and release governance
• Standardized development practices across teams

Software Engineer - Tata Consultancy Services

(2013-07 - 2018-10)

• Developed enterprise ETL pipelines and PL/SQL components
• Supported HR systems for 100K+ global users
• Maintained 99.9% production reliability

BSc - Information Technology - Mumbai University