Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Kalpana Tripathi

Cincinnati,OH

Summary

Insightful Senior Consultant with 8 years of experience in Data Engineering and Analysis consulting with good experience in full life cycle (SDLC) Data Warehousing using Informatica PowerCenter9.x,10.2, Snowflake, Azure Databricks, Oracle SQL, Python and UNIX scripting, Teradata, Hadoop, Hive, Talend DI, Podium, Sqoop, DBT Cloud and DataStage. Optimistic, organized, and flexible. Excellent persuasion and leadership skills. Proficient in generating logical solutions to solve intricate problems.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Senior Data Engineer

EY|USBasedBank
11.2021 - Current
  • Project aids in seamless migration of their legacy system could
  • Client is moving data into snowflake in phases, initial phase revolved around analyzing systems and their scope. Second and on-going phase is mainly focusing on identifying and rationalizing downstream consumers of data.
  • Working on building data product from scratch for consumers to use directly from data market place using data exchange.
  • EDW, analysis of impact to those consumers, and development of strategies to remediate those impacts
  • Identifying consumers in EDW where Business Objects universe(s) will be impacted by other applications migrating to Data Mesh platform and develop interim state solution to supply data to those broken reports and universes.
  • Also, refactoring Bo reports to snowflake from EDW.
  • Built automation tool using python to analyze long and multiple SQL queries at once and generate report containing number of tables, table/column aliases, columns and other relevant details. This tool help client saving around 3000 hours.
  • Mentored junior team members in best practices for software development, code optimization, and troubleshooting techniques.
  • Designed and implemented effective database solutions and models to store and retrieve data.
  • Enhanced system performance by designing and implementing scalable data solutions for high-traffic applications.

Senior Data Engineer

EY|USBasedBank
02.2021 - 10.2021
  • Project aids in seamless migration of all Customer/Account/Loan data from BBVA into PNC Applications and produce dashboards with complete audit trail of data and help in reconciliation of all loaded data
  • In this engagement migrated and Integrated BBVA data into existing PNC system
  • Have also built Automation tool for end-to-end data validation of data from different sources to Teradata database target.
  • Successfully migrated 10 source systems alone.
  • Developed polished visualizations to share results of data analyses.
  • Participated in strategic planning sessions with stakeholders to assess business needs related to data engineering initiatives.
  • Developed custom algorithms for efficient data processing, enabling faster insights and decision making.

Senior Project Engineer

WIPRO|Telecom
08.2019 - 02.2021
  • It’s one of leading Telecom companies in Netherlands which is planning to migrate data into its database system for future analytical implementations post-merger
  • Migrated tele2 data into TMNL
  • TESS database which includes analyzing both systems data and merging it into one system having data files from different sources like salesforce, oracle, Flat Files, Google analytics from which maintain data into TESS (Teradata data model).Then create Extraction queries in which it creates view and make sure that required output data is generated and put that data into final reporting tool.

Senior Project Engineer

WIPRO| US Based Bank
04.2018 - 08.2019
  • It’s one of leading Bank in US and Canada
  • In this Project migrating old mainframe databases to HDFS which includes analyzing mainframe databases and converting them to Hive schema using java codes or Podium
  • Have mainly two parts: Ingestion and Extraction In Ingestion: create tables using hive queries and ingest data into table Also performs unit testing to make sure correct data output is generated In Extraction. Create views in which make data available at final reporting tool.
  • Managed 30 source system to ingest the data into hive.
  • Handled a team of 20 employees.

Project Engineer

WIPRO| Insurance
03.2016 - 07.2018
  • FL-GL project is integration of FL (Friends Life) into existing Aviva life finance system integration includes various accounting source system of FL to be integrated into Aviva GL Each source system of FL has different architecture, so scope of project is first to pre-process each source system to make it equivalent as in exiting Aviva system then integrate it and generate same output file as existing system for each FL source system
  • Generated target files then loaded to finance data warehouse (FDW) to process further for report generation.
  • Migrated more than 40 FL source systems to Existing Aviva system.

Education

Software Engineering

Birla Institute of Technology
Pilani Rajasthan, India
12.2019

Skills

Technical Expertise:

  • Data Integration/Migration (ETL/ELT) – Informatica PowerCenter 95x, 102, DBT cloud/core Talend, DataStage, Azure Databricks

Databases:

  • Oracle- SQL, Teradata, Snowflake, DB2

Scripting:

  • Unix Shell Scripting, Python, Perl

Data Lake:

  • Podium data ingestion, HDFS, HIVE, Sqoop-in

Functional knowledge:

  • ETL, Data Integration, Data Migration and Source System Analysis, EDW, Data Mart

Domain and Functional Expertise:

  • Domain –Telecom, Banking, Insurance

Other Skills:

  • Excel advance formulas, Excel VB, Jira, TFS, Confluence

Certification

DP-900: Microsoft Azure Data Fundamentals

Timeline

Senior Data Engineer

EY|USBasedBank
11.2021 - Current

Senior Data Engineer

EY|USBasedBank
02.2021 - 10.2021

Senior Project Engineer

WIPRO|Telecom
08.2019 - 02.2021

Senior Project Engineer

WIPRO| US Based Bank
04.2018 - 08.2019

Project Engineer

WIPRO| Insurance
03.2016 - 07.2018

Software Engineering

Birla Institute of Technology

Similar Profiles

CREATE PROFILE
Kalpana Tripathi