Divyangi Bajpai

Experience

• 

  Tata Consultancy Services

  Jun 2014 - now

  Worked in Ultimatix Global Recruitment System for recruitment of Experienced Professional as ETL and Oracle SQl developer.Worked for mySRA UK Account as a QA testing engineer , supported onsite QA testers for testing process.Started working as ETL developer Salesforce America Account.Worked on Dev, QA and Deploy activities for AppExchange Partner Analytics Project to Migrate Partner's data from Salesforce cloud to Oracle Data warehouse.Worked on Design, Dev , QA , and Deploy activities for FiTT Reporting Enablement project.Handed the prod migration for the R1, R2 and R3 releases for Fitt and CSG teams for Salesforce. Created more than 100 Workflows (Full load , SCD type 1, SCD type 2 ), Metrics calculations for CSG Salesforce account. Working on Advanced SQL queries to design fact table logic.Working with STG, ODS, DIM and FACT schema strucure designs and dev for EDW datawarehouse in CSG project.Familiar with Snowflake cloud datawarehouse concepts as worked on Data migration into Snowflake DWH from Salesforce Cloud using Python scripts.Completed Tableau and Power BI certifications and hands on knowledge of the same. Created many extracts and dashboards using Tableau for CSG client for AZPRD data quaity checks.Learning new skills like python and Qilksense.Outstanding track record and proven skill set reflected by providing quality deliverable to the clients andstakeholders in every professional assignment. Show less Creation and management of schema.Designing various ETL objects, Database schema objects, Data migration using Informatica,Development of workflows Unit testing.Successfully deployed Paperless module in Global Recruitment system(GRS) which helped TAG team to save 20K US dollars.Successfully automated LATAM offer module for latin american countries like Colombia, Brazil which is ready to go live.It will help in reducing time and efforts of TAG group and will provide smooth offer and joining process to LATAM candidates.Deployed 30 workflows (full load and Incremental load) related to LATAM offer to provide necessary data to ITalent system .Sprint backlog grooming, Identifying the changes and impact analysis, Designing ETL objects ,database schema objects.Data migration using Informatica, Development of workflows, Unit testing, System Testing, Creating deployment scripts, Designing various interfaces through Informatica.Performing DBA functions like importing and exporting databases, Performance tuning, reading TK profs and AWR reports for performance. Show less Started working as Oracle developer for Global recruitment System project.Created various types of procedure and packages .Worked on Integration testing for migration of italent db from oracle to postgre.Appreciation from supervisor for single handedly completing integration testing.Creation of Informatica mappings(Full load and Incremental Load.Worked in sync with Next-Gen MIS to provide reports data for ETL creation and Informatica integration testing. Design and Development of database objects ( Procedures , packages,triggers,views etc). Show less

  • Assistant Consultant

    Jul 2023 - now

  • Information Technology Analyst

    Oct 2018 - now

  • System Engineer

    Oct 2016 - Sept 2018

  • Assistant System Engineer

    Jun 2014 - Sept 2016