We provide IT Staff Augmentation Services!

Etl Test Lead Resume

San Antonio, TX

SUMMARY:

  • Over 6 years of experience in the field of Quality Assurance in both Manual & Automation.
  • Strong expertise in all phases of software test management, Defining requirements, test planning process, test automation & execution, analyzing and reporting results, tracking and managing defects.
  • Extensive experience in ETL/ Data warehouse backend testing and BI reports testing knowledge of SOAPUI,REST testing Experienced with functional web services tests Skilled with creating automated web services testing processes.
  • Executed Test Script in SoapUI for all the existing web services at the end of each Sprint to ensure all the previous functionalities are intact.
  • Hands - on experience on Selenium Automation Tool.
  • Involved in Automation Environment setup using Eclipse, Java, Selenium WebDriver jars and TestNG.
  • Designed Test cases using Selenium WebDriver and TestNG.Enhancing the Selenium Test cases for Cross Browser Testing.
  • Extensive experience in Analyzing the Source to Confidential Mapping Document.
  • Extensive experience in writing ETL Test Scenarios, Test Cases based on Source to Confidential Mapping Documents.
  • Extensive knowledge in writing SQL queries based on the transformation logic present in Source to Confidential mapping document to compare the Source data with that of Confidential data to make the data accurate.
  • Perform various types of Data validations include Null Check, Duplicate Check,Type check, Referential Integrity Check.
  • Developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.
  • Good knowledge in Shell Scripting, Written several UNIX scripts for invoking data reconciliation.
  • Expertise in problem solving and bug reporting using Defect tracking tools like Mercury Quality Center, ALM,JIRA
  • Knowledge of QTP for System, Functional, Integration and Regression testing
  • Experience in SDLC like Agile, waterfall methodologies.
  • Flexible and versatile to adapt to any environment and work on any project

TECHNICAL SKILLS:

Testing Software: ETL,SoapUI,REST AP,QualityCenter(QC),Selenium,Control-M

Programming Languages: SQL, PL/SQL,Java,J2EE

Operating ystems: Windows 9x/2000/XP/NT, MS-DOS and UNIX, LINUX

ETL Tools: Informatica 9/8.6/7.1.1, Data Stage 11.5, Transaction testing (front end to back end testing), Data Mapping/ Data Conversion JIRA, HP ALM,qTest

Requirements management: Microsoft Excel, XML

Databases: Oracle8i/9i/10g/11g, SQL Server 2000, My SQL, MS-Access, DB2 8.1, Java, Tara Data and TOAD

MS-Suite Domain : MS-Word, MS Excel, MS-Project, MS Outlook, Automobile Insurance,Banking,Retail.

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio,TX

ETL Test Lead

Responsibilities:

  • As a QA lead I been worked on Workforce, P&C and Life Scenarios,CorpCard Applications.
  • Interacted with developers, Business & Management teams to understand the project business requirements and ETL design document specifications
  • Designed and Developed of QA documentation like Test Cases and Test scenarios from business and functional requirements.
  • Facilitate/Assist with daily/weekly meetings held by Testing Enablement to discuss status of testing and calendar activities.
  • Used Agile testing methodology for achieving deadlines in UAT testing.
  • Extensively used SQL Queries to verify and validate the Database updates.
  • Performed SQL validation to verify the data extracts and record counts in the database tables by writing SQL queries.
  • Tested the ETL Jobs from Source to Confidential using vb scripts in excel.
  • Written test cases for checking the populated data correctly into fact and dimension tables.
  • Validated for different Data mapping activities from Source systems to Reporting cubes.
  • Wrote and implemented manual automated test scripts for Warehouse decision support system using Smartview.
  • Coordinated with development team in system integration test and services level unit testing.
  • Exported Manually data to MS Excel template directly from Essbase and validated data using Smartview.
  • Worked on qtest Test Management Tool to create a centralize test management system for easy communication and rapid deployment of the task to QA teams and developers.
  • Worked on Control-M jobs to View, automate, and manage all batch workflows.
  • Participated on Java Utility automation dashboard to compare the data from source to seed

Confidential, WI

Web Services ETLTest Engineer

