We provide IT Staff Augmentation Services!

Sr. Etl Qa Tester Resume

Chicago, IL

SUMMARY

  • 7+ years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing and Client - Server.
  • Proficient in analyzing the Business Requirements, Software Requirement Specifications, Functional Design Documents to formulate Tst Plans, Test Strategies and Test Cases for Manual as well as Automated testing for various applications to ensure proper business compliance.
  • Proven skills in all phases within the software development lifecycle and very strong in the implementation and maintenance of Quality Engineering Processes.
  • Experience in HP Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
  • Experienced in writing complex SQL queries.
  • 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
  • Experienced in testing both ETL and BI applications.
  • Extensive experience and highly proficient in Teradata and Oracle writing queries for database testing between “Sources - to - Target”.
  • Experience in Business Intelligence in generating various reports using Cognos, Crystal Reports, Business Objects and SSRS
  • Experienced in testing with Informatica, Ab Initio and data stage tools.
  • Strong Skills in using Integration, Functional, Regression, Performance, Stress and Configuration Testing.
  • Extensive experience with Functional, GUI, Database, Stress, Regression, Load and Performance Testing.
  • Was involved in setting up the test environment, created test data as per the requirement.
  • Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
  • Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, Sybase, Teradata, Ms Access, Flat files into a staging area
  • Good working experience on testing ETL, Reference Data and BI
  • Proficient experience in different Databases like Oracle, SQL Server 2008, DB2, Sybase and Teradata
  • Experience in all phases of Software Development life cycle.

TECHNICAL SKILLS

Data warehousing Tools: Ab Initio, Informatica Power Center 8.x/7.x/6.x, Power Exchange, Informatica Data Quality, IBM Data Stage 8x/7x, SSIS

Databases: Oracle 10g/9i/8i, Teradata v2r6, DB2, SQL Server 2008, Sybase

Languages: SQL, PL/SQL, C, C++, HTML, COBOL, Core Java, JCL.

Database Utilities: BTEQ, Fast Load, MultiLoad, Fast Export, TPump, TOAD 8.0/7.1, SQL *PlusSQL *Loader, SQL Navigator, SQL Assistant for Teradata:

Reporting Tools: Business Objects 6.5, XIR3, Cognos 8 Suite

Operating System: UNIX (Sun Solaris 8.0, AIX5.1) and Windows NT/2000, XP.

Scripting Languages: Shell Scripting, Shell, C Shell, Bourne Shell, Bash

Other Tools: Erwin Data Modeler, SmartFTP, WinScp, Putty, emacs, pico, XML Spy 2010

Testing Tools: HP Quality Center 10.0, Rational Clear Quest, Test Director

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. ETL QA Tester

Responsibilities:

  • Responsible for writing Test Cases, Test Plans, Test scripts and other test documents based on business requirement.
  • Responsible for data validation testing using SQL and executing testing on data Warehousing projects.
  • Responsible for developing detailed UAT test plans, conditions, scenarios, cases and related data and participate in UAT planning and execution activities for business and operations participants.
  • Developed Test Plans and developed Test Cases/Test Strategy with input from the assigned business analysts and data architect.
  • Promoted Unix/Data Stage application releases from development to QA and to UAT environments
  • Reviewed Business Requirements, System Specs and Training Material for accuracy. Planned, developed and executed test plans, including detailed test scripts.
  • Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI R3
  • Developed Test Plans and Developed Test Cases/Test Strategy with input from the assigned Business Analysts and data architect.
  • Written Test plans, Test cases, executed Test cases for SQL/backend test and tracked defects in Quality Center based on the Business Requirements, Functional Requirements, Business Workflows, A&D documents and ICD documents.
  • Used TOAD, DB Artisan tools to connect to Oracle database to validate the data that was populated by ETL applications.
  • Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS
  • Used SQL Assistant to connect to Teradata to write my SQL scripts
  • Involved in testing UNIX shell scripts to run various ETL scripts to load the data into Target Database (Teradata)
  • Responsible to design, develop and test the software to maintain the data marts (Load data, Analyze using OLAP tools).
  • Tested the messages published by data stage and data loaded into various databases
  • Clearly communicated defects with developers and updated comments in HP Quality center.
  • Determine level of testing required to validate new or revised system capabilities.
  • Report accurate testing status and create test summary reports.
  • Continuously improve test models, test data, and test processes based on lessons learned.
  • Tested ETL Packages, Scripts from development to QA environment.
  • Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
  • Used Quality Center and Test Director for defect tracking and reporting
  • Tested both conditional formatting and threshold level testing for several reports developed in Business Objects XIR3.
  • Executed Data stage ETL jobs using UNIX to load the data into target tables
  • Tested whether the reports developed in Business Objects are as per company standards.
  • Developed test reports and participated in testing prioritization and archived test results and user signoff.
  • Involved in extensive data validation using SQL queries and back-end testing
  • Written complex SQL queries to validate the data against the target based on ETL mapping specifications.
  • Used Tidal scheduler for composing and executing the jobs to simulate the production environment in QA.

