PROFESSIONAL SUMMARY:

• Over 8 year of experience in QA testing in the domains of Banking, Finance and Health Care.
• Involved in all phases of SDLC waterfall, agile with timely delivery against aggressive deadlines.
• Experience using query tools for Terad Confidential, Oracle and MS SQL Server to validate reports and troubleshoot d Confidential quality issues.
• Extensively used ETL methodology for testing and supporting d Confidential extraction, transformations and loading processing, in a wide - ETL Solution using Informatica.
• Proficient in writing SQL queries to perform d Confidential driven tests and involved in front-end and back-end testing. Strong knowledge of RDBMS concepts. Developed SQL queries in Oracle d Confidential bases to conduct DB testing.
• Experience in analyzing Business Requirement Document (BRD), Functional Requirement Specification (FRS) and assisting in developing TEST PLAN.
• Expertise in creating/developing TEST CASES and developing TEST SCRIPTS.
• Experience in testing D Confidential Marts, D Confidential Warehouse/ETL Applications developed in Informatica, Cognos using Oracle, Sybase, Terad Confidential, SQL Server and UNIX.
• Expertise in writing SQL queries, PL/SQL Stored Procedures and Triggers
• Familiar with Informatica Repository Manager, Designer, Workflow Manager, Workflow Monitor
• Expertise in developing test cases/ test scripts for Inbound and Outbound ETL processes.
• Experience in testing/validating the Source, Stage and Target (End-to-End), BI Testing, and D Confidential Quality Issues & D Confidential Reconciliation process.
• Performed Functional, and Regression testing.
• Expert in analyzing the error caused to failure of the ETL load with to the log file and report them to the corresponding team to get it rectified.
• Experience with bug tracking tools like Quality Center11.0.0 and Clear Quest.
• Experience in UNIX commands and shell scripting.
• Good understanding of d Confidential modeling with (Star Schema and Snowflake Schema)

TECHNICAL SKILLS:

Testing and defect management Tools: QuickTestPro, Quality Center 11/10/9.2, Jira and Rational Clear Quest, PVCS Tracker

ETL Tools: Informatica 8.x/9.x, D Confidential stage 8

D Confidential bases: Terad Confidential V2R6, Oracle 11g/10g/9i/8i, MS SQL Server 2005/2008

PROFESSIONAL EXPERIENCE:

Confidential

ETL QA Analyst

Responsibilities:

• Understanding the specifications for D Confidential Warehouse ETL Processes and interacting with the d Confidential analysts and the end users for informational requirements
• Involved in Relational modeling and Dimensional Modeling Techniques to design ER d Confidential models and Star Schema designs
• Worked with D Confidential Completeness, D Confidential Transformation, D Confidential Quality, Integration testing, Performance, Scalability and Regression Testing.
• Documented the validation rules, error handling and test strategy of the mapping.
• Tuned the complex SQL queries for better performance by eliminating various performance bottlenecks.
• Created temporary tables for validations after understanding the transformation logic.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Established and documented ETL QA standards, procedures and QA methodologies.
• Verify development of rule-set test scenarios, test cases, expected results and analysis of XML test scripts
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extensively tested several ETL Mappings developed using Informatica.
• Involved in testing d Confidential reports. Written several SQL queries for validating the front-end d Confidential with backend.
• Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.
• Written several SQL statements to confirm successful d Confidential transfers between source and target.
• Worked with d Confidential profiling, d Confidential scrubbing and d Confidential cleansing.

Environment: Oracle11g, Informatica Power Center 9x, Quality Center 11.0.0, XML, SQL, PL/SQL, Microsoft word, Excel,. Net, QTP 9.0, UNIX

Confidential

QA Specialist

Responsibilities:

• Created Test Plan based on Business Requirements documents.
• Test Approach and Test readiness document Preparation
• Test case preparation and uploading test scripts in to QC
• Updating planned execution date and resource details in QC as per the test plan
• Test Environment set up follows up
• Test D Confidential Preparation
• Test case execution and test results reporting
• Created automation scripts using QTP and executed the regression pack before every release
• Defect tracking, defect follow up with IT team
• Daily status call setup, driving daily status calls and addressing the issues
• Publishing daily status report at the EOD and make sure that status report should be in sink with QC status
• Collected metrics and prepared Defect analysis reports
• Getting sign-off mail from product owner after completion of UAT
• Written SQL queries to validate the d Confidential
• Coordinated with the developers to resolve defects.
• Involved in documentation in order to maintain and run scripts for future enhancements.
• Participated in weekly meeting with the management team and walkthroughs.

Environment: PEGA 6.4x, XML, XPATH, JQUERY, QTP 11.0.0, QC 11.0.0

Confidential

ETL Test Engineer

Responsibilities:

• Understanding the specifications for D Confidential Warehouse ETL Processes and interacting with the d Confidential analysts and the end users for informational requirements.
• Involved in preparation of Test Plan and test strategy for DWH testing.
• Prepared Manual Test Suites for various modules d Confidential validation.
• Focused on D Confidential Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Written SQL queries, stored procedures in order to d Confidential validation in migration as part of backend testing.
• Tested stored procedures & views in Toad using SQL/PLSQL.
• Worked with D Confidential Completeness, D Confidential Transformation, D Confidential Quality and Integration Testing for different line of feeds
• Worked with SCD1, SCD2 testing while dimension d Confidential validations.
• Prepared test cases for d Confidential validations between D Confidential Mart to d Confidential cubes.
• Involved in extensive D Confidential validation using SQL queries and back-end testing
• Worked with developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfil d Confidential and reporting requirements including identifying the tables and columns from which d Confidential is extracted.
• Used FTP and Telnet protocols in order to migrate files to heterogeneous Operation systems like UNIX, Linux and windows.
• Worked with UNIX scripts in executing and validating logs for the issues.
• Involved in KT sessions for new joiners to ramp up them.
• Validated all the jobs and successfully system tested the jobs
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Involving in Functional testing, End to End testing and Regression Testing.
• Preparing and supporting the QA and UAT test environments.

Environment: Informatica power center 8.X, Quality Center, MS Excel2003/7, SQL/PLSQL, UNIX, Windows, Oracle 9i, Terad Confidential, TOAD, Flat files.