Hello! I’m a highly motivated technical professional with 20+ years of experience in IT, including 15 years focused on data warehousing, data lakehouse, and ETL/ELT pipeline development. I excel at solution architecture, end-to-end data engineering, performance tuning, production readiness, and coaching teams to deliver scalable, robust data platforms that drive business value. I’m a proactive collaborator who thrives with business users, governance groups, and cross-functional teams to ensure data quality, security, and governed access. I’ve worked across industries such as aviation, finance, healthcare, and manufacturing, building multi-cloud data pipelines and semantic layers that empower BI and analytics. I enjoy solving complex data challenges, sharing knowledge through training and documentation, and continuously improving data governance, metadata management, and operational excellence to help organizations achieve their data goals.

Vikas Thorat

Hello! I’m a highly motivated technical professional with 20+ years of experience in IT, including 15 years focused on data warehousing, data lakehouse, and ETL/ELT pipeline development. I excel at solution architecture, end-to-end data engineering, performance tuning, production readiness, and coaching teams to deliver scalable, robust data platforms that drive business value. I’m a proactive collaborator who thrives with business users, governance groups, and cross-functional teams to ensure data quality, security, and governed access. I’ve worked across industries such as aviation, finance, healthcare, and manufacturing, building multi-cloud data pipelines and semantic layers that empower BI and analytics. I enjoy solving complex data challenges, sharing knowledge through training and documentation, and continuously improving data governance, metadata management, and operational excellence to help organizations achieve their data goals.

Available to hire

Hello! I’m a highly motivated technical professional with 20+ years of experience in IT, including 15 years focused on data warehousing, data lakehouse, and ETL/ELT pipeline development. I excel at solution architecture, end-to-end data engineering, performance tuning, production readiness, and coaching teams to deliver scalable, robust data platforms that drive business value. I’m a proactive collaborator who thrives with business users, governance groups, and cross-functional teams to ensure data quality, security, and governed access.

I’ve worked across industries such as aviation, finance, healthcare, and manufacturing, building multi-cloud data pipelines and semantic layers that empower BI and analytics. I enjoy solving complex data challenges, sharing knowledge through training and documentation, and continuously improving data governance, metadata management, and operational excellence to help organizations achieve their data goals.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
See more

Language

Javanese
Advanced

Work Experience

