Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Shivam Srivastava

ETL, Data Warehousing Manager at Datazymes
Noida

Summary

Technical Manager with 7+ years of experience in data analytics and ETL development. Proficient in utilizing tools such as SSIS, Informatica, and Python scripting to drive efficient data processing. Proven track record in implementing cloud technologies like Azure and AWS, and integrating data for IMS, CRM, and omnichannel platforms. Skilled in project management, leading successful MDM and Tableau reporting initiatives while consistently delivering data-driven solutions. Holds a B.Tech in Information Technology, providing a solid foundation for driving innovation and achieving business objectives.

Overview

8
8
years of professional experience
6
6
years of post-secondary education

Work History

Manager

Datazymes
Noida
11.2021 - Current
  • Promoted to Technical Manager in July 2023 after joining as a Consultant in November 2021.
  • Worked on numerous projects, leveraging technologies like SSIS, Python scripting, C# scripts for SSIS jobs, and cloud platforms such as Azure and AWS (AWS Glue, PySpark).
  • Extensive experience in handling data integration with ICS 867, ICS 852, IMS, CRM (Veeva), and omnichannel data.
  • Key Projects:
  • Omnichannel Data Project:
  • Served as a Data Engineer, using omnichannel data to build a rule-based engine.
  • MDM Project (Master Data Management): Led a team to create an MDM solution using PySpark and Snowflake, incorporating a similarity scoring system for record matching based on fields like name and address.
  • CRM & Sales Reporting (Tableau): Managed a project responsible for reporting on CRM and sales data using Tableau.
  • Delivered multiple dashboards, including sales summary, call summary, and IC reporting.

Associate

Axtria India Pvt. Ltd.
03.2020 - 11.2021
  • Involved in requirements gathering, ETL design, development, and data reconciliation phase of SDLC. Involved in developing ETL code of the data warehouse using Matillion and Informatica. Also, created UNIX shell scripts as per business requirement in previous projects.
  • Worked on various modules, such as Customer Master Data (HCP and Outlets master data processing), Master profiles for Business use, and Roster.
  • Responsible for preparing the design and technical specification documents.
  • Understanding the customer requirements and developing jobs based on the design and technical specification document.
  • Developed and implemented strategies to increase customer satisfaction and engagement.

Systems Engineer

Tata Consultancy Services
Noida
11.2016 - 02.2020
  • Create jobs on Informatica PowerCenter and scripts on Unix.
  • Creation of SQL code to support current jobs present in system.
  • Monitoring of ETL jobs and resolving tickets on data issues in Data warehouse.
  • Client communication regarding failures, status of running jobs.

Education

B. Tech - Information Technology

A. P. J. Abdul Kalam University
Uttar Pradesh, India
06.2012 - 07.2016

12th Class -

G.N.K. Inter College
Kanpur, Uttar Pradesh
04.2010 - 03.2011

10th Class -

G.N.K. Vidya Mandir Inter College
Kanpur, Uttar Pradesh
04.2008 - 03.2009

Skills

Windows Variants, Linux (Ubuntu, Red Hat Enterprise Linux)

MS Office

Unix Shell Scripting, C#

Team Leadership

ETL Tools : Informatica PowerCenter, ICS, IDQ, Matillion, AWS Glue

Python and Pyspark

Project Management: Jira

Airflow, Automic

Ticketing : ServiceNow

Accomplishments

  • Won multiple Team awards and Individual awards in my current organization.
  • Recognition by clients and stakeholders during Townhalls and client meetings.
  • Won Axtria Bravo Award and Best Team Award.
  • TCS Annual appraisal bands: A for all three years
  • TCS, First anniversary rating (November 2017): 5/5
  • TCS On the Spot Award: Twice
  • TCS Star Team Award: Twice
  • TCS Star of the Month Award: Once

Timeline

Manager

Datazymes
11.2021 - Current

Associate

Axtria India Pvt. Ltd.
03.2020 - 11.2021

Systems Engineer

Tata Consultancy Services
11.2016 - 02.2020

B. Tech - Information Technology

A. P. J. Abdul Kalam University
06.2012 - 07.2016

12th Class -

G.N.K. Inter College
04.2010 - 03.2011

10th Class -

G.N.K. Vidya Mandir Inter College
04.2008 - 03.2009

Similar Profiles

CREATE PROFILE
Shivam SrivastavaETL, Data Warehousing Manager at Datazymes