We provide IT Staff Augmentation Services!

Etl Tester Resume

Wilmington, DE

SUMMARY:

  • 7+ years of experience in Requirement’s Gathering, Analysis, Documentation, Testing, Implementation and Maintenance. Specialized in Quality Assurance and testing, worked as ETL Tester, BI Tester and QA Analyst.
  • Database / ETL/Reports Testing - - Validated the data derived in the target table is adhering to the standards and business rules. Played major role in Test Data Creation and Maintenance. Verified if there are any downstream impacts in the warehouse.
  • Solid Back End Testing experience by writing and executing SQL Queries.
  • Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
  • Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
  • Experience in UNIX shell scripting and configuring cron-jobs for Informatica sessions scheduling
  • Experience in writing Teradata SQL Queries for various needs including BTEQ, TPUMP, FLOAD, MLOAD & FEXPORT
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica and DataStage.
  • Expertise in Testing complex Business rules by creating mapping and various transformations.
  • Expertise in using Excel functions and lookups for the Data Comparison and Data Validation.
  • Sound work experience in different software testing methodologies - Waterfall, V Model and AGILE METHODOLOGY.
  • Experience in testing BI reports developed in Business Objects & Cognos Series.
  • Experience in testing XML files and validating the data loaded to Staging, Target tables.
  • Experience in testing and writing SQL and PL/SQL statements.
  • Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Informatica and DataStage.
  • 5+ years of experience in RDBMS technologies like Teradata V2R6/V2R5, Oracle 8.x/9.x/10g/11g, DB 2 8.0/7.0/6.0, MS SQL Server 2008/2005/2000, Sybase and Excel. SQL Developer, TOAD, Embarcadero Rapid SQL, SQL Plus, Win SQL, Quest Central for DB2.
  • Experience in data validation of various sources like Teradata, DB2, Informix, Oracle, SQL Server and Sybase.
  • Excellent written and verbal communication & interpersonal skills.

TECHNICAL SKILLS:

Testing Tools: HP ALM/Quality Center 10.0/9.2/9.0, Rally Software, Test Director 8.0/7.6, Win Runner 7.6/7.0, Quick Test Pro 8.0/6.5, Load Runner 7.6/7.2, Rational Clear Quest

Languages: Java, XML, HTML, SQL, PL/SQL, TSL, Java Script, VB Script

Hardware: HP-9000 Series, IBM Compatible PC Pentiums

Operating Systems: WindowsNT/2000/XP, UNIX, LINUX

Databases: Oracle 11g/10g/9i, SQL Server 2008/2005/2000, MS Access, Teradata V2R6, Sybase, Informix, DB2

ETL Tools: Informatica Power Center 7.1.3/8.1/8.6.1, IBM Infosphere DataStage & Quality Stage 7.5.1/8.0/8.5, Ab Initio

Browsers: Internet Explorer, Netscape Navigator, Fire fox

Bug Tracking Tool: Rally Software, Rational Clear Quest, PVCS Tracker, Bugzilla

BI Tools: Cognos 8.4/8.2/8.0, Business Objects (BO)

GUI Tools: MDM DataStewardship UI, MDM Business Administration UI, MDM Business Administration Test UI, SoapUI-4.5.0, Visual Basic 6.0, Crystal Reports 6.0

App/Web Servers: Web Logic, WebSphere, Apache Tomcat

IBM Tools: IBM MDM Server 9.0.1, IBM WebSphere MQ Explorer V7

PROFESSIONAL EXPERIENCE:

Confidential,Pittsburgh,PA

Sr. ETL/MDM Test Coordinator

