We provide IT Staff Augmentation Services!

Senior Etl Tester Resume

Richmond, VA

SUMMARY

  • Having +8 years of Information Technology experience; all of her experience is relevant in ETL/ Data Warehouse Testing and is being presented for ETL QA Analyst.
  • Experience in software QA Testing and Data Warehouse using ETL tools Informatica, SSIS, Data stage and Reporting tools SSRS, OBIEE and Business Objects.
  • Extensive Experience in Quality Center which includes Uploading Requirement, Preparation of Test cases and uploading, Execution of Test Cases, Logging & tracking Defects, Preparation of Metrics and Preparing Status reports for test design Phase and Execution Phase.
  • Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target Data Warehouse.
  • Strong experience in Cognos reports, cubes, extracts and Data Warehouse tables testing.
  • Sound knowledge and experience in Data Warehousing and Business Intelligence Testing using different tools like SQL, SSIS, SSRS, DataStage, Cognos etc.
  • Expertise in writing and executing test cases based on given software requirement specification and developed detailed Test Plan.
  • Performed Functional testing, Integration testing, System testing, Regression testing, and Smoke Testing.
  • Experience in Problem solving and Bug reports using Defect Tracking Tool Mercury Quality Center.
  • Highly motivated, organized, able to work independently and able to switch between projects quickly.

TECHNICAL SUMMARY:

Testing: Manual Testing, DWH - Testing, Report testing and ETL Testing

Manual Testing: Functional Testing, System Testing, Regression testing

Defect Tracking Tool: MQC, Test director, JIRA

Data Warehousing: SQL Server 2008, Teradata7.2, SSIS, Cognos 10, DataStage

Operating Systems: Windows NT, 9x, 2000, XP, 2003 Server, Linux, SUN Solaris

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Senior ETL Tester

Responsibilities:

  • Identifying field and data defects with required information in ETL process in various jobs and one to one mapping.
  • 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.
  • Load source file data into data warehouse using SSIS package.
  • 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.
  • Validated the data in the reports by writing simple to complex SQL queries in the transactional system.
  • Executed the Test cases for Cognos.
  • Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
  • Oversaw the historical loads in UAT and PROD environments.
  • Also worked on Integration of all the processes in UAT/PROD.
  • Optimizing/Tuning several complex SQL queries for better performance and efficiency.
  • Prepared the test cases after thorough analysis of each requirement.
  • Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.
  • Conducted and actively participated in reviews, walkthroughs of test cases.
  • Reviewed the ETL mappings to ensure the transformation rules are applied correctly.
  • Created and executed SQL queries to perform source to target testing on Oracle database.
  • Coordinated with different users in UAT process.
  • Performed Unit testing for all reports and packages.

Environment: Oracle9i, Mercury QC 9.0/11, SQL SERVER 2008, Cognos 7.0 Series, Windows XP/2000 and UNIX.

Confidential, Wilmington, DE

ETL/SQL Tester

Responsibilities:

  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
  • Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
  • Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
  • Validating the reporting objects in the reporter against the design specification document.
  • Validating the data files from source to make sure correct data has been captured to be loaded to target tables
  • Extensively used Cognos to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata to Teradata. Reviewed Cognos mappings and test cases before delivering to Client
  • Written Test Cases for ETL to compare Source and Target database systems.
  • Extracted data from various sources like Oracle, flat files.
  • Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Cognos.

Environment: SSIS, Oracle8i, SQL, Cognos 7.0 Series, WindowsXP/2000 and UNIX.

Confidential, Chicago, IL

ETL Tester

Responsibilities:

  • Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
  • Analyzing requirements and creating and executing test cases
  • Involved in ETL process testing using Cognos ETL tool.
  • Test Case Execution and Adhoc testing
  • Performed Integration, End-to-End, system testing.
  • Involving in Functional Testing & Regression Testing
  • Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews
  • Performed data validation testing writing SQL queries.
  • Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.
  • Used Teradata utilities (MLOAD & FLOAD) to load the source files in to test region. And did the querying on the same data.
  • Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Cognos.
  • Working on Quality Center for creating and documenting Test Plans and Test Cases and register the expected results

Environment: SQL Server 2000, Teradata V2R6, Crystal Reports, Oracle 8i, Microsoft Business Intelligence, MS Excel, Flat Files.

Confidential, Weehawken, NJ

QA Tester

Responsibilities:

  • Involved in the meeting with business analysts and Marketing team for requirement gathering in Definition Stage.
  • Gathered and Analyzed Functional and Performance requirements.
  • Involved in project planning, coordination and implemented QA methodology.
  • Extracted test data by understanding relational database design diagrams Created.
  • Designed, Created and executed manual Test Cases.
  • Reviewed Test cases for automation and provided inputs about the scope of Automation.
  • Prepared documentation about the automation suite architecture.
  • Peer Review of the scripts and made recommendations for updates if any.
  • Used SSIS to load source files into landing database.
  • Performed extensive backend testing by writing Complex SQL queries.
  • Setup the Performance test environment with the support of technical team.
  • Response time, throughput, hits per second, etc were studied by graphs and reported.
  • Created manual & automated test cases for testing web services.
  • Used Test Director for storing, maintaining the test repository, bug tracking and reporting.
  • Prepared documentation for some of the recurring defects and resolutions and business comments for those defects.
  • Assist QA Team with defining and implementing a defect resolution process including defect priority, severity, next steps, and assigned owner.

Environment: Windows XP, SQL*Plus, Oracle 8i, MS Office Suite, SQL Navigator

Confidential

ETL Tester

Responsibilities:

  • Analyzing the user specification/Client requirement documentation.
  • Prepared and reviewed detailed test scenarios and test cases covering the mappings and Reports.
  • Reports creation and data validation.
  • Execution of test cases and defect tracking through Quality Center.
  • Involved in collection of test metrics.
  • Participated in review meetings and status meetings.
  • System testing of the application and raised maximum number of defects.
  • Identified design flaw and got good appreciation from client.
  • Update testing status to client in client meeting on daily basis.

Environment: SQL, PL/SQL, UNIX and Mercury Test Director.

Confidential

ETL Tester

Responsibilities:

  • Proof of concept development for Back Ground Reports Module.
  • Involved in preparation of test cases.
  • Involved in Functionality Testing and Regression Testing.
  • Testing manually all the Screens for Privileges of user.
  • Effective Coordination between Development team and testing team.

Environment: Spring - Hibernate, JBoss Application Server, SQL and Mercury Quality Center.

Hire Now