Resume

Sign in

ETL tester

Location:
Irving, TX, 75062
Posted:
January 15, 2020

Contact this candidate

Resume:

Punya Pandey

CTFL Certified Data Base Tester

Phone: 469-***-****

Email: adbbdy@r.postjobfree.com

SUMMARY

Over 8 years of extensive experience in Software Quality Assurance and testing with strong knowledge Testing automation and core java, Software development life cycle (SDLC) and Software Testing Life Cycle (STLC).

•Hands on experience in analyzing Business Requirement, Functional Requirement, Design specification and developing Test plan and Test scenarios.

•Hands on Experience on web (front-end) testing.

Expertise in working with Selenium IDE and Selenium Web Driver using TestNG java framework.

Experience on developing a framework using a design pattern - Page Object Model.

Good experience in validating XML and XML Schema, XML Parser.

Worked on IE, Firefox and Chrome Driver.

Experience in writing CSS Selectors, Xpath expressions to identify web elements.

Experience on Working with TestNG for Automation testing Reports.

•Involved in preparation of Requirement Tractability Matrix (RTM), Defect Reports, and Periodic Status Reports.

•Have a knowledge about the Java language with the testing experience of Java Platform.

•comfortable on Regression testing with other kinds of testing.

•Expertise in UAT testing along with the business rules and users expectation

•Extensive experience in all testing methods including Waterfall, Agile and Scrum.

•Expertise in creating/developing Test cases, Test scenarios using standard and modular approach.

•Experience in testing of Data Warehouse/ETL Applications developed in Data stage using SQL Server, Oracle, DB2.

•Expertise in writing simple and complex SQL queries using TOAD, SQL Developer, SQL Server Management Studio.

•Comfortable in working worked with large volume of data in the database/data warehouse.

•Experience in writing test cases/ test scripts for Inbound and Outbound ETL processes and interfaces with other systems and streams.

•Have a knowledge of automation tools like QTP and Selenium.

•Have a knowledge of of Core Java and and OOPS concept.

•Experience on web application by using the SoupUI tool,XML,and Integration testing

•Extensively used ETL methodology for supporting data extraction, transformations and loading, in a corporate-wide-TEL Solution using ODI and Data stage .

•Experience in testing/validating the Source, Stage and Target (End-to-End) data systems

•Experience in analyzing the error caused to failure of the ETL load with reference to the log file and report them to the corresponding team to get it rectified

•Have experience in testing reconcile (initial) and delta (daily) loads.

•Have tested several complex reports generated by OBIEE, Micro-strategy including dashboards, summary reports, master detailed, drill down and score cards.

•Experience working with Quality Center/ ALM to store Business Requirements, Test Cases, Test Runs, and Test Results for every iteration and store defects and link them back to the requirements.

•Experience in testing/validation of Business standard and ad hock reports.

•Experience in End-to-End testing of an application/process. Performed back end testing using SQL Queries and UNIX scripting.

Technical• Expertise Emphasis in Defect tracking management,&scheduling Bug the tracking, and generating the graphs using Test Management Tools Testing Tools such as HP Quality Center:ALM,(ALM)Quality. Center, JIRA

Configuration Management: Sub Version (SVN), Rally, JIRA

Data warehouse

: Oracle Data Integrator (ODI), SSIS, Data-stage,

Reporting tools

Control-M, QTP and Selenium : OBIEE, Business

Languages/scripting

Object, Hyperion, ESS base, EPM 11

RDBMS

: Java, Visual Basic, VB Scripts, Shell, SQL, PL/SQL

Web Technologies

: Oracle, SQL server 2008, DB2, Informix

Methodologies

: JSP, XML, J2EE, Microsoft .net and C#, Java

: Data Vault, Waterfall, V-Model, Agile

EDUCATION

Bachelor Degree in

Science

PROFESSIONAL EXPERIENCE

United States Department of Agriculture, Kansas City MO

JULY 2015 to current

Sr. ETL Data Base Tester/Automation Tester

The United States Department of Agriculture (USDA), also known as the Agriculture Department, is the U.S. federal executive department responsible for developing and executing federal laws related to farming, agriculture, forestry, and food. It aims to meet the needs of farmers and ranchers, promote agricultural trade and production, work to assure food safety, protect natural resources, foster rural communities and end hunger in the United States and internationally. The Enterprise Data warehouse implementation is an internal system that will allow executives and business users to access the historical data and make a quick business decisions, Enterprise Reporting Service System (ERSS) application allows business team to electronically generate the standard and ad-hock reports.

Responsibilities:

•Directly supported the testing of MRT, Business File, Conservation, Farm Records, CARS, MIDAS with the complete understanding of business and those source in USDA.

•Major contributor in the team to validate the OBIEE Reports of Conservation, Farm Records, Business File to validate and certify the Layout, load, performance, Security, and Data validation.

•Analyzed Business Requirement Document, Software Design Document, Software Requirement Specification and Functional Requirement Document.

Developed the Automation Test Scripts in Selenium WebDriver using Java based on the design pattern Page Object Model for re usability

Validated Web Services SOAP request and response XML and Restful Service Calls using SOAPUI tool.