Responsibilities:

  • Analyzed business requirements, system requirements, data mapping requirement specifications from Detailed Business Requirement (DBR) documents and Detailed Technical Design (DTD) documents.
  • Participated in the Requirement understanding discussion with Business and IT teams. Responsible for documenting the functional requirements in Quality Center.
  • Involved in developing the Test Strategy, Test Plan documents for System / Integration Testing.
  • Prepared high level System Test Scenarios and Test Conditions for various functional segments. Worked on the Test schedules, Test estimates for the Test Script development and execution.
  • Written Test Cases for various functional segments based on the Detailed Business Requirement (DBR) documents, Detailed Technical Design (DTD) documents and Use Cases in Quality Center.
  • Responsible for Test Case Design, Test Scenarios walkthrough with Business and IT teams as part of review process and receive the Signoff approvals.
  • Performed the access check for all the databases, tools, servers and interfaces as entrance criteria for the System Testing.
  • Created Requirement Traceability Matrix by mapping test cases to the requirements to address all key points of functionality.
  • Manually performed Smoke testing for basic functionality checking as entrance criteria for the System Testing.
  • Wrote complex minus SQL queries between source and target for ETL DataStage jobs.
  • Tested complex ETL DataStage jobs based on Business requirements and Business rules to load data from source Mainframe files, Views and Stored Procedures to target tables.
  • Involved in extensive data validation using SQL queries and back-end testing.
  • Experience in creating UNIX scripts for file transfer and file manipulation.
  • Used Embarcadero Rapid SQL software for querying ORACLE.
  • Written several UNIX shell scripts for testing the data and verified the logs created in Linux box.
  • Experienced in performing Quality Assurance duties in an Agile Project Environment.
  • Used Quality Center for test execution, track and report System defects, bug fixes.
  • Performed the Manual Testing like Positive, Negative, System, Integration, UAT and Regression testing of an application.
  • Experience in identifying the Regression test cases and conducted Regression tests for reported bugs to test whether fix has been applied or not and also tested if that fix caused any other issue.
  • Experience in creating End to End Test Cases and Test Case execution.
  • Experience in scripting Critical Data Changes (CDC) or Delta processing Test Cases and tested the CDC changes to ensure new or updated records are loaded into MDM Server from the Source.
  • Provided the UAT and Production support for End to End Test Script execution and Defect retest.
  • Good experience in onsite-offshore model work. Schedule and Co-ordinate testing tasks in QC.
  • Produced the System Test Metrics report for the daily meeting showing the number of test cases executed, number passed, number failed and number left to execute.
  • Attended the Weekly Testing Touch base meetings, Daily Defect Status meeting and planning meetings.

Environment: IBM Infosphere DataStage & Quality Stage 8.5, Oracle 11g/10g, DB2, Sybase, IBM Mainframe Files, IBM MDM Server 9.0.1, MDM DataStewardship UI, MDM Business Administration UI, MDM Business Administration Test UI, Quality Center 10.0, SQL Developer, Embarcadero Rapid SQL 7.2.1, IBM WebSphere MQ Explorer V7, SQL, PLSQL, SQL Plus, UNIX, LINUX, Shell Scripting, SoapUI-4.5.0, XML, XML well formedness checker, XML validator, Filezilla, Beyond Compare 3, Notepad++, IVT (Installation Verification Tool), MS Office 2007

Confidential,Pittsburgh,PA

Sr. ETL Tester

Responsibilities:

  • Analyzed business requirements, system requirements, data mapping requirement specifications from product specification document (PSD) and responsible for documenting functional requirements in Rally.
  • Involved in developing detailed test plan, test strategy documents for Functional and Regression Testing.
  • Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be 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.
  • Wrote complex minus sql queries between source and target for ETL Informatica mappings.
  • Written Test Cases, Test Scripts based on the Business requirements and executed Functional testing, data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.
  • Involved in extensive DATA validation using SQL queries and back-end testing.
  • Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
  • Experienced in performing Quality Assurance duties in an Agile Project Environment.
  • Written several complex SQL queries for validating Cognos Reports.
  • Performed the tests in Sandbox, TST and AT environments.
  • Responsible for Data mapping testing by writing complex SQL Queries using Toad.
  • Worked with business team to test the drill down, drill up, master detail and adhoc reports developed in Cognos.
  • Tested whether the reports developed in Cognos are as per company standards.
  • Tested the Provisioning Internal Specification application (PISA) tool using SQL queries in CMDI for end users and product management.
  • Used Rally to track and report system defects, bug fixes and writing test cases/scripts.
  • Tested the front end UI for the CMDI application in CareDiscovery.
  • Ran HDD Explore publication batches from OC and verified the file extract from HDF using UNIX commands.
  • Ran HDD Explore and HDD Iatric Inbound batches from OC and verified the data is published from stage to hold tables using the workflows ran in the Informatica workflow monitor.
  • Ran HDD Projection return batches from OC and verified the data is published to hub tables using the Informatica workflow monitor.
  • Performed the smoke testing for Hospital Drug Database (HDD) for different feeds.
  • Tested the Informatica workflows to verify data from RXI 260 Legacy feed is loaded in to the hub tables.
  • Worked on testing the new Sorian feed source to validate that data from files are loaded into the hub tables respectively through raw and stage tables.
  • Tested all the ETL Informatica mappings enhancements in HDD.
  • Involved in iteration plan meetings, reveals, defect review and attended the daily scrum meetings.

