We provide IT Staff Augmentation Services!

Sr. Etl/qa Bi Tester Resume

Cleveland, OH

SUMMARY:

  • 8 years of extensive experience in Quality Assurance testing of data warehousing and Business Intelligence processes, Web Based and Client/Server applications.
  • Possess excellent knowledge & experience in providing data warehousing solutions and data warehouse concepts.
  • Hands on experience on ETL tools in ETL process development, testing and in maintaining ETL codes.
  • Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
  • Managed/lead/performed test planning, test execution, test data, test coordination, configuration management and defect management areas for the web based, middleware and mainframe applications
  • Excellent experience in Quality Assurance and testing, worked as ETL Tester, BI Tester, Data Tester and QA Analyst.
  • Solid Back End Testing experience by writing and executing SQL Queries.
  • Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
  • Experience in defining Testing Methodologies; creating Test Plans and Test Cases, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC)
  • Experience in all phases of Software Development life cycle such as Agile, Scrum, Waterfall, RUP
  • Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
  • In depth technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.
  • Extensive experience in RDBMS technologies like Oracle 8.x/9.x/10g, DB2 9.1/8.0, Teradata V2R6/V2R5, MS SQL Server, Excel and MYSQL, SQL Developer, TOAD, Quest Central for DB2.
  • Experienced in testing Cognos and Business Objects reports.
  • Four plus years of experience in Business intelligence reporting tools using Cognos Series 8.x/7.0, Power play, Transformer, Impromptu Web Reports (IWR), PowerPlay Enterprise Server, and Business Objects XI R3/R2.
  • Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame
  • Worked with Functional /Testing tools as QTP, Quality Center, Test Director, Rational ClearQuest
  • Experience in Mercury Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
  • Excellent Communication, Analytical and Interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 8.x/7.x (Repository Manager, Designer, Workflow Manager, Workflow Monitor)/6.2(Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager. Repository manager administration), Power Mart 6.2, Data Integrator, Data Mining, OLAP, OLTP, SSIS, Data Stage 8.1, Ab Initio (GDE 1.15, Co>Op 2.15)

BI & Reporting: Business Objects XIR3/R2, Cognos 8 series, Power play, Report studio, Query studio.

Testing Tools: Load Runner 8.1, QTP 8.2, RFT 6.1, Test Director, Quality Center 9.2.

Databases: Oracle 10g/9i/8i/7.3, MS SQL Server, IBM DB2, Teradata V2R6, MS Access 2007 and MYSQL

Job Scheduling: Appworx, Autosys, BMC Control M, Maestro

Operating System: UNIX (Sun Solaris 9.0/8.0/7.0, HP-UX 11i v1.5/1.6/2.0, IBM AIX),WINDOWS 95/98/2000/NT/XP, Linux,MS-DOS

Languages/Tools: CVS, VSS,SQL, PL/SQL, SQL Developer, TOAD, SQL Assistant, UNIX shell scripts, PERL, XML, SOAP UI.

PROFESSIONAL EXPERIENCE:

Confidential, CLEVELAND, OH

Sr. ETL/QA BI Tester

Responsibilities:

  • Analyzed business requirements, data mapping specifications and developed Test Plans, Traceability Matrix, Test Cases, Expected Results and Prioritized tests for the applications for various modules using Quality center.
  • Created complex SQL queries for querying data against different data bases for data verification process.
  • Conducting detailed and keen reviews on every deliverable like Test Cases, Defect reports and Test summary reports.
  • Coordinating with QA Lead/Managers and resolve issues that occur during all phases of testing.
  • Tested new Data migration tool used in the mapping of data to new system.
  • Data migration of raw data to excel documents for clients
  • Attend daily status calls with customers and provide status on testing progress and provide Test status & Defect status reports.
  • Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
  • 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.
  • Extensively used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mappings.
  • Developed and Performed execution of Test Scripts manually to verify the expected results.
  • Validated that application meets requirements and functioning as per the technical and functional specifications.
  • Performed monitoring of the ETL jobs (Extraction, Transformation and Loading) by using Informatica power center Work Flow monitor.
  • Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio.
  • Tested the ETL mappings and other ETL Processes (Data Warehouse Testing)
  • Written several complex SQL queries for validating Business Reports.
  • Tested several stored procedures.
  • Worked with business team to test the reports developed in Cognos
  • Trained the users before UAT on how to test and document the test results. Also, assisted the users during UAT. Took part in Triage Meetings with the required parties after defect analysis to prioritize defect resolution.
  • Used Informatica ETL tool for Extraction, Transformation and Loading the data into target database
  • Involved in testing the Cognos reports by writing complex SQL queries.
  • Involved in recording change requests on the Change Requests.
  • Created Requirement Traceability Matrix by mapping the requirements with test cases to ensure that all requirements are covered in testing
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • Used TOAD & SQL Navigator GUI tools for Querying Database.
  • Interacted with the Business users to identify the process metrics and various keys dimensions and measures.
  • Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
  • Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
  • Experience in creating UNIX scripts for file transfer and file manipulation.
  • Validating the data passed to downstream systems.
  • Strong Informatica and data loading experience.
  • Involved in various testing phases like Integration Testing, System Testing.
  • Developed complex queries to test the reports developed.
  • Involved in testing the XML files and checked whether data is parsed and loaded to staging table
  • Tested the data and data integrity among various sources and targets.

