We provide IT Staff Augmentation Services!

Sr Qa Test Analyst Resume

Los Angeles, CA

PROFESSIONAL SUMMARY:

  • ETL Test Analyst with around 10 years of experience in software testing Which includes testing ETL applications developed using Informatica and Reports developed using BO, Cognos. Expertise includes creating and executing SQL queries. Experience includes Integration, Functional, Regression, System Testing, UAT Testing, Black Box , GUI testing and White box testing
  • Domain experience includes Banking and Financial Services, Insurance, Retail, cable, health care
  • Experience in Data warehousing, Data base Technologies, Credit Cards and Retail Banking, Loan Services
  • Have 5 years’ experience in Capgemini and 7 years onsite experience in USA at client locations
  • Experience in all phases of STLC & SDLC life cycles like Requirement analysis, Design (HLD & LLD), Unit testing, System testing, Regression Testing, Performance Testing and Implementation.
  • Extensive knowledge in Web Testing, ETL testing, Data warehousing Concepts, ETL Mappings, Data Transformation Logic and Data Validation and writing complex SQL and PL/SQL Queries and UNIX scripts
  • Experience in testing various applications developed using Informatica ETL tool and OBIEE and Cognos Reporting tool
  • Experience working in Agile testing methodology
  • Automation experience with QTP, Excel Macros and knowledge in using Informatica DVO (Data Validation Option) tool.
  • Expertise in creating Test Strategy, Test Plan, setting up test data, writing Test Scenarios and Test cases
  • Expertise in using ALM/HP Quality Center for creating new project, adding users, loading requirements, test plan and test lab setup, logging and tracking defects, dashboard reports.
  • Expertise in conducting Defect Triage meetings for defect remediation.
  • Have experience working on selenium and QTP automation tool
  • Have experience with Big data testing.
  • Excellent verbal and communication skills and ability to work with minimum supervision had interacted with business analyst and development team
  • Ability to identify and develop automated solutions for repetitive tasks

TECHNICAL SKILLS:

Testing Tools: Quality Center, QTP, Selenium

RDBMS: Oracle, Teradata, SQL server, Netezza, Greenplum

Reporting Tools: Business objects, Cognos, SSRS

ETL Tools: Abinitio, Informatica, BODS

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Sr QA Test Analyst

Responsibilities:

  • Analyzing the functional requirements document and technical design document and mapping document
  • Involved in preparing the test plan and test scenarios and test cases.
  • Involved in setting up of the test environment and coordination with the offshore team to complete the tasks and knowledge transfer to the offshore team
  • Involved in creating test cases using macros
  • Involved in creating & executing SQL commands and Unix shell scripts.
  • Involved in testing the initial and incremental load.
  • Involved in testing fact. dimension and look up tables and validated the data from source to target tables
  • Involved in testing of the OBIEE reports.
  • Involved in assigning defects to developers and regression testing the defects once the defect is fixed, then closing the defect.
  • Used Mercury Quality Center as test management tool.

Environment: Informatica, Quality Center, Greenplum and QTP, OBIEE, Oracle SQL Developer

Confidential, Albany, NY

ETL Test Analyst

Responsibilities:

  • Analyzing the Business requirements and planning Tests, Estimation, and test case creation.
  • Involved in analyzing the mappings and the transformations in the CDMA mapping doc Involved in testing the business intelligence reports developed using Cognos
  • I involved in assigning the testing tasks to the testing team members and reviewing the tasks done by the team .
  • Involved in reviewing SQL queries and Unix shell scripts.
  • Validated all the dimension, fact tables and lookup tables for the accuracy of the data loaded.
  • Involved in assigning defects to developers and regression testing the defects once the defect is fixed, then closing the defect.
  • Responsible for Test Reports and Test Execution Summary to the management.
  • Used rational quality manager to update and execute the test cases

Environment: Informatica, Rational quality manager, oracle, Tidal, Linux.

Confidential, Englewood Cliffs, NJ

ETL Test Analyst

Responsibilities:

  • Analyzing the Business requirements and planning Tests, Estimation.
  • Involved in assigning the tasks and reviewing the tasks completed by the team members.
  • Tested Initial load & delta load to make sure updates are happening accurately from source to target and validated history tables.
  • Involved in reviewing and executing SQL queries and Unix shell scripts.
  • Involved in manual and automation testing of the web applications developed for front end.
  • Validated all the dimension, fact tables and lookup tables for the accuracy of the data loaded.
  • Involved in Testing of SSRS reports generated by verifying the measures generated, font, header, footer, page layout, graphs, dashboards, charts, filter, conditions, breaks, sorting, Drill Down and hyperlinks.
  • Involved in performance and security testing of the reports generated using SSRS.
  • Involved in assigning defects to developers and regression testing the defects once the defect is fixed, then closing the defect.
  • Providing the daily testing status to the client at the end of the business day through teleconference.
  • Used Mercury Quality Center as test management tool to manage and organize Requirements Coverage, Test Case Management, Test Execution and Defect Management.

