Hosting events
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
Data Warehousing
Teradata SQL, RDBMS
Unix, Windows OS
IICS, Informatica, Powercenter, Datastage
ETL, ELT
JAMS, Crontab, ScheduleIN
Cross-functional teamwork
Documentation skills
Critical Thinking
Test implementation
Analytical skills
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
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