Environment: Informatica 9.1, DB2, Cognos, SQL, PL/SQL, Teradata 13, Mainframe JCL, Teradata SQL Assistant, XML, IBM AIX 5.3, UNIX, Shell Scripting, WINSQL, ALM/Quality Center 11

Confidential, Wilmington, DE

ETL/QA BI Tester

Responsibilities:

  • Involved in development of test plans, analyzed the business requirements and data mapping documents and developed test cases.
  • PL/SQL queries were written to perform operations like joins in the source database.
  • Vigorously worked on Manual Testing. Written Test plans, Test Cases and Test Scripts.
  • Analyzed and reviewed project documentation, business rets to prepare detailed test schedules and plans.
  • Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
  • 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.
  • Written several complex SQL queries for validating Cognos Reports.
  • Provided support to sales team management and sales operations support groups in the receipt, warehousing and reporting account level sales information.
  • Extremely involved in using Test Director for identifying the bugs with the help of SQL queries.
  • Involved in understanding the Requirements of the end Users/Business Analysts and Developed Strategies for ETL processes.
  • Responsible for Mini specifications document that describe the functionality of each subject area.
  • Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
  • Creating and executing SQL queries to perform Data Integrity testing on Oracle Database to validate and test data using TOAD.
  • Coordinated with different users in UAT process.
  • Involved in job scheduling using MS SQL server Agent.
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
  • Responsible for writing shell scripts (wrapper) to schedule the jobs in development environment.
  • Developed graphs for the ETL processes using Join, Rollup and Reformat transform components as well as Partition and Departition components extensively.
  • Personalized Cognos Connection for specified display options for testing regional options and personal information.
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Used SQL for Querying the DB2 database in UNIX environment
  • Developed and tested all the backend programs, Informatica Mappings and update processes.
  • Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, Summary Reports, Portal built on Oracle.
  • Used T-SQL for Querying the SQL Server database for data validation.
  • Executed workflows created in Informatica by the developers then compared before and after transformation of data generated to ensure that transformation was successful.
  • Performed Data validity testing for reports and feeds based on client's requirement.
  • Validated format of the reports and feeds.
  • Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
  • Responsible for different Data mapping activities from Source systems to Teradata
  • Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
  • Created stored procedures, triggers using PL/SQL.
  • Performed quality assurance reviews on all System Development Life Cycle.
  • Promoted Unix/Informatica application releases from development to QA and to UAT environments
  • Participated in defect review meetings with the team members. Used MS-Word for documentation.
  • Involved in other test planning meetings and submitted test metrics daily to the management.

Environment: Teradata V2R6, Informatica 8.6, SQL Assistant 6.0.0, SQL, PL/SQL, Sybase, DB2, HTML, TOAD, UNIX, Mainframe JCL, VSAM, Clear Quest, Quick Test Pro, Quality Center, Load Runner

Confidential, Hoffman Estates, IL

ETL QA Tester

