We provide IT Staff Augmentation Services!

Etl Tester Resume

Naples, FL

Professional Summary:

  • Over 6 years of experience in Information Technology with emphasis on Software Testing/Quality Assurance.
  • Experience in using Quality Assurance for ETL, Backend, Web based, Client/Server Applications using Manual and Automated testing tools.
  • Good understanding of QA methodology and Software Development Life Cycle (SDLC).
  • Involved in analysis, design and quality assurance of Client/server and Web applications for Healthcare, Health Insurance, Banking, Retail and Gaming industries.
  • Extensive experience with testing Multi Tier application architecture.
  • Developed Test Plans, Test Scenarios, and Test cases, Test Scripts, Test reports and Test Metrics for Manual as well as Automated testing for various applications to ensure proper business compliance.
  • Diverse experience in Information Technology with emphasis on Quality Assurance, Manual Testing, Automated Testing.
  • Excellent knowledge in ETL validation, Data Model Validations.
  • Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
  • Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
  • Have good knowledge with Applications like Calyx point, PEGA, CALLIDUS etc.
  • Extensive experience in client/server and web application testing using System Testing, Functionality Testing (White & Black Box), Integration Testing, Regression Testing, Smoke Testing, GUI Testing, Data base Testing and User acceptance testing.
  • Experience in using Visual Source Safe and CVS.
  • Extensive experience with Data warehouse applications.
  • Strong experience in automating the test using QTP and modifying the script code using VB Script.
  • Strong knowledge in Automation tool QTP and Quality Center.
  • Experience in End to End testing with CMM and ISO standards.
  • Experience in BPT (Business Process Testing) using QTP.
  • Expertise in Problem solving and Bug Reports using Bug Tracking Tools.
  • Strong skills in backend (in both Relational & Hierarchical database) testing. Writing SQL queries, generating reports to ensure data integrity and validating business rules
  • Experience in working with Databases and using SQL, SQL Server and Oracle.
  • Good Knowledge in design/testing and implementation of stored procedures, triggers and functions at database level using PL/SQL.
  • Experience in testing Business Intelligence reports generated by various BI Tools like OBIEE, COGNOS and Business Objects.
  • Ability to handle multiple tasks and work independently as well as in a team.
  • Good team player with excellent written and verbal communication, interpersonal skills and ability to work independently and deliver on time.

Technical Skills:

Data warehousing Tools

Informatica, Business Objects, COGNOS, OBIEE

Testing Tools

Mercury Quality Center 10.0/9.0, Quick Test Pro 9.2/ 10.0, HP Quality Center, Load Runner

Languages

HTML, TSL, SQL, PL/SQL

Operating Systems

Windows 9x/2000/ NT/XP, DOS, UNIX

Methodologies

SDLC, Agile

Databases

Oracle 10g/9i, SQL Server 2008/2005, MS Access

Office Tools

MS Office (Word, Excel, PowerPoint), MS Project

GUI

C, C++, .NET, Java, JUNIT, J2EE, Java script, Visual Basics

Professional Experience:

Confidential,Naples, FL
ETL Tester

Responsibilities:

  • Developed Test Plans, Test Scenarios, Test Cases, Traceability Matrix, Test Summary Reports and Test Execution Metrics.
  • Developed and Executed the Test cases & Scripts for Functional, System, Regression, Integration, Performance and UAT.
  • Involved in writing Complex queries using SQL for Data Integrity checks.
  • Participation in Requirement / Use Case analysis, Risk analysis and configuration management.
  • Validating the data in various stages of data movement from Source to Staging and from Staging to Data Warehouse tables.
  • Created Test Cases using the SDLC procedures and reviewed them with the Test Manager.
  • Executed all the Test Cases in the Test Environment and maintained and documented the test queries and result for future references.
  • Retested the modifications, once bugs are fixed after reinstalling the application.
  • Generated Problem Reports for the defects found during execution of the Test Cases and reviewed them with the developers. Worked with Developers to identify and resolve problems.
  • Developed presentation and testing implementation learning to other testing resources for cross functional training.
  • Extensively tested the OBIEE report by running the SQL queries on the database by reviewing the report requirement documentation.
  • Validating the Data files from source to make sure correct data has been captured to be loaded to target tables
  • Validating the load process of ETL to make sure the target tables are populated according to the data mapping provided that satisfies the transformation rules.
  • Validating the Archive process to purge the data that meet the defined business rules.
  • Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in SQL Server.
  • Validate the SELL In, SELL Thru data models and validated the OBIEE reports with Oracle source systems Demantra and Fusion
  • Involved in Defect Review meetings with Business Core Team and Developed use case Analysis
  • Actively participated in project specification reviews, writing and maintaining QA technical documentation.
  • Identify/debug, troubleshoot, modify, document, test the production issues and create production support schedule.

Environment: Informatica, Oracle 11i/10g, Oracle SQL developer, SQL Server 2008, Toad 9.0, OBIEE and Windows XP.

Confidential, Atlanta, GA
DW Tester

