Data Engineer Sr

Vikas Thorat

Summary

Highly motivated Lead/Sr Data Engineer, ETL Architect and Teradata professional with over 20+ years of IT experience and 15 years of Teradata data warehouse and ETL experience in various capacities including Lead/Sr Data Engineer, Sr ETL Architect, Lead, Sr Developer. Specialization in technical lead/architect roles for Dataware house, ELT/ETL, Data Engineering design, development, performance tuning, productionalise, overall system quality assurance and testing functions. Demonstrated strong analytical, technical, critical thinking, multitasking and problem solving skills. Been a self-starter, lead, team player, interacted with clients. Provided revision based, compatible, flexible, full proof and reliable solutions. Consistently driving values, performance, training & mentoring for client’s data warehousing needs.

Teradata Consulting Engagements through APC Inc 11/2020 - todate

SC Johnson

Sr Data Engineer/ Sr ETL Architect 08/2023 – todate

SC Johnson added new source Kinaxis data to their SNP Supply Planning and Demand Forecasting warehouse. My Role includes Architect, Design, Development and support to ingest Kinaxis data into Teradata stage using data pipelines, mapping and build Core, Semantic layer to be used for reporting in BI Reports via secure access. The new data should merge with existing data without impacting data quality and performance. New data also made available to downstream applications via pipelines extracts.

Technologies - Teradata, Azure ADF, Data Bricks, AWS S3, Python, BLOB Storage, Synapse, SnowFlake, GBQ, Informatica IICS, DevOPS, Agile, GITHUB, BPT, Jira, Autosys

T-Mobile

Sr Data Engineer/ Sr ETL Architect 07/2020 – 07/2023

T-Mobile had been building up their HR and Payroll Systems Dataware house to replace their HRDW/ODS SQL Server systems. Role includes to build up the Core and Semantic layer for Employee HR and Payroll Dataware house so HR System employees can have row level secured access to all T-Mobile and Sprint Employee's personal, ADP and work related data. I had been instrumental to successful implementation of Row Level Security Access after proof of concept without compromising the performance of Semantic Layer which feeds the Employee data to Tableau and SSRS reports through Voltage Encryption security. Been leading the team from Offshore as well performing customer facing Lead and Consultant role.on this assignement. Technically building the Core and Semantic Layer as ETL/DW consultant to ingest data from multiple source systems that includs SQL Server, ADP, Kronos, Kenexa, SAP, Workday, Google BigQuery into Teradata/SnowFlake stage, Core and Semantic with the help of BTEQ/TPT scripts, Informatica IICS, Azure Data Factory Pipeline via Notebook (Azure Databricks & Azure blob storage) in the DevOps environment and Agile methodology.

Technologies Deployed: Teradata, TPT, BTEQ, Informatica IICS, SnowFlake, Azure Data Factory, Data Bricks, Google BigQuery, AGILE, DevOPS, GITHUB, GITLAB, JIRA, Control-M etc.

Teradata Consulting Engagements through Teradata Inc 03/2015 - 10/2020

FinancialForce Reporting

TD/ETL Consultant 04/2020 – 06/2020

Teradata has initiated to implement FinancialForce to replace legacy reporting tools and modernize the financial reporting capabilities. I had worked on this assignement as ETL consultant to acquire data from FinancialForce and stage into Teradata and ingest into Talend for reporting with the help of Informatica Intelligent Cloud(IICS) and BTEQ scripts.

Technologies Deployed: Informatica IICS, Teradata 16.20, TPT, PYTHON, Windows, etc.

DELTA Airline

TD/ETL Architect/Sr Data Engineer 08/2019 – 03/2020

Delta Airline building up their dataware house for International Commercial Customers to maintain the data profiling of all indetified commercial customers. I had worked on this assignement as TD consultant to stage the history and incremental data into the dataware house.

Technologies Deployed: Informatica 10.2, IICS, Teradata 15.10, TPT, PDO, PYTHON, Unix, etc.

Concho (Oil and Gas Industry)

TD/ETL Architect/ Sr Data Engineer 04/2019 – 06/2019

TD/ETL Consultant for Teradata 16.20 AWS cloud-based solution at CONCHO, Midland TX. CONCHO had approved POC solution provided by Teradata and is in the process of productionize the solution. Role includes responsibility of TD/ETL consultant to ingest the Bore Well data with the help of KYLO into AWS/TD cloud staging environment and then aggregate with the help of Stored procedures into Semantic layer. Designed and developed the ingestion process for 1 to multiple Bore Wells and for 1 to multiple clients and guided to managed services to validate use cases, ETL processes, ingestion and delta feed samples, facilitating the testing, user acceptance and production environments.

