We provide IT Staff Augmentation Services!

Etl Tester Resume

Minnetonka, MN

SUMMARY:

  • 6+ years of IT experience in Quality Assurance for ETL , Backend, Web based, Client/Server applications using Manual and Automated testing tools.
  • Extensive experience with Test Plans, Test Cases, Test Scripts and Test Execution.
  • Experience with defect management, test execution report and defect status report thru HP ALM/Quality Center.
  • Proficient in gathering and analyzing the Business Requirements, documenting System Requirement specification, Functional Requirement specifications, Requirements Traceability Matrix.
  • Experience in Insurance, Healthcare, Retail, Public Services, Web Apps.
  • Experience using query tools for Oracle, Teradata and MS SQL Server to validate reports and troubleshoot data quality issues.
  • Participate in all meetings planned for particular release and obtain necessary technical automation requirement. Such meetings design review, test execution timeline etc.
  • Experience working in agile environment with bi - weekly sprint ad daily scrums.
  • Significant experience with SQL queries involving DDL, DML, Joins, Set operators and Case statements.
  • Expert in testing Client/Server, Mainframes, Middleware (EDI) and Internet/Intranet based business applications including development and implementation of test plans,test cases and test scripts.
  • Experience in analyzing EDI requirements and mapping documents.
  • Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading.
  • Good concept of ETL, Warehouse and BI applications integration
  • Extensive experience with data warehouse concepts and technologies like OLTP, OLAP, Normalization, De-normalization, ETL, Data Models and Data marts.
  • Good experience with Software Development Life Cycle methodologies waterfall and agile.
  • Extensive experience with database utility tools TOAD for Oracle, SQL Server Management Studio, SQL Developer and SQL Assistant.
  • Good Knowledge in various EDI X12, EDIFACT standards and Flat Files (Prop Format)
  • Experienced with ETL tools - Informatica Power Center, SSIS and DataStage.
  • Experience developing Requirements Traceability Matrix (RTM) and capturing and updating Change Requests.
  • Experienced with System, Integration, Regression, Performance and User Acceptance Testing (UAT).
  • Experience with Microsoft office applications such as Word, Excel, Access, Outlook, Powerpoint.
  • Experienced with White box testing, and Black box testing.
  • Experience with programming languages SQL, PL/SQL, C, HTML and Java.
  • Good experience with large amount of data and large databases.
  • Very good problem solving, interpersonal, and communication skills.

TECHNICAL SKILLS:

Testing tools: ETL,UFT(United Functional Testing), HP Quality Center/ALM, JIRA, QTP, Test Director, Manual Testing, Rational Test Tools Suite, Clear Quest

Defect Tracking Tools: Quality Center (9, 10, 11.0), Jira, Team Foundation Server (TFS 2008, 2010, 2012), Rational Clear quest, Bugzilla.

Languages: C, C++, Java, SQL, PL/SQL, HTML, Visual basics

Project Management: Microsoft Project, Microsoft Office (Word, Excel), Microsoft PowerPoint, MS Access, Agile & Waterfall

Methodologies: SDLC, Agile, Waterfall

Browsers: Internet Explorer, Firefox, Chrome & Safari

Operating Systems: Windows XP, 7, 8 & server 2003, UNIX and Linux

Databases: Oracle R12, MS Access, DB2, SQL Server 2008, TOAD/

PROFESSIONAL EXPERIENCE:

Confidential,Minnetonka,MN

ETL Tester

Responsibilities:
  • Analyzed business requirements and developed test cases and test scripts.
  • Conducted a complete assessment of teams, processes and environment.
  • Defined issues and risks and oversaw the design and introduction of tools, processes and best practices across testing life cycle to improve throughput, communication and on-time delivery of projects in an Agile development environment.
  • Involved in Capacity and resource planning and assigning tasks to team.
  • Experience working in agile environment with bi- weekly sprint ad daily scrums.
  • Written Test Script, Test Cases, Reported bugs and tracked defects using ALM.
  • Experienced in data integration, metadata management, ETL, data modeling tool sets
  • Writing complex SQL queries for data validation for verifying the ETL Mapping Rules.
  • Experience in EDI transactions (837, 835, 270, 271, 276, 277, 278, 820, 834 & 997) Enhanced and maintained QTP scripts, Configured Shared Object Repositories and developed Reusable function Libraries using VBScript.
  • Involved in creating the Object Repositories, QTP Test scripts and executes them during testing.
  • Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
  • Performed system testing on all EDI transactions both inbound and outbound
  • Created and managed issues thru JIRA tracking tool.
  • Discussed QA Testing requirements in QA Team walk through meetings.
  • Expertise in handling Health care EDI Claims 837I, 837P and 835P
  • Involved in/EDL transactions Analysis, Design, Implementation and documentation.
  • Developed shell script in UNIX and automated repeatable and regression test cases.
  • Developed complex SQL queries for testing several ETL transformations.
  • Executed ETL jobs and tested dimension and fact tables in semantic layer.
  • Analyzed EDI translation errors that failed in the inbound and re-processed the EDI's without losing the information.
  • Created Test input requirements and prepared the test data for Data Driven testing.
  • Tested several data mart tables in Oracle database using SQL and PL/SQL queries.
  • Involved in extensive data validation using SQL queries and back-end testing
  • Submitted weekly test execution and defect reports from ALM to project team.

