Summary
Overview
Work History
Education
Skills
Accomplishments
Interests
Timeline
Generic

Pooja Agrawal

QA ETL Test Enigneer
Pune,Maharashtra

Summary

Hardworking ETL Developer/Tester offering 5 years of experience and expertise necessary to take on dynamic and complex Data Warehouse systems. Talented in developing comprehensive approaches to test/develop ETL applications. Strong background in manual testing.
Proven skills in completing black, white box tests.
Fully versed in complete SDLC and has clear understanding of testing/development task using UNIX, SQL and different ETL tools as IICS, Informatica Cloud, Talend, Teradata, IBM Datastage.

Overview

3
3
Languages
4
4
years of post-secondary education
4
4
years of professional experience

Work History

ETL Tester, United Parcel Service

IBM India Private Limited
Pune, Maharashtra
04.2020 - Current
  • Liaise with internal teams (e.g developers, Solution Architect, Business Analyst, Project Manager) to identify system requirements.
  • Estimate, prioritize, plan and coordinate testing activities.
  • Create detailed, comprehensive and well-structured test plans and test-cases.
  • Evaluated function, performance and design compliance of every integration against design standards and customer needs.
  • Implemented use of IBM Datastage and Microsoft SQL Server DB tools to illustrate project features and requirements.
  • Develop and apply testing processes for new and existing products to meet clients needs.
  • Tracked, prioritized and organized defects with Azure DevOps, working with development team to facilitate timely corrections with 100% efficiency.
  • Perform thorough regression testing when bugs are resolved.
  • Track quality assurance metrics, like defect densities and open defect counts.
  • Authored and maintained well-organized, efficient and successful manual test cases for entire team.

ETL Tester, Transcend IDW

Teradata
Pune, Maharashtra
01.2019 - 04.2020
  • Performing end to end testing for Informatica jobs: User Acceptance Testing, System Integration, Regression and Functional.
  • Worked on Unix Commands and Followed ETL Testing Process (Database and Dataflow Validation) Worked on job scheduling tool – JAMS.
  • Developed, documented and maintained functional test cases and other test artifacts like test data and data validation results.
  • Analyze test cases thoroughly to ensure adequate coverage of requirements.
  • Execute test cases, analyze test results and accordingly log defects, track and re-test defects.
  • Review of test cases written, in order to meet acceptable standard Working with Talend from past 6 months with respect to new requirements upcoming in project.
  • Worked on various major components of Talend like tmap, tjoin, tprejob, tpostjob, tfilelist, tunite, treplicate, trunjob, etc.
  • Developed mappings in talend using tmap, tjoin, tunite, tloop, Context, etc components.
  • Designed and developed logic to transform source data to be loaded into target.
  • Migration of code from lower environments in Talend to higher ones.

ETL Developer, Vodaphone Australia

Teradata
Pune, Australia
09.2018 - 12.2018
  • Had short-term role in this project serving short-term requirement.
  • Experienced in client interaction, onsite and offshore model.
  • Worked on ETL base object, Staging, landing, query, package, data mappings, etc.
  • Configuration/Creation of jobs in SAS DI.
  • Written UNIX shell scripts to automate process 30% and job monitoring for application.
  • Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.

ETL Developer, Procter & Gamble

Teradata
Pune, Maharashtra
12.2016 - 08.2018
  • Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations.
  • Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
  • Collaborated with system architects, design analysts and others to understand business and industry requirement.
  • Loaded/Extracted data to and from P&G database and Teradata DW to 1 Consumer Place (1CP – Procter & Gamble’s Enterprise Data Warehouse).
  • Understanding different business scenarios, writing shell scripts, develop interfaces, write and execute testcases, perform data validation using SQL and validate logs.
  • Exposure in end to end development of various application and testing right from requirement analysis to system study, designing, coding, testing, debugging, documentation and implementation.
  • Wrote and optimized in-application SQL statements and was doing performance tuning.
  • Utilized code versioning systems such as GIT-Hub to reduce development times.
  • Writing UNIX shell scripts to automate certain process in Data Warehouse environment, Disk space utilization, ScheduleIN Server Cleanup and UNIX file system maintenance and cleanup, Migrating entire 1CP code, data from Crontab to ScheduleIN tool (Scheduling cum Development tool).
  • ETL server upgradation and testing under Red Hat Enterprise Linux upgradation and NFS configuration.
  • Major role in minor project BIG DATA EXTRACTION with parameterized TPT Fast Export.
  • Preparing Low-Level Design document from High Level Modelling Document.
  • Used Teradata TPT Utilities(FastLoad, MultiLoad, FastExport) and BTEQ for (ETL) operations on target database.
  • Hands on experience in preparing Deployment Plan, Pre-deployment script, Rollback scrips, Provide deployment KT and documentation to Production Support team.
  • Hands on experience in DEV, SIT, UAT phase of development and testing and co-ordinate with onsite-offshore teams.

Education

BE - Information Technology

Pune University
International Institute Of Information Technology
08.2012 - 06.2016

Skills

SQL Programming

undefined

Accomplishments

  • Microsoft Azure AZ-900 Fundamentals Certified.
  • Teradata 14 Certified Professional.
  • Microsoft Technology Associate :Database Certified.
  • AWS Technical Training Certified .
  • AWS Business Training Certified

Interests

Hosting events

Dancing

Arts and Crafts

Timeline

ETL Tester, United Parcel Service

IBM India Private Limited
04.2020 - Current

ETL Tester, Transcend IDW

Teradata
01.2019 - 04.2020

ETL Developer, Vodaphone Australia

Teradata
09.2018 - 12.2018

ETL Developer, Procter & Gamble

Teradata
12.2016 - 08.2018

BE - Information Technology

Pune University
08.2012 - 06.2016

Similar Profiles

CREATE PROFILE
Pooja AgrawalQA ETL Test Enigneer