Responsibilities:

  • Analyzed and reviewed project documentation, business requirements to prepare detailed test schedules and plans.
  • Identifying field and data defects with required information in Informatica ETL process in various jobs and one to one mapping.
  • Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
  • Involved in developing detailed test plan, test cases and test scripts using Test Director for Functional, Security and Regression Testing.
  • Validated all kinds of transformations used in every work flow used to transform data.
  • Validating the data flow from source to target.
  • Involved in installation of Cognos Toolset and assisted in creating users and assigning them appropriate access rights for the entire testing team.
  • Involved in writing the test cases and Test plans based on Informatica Mappings Transformation Matrix or (Traceability Matrix) for supporting Black box and White Box testing.
  • Performed validation tests to ensure that the developed functionality meets the specifications prior to UAT testing.
  • Organized information and ensured the information that goes into user interfaces is edited and organized.
  • Tested Analytical Data Mart (ADM) of Oracle system and Stored Procedures
  • Checking the data flow from one end to another by using SQL queries.
  • Worked with technical staff to create, interpret and implement business requirements into technical specifications.
  • Written several complex SQL queries for validating Cognos Reports.
  • Experience in creating UNIX scripts for file transfer and file manipulation.
  • Extensively used Informatica power center for extraction, transformation and loading process.
  • Developed automated test scripts using QTP to perform Functional and Regression testing.
  • Created Test input requirements and prepared the test data for Data Driven testing.
  • Created and executed Test scripts for system validation and user acceptance testing (UAT)
  • Used Test Director to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
  • Performed quality assurance reviews on all System Development Life Cycle.
  • Extensive User Interface testing for each module for detecting bugs
  • Participated in defect review meetings with the team members. Used MS-Word for documentation.
  • Involved in other test planning meetings and submitted test metrics daily to the management.

Environment: Informatica, Cognos, Java, SQL, PL/SQL, Oracle 9i, HTML, TOAD, XML, UNIX, Quick Test Pro, Quality Center, DB2, Load Runner, MS Excel

Confidential, Jersey City, NJ

QA Analyst

Responsibilities:

  • Developed Test Cases for Functional as well as non-Functional, and Regression
  • Testing based on the Design Document, User Requirements and Use Case Diagrams
  • Planning Test cases and performed Functionality of GUI, Security, Configuration, Back-end and Acceptance Testing Manually
  • Written several UNIX Shell scripts for testing the data.
  • Written several PERL scripts for text processing, data parsing and connecting to the database.
  • Manually performed Smoke Testing of the new builds for Basic Functionality Checking
  • Build a lean Regression Test Suite for Manual and Automated Testing
  • Inserted Database Checkpoints to verify consistency of the database workflow using Win Runner
  • Implemented Database Checkpoints for Back-end Testing
  • Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
  • Performed Functional Testing and Back-end Testing using the database comparable results Manually
  • Interacted with the users to ensure meaningful development of the scripts and simulated real time business scenarios
  • Test Director was used for bug reporting and tracking

Environment: .NET, VB Script, Oracle, XML, XSD, XSLT, Microsoft Office, Test Director, SQL, PL/SQL, PERL, Shell Scripting

Confidential

ETL QA Tester

Responsibilities:

  • Developed Test Cases for Functional as well as non-Functional, and Regression
  • Testing based on the Design Document, User Requirements and Use Case Diagrams
  • Planning Test cases and performed Functionality of GUI, Security, Configuration, Back-end and Acceptance Testing Manually
  • Reviewed the Test Plans covering Unit Test, Integration Test, and Acceptance Test with other team members.
  • Worked with other members of the QA and Development teams and offshore team (Pune, India) in improving the processes, methods, effectiveness and efficiency
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
  • Used TOAD & SQL Navigator GUI tools for Querying Database.
  • Participated in walkthrough and defect report meetings periodically.
  • Documented and reported various bugs during Manual Testing.
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • Set up batches and work flow sessions to run these mappings.
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
  • Involved in running the ETL loads through APPWORX (by specifying the session parameters)
  • Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
  • Developed PL/SQL procedures & triggers.
  • Manually performed Smoke Testing of the new builds for Basic Functionality Checking
  • Build a lean Regression Test Suite for Manual and Automated Testing
  • Created UAT test cases and scenarios based on Use Cases, and made sure those UAT test cases meets the business requirements.
  • Inserted Database Checkpoints to verify consistency of the database workflow using Win Runner
  • Implemented Database Checkpoints for Back-end Testing
  • Expertise in SQL queries for inserting data by join different database and cross verification of data
  • Responsible for all pre-ETL tasks upon which the Data Warehouse depends, including managing and collection of various existing data sources
  • Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
  • Performed Functional Testing and Back-end Testing using the database comparable results Manually
  • Test Director was used for bug reporting and tracking

Environment: ETL (Informatica 6.2), Oracle 9i, SQL, PL/SQL, UNIX, Test Directror, AppWorx, TOAD, SQL Navigator, Windows XP Professional, Putty, SSH Pro, SmartFTP, MS Excel 2003, MS Word 2003, Remedy, PVCS Version Manager, TextPad 5.0

Hire Now