.

•Closely worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression and System (End to End), Browser Compatibility, Back end (Database) Testing.

•Created and maintained requirements tractability matrix (RTM) to ensure that all requirements are traceable from top to bottom on the basis of test plan. Backed testing of the Database by writing SQL and PL/SQL scripts to test the integrity of the application and Oracle databases.

•Extract and deploy various types of data in the target database.

•Involved in various meeting like project kick-off, project planning, weekly & monthly client status meetings,

•Identified the test data to execute the test cases.

•Performed Functionality, Negative, Security, GUI, Integration, System and Database testing.

•Test the entire ETL logic using Data stage to enable initial load and incremental processing from SQL Server and Oracle, error strategy and exception handling, restart ability and recovery, data cleanup, validation and monitoring.

•Have a clear concept of Data Vault Model that has a Link, Hub and satellite tables and their features in data Base.

•Compare and Tested data between different sources to target.

•Used JIRA 6.1.7 for project management and bug reporting

•Extensively used Data stage Work flow Manager to run the work-flows.

•Monitored the session logs/log files in Data stage Work flow Monitor.

•Test the ETL Data stage mappings and other ETL Processes (DW Testing).

•Write complicated SQL queries for data validation and data verification based on data mapping document.

•Wrote SQL queries in Toad and SQL server Management studio 2008 to validate the source and target systems

•Extensively executed T-SQL queries in order to view successful transactions of data between sources

•Tested the reports generated by (SSRS) SQL Server reporting services and checked as they are as per the Organization standards

•Clearly communicated and documented test results and defect resolution during all phases of testing.

•Used HP Quality center 12.1 as our defect tracking tool to upload test cases, track execution and defects.

•Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates and integrity.

•Extensively used SQL to verify and validate the data loaded into Target

•Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.

•Preparing and supporting the QA test environments

•Environment: Data Base Oracle 11g, Quality Center 12, SQL Server 2008, SQL Developer, OBIEE, XML,

PL/SQL, SQL, UNIX, Toad, Share Point, JIRA.

ConAgra Foods Inc. Buckner KY

Jan 2015 to JULY 2015

Sr. ETL Tester/Automation Tester

ConAgra Foods, Inc. is a Fortune 500 nation's leading food companies. It's makes and sells products under various brand names that are available in supermarkets, as well as restaurants and food service establishments. The Enterprise Data warehouse implementation is an internal system that will allow executives and business users to access the historical data and make a quick business decisions, Enterprise Reporting Service System (ERSS) application allows business team to electronically generate the standard and ad-hock reports.

Responsibilities:

•Analyzed Business Requirement Document, Software Design Document, Software Requirement Specification and Functional Requirement Document.

•Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression and System (End to End), Browser Compatibility, Back end (Database) Testing.

•Created and maintained requirements tractability matrix (RTM) to ensure that all requirements are traceable from top to bottom on the basis of test plan. Back end testing of the Database by writing SQL and PL/SQL scripts to test the integrity of the application and Oracle databases.

Designed and Developed the Automation Test Scripts using Selenium Web Driver using Java.

Reviewed the Test Reports using TestNG.

Execution of Selenium test suite and developed reports and reported defects.

Involved in Retesting and Regression Testing using Selenium Web Driver.

Developed SQL queries and Joins to validate the reports.

Automated the functionality and interface testing of application using QuickTest Professional.

Hands on experience on UAT testing and analyzing the business rules.

•Coordinate with business users along with the business rules and defects.

•Hands on experience on Defect life cycle and management of defects.

•Extract and deploy various types of data in the target database.

•Involved in various meeting like project kick-off, project planning, weekly & monthly client status meetings,

•Identified the test data to execute the test cases.

•Performed Functionality, Negative, Security, GUI, Integration, System and Database testing.

•Compared and Tested data between different sources to target.

•Used JIRA for project management and bug reporting.

•Wrote complicated SQL queries for data validation and data verification based on data mapping document.

•Wrote SQL queries in Toad and SQL server Management studio 2008 to validate the source and target systems

•Extensively executed T-SQL queries in order to view successful transactions of data between sources

•Tested the reports generated by (SSRS) SQL Server reporting services and checked as they are as per the Organization standards

•Clearly communicated and documented test results and defect resolution during all phases of testing.

•Used HP Quality center 10.5 as our defect tracking tool to upload test cases, track execution and defects.

•Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates and integrity.

Extensively used SQL to verify and validate the data loaded into Target

•Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.

•Preparing and supporting the QA test environments

•Environment: Oracle 11g, Quality Center 11, SQL Server 2008, SQL Developer, Teradata 13, OBIEE, XML, PL/SQL, SQL, Putty, TFS, UNIX, Toad, Share Point, JIRA.

BBVA COMPASS BANK, Birmingham, AL

Oct 2013 to Dec 2014

Sr. ETL Tester/Data Analyst

The implementation strategy for data warehouse project is based on several planned releases over the period. The projects include upgrades to the current data warehouse components (ETL & BI), implementation of new components to extract the data from various OLTP systems.

Responsibilities:

