We provide IT Staff Augmentation Services!

Etl Tester Resume

2.00/5 (Submit Your Rating)

San Antonio, TX

SUMMARY:

  • Over 7+ years of QA experience in all phases of life cycle, including requirements gathering, risk analysis, project planning, scheduling, testing, defect tracking, management, and reporting.
  • Experience in ETL/Data warehouse backend testing, BI reports testing and Windows / Web Application testing.
  • Experience in Testing all the important pieces in the web application like Functionality Testing, Usability testing, Interface testing, Compatibility testing, Performance testing, Security testing.
  • Experience in End to End testing for the ETL Load process which included testing incoming file format, Loading Staging tables, Business rules implementation, Matching Criteria, Data Cleansing, Load to final tables and Reports generation.
  • Strong knowledge of Software Testing Life Cycle (STLC - Requirement Analysis, Test Planning, Test case development, Test Environment setup, Test Execution, Test Cycle closure).
  • Experience testing ETL using Microsoft SQL Server Integration Services ( SSIS) and Informatica.
  • Knowledge on TFS and Microsoft Test Management.
  • Expert knowledge in creating Test Plans, Test Cases, Test Scenarios and Test Strategies, Defect Management to ensure Quality Assurance and to test all the business requirements.
  • Experience in preparing test reports from Quality Center and prepared daily test status reports to communicate the test status with the team.
  • Experience in using Automation Tool: Quick Test Professional (QTP) and Quality Center (QC) in Client/Server.
  • Expertise on various manual testing types like System testing, Regression testing, Functional testing, UAT testing etc.
  • Excellent Knowledge of Database Systems - MS Access, SQL server and Data ware house concepts.
  • Validation of data transformations and perform End-to-End data validation for ETL & BI systems.
  • Extensive Working experience in applying Relational Database Concepts, Entity Relation diagrams and Normalization concepts.
  • Excellent Knowledge in MS-Office (Word, Excel, PowerPoint), MS-Access, MS Visio.
  • Strong verbal and oral communication skills.
  • Knowledge on Database Design, Data Modelling, Normalization and SSIS Packages / SSRS Reports in MS SQL Server and Dimensional Modeling (Star schema and Snow flake schema).
  • Experience in using scheduling tools like SQL Server agent and Windows Scheduler.
  • Experience in scripting languages like Windows Batch commands.
  • Experience in resolving Data Transformation, Cleansing and Capturing rejects and Exception and Error reporting.
  • Proficiency in creating Test Cases, Test Plans, Technical Design Documents, Functional Design Documents, mapping sheets and data validation.
  • Ability to handle multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
  • Good ability to quickly grasp and master new concepts and technologies.

TECHNICAL SKILLS:

Operating Systems: Windows / Unix.

Databases: SQL Server 2005/2008/2012/2016 , MS Access.

ETL Tools: Informatica Power Center, SSIS, SSRS

Documentation: MS Office, MS Excel, Power Point.

Tools: / Utilities: HP Quality Center, JIRA, SharePoint.

Code Repositories: SVN, TFS.

Test Approaches: Waterfall, Agile/Scrum, SDLC, STLC, Bug Life Cycle, Manual/Automation.

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

ETL Tester

Responsibilities:

  • Analyzed the business process workflows, ETL work flows and mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types.
  • Interacted consistently with the developers and analysts to determine the types of testing required throughout the Bug Life Cycle (BLC) and to report any data discrepancy.
  • Worked with ETL source system and target system (ETL mapping document) for writing test cases and test scripts.
  • Deriving Test Scenarios, Documenting Test Cases and Collecting Test Data for Functional Testing.
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
  • Tested various ETL processes developed using ETL tools like Informatica Power center and SSIS.
  • Verified column mapping between source and target.
  • Developed a Defects Tracking Log for the SharePoint Site to track defects while testing.
  • Contribution to Test Plan Documentation.
  • Updating Traceability Matrix Document.
  • Developed SQL queries /scripts to validate the data such as checking duplicates, null values, concatenated strings, truncated values and ensuring correct data aggregations.
  • Performed End to End testing for the ETL Load process which included testing incoming file format, Loading Staging tables, Business rules implementation, Matching Criteria, Data Cleansing, Load to final tables and Reports generation.
  • Creating Test Batches, Executing Test Cases and Reporting Defects.
  • Data Driven Testing with valid and invalid inputs, and Database Testing (Checking Data Integrity, Data Manipulations, and Data Comparison). Validating the Full loads and Delta loads.
  • Involved in UAT testing, SIT Testing, Regression Testing and Functional testing.
  • Extensively used Informatica power center for extraction, transformation and loading process.
  • Extensively tested several ETL Mappings developed using Informatica and SSIS.
  • Involved in testing data reports. Written several SQL queries for validating the front-end data with backend.
  • Tracking Defects, Selecting Test Cases for Re & Regression Testing.
  • Sanity Testing, Re & Regression Testing on modified Software Builds.
  • Collecting Test Metrics and Documentation.
  • Updating Test Cases and Test Data.
  • Executed SQL queries to perform backend database testing and verify/modify user data
  • Team Communication and Customer Communication.