Environment: Data stage, UNIX, IBM AIX 5.5, IBM Rational Manual TesterV7.0, IBM Rational Clear QuestV7.0, IBM Functional tester, Windows XP, SQL Assistant, HP Quality center, Oracle 10g, TOAD, WinSQL, XML Spy 2010, XM L Files, PL/SQL, Tidal Enterprise Scheduler V5.3, SSRS V9.0, Business Objects XIR3

Confidential

Sr. ETL QA

Responsibilities:

  • Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document).
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Used SQL for Querying the database in UNIX environment
  • Involved in data warehouse testing by checking ETL procedures/mappings.
  • Performed the tests in both the SIT, QA and contingency/backup environments
  • Performed all aspects of verification, validation including functional, structural, regression, load and system testing
  • Extensively used Data Stage for extraction, transformation and loading process.
  • Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
  • Participated in ETL design discussions
  • Performed pre-process validation for existence of specified database objects and grants for the same.
  • Validated the target table column definition with source column definition (including type and length)
  • Experience in data analysis and data testing and verified fields present in the reports are as agreed in the ETL specifications
  • Study of detailed requirement of end users of system & their expectations from Applications
  • Identify the flow of information, analyzing the existing systems, evaluating alternatives and choosing the most appropriate alternative.
  • Experience in loading from various data sources like database, fixed length and Delimited Flat Files.
  • Involved in testing the Business Objects reports by writing complex SQL queries.
  • Developed separate test cases for Inbound and Outbound Processes.
  • Involved with Design and Development team to implement the requirements.
  • Developed and Performed execution of Test Scripts manually to verify the expected results.
  • Validated that design meets requirements and function according to technical and functional specifications.
  • 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.
  • Heavily involved in performance testing and worked with analyzing tables, gathering statistics, tuning of SQL queries used to fetch source data.
  • Presented QA team work update/Status to Project/Program Manager in status meeting and also worked with business team to get approval on test plan/test cases.
  • Developed Test Scripts and executed them manually to verify the expected results and published the same to wider audience upon successful completion along with QA signoff.
  • Worked with different Time zone data
  • Tested several Data stage ETL jobs and ran on UNIX for loading purpose and checking the log files
  • Used HP Quality Center to state requirements, business components, test cases, test runs for every iterations, defects. Also link defects with requirements.
  • Participated in walkthrough and defect report meetings periodically.
  • Documented and reported various bugs during Manual Testing.
  • Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
  • Retesting the resolved defects/issues after the developers fix the defects
  • Involved in preparing Test Summary Document
  • Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
  • Involved in preparing test data for UAT and participated in UAT signoff

Environment: Data Stage, Oracle 9i/10g,Teradata, SQL, UNIX, HP Quality Center, TOAD, SQL Navigator, Windows XP Professional, PL/SQL, SSH Pro, SmartFTP, MS Excel 2003, MS Word 2003, Remedy, PVCS Version Manager, Text Pad 5.0, Business Objects XI R2, SharePoint

Confidential, Charlotte, NC

ETL QA Analyst

Responsibilities:

  • Written complex SQL queries using joins, sub queries and correlated sub queries.
  • Responsible for the creation and execution of test plans and scripts to verify software functionality is working according to business requirements.
  • Developed Test Plans and developed Test Cases/Test Strategy with input from the assigned business analysts and data architect.
  • Reported accurate testing status and created test summary reports.
  • Analyzed business requirements, system requirements, and data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
  • Tested several Data stage ETL jobs and ran on UNIX for loading purpose and checking the log files
  • Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
  • Worked on a Business Intelligence reporting system that was primarily functioning on Oracle Applications OLTP environment with Business Objects for Business Intelligence reporting
  • Executed Data stage ETL jobs using UNIX to load the data into target tables
  • Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
  • Responsible for external interactions with WCC, CED and GWM hubs and various test teams in which EPI was associated.
  • Involved in data mapping specifications to create and execute detailed system test plans. The data mapping specified what data was extracted from an internal data warehouse, transformed and sent to an external entity.
  • 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.
  • Involved in testing various Business objects reports List Reports, Grouped Reports, Cross-tab Reports, Chart Reports, and Drill-Through Reports.
  • Tested Model Filters, Query Filters, User access filters Detail filters and Summary Filters.
  • Tested the WEBI reports before publishing Worked with software testing methodologies with all phases and stages of testing desired (Functional, System, Integration, Regression, Data Validation, User Acceptance (UAT)).
  • Back end testing experience of being able to compare DB2 vs Oracle tables
  • Responsible for gathering business requirements to create detailed test cases. Ability to map test cases to business requirements and perform high end regression testing.
  • Worked with software testing methodologies with all phases and stages of testing desired (Functional, System, Integration, Regression, Data Validation, User Acceptance (UAT)).
  • Creating the test data before executing the tests. Responsible for designing, developing and the execution of reusable performance scripts.
  • Coordinating with the Business Analysts to understand the business Requirements
  • Involved in testing XML files and checked whether data was parsed and loaded to staging tables.

Environment: Data Stage 8.x, XML, XML Spy, Business Objects XIR2/6.5.1, MDM 8.5, IBM AIX 5.3, UNIX, Shell Scripting, IBM Rational Clear Quest, IBM Functional tester, Ultra edit, Mercury Quality Center 9.2, Oracle 10g, DB2, TOAD, MQ Series 6.0

Hire Now