Environment: Informatica Quality Center, Teradata, SSRS, SQL server, QTP, Unix.

Confidential, Charlotte, NC

ETL Test Analyst

Responsibilities:

  • Analyzing the functional requirements document and technical design document and business data dictionary.
  • Involved in preparing the test plan and test scenarios.
  • Involved in setting up of the test environment.
  • Involved in creating & executing SQL commands and Unix shell scripts.
  • Involved in testing the initial and incremental load.
  • Involved in testing fact. dimension and lookup tables.
  • Involved in performance and security testing of the BI reports.
  • Involved in assigning defects to developers and regression testing the defects once the defect is fixed, then closing the defect.
  • Used Mercury Quality Center as test management tool.

Environment: Informatica, Quality Center, Netezza, Cognos, and QTP.

Confidential, Northbrook, IL

Database Test Analyst

Responsibilities:

  • Involved in the Requirement gathering from the Business team.
  • Developed Test Plan, Test scenarios, test cases.
  • Involved in assigning the tasks to the team members.
  • Involved in ETL (Extract, Transform and Load) testing.
  • Verified data quality by employing SQL and PL/SQL queries for data integrity.
  • Involved in the testing of Oracle financial modules.
  • Involved in testing of reports generated using Cognos.
  • Responsible for Test Reports and Test Execution Summary to the management.

Environment: Informatica, Quality Center, Oracle.

Confidential, Chicago, IL

QA Analyst

Responsibilities:

  • Participation in planning Tests, Estimation, and Execution.
  • Designing Test Scenarios and Test Cases.
  • Involved in ETL (Extract, Transform and Load) testing.
  • Review of Test plan, Scenarios and Test cases.
  • Involved in automation testing of web applications.
  • Involved in the testing of Oracle financial modules.
  • Involved in testing of reports generated.
  • Defect Management, Reporting and Tracking to closure.
  • Test results, Status updating and quality deliverables to the client.

Environment: Informatica, Quality Center, Oracle.

Confidential, Boston

ETL QA Analyst

Responsibilities:

  • Involved in the Requirement gathering from the Business team.
  • Developed Test Plan, Test scenarios, test cases.
  • Involved in assigning the tasks to the team members.
  • Involved in ETL (Extract, Transform and Load) testing.
  • Verified data quality by employing SQL and PL/SQL queries for data integrity.
  • Involved in the testing of Oracle financial modules.
  • Involved in testing of reports generated using Cognos.
  • Responsible for Test Reports and Test Execution Summary to the management.

Environment: Informatica, BO, Quality Center, Oracle.

Confidential, Plano

ETL QA Analyst

Responsibilities:

  • Involved in the Requirement gathering from the Business team.
  • Developed Test Plan, Test scenarios, test cases.
  • Involved in assigning the tasks to the team members.
  • Involved in ETL (Extract, Transform and Load) testing.
  • Verified data quality by employing SQL and PL/SQL queries for data integrity.
  • Involved in the testing of Oracle financial modules.
  • Involved in testing of reports generated using Cognos.
  • Responsible for Test Reports and Test Execution Summary to the management.

Environment: Informatica, SAP, BO, Quality Center, Teradata

Confidential, Plano, TX

Database Test Analyst

Responsibilities:

  • Developed a road map by understanding the business logic and User Requirements for Test execution.
  • Designing Test Scenarios and Test Cases.
  • Executing the Abinitio graphs in UNIX environment for Data extraction and transmission Process.
  • Analyzing the Abinitio graph Error log files to find out the specific error if graph fails .
  • Balancing all the counts and Balances of Account files in different stages of Data Migration like Source, Pre Abinitio, Post Abinitio, Data load to ODS and Data warehouse.
  • Copying Input data files from ACS to UNIX test server and Pre - Prod server using FTP and validating the Data.
  • Involved in testing of reports generated.
  • Defect Management, Reporting and Tracking to closure.
  • Test results, Status updating and quality deliverables to the client.

Environment: Abinitio, Test director, Crystal Reports, SQL Server.

Hire Now