Environment: Informatica Power Center, ETL, MS SQL Server, Visual studio, MS Access, MS Excel, Windows Batch Jobs, TFS, HP Quality Center, JIRA, SSIS.

Confidential, Chevy Chase, MD

ETL Tester

Responsibilities:

  • Reviewed Business requirements, IT Design documents and prepared Test Plans which involved various Test Cases for all assigned module/projects; Review Test Requirements, Creating Test Plans and Test Strategy documents.
  • Analyzed the business process workflows, ETL work flows and mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types.
  • Interacted consistently with the developers and analysts to determine the types of testing required throughout the Bug Life Cycle (BLC) and to report any data discrepancy.
  • Worked with ETL source system and target system (ETL mapping document) for writing test cases and test scripts.
  • Responsible for Test execution of ETL Processes based on business rules. Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
  • Responsible for the validation of data on each layer with Mapping Document. Capturing the details test results with each of the test case.
  • Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center and SSIS.
  • Performed data validation testing after the ETL process using Informatica. Tested several Informatica and SSIS Mappings to validate the business conditions. Testing the source and target databases for conformance to specifications.
  • Contribution to Test Plan Documentation and updating Traceability Matrix Document.
  • Responsible for Logging of defects, Re-testing and follow up till closure of defects assigned to team.
  • Creating Test Batches, Executing Test Cases and Reporting Defects.
  • Data Driven Testing with valid and invalid inputs, and Database Testing (Checking Data Integrity, Data Manipulations, and Data Comparison).
  • Involved in UAT testing, SIT Testing, Regression Testing and Functional testing.
  • Tracking Defects, Selecting Test Cases for Re & Regression Testing.
  • Sanity Testing, Re & Regression Testing on modified Software Builds.
  • Collecting Test Metrics and Documentation.
  • Updating Test Cases and Test Data.
  • Tracking Changes, Preparing Reports and Updating Documents.
  • Team Communication and Customer Communication.

Environment: Informatica Power Center, MS SQL Server, Visual studio, MS Access, MS Excel, Windows Batch Jobs, TFS, HP Quality Center, JIRA, SSIS.

Confidential, Denver, CO

ETL Tester

Responsibilities:

  • Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.
  • Testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.
  • Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
  • Formulate methods to perform Positive and Negative testing against requirements.
  • Conducted Smoke testing, Functional testing, Regression testing, Integration testing, and User Acceptance Testing (UAT) and Data validation testing.
  • Creating test cases for ETL mappings and design documents for production support
  • Monitoring and using Job Control System in QA.
  • Extensively used Informatica for extraction, transformation and loading process.
  • Several ETL Mappings developed using Informatica and SSIS.
  • Validated data in between source and target after running Mappings by the Informatica developer team.
  • Writing SQL queries to validate the ETL process and BI Reports.
  • Create traceability matrix.
  • Interactions with BA and Dev. Teams to resolve the issues.
  • Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
  • Used Agile testing methodology for achieving deadlines in UAT.

Environment: Informatica Power Center (Power Center Designer, workflow manager, workflow monitor), BI Reports (MSTR), ALM, SQL Server, SSIS.

Confidential

QA /ETL Tester