Responsibilities:

  • Involved in leading and participating in the full software life cycle for testing (STLC) activities from test planning, test execution to test monitoring, status reporting, documentation and Business Objects report validation.
  • Reviewed requirements documented (mapping document/Report Specs) by Business Analyst for thorough understanding of the application.
  • Validating the data thru various stages of data movement from staging to Data Store to Data Warehouse tables.
  • Created Test Cases using the SDLC procedures and reviewed them with the Test lead.
  • Executed all the Test Cases in the Test Environment and maintained them and documenting the test queries and result for future references.
  • Validating the external data source by connecting thru Oracle heterogeneous services and joining them to existing tables and reporting the anomalies in the data.
  • Testing included Unit, System, Regression testing, Business Objects reports testing.
  • Provide flexible & high quality support to wider Testing strategies on key regular deliverables & ad hoc reporting issues.
  • 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
  • Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
  • Validating the Archive process to purge the data that meet the defined business rules.
  • ETL validation, Data Model Validation.
  • Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
  • Involved in validating the aggregate table based on the rollup process documented in the data mapping.
  • Retested the modifications, once bugs are fixed after reinstalling the application.
  • Developed automated scripts for functional and regression testing.
  • Reported the bugs through email notifications to developers using Quality Center.
  • Generated Problem Reports for the defects found during execution of the Test Cases and reviewed them with the Developers. Worked with Developers to identify and resolve problems.

Environment: Informatica, Business Objects, Mercury Quality Center 9.0, Java, HTML, XML,
Oracle 9i/10g, SQL Server 2005, MS Office2003.

Confidential, Chicago, IL

ETL Tester

Responsibilities:

  • Performed ETL test scenarios by writing SQL scripts with consideration of Business scenarios.
  • Exclusively worked with ETL team to analyze the source and Target Database systems
  • Exclusively worked on ETL test case scenarios with business functionality and generated the reports for business users.
  • Translating business requirements and technical specifications into test cases, test script.
  • Identifying the gaps between the requirements and use cases.
  • Creating and managing system testing schedule and executing the test cases against the functional specifications.
  • Created manual and automated tests by conducting functionality testing, regression testing.
  • Worked closely with the project team in planning, coordination and implementing QA methodology in Agile Environment.
  • Developed Test cases for different Loan scenarios (Conventional\\High balance\\Jumbo).
  • Executed test cases manually to verify the expected results, as well as using automation tool Quality Center and QTP.
  • Involved in preparation and enhancement of automated scripts for the identified automation scenarios using QTP.
  • Analyzed and helped in modifying the Use Cases and created the Test cases based on them.
  • Used Quality center to track, analyze and document defects.
  • Reporting and tracking defects using test management.
  • Involved in developing Entry & Exit criteria and defined the pass and fail standards.
  • Performed Positive & Negative Testing.
  • Participated in various meetings and discussed Enhancement and Modification Request issues (Change Requests).
  • Performed Functional, Smoke, Integration, and System testing of Data warehouse application.
  • Involved in Data testing by writing SQL queries in database tables to ensure UI result match the Database results.
  • Validated Source Target mappings applying various transformation rules and Business Rules.
  • Involved in testing various reports created using Cognos.
  • Effective co ordination between development team and testing team.

Environment: Quality Center10.0, QTP8.2, Informatica, Cognos, XML, SQL Server 2008/2005,

UNIX, Excel

Confidential, Glastonbury, CT

ETL Tester

Responsibilities:

  • Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
  • Performing manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
  • Analyzed application data using the SQL to identify the ETL processes
  • Modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
  • Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
  • Performing backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases.
  • Wrote and modified SQL validation scripts, and writing scripts in SQL to validate the outputs.
  • Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters to extract only the additional data added during that period.
  • Wrote complex queries to compare the counts and data from source to target.
  • Formulating the QA plan for black box testing of the application including Functional, Regression, Integration, Systems and User Acceptance Testing.
  • Performing database testing to verify backend database transactions.
  • Coordinating user acceptance testing activities for business groups and IT.
  • Involving in communication between UAT team members, business leaders, and IT.
  • Participates in application release planning and status sessions.
  • Used Agile testing methodology for achieving deadlines in UAT testing.
  • Working on conversion of manual tests into automated test scripts
  • Created, maintained and updated regression suites upon receiving new build.
  • Modifying and executing test scripts for web based environment using Quality Center.
  • Extensively used Load Runner for generating the automated test scripts.
  • Created and executed goal oriented and manual scenarios using Load Runner Controller.
  • Creating traceability relationship between requirements in the same module and also between different modules.
  • Extensively used Quality Center for documenting, organizing and tracking requirements.
  • Involving in formulating the test plan, procedures and Wrote test cases.

Environment: HP Quality Center, Informatica, Oracle10g, QTP, SQL, PL/SQL, SQL*Plus, Load Runner, UNIX

Confidential, acksonville, FL

ETL Tester

Responsibilities:

  • Involved in the testing of Data Marts using Power Center
  • Identified and Documented additional data cleansing needs and consistent error patterns that could diverted by modifying ETL code.
  • Tested Business Objects reports migration and created Business Objects reports for defect tracking.
  • Reports created in Business Objects were tested by running SQL statements.
  • Coordinated the test data, Business Objects environment and UAT of reports
  • Performed User Acceptance Testing and Regression Testing.
  • Participated in discussions with the business owners regarding rating test cases/results.
  • Wrote T SQL and PL/SQL scripts to validate the database systems and for backend database testing.
  • Wrote several UNIX scripts for invoking data reconciliation.
  • Created UNIX shell scripts for file transfer and file manipulation
  • Optimizing/Tuning several complex SQL queries for better performance and efficiency.
  • Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
  • Involved in functional testing the Web application using Quick Test Pro.
  • Processed a query to update a field in an Oracle database, to ensure that debt payments are allocated.
  • Performed User Acceptance Testing and Regression testing.
  • Involved in System Analysis, Design and Development of the OLAP application
  • Extensively used Informatica client tools to extract data stored in database and for testing purposes.

Environment: Informatica, Quick Test Pro, Unix Shell Scripting, Oracle, SQL server, Toad

Hire Now