Jyotishna 720-***-****)

ETL/DWH QA Tester

Professional Summary:

Extensive knowledge on all phases of Software Development Life Cycle (SDLC).Experience in Agile and Waterfall models of SDLC.

Extensive experience in Software Testing Life Cycle (STLC) and Defect Life Cycle (DLC). Participate in complete testing Lifecycle, Test Plan, Test Cases, Test Execution, & Defect Report.

Met with business analysts to understand the business and involved in walkthroughs, and periodical meetings to come up with project plans.

Extensive use of defect tracking tools like Quality Center and Test Director

In-depth knowledge of all QA Phases that include Manual, Functional, System, Integration, Regression Testing End-to-End testing

Uploaded Business requirements, test scenarios, test cases and defects from MS Excel to Test Director. Analyzed and Reported the Defects to the Developers using QC.

Experienced in Integrating and coordinating testing activities into software development activities.

Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.

Helped in building scalable distributed data processing solutions with Hadoop (CDH4, CDH5), Sqoop, Zookeeper, Oozie, Flume, Hive & Pig, Kafka

Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, Sybase, and Teradata, Netezza, Ms Access, Flat files into a staging area.

Experience using query tools like, TOAD, Teradata SQL Assistant, WinSQL, SQL server Management Studio for Teradata, Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.

Proficient in designing, reviewing and documenting system test plans, defining test procedures and creating test cases on the basis of product release features, client’s requirements and related technical documents.

Worked heavily on testing various ETL process as well as many reports developed used various BI tools.

Working knowledge on various types of data feeds like: XML and Flat files.

Excellent in writing SQL queries and UNIX shell scripts to perform Backend testing

Experienced in supporting multiple projects simultaneously while maintaining strong quality and ability to meet deadlines

Excellent analytical skills, documentation skills and presentation skills

Self-starter and ability to present ideas in a concise, logical and well organized format

Technical Skills:

Bug Tracking / Test Management Tools

HP ALM/ Jira/ VersionOne/ TestLink/ Quality Center

ETL Tools

Informatica, AbInitio, SSIS

Languages

Sql,, Shell script, PL Sql, T Sql

BI Tools

Business Objects, SSRS, Cognos

DBMS

MS Access, SQL Server, Oracle, Teradata

Operating Systems

Windows XP/2000/2003/Vista/ 2016,UNIX

Big Data

Hdfs, MapReduce, hive, pig, sqoop, flume, storm, Kafka

Software Lifecycle Management Methods:

Scrum, Agile, Spiral, and Traditional Waterfall model.

General Business Tools:

Microsoft Office, Toad for Oracle, QTP

Professional Experience:

PNC Bank August 2017 – Present

Role: Security and Authentication/ Lead System Quality Analyst

Responsibilities:

Worked heavily on a Agile methodology as a Security and Authentication Lead for Online Banking Application

Co-Ordinate between on shore and off shore team

Delegate responsibilities between on-shore and off-shore team during critical releases

Attend daily stand ups and provide with updates

Frequently communicating with different application team (Virtual Wallet, Mass Market, Wealth, Mobile) to provide with the details

Attend various meeting with Product Owners and with my application

Updating user stories and defining their levels in Version One and updating Test Plans in HP ALM

Provide Daily Status Report (DSR) after End of Business to all the stakeholders on a daily basis

Facilitate Defect Management Meeting with entire team and provide with the Defect status

Creating Test Data in Mainframe and providing different test datas to test team and development team if needed

Work closely with thorough regression team to do testing with different application before each release

Used Postman to do the API testing for Online Banking Application after designed document has been given by the development team

Attended each Sprint Meeting and discuss testing hours, points to be provided for User Stories

Attend Grooming meeting with Scrum Master, Develeoper, Product Owners and BA, Tech Lead

Provide production team support during release

Support hotfixes by doing regression testing

Interact with Performance team and provide with datas for Performance testing and with automation teams for the scripts to be automated for the current sprint

Environment:

VersionOne, Postman, HP ALM, Mainframe, Perfecto, Monitise, Switiches, Jira

Professional Experience:

Catalina Marketing, St. Petersburg, FL February 2016– June 2017

Role: ETL QA Tester

Responsibilities:

Collaborating with team members across the globe.(France, UK)

Involved reviewing systems requirements to write detailed test plans and scripts, track and facilitate defect resolutions, and apply analytical problem-solving skills by collaborating with business and technical staff throughout the testing process within an Agile SDLC.

Run the given job in Autosys before testing.

Participated in test plan and test case review.

Reported and tracked issues/bugs in QA/UAT environment

Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.

Tested and worked on creating open document reports for business.

Worked with QA Team and use Jira to Defect logging and tracking them to closure.

Provide status updates to development leads and project manager.

Working closely with Developers and Architects in solving software defects.

Loaded data into Netezza tables from various data sources like Netezza, SQL Server, Oracle, flat files by creating Informatica Mappings

Written several complex SQL queries for validating Cognos Reports

Handled importing of data from various data sources, performed transformations using Hive, MapReduce, loaded data into HDFS and Extracted the data from MySQL into HDFS using Sqoop

Worked on Sqoop to export data into HDFS and Hive

Performed data validation on the flat files that were generated in UNIX and Netezza environment using UNIX and sql Loader commands as necessary

Tested Cubes by using Cognos Power Play to analysis

Responsible for testing packages using Informatica (ETL) to verify data and Involved in testing data migration.

Identifying field and data defects with required information in ETL process in various mappings and one to one mapping.

Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.

Tested the entire compliance reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.

Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse

Executed SQL queries for validation of data and used TOAD for Oracle

Used TOAD and NZSQL for Netezza and Oracle to write SQL queries for validating constraints, indexes.

Analyze changes that span application test team and functional processes to ensure all impacts have been identified for testing

Conduct test team meetings to ensure business and IT testing expectations are met, and test deliverables are traceable to business requirements

Collaborate with software/systems personnel in application testing, such as unit, system, regression, load and acceptance testing methods

Collaborate with the development and configuration management team for deployments into the test environments

Environment: Informatica 9.6, Oracle 11g, SQL, Netezza NPS (data warehouse appliances), Cognos, Hadoop, TOAD, WinSQL, Business Objects 4.1,Testlink (web based test management system).Jira, Putty, Autosys, UNIX

Wells Fargo, Addison TX August 2014 – February 2016

Role: ETL/DWH QA Tester

Responsibilities:

Managed multiple OLAP and ETL projects for various testing needs.

Debugging the SQL-Statements and stored procedures for various business scenarios.

Performed extensive Data Validation, Data Verification against Data Warehouse

Loading Flat file Data into Teradata tables using Unix Shell scripts.

Analyzed business requirements and develop detailed Test Matrices, Test Scenarios and Test Cases.

As an ETL Tester responsible for the understanding the business requirements, ETL and subsequently design ETL testing strategy using SQL scripts.

Performed Metadata Analysis by Data Profiling and acted as a data steward in maintaining the quality metrics on a continuous basis.Extensively used Informatica Workflow Manager to run the workflows.

Monitored the session logs/log files in Informatica Workflow Monitor.

Participated in Requirement gathering phase with business team for Data migration test

Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.

Wrote SQL scripts in TOAD for Oracle and Teradata SQL Assistant for Teradata

Written several complex SQL queries for validating and verifying the data across different databases including SQL Server 2005 and Oracle 10g.

Wrote Complex SQL queries and PL/SQL subprograms to support the test case results, SQL performance tuning.

Tested the reports developed in Cognos against the database

Involved in Test Scenarios & Test cases authoring in HP ALM QC – Test Plan & Test Lab, Test

SQL Design using Oracle SQL Developer 4.0, Oracle client 11g.

Experience testing SOA with Restful/SOAP Web Services and Create entire architecture for backend testing internal and third party API using Test Complete and SOAP UI.

Performed UI/Reports and Data centric tests for to satisfy business in test SQL server environments

Tested several Informatica Mappings to validate the business conditions.

Testing the source and target databases for conformance to specifications

Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center 10

Used Informatica Power Center Workflow Manager to run the workflows.