Responsibilities:

  • Interacted consistently with the developers and analysts to determine the types of testing required throughout the Bug Life Cycle (BLC) and to report any data discrepancy.
  • Developed test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability.
  • Deriving Test Scenarios, Documenting Test Cases and Collecting Test Data for Functional Testing.
  • Develop and execute detailed ETL related functional, performance, integration and regression test cases, and documentation.
  • Tested developed websites prior to rollouts for usability and functionality.
  • Tested all the important pieces in the web application like Functionality Testing, Usability testing, Interface testing, Compatibility testing, Performance testing, Security testing.
  • Approached website testing from a user perspective.
  • Developed SQL queries /scripts to validate the data such as checking duplicates, null values, concatenated strings, truncated values and ensuring correct data aggregations.
  • Performed End to End testing for the ETL Load process which included testing incoming file format, Loading Staging tables, Business rules implementation, Matching Criteria, Data Cleansing, Load to final tables and Reports generation.
  • Executed the jobs in job scheduler for QA testing by taking the job information from the developers.
  • Validated the job execution logs for any errors and reported them to developers.
  • Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center and SSIS.
  • Performed data validation testing after the ETL process using Informatica. Tested several Informatica and SSIS Mappings to validate the business conditions. Testing the source and target databases for conformance to specifications.
  • Created the defect tracking report by listing all the passed defects, deferred defects.
  • Logged the defects in HP quality center and TFS for tracking purpose.
  • Contribution to Test Plan Documentation and updating Traceability Matrix Document.
  • Involved in UAT testing, SIT Testing, Regression Testing and Functional testing.
  • Tracking Changes, Preparing Reports and Updating Documents.
  • Participated in the daily stand up calls, scrum calls and worked in both Agile and Waterfall methods.
  • Team Communication and Customer Communication.

Environment: : MS SQL Server, Visual studio, MS Access, MS Excel, Windows Batch Jobs, TFS, HP Quality Center, SSIS.

Confidential

QA /SQL Tester

Responsibilities:

  • Understanding Functionalities as per the Client.
  • Tested developed websites prior to rollouts for usability and functionality.
  • Tested all the important pieces in the web application like Functionality Testing, Usability testing, Interface testing, Compatibility testing, Performance testing, Security testing.
  • Approached website testing from a user perspective.
  • Prepared test data for functional & Integration testing.
  • Developed SQL queries /scripts to validate the data such as checking duplicates, null values, concatenated strings, truncated values and ensuring correct data aggregations.
  • Interactions with BA & Dev teams to resolve the issues.
  • Designed, Reviewed & Executed Test cases.
  • Identified Test cases for Regression testing
  • Working on Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.
  • Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews
  • Performed data validation testing writing SQL queries.

Environment: Informatica, SSIS, SQL, DB2, HP Quality Center, Windows, UNIX.

Confidential

Support Analyst

Responsibilities:

  • Interacted with real-time users to know the bugs encountered during the real-time usage of the product and replicate them in lower environments.
  • Worked on AbuseDesk tasks. AbuseDesk, a sub-team of Security & Abuse Team consists of published postmaster & abuse (support) addresses, where members and non-members write in with their Security & Abuse related concerns with respect to United Online. All messages received by AbuseDesk are processed within 24 hours TAT (Turn Around Time),
  • Reviewing the PhotoSite albums and removing i.e. (Ban or Suspend) the albums that are posted against UOL policies.
  • Handling operations at United Online (UOL) Security and Abuse team that is primarily involved with the issues related to - Email/Account Security and Fraud Operations.
  • Working closely with Email back-end team to resolve any Mail Delivery issues associated with all UOL domains (Juno, NetZero, BlueLight or EmailmyName). Work with the concerned domain authorities, as and when required to resolve issues associated with other domains (AOL, Yahoo, etc.).
  • Handling issues related to Spam and how to combat Spam.
  • Reviewing the automated Responses and providing suggestions for any modifications.
  • Preparing Monthly Reports. Preparing the Mail Handling trend report, this will help the management to know the efficiency of the work done.
  • Executing a few basic Unix commands to check certain logs.
  • Analyzing the ISP accounts for any fraudulent activity like Phishing/419 scam or are involved is Postings (Craiglist, eBay, etc.).
  • Querying the database to find the records.
  • Providing the assistance in using the Software.

Environment: SQL Server /Windows XP/2000, Excel.

We'd love your feedback!