We provide IT Staff Augmentation Services!

Etl/bi Tester Resume

Westfield Center, OH

SUMMARY:

  • Over 9 years of extensive experience in Software Quality Assurance and testing with strong knowledge of Software Development life cycle (SDLC) and Software Testing Life Cycle (STLC)
  • Hands on experience in analyzing Business Requirement, Functional Requirement, Design specification and developing Test plan and Test scenarios
  • Hands on experience in Functional testing, Integration testing, System testing, Regression testing and End to End testing
  • Experience in financial application testing such as Insurance, Banking, Health and web applications integrated with various legacy systems
  • Extensive experience in all testing methods including Waterfall, Spiral, V model, Agile and Scrum
  • Expertise in creating/developing Test cases, Test scenarios using standard and modular approach
  • Experience in working as a single point of contact for all testing activities and as liaison between the different teams members and the manager
  • Experience in testing of Data Warehouse/ETL Applications developed in Informatica, DataStage using SQL Server, Oracle, DB2, and UNIX.
  • Ability to evaluate ETL/BI specifications and processes to develop BI Test Strategy
  • Expertise in writing simple and complex SQL queries using TOAD, SQL Navigator
  • Comfortable in working with fixed length, delimited flat files and also worked with large volume of data in the database/data warehouse
  • Experience in writing test cases/ test scripts for Inbound and Outbound ETL processes and interfaces with other systems and streams
  • Experience in testing/validating the Source, Stage and Target (End - to-End) data systems
  • Experience in analyzing the error caused to failure of the ETL load with reference to the log file and report them to the corresponding team to get it rectified
  • Familiar in working with Quality Center to store Business Requirements, Test Cases, Test Runs, and Test Results for every iteration and store defects and link them back to the requirements.
  • Expertise in Defect Tracking, Defect management and Bug Reporting using tools like Clear Quest, TestDirector, Quality Center
  • Experience in testing/validation of Actuate reports, Business standard and ad hoc reports
  • Experience in End-to-End testing of an application/process. Performed backend testing using SQL Queries and UNIX scripting
  • Experience in creating & scheduling the jobs using Autosys
  • Ability to work as independent and team member in challenging and cross platform environment
  • Highly motivated team player with excellent analytical, problem solving, interpersonal and communication skills

TECHNICAL SKILLS:

Databases: Oracle7/8i/9i/10g/11g, DB2, Teradata V2R6/V2R5SQL Server 2000/2005/2008, IBM Netezza 7.2

ETL Tools: Informatica Power Center, Abinitio, DataStage, SSIS

Operating System: Windows, UNIX (Solaris)

Scripting: UNIX Shell Scripting, PL/SQL scripts

RDBMS Load Tools: SQL Developer, SQL * Plus (Oracle), T-SQL (SQL Server)

Reporting Tools: Business Objects, Cognos

Database Tools: TOAD 7.6/8/9.5/9.7, SQL Developer, Erwin 3.x/4.x

Office Applications: WinSCP, Putty, MS Office Suites including Excel, Word, Access, Outlook, Visio, Quality Center, XML spy, SoapUI

Languages: SQL, PL/SQL, C, C++, XML

PROFESSIONAL EXPERIENCE:

Confidential, Westfield Center, OH

ETL/BI Tester

Responsibilities:

  • Reviewed Business Requirements and Mapping Documents developed for the Data Warehouse and Data Mart tables identified for the SQB - Submit Quote and Bind & ACC - Agency Compensation and Contract Projects
  • Thoroughly understood the ETL Business Logic and data flow
  • Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using DataStage
  • Performed the validations on DWH tables for both Initial and Incremental loads
  • Extensively written test scripts to test the transformation logics used in ETL process
  • Validated the new tables loaded in Warehouse and Mart for the SQB - Submit Quote Bind Project
  • Testing various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data
  • Testing Cognos Reports, which would facilitate decision-making. The Cognos Reports designed were complex and used formulas, parameters, selection criteria, sub reports etc.,
  • Formulate methods to perform Positive and Negative testing against requirements
  • Conducted Smoke testing, Functional testing, Regression testing, Integration testing, and Data validation testing
  • Used Agile testing methodology for achieving deadlines in UAT
  • Executed and managed test cases and reported bugs in Quality Center
  • Experience in testing Drill-Down, Drill-Through, Sub Reports, Linked Reports, Snapshot Reports
  • Developed SQL queries to check data in the database and checking the data integrity in accordance with business standards of the company

Environment: IBM Netezza 7.2, DataStage 8.5, Cognos 10.2.2, SQL Developer, MS Sql Server, HP ALM QC

Confidential, Erie, PA

Senior Manual QA/ETL Tester

Responsibilities:

  • Getting finalized requirements about Request For Change (RFC) from business analyst for the monthly release
  • Simultaneously gathering the requirement document for the actual project while analyzing them and preparing for the test scenarios
  • Created the test strategy for all the monthly releases and test case document for testing the RFC’s
  • Created a separate folder for every release in HP ALM Quality Center
  • Validated web services using SOAP UI
  • Created test strategy document for the project - MDM web service and for ETL migration from stored procedure to DataStage jobs for the initial load.
  • Involved in working with ETL validation for SSIS jobs for claims in Claim center project. Validation of data flow from source to target data bases.
  • Retesting the defects once they are fixed and reopening them based on necessity as per the validation results followed by regression testing after resolving the issues to ensure the existing functionality is working as expected
  • Writing complex SQL queries on various source and target databases such as Oracle, Microsoft SQL Server by retrieving the data using various kinds of joins
  • Providing updates to the QA Manager once the release is completed and discussing how the release went, ways to improve the process and fill the gaps if there are any

