We provide IT Staff Augmentation Services!

Etl/qa Analyst Resume

Richmond, VA

SUMMARY

  • Over 7 years of extensive experience as a QA Engineer involving in the entire SDLC and working with DWH/BI applications using Data Modeling, Data Extraction, Data Loading and Data Analysis.
  • Extensive experience in ETL and BI testing of DWH applications and reporting applications.
  • Proficient in writing Test Strategies, Test Plans, Test Cases, Test Scripts and Test Scenarios
  • Experienced in testing requirements that were developed in ETL and BI of DWH applications and reviewed scripts for positive and negative test scenarios, and prepared test summary.
  • Possess extensive experience performing Backend, Frontend, Regression, Functional, System, Interface, Usability, Black box, Integration and User Acceptance Testing.
  • Extensive Experience in Agile Methodology and waterfall methodologies of SDLC.
  • Well experienced in writing complex SQL queries for extracting data from multiple sources.
  • Technical strengths and automated test tool expertise includes Quick Test Professional (QTP), Quality Center, VBScript, SQL and Rational Tool Suite
  • Excellent experience in different Databases like Oracle, MS SQL Server, DB2 and Teradata.
  • Proficient in HP s Quality Center for Test Designing, Requirement Mapping, Reports and Defect Tracking
  • Hands on experience in writing SQL queries, Joins, Functions, Procedures, Packages, DBMS, RDBMS, and Triggers in Oracle and SQL Server databases.
  • Created requirements from Test plans, FRD, Use cases and updated those is Requisite pro and then in Clear Quest(CQ),Quality Center(QC) and Application Life Management(ALM).
  • Ability to work independently or in a team environment or in a rapid pace environment.
  • Possess strong interpersonal skills, communication and presentation skills with theability to interact with people at all levels.

TECHNICAL SKILLS

Testing Tools: HP UTF, ALM, Bugzilla, HP Quality Center 10/9.2/8.2

ETL Tools: InformaticaPowerCenter 8.6.1/8.1,7.x, Data Stage 8.1

BI Tools: Business Objects, Crystal Reports, SSRS

IBM Rational Suite: Rational Functional Tester 8.0/7.0, Rational Clear Quest, Clear Case

Scripting languages: VB Script, HTML, Shell Scripting

Operating Systems: Windows XP/NT/2000/Vista/7, DOS, UNIX

Databases: Oracle 11g/10g/9i, MS SQL Server, IBM DB2

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

ETL/QA Analyst

Responsibilities:

  • Prepare the Test Strategy and Test plan for the project covering System Testing, Integration Testing and UAT support.
  • Developed complex SQL queries for querying data against different data bases for data verification process.
  • Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
  • Tested data quality for customer data integration and Match - Merge process.
  • Tested Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
  • Validating the messages flow in IIB9 MQ service bus from EDM to ESB.
  • Designed and implemented complex SQL queries for QA testing and report/ data validation.
  • Write complex SQL queries against the target Oracle database to generate reports and compare against legacy Access database reports
  • Worked with Source to Staging area to validate the Basel II multiple source system data with SQL queries
  • Validating the EDM and ESB integrations flow through, IBM WebSphere Message Broker 7/IIB9,work with downstream application to name few SAP, FoodStar, etc. provide the required input to them.
  • Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts
  • Validating the databases designed in Microsoft SQL server and ORACLE by utilizing SQL Server Management Studio and Informatica Power Center.
  • Develop the requirement traceability matrix to map the requirements to test cases, Defining test methodology to carry out the development schedule.
  • Analyze complex SQL queries of in scope reports and identify critical elements, complex calculation logics and capture them in requirements template.
  • Work with team to ensure test environments are setup and test data are available for test execution.
  • Allocate the Test cases for Execution. Monitor and track the progress of Test execution and the various cycles involved.
  • Reported bugs and tracked defects using Quality Center/ALM
  • Performed Functional, Regression, UAT and Integration testing.

Environment: Informatica Power center 9.1,HP ALM Quality Center 11.0, Agile/Scrum, MSSQL, SAP (FI/CO, SD, MM, WM), IBM WebSphere Message Broker 7/IIB9, IBM WebSphere MQ, Retalix Product suite.

Confidential, San Jose, CA

QA analyst/ETL Tester

Responsibilities:

  • Extensively involved in Business Analysis and Requirements Gathering
  • Analyzed business requirements and interfaced with vendors for development and enhancement of a system to support multiple business areas including Asset Management, portfolio management and risk management.
  • Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.
  • Performed Regression, UAT and Database testing. Performed data validation-using SQL.
  • Involved in analyzing the requests for new, enhanced, and modified systems, against user and business requirements.
  • Conducted discussions and facilitate requirements gathering, process analysis, and application design sessions with company staff across all levels and functions
  • Responsible for validating the files availability, format and data on UNIX server
  • Executed SQL queries to verify the flow of data between back end and front end.
  • Coordinated system walk through, training, User Acceptance Testing (UAT) and facilitate issue resolution
  • Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
  • Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD/Exceed.
  • Strong hands-on experience in maintaining and using IBM Rational Clear Quest for Defect reporting, tracking & Change Management.
  • Performed ETL testing and extensively used SQL functionalities. Used TOAD to connect to Oracle Database.
  • Executed SQL queries to verify the flow of data between back end and front end.
  • Performed Data Driven Testing of the Application for different users/data sets
  • Developed Test cases for the data warehouse in Oracle System
  • Conducted Functional testing to ensure that the application meets the requirements and to ensure usability readiness
  • Involved in creation of defect analysis report for system Test and UAT.
  • Experience in creating UNIX scripts for file transfer and file manipulation.

Environment: Informatica Power Center, SQL, PL/SQL, UNIX, Toad, HP Quality center, SSIS, MS SQL server, Rational Functional Tester, Rational Clear Quest, Rational RequisitePro, Oracle 9i, Crystal Reports and Netezza.

Confidential

Responsibilities:

  • Reviewed Business Requirements Documents and the Technical Specification.
  • Written test plans, which detailed the testing scope, strategy, hi-level test requirements, and necessary resources.
  • Documented test cases corresponding to business rules and other operating conditions.
  • Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to Test changes.
  • Involved in business requirements, user requests and bug Scrubs meetings
  • Wrote test cases and test scripts for the functionality testing.
  • Performed End-to-End testing manually.
  • Closely worked with developers and System Engineers to nail down the technical problems.
  • Performed Regression testing using Silk test.
  • Tested the application compatibility in all versions of Netscape and Internet Explorer browsers.
  • Performed web testing for this application to test HTTP links, SSL (40&128bit) encryptions.
  • Reported the bugs, Email notifications to the developers using the QC Tracker.
  • Extensively involved in using QC Tracker to report bugs.
  • Monitored QC to close the bugs/cases as and when developers fix the bugs.

Confidential

Responsibilities:

  • Executed the test scripts for regression test of application.
  • Updated the test cases depending on the requirement.
  • Involved in testing the application compatibility for various browser versions.
  • Documented the errors in the bug-tracking tool QC Tracker.

Environment: Java, JSP, Quality Center, Oracle, Windows NT and Unix.

Hire Now