Responsibilities:

  • Created and executed both load and functional tests for web Applications.
  • Worked closely with the web development team to ensure quality deliverables.
  • Work on day to day issues and coordinate with development team as necessary.
  • Performed Black Box, Manual, Functional, Regression, Integration, System tests.
  • Manually tested End-to-End(E2E) applications.
  • Performed Functional, GUI testing, ETL testing, Data warehouse testing & web based application.
  • Conducted the Smoke Testing to check the High Level functionality of an application.
  • Responsible for performing Integration testing and ensure all services developed are well integrated according to the specifications.
  • Created the Automation Framework for the application to make sure the adequate coverage for the regression testing.
  • Performed SQL Server's data validation and database queries
  • Used Back-end database SQL Queries to perform data testing
  • Planned and executed Back-End testing using SQL Queries to verify the dataflow from the database.
  • Responsible for coordinating with offshore and ensure that deliverables are meeting service test team
  • Responsible for researching and improving quality testing productivity and effectiveness within the service testing domain
  • Build, execute, and maintain Integration test harnesses, tests scripts as assigned
  • Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads
  • Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data in the databases
  • Worked on issues with migration of Data from development to QA-Test Environment
  • Prepared daily status reports with details of executed, passed, and failed test cases and defect status
  • Ensure all testing artifacts are completed on time and in keeping with the quality standards and goals of the Quality Services organization
  • Collaborate in the definition and implementation of QA testing methodologies in all application areas. Collaborate in the definition and gathering of testing metrics.
  • Escalated Defects while studying Project Requirements and writing Test Cases by using SOAPUI and followed logged defects throughout its lifecycle in JIRA.
  • Provide testing estimations and metrics as required to team lead and Manager
  • Provide input to establishment/maintenance/improvement of methodologies, templates, process/procedure as appropriate
  • Performed Web Services and XML testing using SoapUI.
  • Retrieved the WSDL via WS discovery endpoint URL into SoapUI.
  • Tested the Web Service by giving input in WSDL and checked the responses per requirement document.
  • Executed Test Script in SoapUI for all the existing web services at the end of each Sprint to ensure all the previous functionalities are intact.

Environment: Informatica, SQL,Oracle,Java,SoapUI,Groovy Script, Windows 2008RC and Firefox, JIRA

Confidential, GA

Selenium Tester

Responsibilities:

  • Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
  • Extensively worked on power center tools like Designer, workflow monitor and workflow manager to monitor and schedule sessions and workflows.
  • Developed Test Cases for Application using JUnit Framework using Eclipse IDE.
  • Designed Test cases using Selenium WebDriver and TestNG.
  • Enhancing the Selenium Test cases for Cross Browser Testing.
  • Facilitate/Assist with daily/weekly meetings held by Testing Enablement to discuss status of testing and calendar activities.
  • Used ALM for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result
  • Performed SQL validation to verify the data extracts and record counts in the database tables by writing complex SQL minus queries.
  • Experience in manual testing which involves web-based application testing for provider and claims system.
  • Promoted Unix Informatica application releases from development to QA and to UAT environments
  • Used Agile testing methodology for achieving deadlines in UAT testing.
  • Tested the ETL mappings from Source to Confidential .
  • Written test cases for checking the populated data correctly into fact and dimension tables.
  • Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
  • Responsible for different Data mapping activities from Source systems to Teradata
  • Extensively used Informatica power center for extraction, transformation and loading process.
  • Wrote and implemented manual automated test scripts for Risk Warehouse decision support system using ALM.
  • Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the Confidential
  • Coordinated with development team in system integration test and services level unit testing.
  • Exported Manual Test Cases from MS Excel template directly to HP Quality Center and executed all the Test Cases in Quality Center with Pass/Fail/Blocked status.
  • Extensively worked with backend activities for testing several reports developed by BI tools. Written several complex SQL queries.
  • Extensively used SQL Queries to verify and validate the Database Updates.
  • Actively participated in creating requirements Traceability matrices and Test plans

Environment: Informatica, Java, PL/SQL, SQL, Selenium,Web Driver, XML, Windows 2008RC and Firefox, ALM

Confidential

ETL Tester

Responsibilities:

  • Involved in analyzing Source to Confidential Mapping Documents and development of ETL Test Scripts, Test Cases and executing & reviewing them.
  • Developed ETL Test Designs for different scenarios based on Source to Confidential mapping Documents.
  • Performed Data Validation includes Null Check, Type Check, Duplicate Check and Referential Integrity Check among the tables in order to make the data accurate.
  • Developed both positive and negative Test Cases for different functionalities.
  • Developed extraction mappings to load data from Source systems to ODS to Data Warehouse
  • Involved in developing the ETL data flows to move the data across Legacy, OLTP, Data ware house and Marts.
  • Extensively created mapping/ mapplets, reusable transformations using all the transformations like Joiner, Normalizer, lookup, filter, expression, stored procedure, aggregator, update strategy, worklets etc.
  • Executed Test scripts, analyzed the results and reported bugs in Quality Center.
  • Involved in maintaining and uploading the Test Scripts to Quality Center.
  • Performed User Acceptance testing in TEST and PROD environment.
  • Used SQL queries to run Comparison testing to compare data in database and data displayed on front-end.
  • Involved in Peer Reviews, Functional and Requirement Reviews.
  • Involved & prepared the test data creation.
  • Closely worked with Developers to resolve the issues faced during testing.
  • Participated in regular project status meetings related to testing.
  • Participated in Defect triage meetings to discuss about the defects.
  • Reporting and tracking the defects using Defect Tracking tools (HP Quality Center).
  • Accounts, Points and Rewards associated with the Customers and Clients doing cross browser testing.
  • Recorded and managed defects utilizing Quality Center.

Environment: Informatica, Oracle 10g, DB2, Mercury Quality Center, UAT, UNIX, SQL

Hire Now