Technologies Deployed: TD 16.20, BTEQ, TPT, Stored Procedures, AWS, KYLO, etc.

Fannie MAE (Finance Loan Industry)

TD/ETL Architect/ Sr Data Engineer 02/2019 – 03/2019

TD/ETL Consultant for Teradata 16.20 POC at Fannie Mae, Reston VA. Fannie Mae is in the process of getting rid of their existing Netezza database and replacing with another data ware house database which can fulfill their data ware house exceeding demands and requirements. Role includes responsibility of installing TTU16.20 on various Linux and Solaris ETL severs which are configured to connect Teradata 16.20 by various tools includes INFORMATICA and ABINITIO. Helped and guided Fannie Mae’s various functional team resources to validate the connectivity with Teradata and run their modified mappings against Teradata DB with TPT connectivity to validate their use cases, ETL processes, backfill and delta feed samples, facilitating the testing and user acceptance environment.

Technologies Deployed: TD 16.20, BTEQ, TPT, Informatica 10.1, IICS, Power center, etc.

MARSH & McLennan (Finance Industry)

TD/ETL Lead 08/2017 – 12/2018

TD/ETL Consultant for new cloud-based Teradata Enterprise Data Warehouse for Marsh Global Analytics. Role includes responsibility of design and development of the ETL process, defining the backfill and delta feed strategy, facilitating the testing and user acceptance, and Release Management and production implementation.

Technologies Deployed: TD 16.20, BTEQ, TPT, Informatica 9.x Power center, etc.

Cincinnati CHILDREN HOSIPTAL (Healthcare Industry)

TD/ETL Lead 01/2017 – 07/2017

TD/ETL Consultant for new cloud based Teradata Enterprise Data Warehouse for CCHMC. Role includes responsibility of design and development of the ETL process, defining the backfill and delta feed strategy, facilitating the testing and user acceptance, and production implementation in Agile environment.

Technologies Deployed: TD 15.10, BTEQ, TPT, Informatica 9.x Power center, etc.

CVS Health (Healthcare Industry)

TD/ETL Lead 11/2016 – 12/2016

Provided technical support to Vendor Client Billing project to migrate in the production. Helped client to identify gaps among all the modules of VCB project and developed scripts to overcome those gaps. This VCB data will be used by the CVS business users to analyze customer promotions and Vendor billing. Also performed a high-level system performance analysis to identify potential pitfalls and areas of improvement.

Technologies Deployed: TD 15.10, BTEQ, Stored Procedures, UDFs, Macros, etc.

GameStop (Gaming Industry)

TD/ETL Consultant 03/2016 – 10/2016

ETL Consultant for new cloud based Teradata Enterprise Data Warehouse. Role includes responsibility of design and development of the ETL process, defining the backfill and delta feed strategy, facilitating the testing and user acceptance, and production implementation. Additional responsibility includes create and maintain gold copy of customer master data through set of 15 waterfall rules, performance tuning, Semantic layer queries and setup and monitoring of environment.

Technologies Deployed: TD 15.10, BTEQ, TPT, Informatica 9.x Power center, SQL Server, Vertica, etc.

MICRON (Manufacturing Industry)

TD/ETL Lead 01/2016 – 03/2016

ETL Consultant for new Teradata Enterprise Data warehouse development along with Big Data integration. Role includes responsibility of design and development of ETL process, defining the backfill and delta feed strategy for data integration of legacy systems, EDW and Big data.

Technologies Deployed: TD 14.10, BTEQ, TPT, Informatica 9.x BDE and Power Center, Big Data, HDFS, Oracle, etc.

Community Health System (Healthcare Industry)

TD/ETL Lead 08/2015 – 12/2015

ETL lead for new Teradata Enterprise Data warehouse design and development. Role includes design and development of ETL process, defining the backfill and delta feed strategy for data integration in EDW with Big data. Facilitating the testing and user acceptance, and production implementation. Additional responsibility includes performance tuning, Semantic layer queries and setup and monitoring of environment.

Technologies Deployed: TD 14.10, BTEQ, TPT, Informatica 9.x BDE and Power Center, Big Data, HDFS, Oracle8, etc.

Other Professional Work History

Frontier Communications (Communication Industry)

ETL Architect 02/2014 – 02/2015

ETL Lead for migration of AT&T Customer data into Frontier Data warehouse and Legacy Billing system. Role includes design and development of ETL process for backfill of Customer and Product data. Facilitating the data mapping and user acceptance and production implementation.

Technical Environment: TD 14.10, BTEQ, TPT, Informatica 9.x Power Center, Oracle, DB2, SQL Server.

