SUMMARY:

• 11 years of experience in Software Quality Assurance with expertise in Data warehousing, database testing and data analysis in Healthcare, Retail, Finance, Investment and Telecom domains.
• Experienced in ETL/BI testing.(Informatica, Data Stage, Abinitio, SSIS). Proficiency in writing Test Plan, Test Scenarios and Test Cases using requirements, design specifications and process flow diagrams.
• Experience in Functionality testing, Database Testing, GUI testing, System testing, Ad - hoc testing, Regression testing, E2E testing and Automation testing.
• Expert in using the RUP, Agile/Scrum and Waterfall testing lifecycle Methodologies. Experienced in developing, reviewing, and Executing Test Strategy, Test Plans, Test Scenarios, and Test Cases/Script.
• Experience in manual testing process and in creating automation environment using Quick Test Pro (QTP), Test Director, and Quality Center/ALM 11.0. Expertise in test strategy design based on the various types of testing including unit, integration, function, system, usability (UI), End to End, security, load, stress, capacity and performance testing.
• Experience in testing of Data Warehouse/ETL Applications developed in Informatica, Ab initio using SQL Server, Oracle, DB2, and UNIX and ability to evaluate ETL/BI specifications and processes.
• Experienced in performing Quality Test to determine the quality of the ETL processes.
• Strong skills in data requirement analysis, data mapping, and debugging for ETL processes.
• Experience in using the Informatica command line utility to schedule and control sessions and batches. Working experience in using Informatica Workflow Manager to create and schedule workflows and Worklets.
• Used Debugger to validate the mappings and gain troubleshooting information about data and error conditions. Experience in testing and writing SQL statements, procedures, functions.
• Worked with different data sources like Flat files, XML files and other Relational Databases.
• Extensive knowledge of SSIS transformations such as lookup, derived column, data conversion, aggregate and conditional split.
• Skilled in full life cycle development for building a Data Warehouse.
• Skilled in Reporting tools like IBM Cognos, SAP Business Objects and SSRS, Tableau.
• Expert in writing UNIX shells scripts and automate the sessions running processes using pmcmd commands in UNIX shell scripts.
• Excellent problem solving skills with a strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.
• Extensively used Informatica Power Center - Designer, Workflow Manager, Workflow Monitor, Repository Manager and Metadata Manager.
• Worked with different RDBMS: Oracle SQL, MySQL & MS SQL Server.
• Development experience across business areas such as healthcare, Insurance, Pharmaceutical domain. Comprehensive experience in Data Warehouse/Data Mart Testing lifecycle.
• Working knowledge in Agile/Scrum (using Rational Team Concert - IBM), Waterfall and Iterative SDLC methodologies.
• Was involved in setting up the test environments and Creation & Maintenance of test data as per the requirement. Experienced in testing Star and Snow Flake Schema Dimensional Data Models. Experienced in end-to-end testing of ETL, Reference Data, Date Warehousing and Business Intelligence solutions for large enterprise data.
• Experience in identifying and resolving the bottlenecks in Source, Target, Transformations, Mappings and Sessions for better performance.
• Experience in optimizing query performance, session performance and fine tuning the mappings for optimum performance. Expertise in implementing complex Business rules by creating robust Mappings, Mapplets, and reusable transformations using Informatica Power Center.
• Working experience in using Informatica Workflow Manager to create and schedule workflows and Worklets.

PROFESSIONAL EXPERIENCE:

Sr.ETL QA Tester

Confidential - Macon, GA

Environment: HP ALM, QTP/UFT, MicroStrategy, TOAD, LoadRunner, LINUX, XML, Windows, VB Script, HTML, Agile, Soap UI

Responsibilities:

• Testing, Integration, Data Migration and implementation of customer oriented business applications in Created Test plan and Strategy document, Critical scenarios and Test Scripts and schedule for testing.
• Worked with technical designers and business analyst to understand the requirements for a test environment setup.
• Wrote User Stories based on the requirements gathered from all the stake holders and get approved from product owners.
• Coordinated with systems partners to finalize designs and formalize requirements. Sizing and Planning techniques as needed based on the length of the backlog and priorities.
• Performed Smoke Testing to make sure all the Test Channels and Test Environment are working as desired.
• Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.
• Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Tested the performance bottle necks at sources, targets, mappings, and sessions and employed required measures.
• Interacted with Developers and management to identify and resolve technical issues.
• Conducted Functional and Back End testing and Demo the test results for completed user stories and get approval from product owners.
• Operated in 2 week sprints with flexibility on length based on immediate functionality concerns.
• Ensured application availability and data integrity through preventative maintenance and upgrades.
• Attended Agile and Scrum meetings, which included Sprint Planning, Daily Scrums or Stand-ups, Sprint Check-In, Sprint Review & Retrospective.
• Worked on preparing SQL queries to performed database validation according to the business logic.
• Used Enterprise Servicing platform to monitor E2E Pre-Ready and Ready process in PROD and BUAT and updated product owner about the status.
• Tracked and reported defects into QC and notified management with details.
• Used Debugger wizard to analyze the flow of data on row by row basis from transformation to transformation.
• Involving in trouble shooting of long running sessions and fixing bugs.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming.
• Written, executed Test cases, and documented defects in the Quality Center.
• Solved day to day problems of the team arising due to functionality and validation issues.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Tested Canned/Ad-hoc reports using Business Objects Reporter functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, sorting.
• Cascading Prompts and User Defined Objects.
• Worked on preparing test cases and testing Tableau Worksheet, Dashboard and Stories.
• Prepared Low Level Design document..