Lead Data Engineer/ETL Data Architect at Farm Credit Financial Partners
June 1, 2025 - November 25, 2025
Architected and built automated, metadata-driven, multi-cloud ETL pipelines using Databricks, DBT, Snowflake, Synapse, Informatica IDMC, and Kafka. Designed an Extract Framework to securely ingest data from banks, populate Core and Analytics layers, and deliver governed data extracts to partner organizations with automated distribution to downstream systems.
Lead Data Engineer/Data Architect at SC Johnson
May 31, 2025 - May 31, 2025
Ingest Kinaxis data into the SNP Supply Planning/Demand Forecasting warehouse, architect Core and Semantic layer, and enable secure BI reporting. Built automated pipelines to blend new Kinaxis data with existing data and exposed downstream extracts to applications with governance and data quality controls.
Lead Data Engineer/ Data Architect at T-Mobile
July 31, 2023 - July 31, 2023
Built the HR and Payroll Data Warehouse, defining Core and Semantic layers and enabling row-level security for sensitive employee data. Delivered semantic layer feeding Tableau and SSRS reports, with performance-conscious metadata-driven design and DevOps-enabled pipelines across multi-cloud environments.
TD/ETL Consultant at Teradata (FinancialForce Project)
June 30, 2020 - June 30, 2020
Worked on FinancialForce data acquisition and staging into Teradata Vantage, orchestrating ETL via IDMC, Talend, and BTEQ to support modernized financial reporting.
TD/ETL Architect/ Sr Data Engineer at Delta Airlines
March 31, 2020 - March 31, 2020
Implemented a data warehouse for International Commercial Customers, developed backfill and delta strategies, and established semantic layer with row-level security to support reporting in Tableau and SSRS.
TD/ETL Architect/ Sr Data Engineer at Concho (Oil and Gas)
June 30, 2019 - June 30, 2019
Ingested Bore Well data via KYLO into AWS/TD staging, then aggregated with stored procedures into the semantic layer; designed scalable ingestion and delta feed for multi-well, multi-client use cases.
TD/ETL Architect/ Sr Data Engineer at Fannie Mae
March 31, 2019 - March 31, 2019
Supported migration from Netezza by validating connectivity and running mappings against Teradata 16.20 with TPT, guiding backfill and delta feeds for production readiness.
TD/ETL Lead at Marsh & McLennan
December 31, 2018 - December 31, 2018
Led ETL design and development for enterprise data integration; defined backfill and delta strategies, release management, and production deployment.
TD/ETL Lead at Cincinnati Children’s Hospital
July 31, 2017 - July 31, 2017
Designed and developed ETL processes for EDW with Big Data integration, enabling timely and accurate reporting for healthcare analytics.
TD/ETL Lead at CVS Health
December 31, 2016 - December 31, 2016
Provided technical support for vendor billing data migration, identified gaps, and developed scripts to address gaps while validating connectivity and ETL flows.
TD/ETL Consultant at GameStop
October 31, 2016 - October 31, 2016
Designed and developed ETL processes, backfill and delta feeds, and maintained a gold copy of customer master data with performance tuning and semantic layer optimization.
TD/ETL Lead at MICRON
March 31, 2016 - March 31, 2016
Led ETL design and development for EDW and Big Data integration, establishing backfill/delta strategies across legacy systems.
TD/ETL Lead at Community Health System
December 31, 2015 - December 31, 2015
Designed and developed EDW ETL with Big Data integration, performance tuning, and semantic layer queries in an Agile environment.
ETL Architect at Frontier Communications
February 28, 2015 - February 28, 2015
Led ETL design and backfill for customer and product data; oversaw production deployment and validation across multiple environments.
ETL Architect at JCPenny
January 31, 2014 - January 31, 2014
Led design and development of ETL for new retail merchandize system; performed backfill and delta data loads for customer/product data.
Technical Lead at BNSF
January 31, 2013 - January 31, 2013
Led development of a Corporate Dashboard; implemented backfill and delta data from multiple legacy systems to the dashboard.
ETL Architect at PepsiCo
December 31, 2011 - December 31, 2011
Technical lead for S&OP/SCM data warehouse; designed backfill and delta feeds and oversaw production deployment.
ETL Architect at Centurylink
October 31, 2010 - October 31, 2010
Led migration and ETL design for customer data and legacy billing systems; backfill/delta strategy and production readiness.
Technical Lead at AT&T
February 28, 2009 - February 28, 2009
Led Data Warehouse initiatives sourcing from multiple legacy systems; design, development, testing, and production support.
ETL Architect at Centurylink
February 28, 2006 - February 28, 2006
Migration and ETL design for backfill of customer data and legacy systems.
Technical Lead at Sprint
April 30, 2005 - April 30, 2005
Design and development of BSS data integrations; ETL and reporting readiness.
Technical Lead at Amdocs
May 1, 1999 - May 1, 1999
AMDOCS billing product development and integration; end-to-end data flow design and implementation.
TD/ETL Consultant at APC Inc
May 1, 2025 - May 1, 2025
Teradata consulting engagements delivering multi-cloud ETL pipelines using Informatica IDMC/IICS, BTEQ, and TPT; collaborated with SC Johnson and other clients on data integration, staging, and semantic layer development.
Lead Data Engineer/Data Architect at SC Johnson
May 1, 2025 - May 1, 2025
Ingest Kinaxis data into the SNP data warehouse stage; design Core and Semantic layers for reporting; ensure data quality and performance; expose data to downstream applications via pipelines and extracts.
Lead Data Engineer/Data Architect at T-Mobile
July 1, 2023 - July 1, 2023
Built the HR & Payroll data warehouse core and semantic layer with row-level security; integrated sources including SQL Server, ADP, Kronos, Kenexa, SAP, Workday, and Google BigQuery into Teradata Vantage/Snowflake; implemented pipelines via Informatica, AWS, Azure Databricks; enabled BI reporting via Tableau/SSRS.
TD/ETL Consultant at FinancialForce
June 1, 2020 - June 1, 2020
Acquired data from FinancialForce, staged into Teradata Vantage, and ingested into Talend for reporting using Informatica IICS; provided initial production support and routine maintenance.
TD/ETL Architect/Sr Data Engineer at Delta Airline
March 1, 2020 - March 1, 2020
Developed a data warehouse for International Commercial Customers; staged historical and incremental data, built core/semantic layers, and ensured data quality and performance; established secure data access for analytics.
TD/ETL Architect/Sr Data Engineer at Concho
June 1, 2019 - June 1, 2019
POC completed; ingested Bore Well data with KYLO into AWS/TD cloud staging, then aggregated into the semantic layer; designed reusable ingestion patterns for multi-client use cases; guided managed services for testing and production.
TD/ETL Architect/Sr Data Engineer at Fannie Mae
March 1, 2019 - March 1, 2019
Migrated from Netezza to a Teradata-based warehouse; installed TTU16.20 on Linux/Solaris ETL servers; validated connectivity and run mappings via TPT; supported backfill and delta data feed for production.
TD/ETL Lead at Marsh & McLennan
December 1, 2018 - December 1, 2018
Designed and developed ETL processes; defined backfill/delta feed strategies; facilitated testing, UAT, and release management for production deployment.
TD/ETL Lead at Cincinnati Children's Hospital
July 1, 2017 - July 1, 2017
Designed and developed ETL processes, defined backfill and delta feeds; facilitated testing, UAT, and production deployment in an Agile environment.
TD/ETL Lead at CVS Health
December 1, 2016 - December 1, 2016
Provided technical support for Vendor Client Billing migration; identified gaps across modules and developed scripts to address gaps; performed high-level performance analysis.
TD/ETL Consultant at GameStop
October 1, 2016 - October 1, 2016
Designed and developed ETL processes with backfill/delta strategies; built gold copy of customer master data; performed performance tuning and semantic layer optimization; environment monitoring.
TD/ETL Lead at MICRON
March 1, 2016 - March 1, 2016
ETL development for EDW and Big Data integration; backfill/delta feeds for legacy systems; integration with Big Data platforms.
TD/ETL Lead at Community Health System
December 1, 2015 - December 1, 2015
ETL design for EDW with Big Data; performance tuning; semantic layer queries; production deployment.
ETL Architect at Frontier Communications
February 1, 2015 - February 1, 2015
ETL design for backfill of Customer and Product data; production implementation.
ETL Architect at JCPenny
January 1, 2014 - January 1, 2014
Technical lead for Retail Merchandise System data migration; backfill/delta feeds; production.
Technical Lead at BNSF
January 1, 2013 - January 1, 2013
Development of a Corporate Dashboard system to publish performance; backfill/delta data from legacy systems to DW.
ETL Architect at PepsiCo
December 1, 2011 - December 1, 2011
ETL lead for a Supply Chain Data Warehouse; backfill and delta feeds; data migration and production deployment.
ETL Architect at CenturyLink
October 1, 2010 - October 1, 2010
Migration of EMBARQ Customer data into Data Warehouse and Legacy Billing system; ETL design and production deployment.
Technical Lead at CenturyTel
February 1, 2006 - February 1, 2006
ETL Lead for Madison River customer data migration; design, development, testing, and production readiness.
Technical Lead at Sprint
April 1, 2005 - April 1, 2005
Technical Lead for SPRINT PCS BSS projects; design, development, testing, and implementation; involved in C, C++, Java components.
Technical Lead at Tata Infotech
May 1, 1999 - May 1, 1999
In-house consultancy projects; design, development, testing, and implementation across telecom initiatives.
Lead Data Engineer / Data Architect at APC Inc
May 1, 2025 - May 1, 2025
Delivered Teradata consulting engagements as Lead Data Engineer/ETL Architect, designing scalable data pipelines, semantic layers, and data models across multi-cloud environments. Collaborated with business users and governance teams to ensure data quality, performance, and secure access.
Lead Data Engineer/ Data Architect at T-Mobile
July 1, 2023 - July 1, 2023
Built HR/Payroll data warehouse core and semantic layer with row-level security for Tableau/SSRS reporting; implemented production-grade semantic layer using ETL/DW patterns; led offshore team and customer-facing delivery.
TD/ETL Lead at Cincinnati Children’s Hospital
July 1, 2017 - July 1, 2017
Design and development of ETL processes, backfill and delta feed for EDW with Big Data; testing and production implementation in Agile environment.
ETL Architect at JCPenney
January 1, 2014 - January 1, 2014
Lead ETL architecture for new Retail Merchandise System; backfill and delta data migrations; production implementation.
ETL Lead at PepsiCo
December 1, 2011 - December 1, 2011
ETL lead for Supply Chain Data Warehouse; backfill and delta feed design, testing, and production deployment.
TD/ETL Architect at CenturyLink
October 1, 2010 - October 1, 2010
Migration of EMBARQ data into CenturyLink data warehouse; ETL design, backfill, and delta data integration.
Technical Lead at AT&T
February 1, 2009 - February 1, 2009
DW implementation sourcing data from legacy systems; ETL development, testing, and production support.
ETL Architect at CenturyLink
February 1, 2006 - February 1, 2006
Migration of Madison River data; ETL design, backfill, and production deployment.
Technical Lead at Amdocs
February 1, 2003 - February 1, 2003
AMDOCS telecom billing product customization and integration projects; ENSEMBLE/ENABLER modules.

