SUMMARY

• 11 years of Experience in ETL/Data warehouse /Report Testing/Data Centric Testing
• Specialized in identifying high level scenarios, preparing test plan, execution of test case to verify application functionality against business requirements.
• Worked on Agile methodologies and Knowledge on Big Data testing
• Extensive working experience on Smoke, Functional, Integration and Regression Testing.
• Experience in Data Analysis, Data Validation, Data Verification and identifying data mismatch.
• Used HP ALM for documenting Test cases, Defect reporting, Defect tracking.
• Experience in quality assurance of scope coverage, tests, data, requirement/test/defect traceability, test result & sign - off evidence and defect content
• Review of project requirements and active involvement with all phases of SDLC.
• Experience in the financial, Insurance, Retail and Banking Data warehouse Domain industry
• Worked on multiple projects at a time, balancing according to the priorities set by the organization for clients.
• Expertise in Testing complex Business rules by creating mapping and various transformations.
• Experience testing and writing SQL and PL/SQL statements
• Solid experience in Black box testing techniques, which includes, Integration, Functional, System, Regression Testing.
• Expertise in creation, execution and maintenance of Test Plans, Test Scenarios, Test Scripts and Test cases.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Involved in Bug Tracking and created Defect Reports using Test Management/ Defect Tracking Tools like Quality Center HP ALM, Clear Quest and documented Test Documents using MS Office Tools - MSWord,Excel and PowerPoint.
• Handling offshore six persons in a team and sending consolidate report to Management.
• TEMPEffective communication, professional attitude, strong work ethic and interpersonal skills

TECHNICAL SKILLS

Operating Systems: Windows NT/2K, Solaris 8, 9 and 10, and Linux.

Script Languages: Shell script, VB script

Database: Oracle 8.x., 9.me, 10g, DB2 9.0 SQL Server, Teradata 14.0

ETL/BI Tools: Informatica 7.1.x / 8.5.1/8.6, Data stage V8.1 Business objects

Testing Tools: QTP, IBM RTC, and Quality Centre 9.2/11.0, HP ALM,Ruby/cucumber

PROFESSIONAL EXPERIENCE

Confidential, Ohio

ETL Test lead

Responsibilities:

• Work with business partners, developers and project managers to develop test plans, produce test scenarios and repeatable test cases/scripts through all parts of the development lifecycle, execute and sign-off
• Collaborate with Project Managers, business partners, and developers to coordinate project schedules and timelines.
• Business Requirements, Functional Specifications and the Technical Specification analysis and review
• Developed Test Plans, Test Scenarios and Test Cases to define scope of overall quality assurance testing.
• The Traceability Matrix is maintained in QC by linking the test cases with the Requirements and defects are linked to Test cases.
• Developed Test cases for field level validations, End-To-End scenarios to cover the entire flow of data from source to target through Informatica.
• Conducted Field level validations, Functionality Testing and Regression Testing
• Developed and executed UNIX scripts for bulk loading and extraction of the data. Created different format files to upload the data into the tables

Technologies used: Informatica9.x, Teradata 14.0, Window 7, UNIX, SFTP, Control-M Quality Center9.2.Putty and Data Gen

Confidential, MA

ETL Test lead

Responsibilities:

• Understood the application and existing business logics in short span of time
• Collaborate with Project Managers, business partners, and developers to coordinate project schedules and timelines.
• Business Requirements, Functional Specifications and the Technical Specification analysis and review
• Developed Test Plans, Test Scenarios and Test Cases to define scope of overall quality assurance testing.
• The Traceability Matrix is maintained in QC by linking the test cases with the Requirements and defects are linked to Test cases.
• Developed Test cases for field level validations, End-To-End scenarios to cover the entire flow of data from source to target through Informatica.
• Conducted Field level validations, Functionality Testing and Regression Testing
• Developed and executed UNIX scripts for bulk loading and extraction of the data. Created different format files to upload the data into the tables.
• Provided Mock Run Testing Support and conducted sanity testing in live environment.
• Analyzed and Reported Data Quality to Transactional Processing System.
• Responsible in Developing Test Cases from specifications, Defect tracking and reporting through QC, Defect Management Analysis.
• Verified Interface Files, End-to-End connectivity, Exceptions & Rejections as per mapping document
• Provided Impact analysis for Change requested and Tested accordance with test process.
• Supervise the team member’s users for test execution and consolidate the report

Technologies used: Abinitio3.0, Oracle 11g, Toad 8.6, Window 7, UNIX and SSH Secure Shell, Control-M, HP ALM, pl/sql developer, Putty, Ruby/cucumber

Confidential, MI

ETL Test lead

Responsibilities:

• Clearly communicated and documented test results and defect resolutions during all phases of testing.
• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Performed Black-box testing, System Testing, Data Integrity testing and end to end testing.
• Implemented SDLC, QA methodologies and concepts in the Project
• Involved in Developing Test Plans and Developed Test Cases/Test Strategy with input from the assigned Business Analysts
• Involved in testing of Universes from different data sources like Oracle/SQL Server.
• Involved in Writing Detailed Level Test Documentation for reports and Universe testing.
• Involved in developing detailed Test strategy, Test plan, Test cases and Test procedures using Quality Center for Functional and Regression Testing
• Responsible for data mapping testing by writing complex SQL Queries.
• Tested the source and target systems Extracted data from Teradata tables and upload to Oracle.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Coordinated component, system testing with the appropriate technical groups and Release management and documented test procedures and findings.
• Implementing logical and physical data modeling with STAR schema using Erwin in Data Mart.
• Automated test scripts for Functional, GUI validation, Data Driven testing using QTP.
• Worked on profiling the data for understanding the data and mapping document.
• Reported bugs and tracked defects using Quality Center
• Performed day to day migrations of various Informatica objects using export-import option for testing of new functionality
• Tested the aggregate Universe to ensure the query is pulling correct level of Aggregation.
• Test Business Objects reports for data validation and compare results with TOAD.
• Testing of Business Objects and Reports, which Includes, Database Connectivity, Tested objects in the Universe to ensure the correct mapping of the objects, tested the Universe Structure to ensure that tables are properly uploaded, tested the aggregate Universe to ensure the query is pulling correct level of Aggregation.
• Performed the tests in both the SIT, QA and contingency/backup environments
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment
• Performed data driven testing with Data Driven Wizard in QTP and enhanced the overall functionality of the application.
• Prepared and ran regression scripts, Prepared Integration, sanity and end-end testing.

