We provide IT Staff Augmentation Services!

Sr Etl Tester Resume

Malvern, PA

PROFESSIONAL SUMMARY:

  • 6+ years of IT experience in testing both Business Intelligence and ETL Applications and Data Ware House (DWH) Testing, Frontend Testing, and Web Based Applications.
  • Highly skilled in developing Test Plans, Test scripts, Test Matrix and executing Test Cases
  • Hands on experience in writing test scripts, preparing test data, testing Informatica Mappings and creating SQL scripts using stored procedures, functions, PL/SQL.
  • Extensive experience in writing SQL and PL/SQL scripts to validate data warehouse.
  • Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
  • Expert in Informatica Data Validation (DVO) to test the migrated data from source to Target.
  • Strong experience in Informatica TDM tool for Data Validation, Data Discovery (sensitive data)
  • Experience in creating ETL test scenarios and test cases and deployment plan by using ETL mappings
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Informatica
  • Experience in executing the test cases and reporting bugs using test management tools like HP ALM and JIRA.
  • Extensive experience in Black box/White box, manual and Automation (QTP) testing.
  • Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Microstrategy
  • Expertise in testing of the reports using Data Mart Reports, Partition Mappings, Aggregate Tables and Intelligent Cubes.
  • Highly experienced with different RDBMS such as Oracle 9i and 10g, MS SQL Server 2000, Teradata and DB2.
  • Knowledge of UNIX shell scripting and scheduling and executing jobs.
  • Excellent analytical, problem solving, and communication skills, with ability to interact with individuals at all levels.
  • Responsible for mentoring resources technically and training other QA Team Members.
  • Experience with QA Methodology to ensure the Quality Assurance Control.
  • Good in analyzing risk and issues and able to communicate to Management for determining mitigation plan in timely manner
  • Strong communication and interpersonal skills to maintain effective work relationships with all levels of personnel. Clear understanding of business rules and ability to work as a part of team.
  • Excellent analytical, problem solving, and communication skills, with ability to interact with individuals at all levels.

TECHNICAL SKILLS:

Operating Systems: UNIX, LINUX, Windows

Languages: UNIX, C, C++, SQL, XML

Databases: SQL Server, Netezza, DB2, Oracle, Teradata, Salesforce Cloud

Tools: Informatica, Microstrategy, Cognos, Oracle, JIRA, Toad, Rally, HPALM, Splunk, Fiddler, Selenium, IBM DB2, SQL Server, IBM Netezza, Denodo, Active Batch, FileZilla, Microsoft Windows/Excel/PowerPoint

Learning Skills: Selenium, Hadoop, Python

PROFESSIONAL EXPERIENCE:

Confidential, Malvern, PA

Sr ETL Tester

Responsibilities:

  • Reviewed Business requirements to provide QA test estimates
  • Experience in working in both waterfall and Agile SDLC methodology for achieving project goals.
  • Implemented SDLC methodology using JIRA.
  • Handled multiple projects and was actively working as lead on most of the project.
  • Worked on Analysis of BRD & SRS to determine the functionality of the ETL and report functions.
  • Developed and assisted juniors team members to write Test Cases for ETL to compare Source and Target database systems in HP ALM 9.0 and 10.0.
  • Developed and executed test cases to cover all the reporting requirement in HP ALM.
  • Performed data validation of both clinical/revenue data.
  • Created ETL test cases with different data sources (SQL Server, Salesforce, Flat files, Excel source files, Oracle, Netezza) and loaded the data into target tables by performing different kinds of transformations using Informatica.
  • Performed extensive Backend Testing by developing, modifying, and executing SQL queries for data validation and data verification on database.
  • Developed UNIX scripts to validate the flat files and to automate the manual test cases.
  • Experience using FileZilla/WinSCP for file transfer protocol.
  • Experience in Salesforce framework with involvement in design, write, maintain and scale complex test framework and also setup test environment.
  • Involved in testing company’s Salesforce CRM application which includes preparing Test procedure, Test scenarios, Test cases and Test data.
  • Involved in gathering information from business user teams spread over the Sales, Marketing and Service cloud.
  • Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects.
  • Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into house using Informatica
  • Co-ordinate with the team (Onsite, offsite/offshore) to ensure and track total quality deliverables to satisfy business need.
  • Documented all errors/defects identified in the process of testing in share point site as defined by the management.
  • Actively involved in process and improvement tasks in QA.
  • Developed consolidated defect dashboard every month to present the upper management the root causes of all defects identified in QA organization.
  • Prepared and submitted daily dashboard to present snip of daily project testing activities to the upper management.
  • Tested connections for Interfaces running that is responsible for data movement within the organization.
  • Bouncing the domains on which the interfaces were running as part of regular checkups.
  • Performed negative testing to break the authentication placed to protect the Personal Information of the Patients while data movement.
  • Analyzed the logs generated and worked on resolving issues with the DEV team for critical interfaces that were down.

Confidential, Phoenix AZ

Sr. ETL QA Tester/DW Tester

