Hi, I’m Ankit Goyal, a Technical Lead and Senior Data Engineer with 10+ years of experience designing data platforms, migrating legacy systems to the cloud, and building distributed cloud solutions. I specialize in data warehousing, data governance, and end-to-end data pipelines using Azure Databricks, Azure Data Factory, Synapse, and related technologies. I enjoy client engagement, solution design, and leading cross-functional teams to deliver scalable, business-focused data solutions. I collaborate closely with business stakeholders and technical teams to translate requirements into robust architectures, establish data quality and governance, and drive continuous improvement through thoughtful design, mentoring, and strategic planning. In my free time I stay current with emerging data technologies and look for opportunities to optimize performance and cost across cloud data platforms.

Ankit Goyal

Hi, I’m Ankit Goyal, a Technical Lead and Senior Data Engineer with 10+ years of experience designing data platforms, migrating legacy systems to the cloud, and building distributed cloud solutions. I specialize in data warehousing, data governance, and end-to-end data pipelines using Azure Databricks, Azure Data Factory, Synapse, and related technologies. I enjoy client engagement, solution design, and leading cross-functional teams to deliver scalable, business-focused data solutions. I collaborate closely with business stakeholders and technical teams to translate requirements into robust architectures, establish data quality and governance, and drive continuous improvement through thoughtful design, mentoring, and strategic planning. In my free time I stay current with emerging data technologies and look for opportunities to optimize performance and cost across cloud data platforms.

Available to hire

Hi, I’m Ankit Goyal, a Technical Lead and Senior Data Engineer with 10+ years of experience designing data platforms, migrating legacy systems to the cloud, and building distributed cloud solutions. I specialize in data warehousing, data governance, and end-to-end data pipelines using Azure Databricks, Azure Data Factory, Synapse, and related technologies. I enjoy client engagement, solution design, and leading cross-functional teams to deliver scalable, business-focused data solutions.

I collaborate closely with business stakeholders and technical teams to translate requirements into robust architectures, establish data quality and governance, and drive continuous improvement through thoughtful design, mentoring, and strategic planning. In my free time I stay current with emerging data technologies and look for opportunities to optimize performance and cost across cloud data platforms.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert

Language

English
Fluent

Work Experience

Sr. Data Engineer at Banking client
April 1, 2024 - November 11, 2025
Design and migrate legacy data to cloud; develop streaming CDC-based data pipelines; implement reusable frameworks for Salesforce data integration and data quality logging; performance-tune pipelines and implement Delta Lake-backed data storage.
Sr. Technical Lead at Chubb Insurance (Capgemini)
January 1, 2024 - January 1, 2024
Designed Location 360 platform for location mastering/enrichment/certification; migrated legacy data to Azure; built PySpark-based pipelines to Cosmos DB; implemented Medallion Architecture; developed ADF pipelines and led a 12-14 member team.
Solution Designer at Aviva Insurance (Capgemini)
April 1, 2023 - April 1, 2023
Developed Data Lake/Data Mart on Hadoop; analyzed and enhanced data pipelines; supported data governance and data quality initiatives.
Technical Lead at Ernst & Young (formerly Gensquared)
January 1, 2022 - January 1, 2022
Architected Enterprise Data Warehouse and IT Roadmap; integrated multiple source systems and cloud migration; led migration to Azure Databricks; advised on architecture and IT strategy.
Technical Lead at Jones Lang LaSalle (JLL) / Cognizant
September 1, 2021 - September 1, 2021
Managed 7-8 concurrent projects; led data integration across Salesforce, JD Edwards, Workday, and other systems; established data governance and auditability; designed scalable data pipelines and mappings.
Team Member at JP Morgan Chase - Retirement Planning Services
December 1, 2015 - December 1, 2015
Developed 50+ ETL mappings; built grid-based Informatica architecture; implemented error handling, threshold logic, and production support for data warehousing.
Team Lead at Mercedes Benz Financial Services
May 1, 2014 - May 1, 2014
Created Data Warehouse and DataMart; performed dimensional modeling; developed 70+ ETL mappings; built mainframe data extraction with Informatica Power Exchange; established audit/archiving.
Team Lead at Hyundai Information Service North America (HISNA)
June 1, 2013 - June 1, 2013
CRM analytics-driven reporting; developed ETL mappings and OBIEE reports; enhanced data modeling and star schema for BI reporting.
Team Member at Dell Inc.
August 1, 2012 - August 1, 2012
HR Analytics implementation; developed 60+ ETL mappings; monthly/quarterly/yearly workforce data aggregations; data integration for talent management and reporting.
Team Member at Hitachi Data Storage Systems
May 1, 2011 - May 1, 2011
Enhancement of Data Warehouse/DataMart on Hadoop; updated 30+ mappings; designed accounting/receivables data modeling.
Team Member at Citibank NA
September 1, 2010 - September 1, 2010
Support and enhancement of financial Data Warehouse; trade settlements data; expanded ETL mappings and production support.
Team Member at AT&T (Toyota Financial Services project iteration)
June 1, 2008 - June 1, 2008
Development of an Enterprise Data Warehouse for Toyota Financial Services; 300+ ETL mappings; staging to EDW/data mart loads; grid-based Informatica architecture.

Education

Master’s in Business Administration (MBA) at Institute of Management & Technology, India
January 11, 2030 - November 11, 2025
Bachelor of Engineering (BE) at Rajasthan University, India
January 11, 2030 - November 11, 2025

Qualifications

Microsoft Certified – Azure Data Engineer Associate (AZ-203)
January 11, 2030 - November 11, 2025
Microsoft Certified – Azure Data Fundamentals (AZ-900)
January 11, 2030 - November 11, 2025

Industry Experience

Financial Services, Professional Services, Software & Internet, Other