Tested UNIX Shell Scripts and SQLs to get data from Oracle tables before executing Informatica workflows.

Designed and prepared scripts to monitor uptime/downtime of different system components

Written Test Cases for ETL to compare Source and Target database systems.

Interacting with senior peers or subject matter experts to learn more about the data

Identifying duplicate records in the staging area before data gets processed

Extensively written test scripts for back-end validations

Environment: Informatica, Oracle 11g, TOAD, SQL Server, Teradata, Cognos,ALM, Server, SQL, HP Quality Center, Agile, UNIX, XML, Autosys, PL/SQL

United Health Group, Eden Prairie, MN February 2012 – July 2014

ETL/QA Tester

Responsibilities:

•Created test cases and test plans for user acceptance testing and system testing based on functional specifications.

•Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.

•Tested the entire compliance reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.

•Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse

•Extensively worked on Oracle 10g DB and queried the DB using TOAD.

•Performed back-end testing on the Oracle database by writing SQL queries.

•Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.

•Performed Integration Testing and Batch Testing in QTP

•Developed Test Plans with the QA team and helped develop test scenarios for system testing and integration testing.

•Extensively executed T-SQL queries in order to view successful transactions of data and for validating data in Sql Server Database.

•Performed MS SQL Server T-SQL Queries, creating Tables, and Views by following Teradata Best Practices.

•Experience in using Automation Tool Quality Center (QC) in Client/Server.

•This work will include loading of historical data onto the Teradata platform, as well as reference data and metadata.

•Tested the Informatica Mappings to load data from Source systems to ODS and then to Data Mart.

•Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)

•Tested the Oracle PL/SQL testing programs

•Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.

•Tested the XMLs feeds received from another source which is a third party for data consistency.

•Tested the ETL with XML as source and tables in the data warehouse as target.

•Tracked defects to closure by coordinating with the dev team.

•Tested source data for data completeness, data correctness and data integrity.

•Performed End to end testing starting from the source to the report.

•Conducted and coordinated integration testing and regression testing.

•Participated in business requirements gathering and in modifications of the requirements based on the scope.

•Worked with the DSO team to understand the source to target mapping document and accordingly helped them to clean the source data to decrease the defects and to ensure that final data matches with the data warehouse standards.

•Prepared test data to cover all the test scenarios.

•Prepared UNIX scripts to run the informatica ETL jobs from command line.

•Maintained all the test cases in HP Quality Center and logged all the defects into the defects module.

•Tested the migration of reports from Business objects XIR2 to XIR3.

Environment: Informatica, Oracle 11g, TOAD, SQL Server, QTP, Oracle 10g, Teradata, Agile, SQL, HP Quality Center, PL/SQL, Business Objects, UNIX, Rational Clear Quest, Autosys

EXTEDO, INC.

Jr. QA/ Validation Services Jan 2010- Feb 2012

EXTEDO is a leading Regulatory Information management and global electronic data solution provider with 700 + life science customer including 35+ regulatory authorities.

Responsibilities:

Supporting the installation and implementation of EXTEDO products.

Gaining a deep understanding of the regulatory environment of EXTEDO products, and applying that knowledge to help client’s better leverage our products.

Assisting Clients with technical and product functionality inquiries.

Prepared the Test Plan, Test data and Testing Strategies for EXTEDO’s Application

Working closely with QMS team enhancing the Validation/test scripts and SOP’s.

Validate EXTEDO’s application to see if it meets the required business requirement for provided by the clients.

Worked with Clients during migration of DMS products to check the Correctness and Completeness during the migration.

Worked directly with clients during submissions to the governing body, to make sure that there are not any issues during export.

Performed Validation activities on several projects involving authoring and where applicable execution of SOP’s, validation protocols, functional requirement specifications, user requirement specifications, installation qualification, operation qualification, performance qualification, master validation plan and master test plan strategy.

Working closely with the Product owners, Development and Support team to discuss about the enhancements and bug defects.

Environment: eCTDmanager, eSUBmanager, RImanager, Veeva Vault, MS Share Point, MS SQL Server, MS Word, Adobe Acrobat, TFS, Microsoft Dynamics CRM

Contact this candidate