We provide IT Staff Augmentation Services!

Etl/dw Qa Tester Resume

Rosemont, IL

SUMMARY

  • 7+ years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications.
  • Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
  • Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs.
  • Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
  • Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
  • Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP and SDLC methodology environments
  • Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
  • Well versed in GUI application testing, Database testing and Front-end testing.
  • Experience in Financial, Banking, Brokerage, and Securities industries.
  • Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
  • Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
  • Experience in testing and writing SQL and PL/SQL statements.
  • Experienced working with Customer Information Data Mart for business reporting thru MDM and Reference Data
  • Strong Problem Analysis & Resolution skills and ability to work in Multi Platform Environments like Windows and UNIX
  • Experience in testing XML files and validating the data loaded to staging tables.
  • Strong skills in database programming using SQL, PL/SQL, T-SQL, Stored Procedures
  • Good experience in Cognos & Business Objects Reports testing.
  • Automated and scheduled the Informatica jobs using UNIX Shell Scripting and expert knowledge in UNIXshell scripting
  • Excellent analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS

ehousing: Ab Initio CO>Op 2.15, GDE 1.15, Informatica 8.6/8.1/7.1/6.1 , Data Stage 8.x

Reporting Tools: Business Objects6.5, XIR3, Cognos 8 Suite

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, Fact and dimension tables, Pivot Tables, Erwin

Testing Tools: Win Runner, Test Director, Mercury Quality Center, Rational Clear Quest

RDBMS: Oracle 10g/9i/8i/7.x, MS SQL Server 2008, UDB DB2 9.x, Sybase 12.5, Teradata V2R6, MS Access 7.0

Programming: UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, SQL*Plus, PL/SQL, T-SQL, TOAD, C++

Web Technologies: JavaScript, HTML 4.0, and DHTML, Java, J2EE

Environment: UNIX, MVS, HP-UX, IBM AIX 4.2/4.3, Novell NetWare, Win 3.x/95/98, NT 4.0, Sun-Ultra, Sun-Spark, Sun Classic, and SCO

PROFESSIONAL EXPERIENCE

Confidential, Rosemont, IL

ETL/DW QA Tester

Responsibilities:

  • Responsible for coordinating testing throughout both systems ODS and EDW which were two different teams.
  • Generated automated test cases on first build of the module using QTP, Rational Tools.
  • Performed Black-box testing, White-box testing, and System Testing, Data Integrity Testing, Sanity, Regression and end-end testing.
  • Promoted Unix/Informatica application releases from development to QA and to UAT environments
  • Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
  • Developed data quality test plans and manually executed ETL and BI test cases.
  • Designed and kept track of Requirement Traceability Matrix in Quality Center and test cases creation, loading and writing Test Plan and executing Test Cases and printing status report for the team meetings and defect tracking
  • Involved as part of automation team using Selenium 0.6 and developed test scripts.
  • Used Informatica as an ETL tool to extract data from sources systems and aggregate the data and load into the Tera Data database. Prepared test data using Informatica and UNIX sessions.
  • Tested ad hoc and canned reports for Business objects.
  • Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using QTP.
  • Testing of Business Objects and Reports which Includes, Database Connectivity, Tested objects in the Universe to ensure the correct mapping of the objects, tested the Universe s Structure to ensure that tables are properly uploaded. Tested the aggregate Universe to ensure the query is pulling correct level of Aggregation.
  • Performed extensive Backend Testing using SQL and checked the data flow and data validation
  • Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.
  • Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
  • Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
  • Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
  • Validating the data between SAP R3 and Tera Data Staging.
  • Performed all aspects of verification, validation including functional, structural, regression, load and system testing
  • Carried out extensive testing with Quick Test Pro (QTP) testing tool with different test cases.
  • Extensively used Informatica power center for extraction, transformation and loading process.
  • Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
  • Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
  • Worked on test data and completed unit testing to check all business rules and requirements are met. Also tested for negative data to check that the job fails on any critical error.
  • Tested several data migration application for security, data protection and data corruption during transfer
  • Validating the data between Tera Data Staging and EIS Data Store by using SQL Statements.
  • Responsible to help testing team on creating test cases to make sure the data originating from source is making into target properly in the right format.

Environment: Quality Center 10.0, SQL, PL/SQL, Business Objects XIR3, Teredata, Informatica 8.6.1/8.1, MainFrame Flat Files, Agile, COBOL II, UNIX, Korn Shell Scripting, Oracle 10G, DB2, TOAD9.7