Environment: Teradata 14, ALM/Quality Center 10, EDI, Power Center 9, JIRA, Oracle 9i, SQL Server 2008, SQL, TOAD, Hadoop, Hive, Big Data, SVN, Unix,TWS 9.3.

Confidential,Denver,CO

ETL QA Tester

Responsibilities:
  • Analyzed business requirements and developed test cases.
  • Written Test Script, Test Cases, Reported bugs and tracked defects using Quality Center.
  • Used Informatica Power Center workflow manager for executing sessions and workflows.
  • Used Informatica workflow monitor for monitoring workflows and reviewing session logs.
  • Experienced in data integration, metadata management, ETL, data modeling tool sets
  • Writing complex SQL queries for data validation for verifying the ETL Mapping Rules.
  • Extensively test the reports for data accuracy and universe related errors.
  • Used Toad to query and validate the data loaded into Oracle tables.
  • Developed test cases and SQL queries for validating ODI mappings.
  • Executed ODI jobs and tested target tables in Oracle database.
  • Used Toad for data analysts and SQL server Management Studio to query SQL server.
  • Report defects after reviewing test results and Track discovered defects and defect resolution in Quality Center.
  • Worked with various EDI files, understanding of how to Drop, translate and Load them using various EDI editors and web tools
  • Based on user requirements documented the test cases in Quality center.
  • Developed test cases for SSIS packages and transformations using complex SQL queries.
  • Executed SSIS packages and loaded target tables in SQL Server.
  • Validated Stored Procedures using SQL queries involving joins and set operators.
  • Executed SQL queries in SQL Server Management Studio for testing SSIS transformations.
  • Validated SSRS reports like Drilldown and Crosstab reports using SQL queries.
  • Tested SSRS report cosmetics like font, color and headers.
  • Created and managed issues thru JIRA tracking tool.
  • Discussed QA Testing requirements in QA Team walk through meetings.
  • Developed shell script in UNIX and automated repeatable and regression test cases.
  • Developed complex SQL queries for testing several ETL transformations.
  • Executed ETL jobs and tested dimension and fact tables in semantic layer.
  • Created Test input requirements and prepared the test data for Data Driven testing.
  • Tested several data mart tables in Oracle database using SQL and PL/SQL queries.
  • Involved in extensive data validation using SQL queries and back-end testing
  • Submitted weekly test execution and defect reports from ALM to project team.

Environment: Teradata 14, ALM/Quality Center 10, SSIS, T-SQL, SSRS, Informatica Power Center 9, JIRA, Oracle 9i, SQL Server 2008, SQL, TOAD, Unix.

Confidential

QA Tester

Responsibilities:
  • Writing test plans and test scripts and complex SQL queries.
  • Performed Requirement Traceability Matrix (RTM).
  • Involved in functional, system, integration and performance testing.
  • Recorded Testable and Non Testable requirements in spreadsheet.
  • High Level Test Case Design and writing detailed test cases
  • Involved in extensive DATA validation using SQL queries and back-end testing.
  • Involved in functional, system, integration and performance testing.
  • Assigned defects to developers through Test Director.
  • Updated defect status in Test Director.
  • Involved in extensive data validation using SQL queries and back-end testing.
  • Reported periodic project status and updates to the QA Lead and QA Manager.
  • Involved in interacting with UNIX Shell scripts.
  • Wrote the test scripts with respect to test cases to fix defects.
  • Recorded Testable and Non Testable requirements in spreadsheet.
  • Assisted in High Level Test Case design and writing detailed test cases.
  • Used DDL, DML commands for testing backend database validations.
  • Used Test Director for developing test cases.
  • Used Toad for Oracle for querying Oracle database tables.
  • Updated the defects status in Test Director.
  • Reported periodic project status and updates to the QA Lead and QA Manager.

Environment: SQL, Oracle 8i, Test Director 8.0, MS Office, UNIX, Putty

Confidential

Manual tester

Responsibilities:

  • egression testing upon the change control request feedback from clients.
  • Reviewed and Analyzed the System Requirement Specs (SRS) and design documents.
  • Analyzed the business requirements and wrote a Test Strategy and Test Plan.
  • Was involved in the complete Software Development Life Cycle (SDLC)
  • Created Test plans, Test Cases in Test Director as per the business requirements and executed them.
  • Involved in writing and implementation of the various test cases and test scripts created for Functional testing using Win Runner.
  • Involved in testing GUI applications in client/server system
  • Test results and bugs are reported to the development team.
  • Involved in System testing and Performance testing
  • Interacted with developers, Business & Management Teams and End Users
  • Interacted with programmers to identify and resolve technical issues
  • Conducted integration, functional, Validation, Regression testing.
  • Extensively worked on Test Director for bug reporting/tracking.
  • Conducted R

Environment: JAVA, J2EE, Oracle, SQL, UNIX, Windows, Toad, Test Director, Manual Testing

Hire Now