Environment: Informatica Power Center 8.6.1, Oracle 10g, SQL Server 2005, MS Access, Cognos 8.4/8.2, Rally Software, XML, UNIX, Shell Scripting, SQL, PLSQL, SQL Plus, WINSQL, Ultra edit, Toad, SQL Developer, OC, XML Spy 2008

Confidential,Wilmington,DE

Sr. ETL/QA Analyst

Responsibilities:

  • Analyzed and reviewed project documentation, business requirements to prepare test plan and test strategy documents.
  • Written Test Cases, Test Scripts based on the Business requirements from the BRD and performed functional testing, data validation with defect correction and retesting.
  • Performed Integration, System, Regression and Performance testing for an application.
  • Involved in extensive DATA validation using SQL queries and back-end testing.
  • Used TOAD Software for Querying ORACLE.
  • Validated all kinds of transformations used in every work flow used to transform data.
  • Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.
  • Checking the data flow from one end to another by using SQL queries.
  • Extensively used Informatica power center for extraction, transformation and loading process.
  • Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements.
  • Experience with software methodologies like Agile and waterfall.
  • Wrote complex SQL queries for validating the reports developed from Cognos.
  • Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detail and Score Cards.
  • Worked with the DW Architecture team in Testing complex Delta processing Loads.
  • Involved in creating both positive and negative test data to cover all business scenarios.
  • Written several UNIX Shell scripts for testing the data.
  • Tested several stored procedures.
  • Used Quality Center to track and report system defects, bug fixes and writing test cases/scripts. Written modification requests for the bugs in the application and helped developers to track and resolve the problems
  • Involved in the error checking and testing of the ETL workflows using Informatica workflow log and session log.
  • Involved in iteration plan meetings, reveals and attended the daily scrum meetings.

Environment: Informatica Power Center 8.1, Oracle 10g, SQL Server 2005, MS Access, Cognos 8.2, Quality Center 9.2, SQL, PL/SQL, SQL Plus, HTML, TOAD, UNIX, Shell Scripting, Ultra edit, WINSQL, XML, XML Spy 2008

Confidential,Washington,DC

ETL Tester

Responsibilities:

  • Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0.
  • Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
  • Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Used SQL for Querying the DB2 database in UNIX environment
  • Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata.
  • Experience with software methodologies like Agile and waterfall.
  • Responsible for different Data mapping activities from Source systems to Teradata
  • Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
  • Tested Ab Initio graphs for data loading.
  • Tested jobs and used Ab Initio as an ETL tool to load the final loads.
  • Worked with the DW Architecture team in Testing complex Delta processing Loads
  • Ran Ab Initio graphs for both GDE and UNIX korn shell/command line for testing needs.
  • Involved in creating both positive and negative test data to cover all business scenarios
  • Involved in developing detailed test plan, test cases and test scripts for Functional, Security and Regression Testing.
  • Written several complex SQL queries for validating Cognos Reports.
  • Tested whether the reports developed in Cognos are as per company standards.
  • Used Quality Center to track and report system defects and writing test cases/scripts.
  • Used Clear Quest to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
  • Participated in defect review meetings with the team members. Used MS-Word for documentation.
  • Involved in other test planning meetings and submitted test metrics daily to the management.

Environment: Ab Initio (GDE 1.14, Co>Op 2.14), Teradata V2R6, SQL Assistant 7.0, DB2, Oracle 9i, Cognos 8.0, SQL, PL/SQL, HTML, TOAD, UNIX, Rational Clear Quest, Quick Test Pro, Quality Center 9.0, Shell Scripting, SQL Plus, WINSQL

Hire Now