Environment: MDM, DataStage, Oracle 10g, SQL Developer, Sql Assistant, MS Sql Server, SoapUI, Xml Spy, MS Access, HP ALM QC

Confidential, Danville, PA

Senior Manual QA/ETL Tester

Responsibilities:

  • Worked as ETL Test Analyst and responsible for the Business requirements, ETL Analysis, ETL Testing and designing of the flow and the logic in developing XML files using Informatica, SQL and PL/SQL.
  • Understanding of ETL Business Logic and data flow.
  • Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types
  • Performed Functionality Testing, Regression Testing, Integration Testing, and System Testing and Documented the Test Procedures.
  • Validated XSD and XML using XML Spy
  • Validated XML files by loading them into tables using SSIS package against Source
  • Verified whether ETL Mapping documents followed data models and business requirements logic for various builds.
  • Extensively written test scripts to test the transformation logics used in Informatica ETL process.
  • Used SQL Queries to verify the data from the Oracle and MS SQL Server databases.
  • Experienced in writing complex SQL queries for extracting data from multiple tables.
  • Interacted with client user personnel to ensure continuing adherence to requirements and user standards.
  • Performed backend testing using SQL queries.
  • Used HP Quality Center as test management tool to track the issues found in testing.
  • Involved in formal review meetings with project teams and developers to report, demonstrate, prioritize and suggest resolution of issues discovered during testing.
  • Actively participated in System testing, integration testing and coordinated UAT

Environment: Informatica Power Center 9, Oracle 10g, SQL Developer, Sql Assistant, MS Sql Server, Xml Spy, MS Access, Teradata 13.10, HP ALM QC

Confidential, Nashville, TN

Senior Manual QA/ETL Tester

Responsibilities:

  • Involved in Business analysis and requirements gathering.
  • Involved in various meeting like Project Kick-off, Project planning, Weekly & Monthly client status meetings
  • Writing and reviewing the test scripts.
  • Compared and Tested Source data.
  • Tested the entire ETL logic using Informatica to enable initial load and incremental processing from SQL Server and Oracle, error strategy and exception handling, restart ability and recovery, data cleanup, validation and monitoring.
  • Experienced using database query and integration tools such as TOAD, SQL plus etc.
  • Experienced in data analysis using SQL, TSQL, PL/SQL and many other queries based applications.
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Reported bugs and tracked defects using JIRA.
  • Extensively used SQL to verify and validate the data loaded into Target
  • Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
  • Preparing and supporting the QA test environments

Environment: Informatica Power Center 8.6 /9.1, Oracle 11g, Teradata V2R6/V2R5, SQL Developer, Cognos 10, XML, PL/SQL, SQL, WinSCP, Putty, JIRA, UNIX, Toad, SharePoint, Windows Office

Confidential, Philadelphia, PA

Senior Manual QA/ETL Tester

Responsibilities:

  • Involved in Business analysis and requirements gathering.
  • Written 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
  • Tested the entire ETL logic using Data Stage to enable initial load and incremental processing from SQL Server and Oracle, error strategy and exception handling, restart ability and recovery, data cleanup, validation and monitoring.
  • Experienced using database query and integration tools such as SSIS, TOAD, SQL Plus etc.
  • Obtained detailed understanding of data sources, Flat files & Complex Data Schemas in order to write the best test scripts.
  • Tested & developed the mapping for extracting, cleansing, transforming, integrating & loading data using Autosys.
  • Experienced in data analysis using SQL, TSQL, PL/SQL and many other queries based applications.
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Reported bugs and tracked defects using Clear Quest.
  • Extensively used SQL to verify and validate the data loaded into Target
  • Performed the tests in both the SIT, QA and contingency/backup environments
  • Used SQL for Querying the Data Stage database for data validation, data verification and data conditioning.
  • Writing the test scripts, test cases & test plan for multiple ETL Feeds.
  • Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
  • Involving in Functional testing, Backend Testing, End to End testing and Regression Testing
  • Preparing and supporting the QA test environments
  • Load new or modified data into back-end database.
  • Defect Triage with Development team.
  • Involved in peer review of test cases.

Environment: Informatica 7.1, SQL Server 2008/2005, Oracle 9i/10g, XML, Flat Files, MS Excel, SQL, TSQL, PL/SQL, Business Objects XI, SSIS, Toad, Clear Quest, Windows, UNIX, Clear Case, Quality Center 10, Remedy

Confidential, Phoenix, AZ

QA/ETL Tester

Responsibilities:

  • Involved in Business analysis and requirements gathering.
  • Involved in complete project software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC).
  • Validating the data passed to downstream systems.
  • Used data stage director to run the jobs and check the log files.
  • Involved in validating SSRS packages according to functional specifications.
  • Reported periodic project status and updates to the QA Lead and QA Manager
  • Performed Integration Testing of different modules.
  • Analyzed Business Requirements and Developed the Test Scripts and Test Cases
  • Used Test Director for Bug Reports and Defect Tracking.
  • Performed Risk Analysis based on Defect Severity and Priority.
  • Tested User Interface inconsistency and application functionality.
  • Worked on issues with migration from development to testing.
  • Tested application in various browsers.

Environment: DB2, Oracle 10g, XML, Flat Files, MS Excel, SQL, TSQL, PL/SQL, SQL Server 2008/2005 SSIS, SSRS, Toad, Clear Quest, Windows, UNIX

Hire Now