Confidential, New York

ETL/ DW QA Tester

Responsibilities:

  • I have imparted and organized training to newcomers in the team regarding different technologies like SQL, PL/SQL and different processes.
  • Expert in writing complex SQL queries using Functions, Joins for all databases including Oracle and SQL Server.
  • Developed automated Test scripts using QTP to perform Functional and Regression testing.
  • Used Informatica as an ETL tool to extract data from sources systems and aggregate the data and load into the Tera Data database. Prepared test data using Informatica and UNIX sessions.
  • Extensively used Data Stage for extraction, transformation and loading process
  • Attending Client calls for Business understanding and Clarifications.
  • Tested Business Objects reports and Web Intelligence reports and Responsible for testing Business Reports developed by Business Objects XIR2
  • 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, breaks, sorting, @Functions, Alerts, Cascading Prompts and User Defined Objects.
  • Worked in an Agile technology with Scrum
  • Written several shell scripts using UNIX Korn shell for file transfers and clean up process.
  • Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
  • Reported bugs and tracked defects using Quality Center
  • Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
  • Developed test scripts using QTP for Functionality and Regression Testing
  • Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
  • Worked with T-SQL for validating the SQL Server 2000 data.
  • Extracted Data from Teradata using Data Stage ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
  • Validating the data between SAP R3 and Tera Data Staging.
  • Involved in data warehouse testing by checking ETL procedures/mappings.
  • Performed all aspects of verification, validation including functional, structural, regression, load and system testing
  • Tested the Oracle PL/SQL testing programs.
  • Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
  • Involved in conversion of WinRunner scripts to QTP (Quick Test Pro).
  • Tested several data migration application for security, data protection and data corruption during transfer
  • Involved in creating source target mappings based on the Technical Design requirements.
  • Worked on test data and completed unit testing to check all business rules and requirements are met. Also tested for negative data to check that the job fails on any critical error.

Environment: SQL,PL/SQL, HP Quality Center 10, Business Objects XIR2,Rational Clear Quest, MS Excel, Agile, Data Stage, Teradata SQL Assistant, Korn Shell Scripting, XML

Confidential, Richmond, VA

Data Warehouse Tester

Responsibilities:

  • Involved in creating source target mappings based on the Technical Design requirements.
  • Involved in Business analysis and requirements gathering.
  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
  • Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings and Used Quality Center for defect tracking
  • Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
  • Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
  • Developed Test scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
  • Effectively communicate testing activities and findings in oral and written formats.
  • Worked with Oracle database to compare the results from front-end data values with backend data values.
  • Extensively used Informatica power center for extraction, transformation and loading process and worked with ETL group for understating mappings for dimensions and facts.
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
  • Validated cube and query data from the reporting system back to the source system.
  • Tested analytical reports using Analysis Studio
  • Applied appropriate validation rules and created graph parameters to check the validations are correct so that the graph should stop.
  • Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers.
  • Created different user defined functions for applying appropriate business rules

Environment: Informatica power center, Quality Center, EME, MVS, UNIX (K-Shell Script), Oracle 10G, DB2, Windows 2000 Pro, XML, Agile, XSLT, XSD, Rapid SQL, PL/SQL, TOAD

Confidential, Durham, NC

SQL Tester / Data Tester

Responsibilities:

  • Participated in business requirement walk through, design walk through and analyzed Business requirements.
  • Involved in developing detailed test plan, test cases and test scripts using Test Director for Functional and Regression Testing.
  • Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
  • Created Test plan, Test Design, Test scripts and responsible for implementation of Test cases as Manual test scripts.
  • Involved in Teradata SQL Development, Unit Testing and Performance Tuning
  • Created the test environment for Staging area, loading the Staging area with data from multiple sources.
  • Extraction of test data from tables and loading of data into SQL tables.
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
  • Written several complex SQL queries for validating Cognos Reports.
  • Tested several stored procedures.
  • Validating the data passed to downstream systems.
  • Involved in testing data mapping and conversion in a server based data warehouse.
  • Involved in testing the UI applications
  • Tested whether the reports developed in Cognos are as per company standards.

Environment: Informatica, DB2, Java, Cognos, SQL, Teradata V2R4 (MLOAD, FLOAD, FAST EXPORT, BTEQ), XML, IBM AIX 5.3, UNIX, Shell Scripting, WINSQL, Oracle 8i/9i, DB2, SQL Server 2000, Windows XP

Hire Now