Sheetal Katiyar

Experience

• 

  Teradata

  Aug 2013 - Jun 2019

  Database Analyst

  • Created Teradata objects like tables and Views.• Tuning of SQL to optimize the performance, Spool space and CPU Usage.• Worked on data load failures ,duplication issues and data mismatch.• Involved in troubleshooting the production issues and providing production support.• Development of scripts for loading the data into the base tables in EDW using fastload,multiload and BTEQ utilities of Teradata.• Involved in loading of data into Teradata from legacy systems and flat files using mload,fastloadscripts.• Agile team interaction. • Implementation of new database, including creating users, database objects. • Monitoring Teradata system through Viewpoint.• Resolving DBS issues like long parsing time, query taking more time etc.• Upgrades related to OS, Database, Viewpoint, DataMover, Hardware. Show less

• 

  Cognizant

  Jun 2019 - May 2020

  Senior Developer/DBA

  • Responsible for scheduling, running and monitoring job run batches• Handle change requests during production and watch the Code until UAT.• Design Scheduler nodes for Production support.• Worked on Scheduler-Event engine, custom procedures, testing on processed data and procedures.• Perform data quality analysis using advanced SQL skills.• Perform Financial Balancing count validation, and Quality Checks.• Extensive SQL querying on Staging, Data warehouse and Data Marts.• Create feeds (tables) as per checklist, load data from source using Teradata TPT script and UNIX environment.• Worked on to create ETL flow as per Amex standard and process the data in each phase.• Solved various defects in set of wrapper scripts which executed the Teradata BTEQ, MLOAD, FLOAD utilities. • Providing support to business user queries by solving data integrity issues .• Developed a Troubleshooting Documents which listed all the support related activities and day-to-day issues encountered every day.• Created and maintained several custom reports using Business Objects.• Handled tickets using Incident management through Service now. Show less

• 

  GAVS Technologies

  May 2020 - May 2021

  Senior Teradata DBA
• 

  Wipro Ltd

  Sept 2021 - now

  Technical Lead(Teradata DBA)