JCPenny (Retail Industry)

ETL Architect 02/2013 – 01/2014

Technical lead for new Retail Merchandise System implementation and to convert Customer and Product data from JcPenny legacy systems. Role includes design and development of ETL process for backfill and delta feed of Customer and Product data. Facilitating the data mapping and user acceptance and production implementation.

Technical Environment: TD 14.10, BTEQ, TPT, Informatica 9.x Power Center, Oracle, DB2.

BNSF (Rail Industry)

Technical Lead 01/2012 – 01/2013

Technical lead for development and implementation of Corporate Dashboard system to publish performance of all subsystems and elements of business. Role includes the design and development of backfill and delta source data from various legacy systems to dashboard. Facilitating the data integration and user acceptance and production implementation.

Technical Environment: TD 13, BTEQ, TPT, Stored Procedures, UDFs, Macros, Informatica 9.x Power Center, DB2.

Pepsico (Food Industry)

ETL Architect 09/2010 – 12/2011

Technical ETL lead for development and implementation of Supply Chain Data warehouse. Role includes the design and development of backfill and delta source data from various legacy systems to data warehouse. Facilitating the data mapping and user acceptance and production implementation.

Technical Environment: TD 13, BTEQ, TPT, Informatica 9.x Power Center, DB2, Oracle

Centurylink (Communications Industry)

ETL Architect 03/2009 – 10/2010

Technical ETL Lead for migration of EMBARQ Customer data into CenturyLink Data warehouse and Legacy Billing system. Role includes design and development of ETL process for backfill of Customer and Product data. Facilitating the data mapping and user acceptance and production implementation.

Technical Environment: TD 13, BTEQ, Informatica 8.x Power Center, Oracle, DB2, SQL Server

AT&T (Communications Industry)

Technical Lead 02/2006 – 02/2009

Technical lead for Data Warehouse implementation to source data from the various AT&T legacy systems. Role includes design, development, upgrades, user acceptance, testing and maintenance of Data ware house. Additional responsibilities to facilitate integration of new source data coming from various migration, conversion and acquisition.

Technical Environment: TD12, BTEQ, TPT, Oracle, Informatica 8.x

Centurylink (Communications Industry)

ETL Architect 05/2005 – 02/2006

Technical ETL Lead for migration of Madison River Customer data into CenturyTel Data warehouse and Legacy Billing system. Role includes design and development of ETL process for backfill of Customer and Product data. Facilitating the data mapping and user acceptance and production implementation.

Technical Environment: TD 12, BTEQ, Oracle

SPRINT (Communications Industry)

Technical Lead 03/2003 – 04/2005

Technical Technical Lead for design, development, testing and implementation of SPRINTPCS Business Support Systems (BSS) including Customer Care, Billing, Accounting and Revenue and Bill Format systems.

Technical Environment: C, C++, Pro*C, Java, Oracle

Amdocs (Communications Industry)

Technical Lead 06/1999 – 02/2003

Technical Member of the AMDOCS Cyprus development team to provide the telecom Billing services to European and US Clients. Role includes design, development, customization, testing and implementation of ENSEMBLE/ENABLER AMDOCS telecom billing products and their respective modules Customer Care, Billing, Order Management, Rating, Guiding, Accounting and Revenue systems.

Technical Environment: C, C++, Pro*C, Java, Oracle, Tuxedo

Tata Infotech (Consultancy Industry)

Technical Lead 06/1998 – 05/1999

Technical Technical lead for TIL in house projects to design, development, testing and implementation.

Technical Environment: C, C++, Pro*C, Java, Oracle

Roles

Lead/Sr Data Engineer

Sr ETL Architect

Teradata Consultant

EDW/Data Architect

Technologies

Informatica 10.x, ICS

Teradata Vantage

Temporal TPT BTQ

Snowflake

CDC Pipeline

CLOUD Azure GCP AWS

Google Big Query

Azure Data Factory

Azure Databricks

AWS Glue Lambda

Industries

Aviation

Retail

Manufacturing

Healthcare

Finance

Communications

Technical Expertise

Informatica IICS TD utilities

Databases TD SQL Server Snowflake GBQ DB2 Oracle

Languages PYTHON C++ Java

Environments CLOUD (AWS Azure GCP) Unix Mainframe Windows DevOPS

Education

Masters in Computer Applications

BSc Electronics

Professional Certifications

Informatica 9.x Developer

Informatica 9.x Administrator

Teradata 14 Professional

Teradata 14 SQL

AWS Technical Professional

AZURE fundamentals

Teradata Vantage

Contact this candidate