Environment: Datastage8.5, DB2, Toad 8.6, Window 2000/ UNIX and SSH Secure Shell, Appworx, Quality Center9.2,, Ruby/cucumber

Confidential, UK

Sr. ETLQA

Responsibilities:

• Business Requirements, Functional Specifications and the Technical Specification analysis and review
• Developed Test Plans, Test Scenarios and Test Cases to define scope of overall quality assurance testing.
• Developed Test cases for field level validations, End-To-End scenarios to cover the entire flow of data from source to target through Informatica.
• Conducted Field level validations, Functionality Testing and Regression Testing
• Developed and executed BCP scripts for bulk loading and extraction of the data. Created different format files to upload the data into the tables.
• Developed many Shell Scripting for various purposes like removing Log on daily base, maintaining Environment Setup file, large amount of Data comparison Script.
• Used Quality center tool for defects logging and tracking and reported the defects and was involved in complete Defect Life Cycle.
• Designed Comparison scripts to test the field level validations and generated the Error Report for clear understanding in Microsoft Excel.
• The validation includes both Quantitative and Qualitative testing, Quantitative Testing - ensures both the field mapping technically made it to the correct target location and the total records sent equals the total records processed. Qualitative Testing - Ensures the primary business processes work as designed using the underlying customer data and the open AR validated in the quantitative testing.
• The Traceability Matrix is maintained in QC by linking the test cases with the Requirements and defects are linked to Test cases.

Environment: Informatica 7.1.3/8.5.1 Oracle 10g, Toad 8.6, Window 2000/ UNIX and SSH Secure Shell, Appworx, Quality Center9.2.

Confidential, CA

Sr. ETLQA

Responsibilities:

• Extensively involved in Business Analysis and Requirements Gathering
• Involved in analyzing the requests for new, enhanced, and modified systems, against user and business requirements using RUP methodology
• Developed scripts to create fixed width files from flat file sources, to wrap Informatica Mappings and SQL code, and to validate/test the load process.
• Developed Reports and Graphs to present the results to the management.
• Performed Data Driven Testing of the Application for different users/data sets
• Preparation of test data for various levels of testing
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
• Gave production support in scheduling and tested this data with the existing data.
• Developed Test cases for the data warehouse in Oracle System
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Developed automation test scripts to test the database by retrieving the data from the tables using HP QTP and VB Scripting.
• Worked on Oracle to implement the project and written the Test Plan and Test Cases for the module Sales Cycle
• Written complex SQL queries to validate the data against the target based on ETL mapping specifications
• Tested ad hoc and canned reports for Business objects
• Coordinated with the business analysts and developers and discussed issues in interpreting the requirements and TEMPeffectively managed the finalized requirements using Quality Center.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Analyzed test cases for automation and created scripts for regression testing using QTP 9.2.
• Automated Test cases for the purpose of regression testing.
• Conducted Integration testing, Performance testing, Functional testing and Load testing to ensure that the application meets the requirements and to ensure usability readiness
• Developed test automation scripts for Regression and Performance testing

Environment: Informatica 7.1.3/8.5.1 Oracle 10g, Toad 8.6, Window 2000/ UNIX and SSH Secure Shell, Appworx, Quality Center9.2.

Confidential, CA

ETL QA

Responsibilities:

• Worked closely with Business user in Understanding designing and documenting the Functional testing plan and tan Writing, executing, documenting the results and Logging defects.
• Involved in development and implementation of test cases test plans test data and test scripts for customers.
• Involved in various kinds of testing like functional testing, system testing and integration testing.
• Constructed context diagrams and data-flow diagrams based on the description of a business process.
• Analyzed the data model to code efficiently in SQL.
• Created and Configured Workflows, Work lets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Extensively involved in performance tuning at source, target, mapping, session and system levels.
• Worked with SQL queries to validate the data in database (SQL Server, Oracle).
• Worked on generating reports using SQL Plus and PL/SQL. Worked on tuning SQL statements.
• Involved in preparing detailed Business Analysis documents, ETL design documents, unit test plans for the mappings
• Involved in complete life cycle activities like pre-testing phase and testing phase.
• Analyzed system requirements specifications, developed executed detailed test plan test cases, security and usability of application information.
• Created Test Procedures and Test Cases to perform the system testing and Regression testing.
• Attended bug review and client meetings.

Environment: Informatica 7.1.3, Oracle 9i, Toad 8.6, SSH Secure Shell and Control-M-jobs,Putty,HP Quality center

Confidential

Test engineer

Responsibilities:

• Developed test cases, configured environments and prepared test data for testing.
• Worked with Business analysis team to prepare a detailed Business Requirement documents.
• Involved in writing & implementation of the test plan, various test cases & test scripts.
• Performed Functionality, Stress, Security, and GUI & Regression testing of web-based applications.
• As QA Tester, performing responsibilities with both the functionality and back end testing.

Environment: Solaris o/s, Sun Ray 1, Java1.4.2. JSP, XML,LDAP, ANT, CVS, and Bugster2.0,Test director