•Analyzed requirements for Fixed Income Forwards, Interest Rates derivatives, traded loans, Reference data and other various systems.

•closely work with the source team to get the financial applications.

•Lead and/or participated in the creation, distribution and walk through of software test cases, scripts and other documents surrounding testing activities and ensure that all testing activities and deliverable are conducted/produced in compliance with company standards.

•Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements.

•Use Business Objects OLAP Intelligence to access and analyze OLAP servers. OLAP Intelligence tool helps to Slice, dice, and drill directly on multidimensional sources and deliver work-flows via the Web, Windows, and Microsoft Excel.

•Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs.

•Prepared Test Scenarios by creating Mock data based on the different test cases.

•Involved in extensive data validation using SQL queries and back-end testing.

•Created and designed logical database schema for data warehouse (Teradata) environment to prepare for ETL.

•Checked the naming standards, data integrity and referential integrity.

•Exported the Report data from oracle and Teradata warehouse to Excel and validated using formulas.

•Tested data based on fixed income products like mortgage-backed securities and asset-backed securities.

•Referred models to quantify the basis and credit risk of the fixed income portfolio.

•Tested various ETL Scripts to load the data into Target Data Warehouse (Oracle / Teradata).

•Validated Data in Database using SQL queries (Teradata, Oracle).

•Performed Back end testing by writing SQL queries and running PL/SQL scripts in TOAD.

•Created SQL compare statements to validate Actual result with the Expected Results.

•Extensively involved in System testing & Regression testing and Integration testing

Environment: Oracle 11g, SQL, PL/SQL, Rational Clear Quest, Clear Case, T-SQL, HP Quality Center, QTP 10.0, Toad, Teradata 12.0, Teradata, Quick View

CVS Care mark, Birmingham, AL

Oct 2011 to Sep 2013

Sr. ETL Tester/Data Analyst

Responsibilities:

•Involved in Business analysis and requirements gathering.

•Written SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted

•Tested Workflow for various ETL data mapping requirements.

•Tested tables SCD Type 2 and Type 3 extensively.

•Extensively involved in testing the ETL process of data sources, SAP, People-soft, Terra-Data, SQL Server, Oracle, flat files into the target Teradata, Oracle database as per the data models.

•Experienced using database query and integration tools such as SSIS, TOAD, SQL plus etc.

•Involved in testing SSIS Packages, and in Data Migration.

•Tested SSIS packages according to business requirements and data mapping requirement documents.

•Obtained detailed understanding of data sources, Flat files & Complex Data Schema in order to write the best test scripts.

•Responsible in testing Initial and daily loads of ETL jobs.

•Interacted with design team to decide on the various dimensions and facts to test the application.

•Tested & developed the mapping for extracting, cleansing, transforming, integrating & loading data using Autopsy.

•Involved in extensive DATA validation using SQL queries and back-end testing

•Reported bugs and tracked defects using Clear Quest.

•Extensively used SQL to verify and validate the data loaded into Target.

•Validated the front end reporting components created using OBIEE Reports as well as performed back end testing, making sure that the correct data for a specific report are being pulled out from the Data Warehouse.

•Performed the tests in both the SIT, QA and contingency/backup environments

•Used SQL for Querying the database for data validation, data verification and data conditioning.

•Writing the test scripts, test cases & test plan for multiple ETL Feeds.

•Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.

•Involving in Functional testing, Back end Testing, End to End testing and Regression Testing

•Involved in Preparing and supporting the QA test environments

•Load new or modified data into back-end database.

•Defect Triage with Development team.

•Involved in peer review of test cases.

•Environment: SQL Server 2008, SSIS, Informatica 9, Oracle 11g,OBIEE, Teradata V2R6, XML, Flat Files, MS Excel, SQL, TSQL, PL/SQL, SSRS, SSAS, Toad, Clear Quest, UNIX, Clear Case, Quality Center 10, Rational Clear Quest, Business Object XI R2

Coventry Health Care, Bethesda MD

OCT 2010 to Aug 2011

ETL Tester/Data Validation Analyst

Responsibilities:

•Involved in Business analysis and requirements gathering.

•Involved in complete project software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC).

•Validating the data passed to downstream systems.

•Used data stage director to run the jobs and check the log files.

•Involved in validating SSIS and SSRS packages according to data mapping specifications.

•Involved in validating SSAS cubes according to functional specifications.

•Validated SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multi casting).

•Involved in Testing SSIS Packages, and also involved in Data Migration.

•Reported periodic project status and updates to the QA Lead and QA Manager

•Performed Integration Testing of different modules.

•Exclusively used Analysis Studio and Report Studio to test the Cog-nos Reports.

•Tested several complex reports generated by Cog-nos including Dashboards, Summary Reports, Master Detailed, Drill down.

•Validated Query Prompts, Cascading Prompts, Calculations, and Conditions& Filters.

•Analyzed Business Requirements and Developed the Test Scripts and Test Cases

•Used Quality Center for Bug Reports and Defect Tracking.

•Performed Risk Analysis based on Defect Severity and Priority.

•Tested User Interface inconsistency and application functionality.

•Worked on issues with migration from development to testing.

•Tested application in various browsers.



Contact this candidate