Sr.ETL QA Tester

Confidential, CA

Environment: Windows 2007, Oracle 10g, Abinitio, Cognos10, SQL Server 2012, UNIX, Espresso job scheduler.

Responsibilities:

• Tested Slowly Changing Dimensions (SCD) Type 2.
• Performing Defect Tracking and Performing Root Cause Analysis for issues.
• Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.
• Testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.
• Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Tested the performance bottle necks at sources, targets, mappings, and sessions and employed required measures.
• Managed software defect information, interacted with Business users to fix severity and priority of issues.
• Participated in weekly project status meeting and updated the testing Progress.
• Worked on preparing test case for Abinitio graphs.
• Developed test cases for several reports featuring multiple prompt selections, drill through reports, List Report, Crosstab Report and Chart Report using Cognos10.
• Performed testing for reports and prepared testing document.
• Verified requirements coverage by conducting walkthrough meetings of Test plan and scenarios with business analysts, project manager and test supervisors.
• Created Test plan, Test strategy, Critical scenarios and Test Scripts and schedule for testing.
• Worked with technical designers and architects to understand the requirements for a test environment setup.
• Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.
• Used predefined UNIX scripts for file transfer and file manipulation as part of Test Data preparation.
• Manual Execution and validation of Functional and Migrations Tests for ETL and BI processes.
• Used Toad and SQL Plus for testing execution of ETL Processes for business rules.
• Interacted with Developers and management to identify and resolve technical issues.
• Conducted GUI, Functional, Front end & back end testing and reviewed pages for content problems.
• Also worked on Integration of all the processes in UAT/PROD.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Ran SQL queries to performed database validation according to the business logic.
• Developed Integration and System test cases using Quality Center.
• Tracked and reported defects into QC and notified management with details.
• Written, executed Test cases, and documented defects in the Quality Center.
• Solved day to day problems of the team arising due to functionality and validation issues.
• Analyzed root cause for defects and documented.

ETL QA Tester

Confidential - Boston, MA

Environment: Informatica 8.5.1, IBM DB2, Oracle, XML Files, CSV, VSAM Files, SQL Server 2008, ASP.NET, ADO.Net, C#, XML, COM, SSIS, JavaScript, Visual Source Safe 6.0, QTP 9.0, Quality Center 10.0, SQL, PL/SQL, PERL, Shell Scripting, SQL, PL/SQL, PERL, Visual Studio, .NET 2008, Teradata V2R6, Cognos 8.0 Series.

Responsibilities:

• Involved in developing detailed Test plan, Test cases and Test scripts using QualityCenter for Functional and Regression Testing.
• Designing SQL queries while performing database testing.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Developed Test Cases and Test Scripts for System and UAT Testing.
• Written several complex SQL queries & PL/SQL stored procedures for validating Cognos Reports.
• Extraction of test data from tables and loading of data into SQL tables.
• Helped the System test lead in developing the Test Plan and Testing Strategy for ETL/BI.
• Managed and executed the test process, using Agile Methodology.
• Worked with Teradata SQL Assistant for data retrieval and data validation.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing) Written several complex SQL queries for validating Cognos Reports.
• Used Quality Center for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Used Informatica Data Validation which reduces the time required for data validation and production data auditing and verification.
• Conducted manual back-end testing on a reconfigured sales application system.
• Performed extensive Back-End testing by writing and executing SQL queries on the database-using SQL Query Analyzer.
• Contributed to design, analyzed and conducted back-end testing using SQL scripts on a database developed from Data Mining.
• Used T-SQL for Querying the SQL Server database for Data validation and data conditioning.
• Raised defects in HP Quality Center defect tracking system.
• Designed Traceability Matrix to match the test scripts with the Functional design document.
• Worked with ETL group for understating mappings for dimensions and facts.

ETL Tester

Confidential - Charlotte, NC/

Environment: Windows 2007, Data Stage, Oracle 11g, SQL Server, SSRS, UNIX.

Responsibilities:

• Analyzed the data from heterogeneous sources to maintain consistency and performed validation.
• Tested mappings as per the technical specifications approved by the client.
• Tested various fact and dimension tables which were implemented on Star and Snowflake schema.
• Extensively used Data Stage maps for ETL testing process.
• Design and execute the test cases on the application as per company standards.
• Preventing occurrences of multiple runs by flagging processed dates.
• Test Cases have been written for ETL to compare Source and Target database systems.
• Also tested for performance of the mappings and SQL performance.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Ensured data integrity and verified all data modifications and calculations during database migration using ETL tools.
• Developed test cases to accomplish ETL data migration.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Prepared test cases and test documents for SSRS Reports and performed testing.

ETL Tester

Confidential - Raritan, NJ

Environment: ETL Data stage, BI Business Objects, Oracle 9i/10g, SQL, PL/SQL, Stored Procedures, XML, XSD, Unix Shell Scripting, Teradata V2R5, SSIS, SQL Assistant 6.0, QTP9.2, Business Objects 6.5.

Responsibilities:

• Created PL/SQL procedures, triggers, views, functions.
• Gathered information about the transaction process, planning and development of the various screens.
• Responsible for designing database tables and writing SQL & PL/SQL procedures, functions.
• Developed various forms (screens) and some complex reports.
• Generated expected liability sheet containing loan no, name, amount disbursed, no of installments, gestation period.
• Written complex SQL queries for each level of data validation.
• Involved in creating both positive and negative test data to cover all business scenarios Involved in developing detailed test plan, test cases and test scripts for Functional, Security and Regression Testing.
• Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment
• Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, Summary Reports, Portal built on Oracle.