Education

Add your educational history here.

Qualifications

Masters in Computer Applications
January 11, 2030 - November 25, 2025
BSc Electronics
January 11, 2030 - November 25, 2025
Informatica 9.x Developer
January 11, 2030 - November 25, 2025
Informatica 9.x Administrator
January 11, 2030 - November 25, 2025
Teradata 14 Professional
January 11, 2030 - November 25, 2025
Teradata 14 SQL
January 11, 2030 - November 25, 2025
AWS Technical Professional
January 11, 2030 - November 25, 2025
AZURE fundamentals
January 11, 2030 - November 25, 2025
Teradata Vantage
January 11, 2030 - November 25, 2025
Masters in Computer Applications
January 11, 2030 - November 25, 2025
BSc Electronics
January 11, 2030 - November 25, 2025
Informatica 9.x Developer
January 11, 2030 - November 25, 2025
Informatica 9.x Administrator
January 11, 2030 - November 25, 2025
Teradata 14 Professional
January 11, 2030 - November 25, 2025
Teradata 14 SQL
January 11, 2030 - November 25, 2025
AWS Technical Professional
January 11, 2030 - November 25, 2025
AZURE fundamentals
January 11, 2030 - November 25, 2025
Teradata Vantage
January 11, 2030 - November 25, 2025
Masters in Computer Applications
January 11, 2030 - November 25, 2025
BSc Electronics
January 11, 2030 - November 25, 2025
Informatica 9.x Developer
January 11, 2030 - November 25, 2025
Informatica 9.x Administrator
January 11, 2030 - November 25, 2025
Teradata 14 Professional
January 11, 2030 - November 25, 2025
Teradata 14 SQL
January 11, 2030 - November 25, 2025
AWS Technical Professional
January 11, 2030 - November 25, 2025
AZURE fundamentals
January 11, 2030 - November 25, 2025
Teradata Vantage
January 11, 2030 - November 25, 2025

Industry Experience

Healthcare, Manufacturing, Retail, Financial Services, Telecommunications, Transportation & Logistics