Responsibilities:

  • Used Informatica Data Validation to create ETL Testing situation and conducted Data Validation before and after migration.
  • Archived and retrieved several applications using Informatica to archive the data and backload into the data warehouse.
  • Analyzed the relevant business information, transformed the data into a required business format and loaded into the Data Warehouse.
  • Used Informatica DVO to create repeatable tests that validate PowerCenter mapping data.
  • Performed the validation between the development target and the testing target.
  • Used Informatica TDM tool for data masking. Tested complex masking rule, Plans in TDM to mask application
  • Created Test Data in each release for validating the ETL process.
  • Worked actively in ETL process and writing complex SQL queries for querying data against different databases (SQL Server and Netezza) for data verification process.
  • Created and executed all the test cases using Informatica PowerCenter.
  • Worked actively in data profiling, data scrubbing and data cleansing for Data Warehouse.
  • Written SQL queries to validate the data from Source to Target database.
  • Developed test scripts using QTP for Functionality and Regression Testing
  • Coordinate between various department dependencies and escalation of issues to keep project schedules on track, utilizing JIRA for online issue tracking
  • Created test conditions (test cases) for every release for SIT.
  • Worked on an Agile project.
  • Used Rally for Test Management and Defect Management.
  • Used HPALM to execute the Test Condition for SIT.
  • Supported business for UAT.
  • Worked in OBIEE to generate reports and also test those reports according to the business needs.
  • Worked on automating most of the Manual testing scenarios using QTP and VBScripts.
  • Generated the automation framework design using Microsoft Visio.
  • Involved in writing automation script to validate the data from pre stage to different staging layer and to the fact table.
  • Used the UFT (Unified functional tool) for automation using the VB script as a scripting language.
  • Actively involved in Business meeting and Team meeting to understand the requirement properly.
  • Performed end to end data validation in the Historical Migration process from SQL Server to Netezza.
  • Performed end to end data validation in incremental data load in Netezza and making sure the data is flowing from Retention to Fact as per the lookup condition.
  • Used Informatica (Informatica Designer, Manager, and workflow) as ETL tool to check if the data is loading correctly and also to debug the data using the debugger tool in Informatica.
  • Reported directly to the Director of Technology and Channel Managers on project metrics, status, schedules and risk assessments
  • Manage technical projects for software development and infrastructure improvements that encompass software and system upgrades.
  • Worked on SFT application for pulling and pushing the files to different UI application.

Confidential, Chicago, Illinois

ETL Tester/ Frontend Tester

Technologies Used: Windows XP, Informatica 8.1, QTP 9.2, SQL, PL/SQL, Teradata, XML, Quality Center 9.0, DB2, Oracle 10g, Java, Perl Script, Unix AIX 5.2,VB Script, OBIEE

Responsibilities:

  • Created ETL test data for all transformation rules and covered all the scenarios required for implementing business logic.
  • Performed Data Quality Testing Data Analysis, Data Validation, Data Verification, Data Cleansing, Data Completeness and identifying data mismatch for Date Warehouse Testing.
  • Setting up of environments to be used for testing and the range of functionalities to be tested as per technical specifications.
  • Written complex SQL queries for querying data against different databases for data verification process.
  • Creating UNIX scripts for file transfer and file manipulation.
  • Created and executed test scripts, cases, and scenarios that will determine optimal system performance according to specifications
  • Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.
  • Tested several Informatica Mappings to validate the business conditions.
  • As part of Frontend testing validated the latest build, proxy and version for the RBI web application.
  • Validated Response and Result code for different platform automation using the assertion configuration file.
  • Extensively worked in cross browser testing for multiple devices and web.
  • Used Fiddler and developer tool for validation the commands, results and response code, methods, status, url.
  • Used Omniture as the analytical tool for the Ecommerce Web Application.
  • Performed different kind of testing such as Ad Hoc Test, Full Regression Test, Smoke Test, Functional Testing, Intermediate Regression, etc.
  • Extensive Experience on Online Video Streaming (web Player) validation based on asset’s bit rates delivered from CDN servers & generated Player Optimization test plan with testing reports

Confidential, Salt Lake City

QA Tester

Technologies Used: Informatica, Rally, HPALM, Microstrategy, SQL Server, Netezza, DB2, Unix, Visual Studio

Responsibilities:

  • Worked on extensively agile environment.
  • Involved in documenting Test Plan, Test Cases and Test Procedure using Business requirements document and Functional requirements document of the system.
  • Performed testing in events related to ETL application.
  • Tested mappings to load data into SCD Type II dimension tables.
  • Tested several Informatica Mappings to validate the business conditions.
  • Tested data flow from the source to target databases to confirm the business requirements
  • Written complex SQL queries to validate the incremental load in in IBM Netezaa Database and for querying data against different databases for data verification process.
  • Actively involved in supporting business during the UAT.
  • Extensively worked in generating reports using ALM after each Iteration and UAT.
  • Written Test Cases for ETL to compare Source and Target database systems.
  • Debugging the SQL Statements and stored procedures for various business scenarios.
  • Tested Customized reports in Microstrategy Web.
  • Debugged the reports generated with help of the Microstrategy Knowledge Base to troubleshoot any data or report related issues.
  • Tested the customized Reports as per the business Requirements using Microstrategy.

Hire Now