We provide IT Staff Augmentation Services!

Etl Test Lead Resume

NJ

SUMMARY:

  • Experience QA software test engineer, with full system development lifecycle experience, including designing, developing and implementing test plans, test cases and test processes, significant cost savings and fault - free audits.
  • Qualifications include 8+ years of QA software testing experience and 5+ years of user-acceptance testing experience.
  • Backed by strong credentials including a computer science degree and command of various testing suites, agile methodologies and monitoring tools, ETL Testing. Vast experience in healthcare and telecommunication industry and cross-platform skills in Windows, Linux and UNIX.
  • Over 8+ years of experience in manual testing on web based, Client/Server and data warehousing applications.
  • Well-versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
  • Professional experience in Integration, Functional, Regression, System Testing, Load Testing, UAT Testing, Black Box and GUI testing.
  • Experience in Web based applications like online banking, transactions applications.
  • Experience in SQL and PL/SQL scripting
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica and IBM DataStage.
  • Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
  • Tested the ETL Informatica and IBM DataStage mappings and other ETL Processes (Data Warehouse Testing)
  • Experience in creating Test Readiness Review (TRR), Requirement Traceability Matrix (RTM) documents.
  • Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
  • Technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modelling for OLAP and star and snow fleck schema and ER modeling.
  • Strong working experience in the Data Analysis, Data Verification and Validation of an ETL Applications using Backend/Database Testing
  • Experience in Automation using Mercury Interactive Tools such as Win Runner, QTP, Load Runner and Test Director.
  • Experience in using Bugzilla, Test Director and HP Quality Center, DDTS, Clear Case for Bug Tracking and Defect Reporting.
  • Experience in working with Software Development team in resolving Defects, presenting the Defect Status reports, resolving requirement, and observed design inconsistencies.
  • Expertise in querying and testing RDBMS such as Oracle, MS SQL Sever using SQL, PL/SQL for data integrity.
  • Experience in Reports/GUI testing in Crystal Reports XI Environment.
  • Clear understanding of business procedures and ability to work as an individual and as a part of a team.
  • Experience in mentoring and leading the Test Team
  • Created complex SQL queries to test the Data Transformation and loading logic from source to Target tables.
  • Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
  • Leading or guiding offshore test team to write queries and to help them understand the scope of testing of the application under test.
  • Wrote various shell/Perl script to automate the test scenarios for regression and functional testing and to monitor the testing environment.
  • Automated regression and functional test cases using Jmeter, Conformic, Selenium.

TECHNICAL SKILLS:

ETL Tools: IBM DataStage 9x/8x, Informatica 9x, TWS

Tools: Selenium, Jira, Tableau, Business Object, Jmeter, IAf Framework

Programming Language: C, HTML, XML, PL/SQL, Perl scripting, shell scripting, Python, SOAP UI

Data Base: Oracle SQL developer, Microsoft SQL Management studio, Teradata, HP Vertica, Oracle, Big Data

Operating System: Windows 7, Vista, Windows XP / 2000 / 98 / UNIX, Linux

Protocols: TCP/IP, UDP, VOIP,IMS, EWD

Browsers: Internet Explorer, Fire fox, Netscape Navigator, Chrome

Source Control Tool: SCME, Clear Case, DDTS, HP Quality Centre, Bugzilla.

Data Modeling Tools: Erwin 3.5.2/4.0, Visio 2003

PROFESSIONAL EXPERIENCE:

Confidential, NJ

ETL Test Lead

Roles & Responsibilities:

  • Created test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
  • Analyzed requirements and creating and executing test cases
  • Created ETL process testing using Informatica ETL tool.
  • Executed Test Case and Adhoc testing
  • Performed Integration, End-to-End, system testing
  • Executed Functional Testing & Regression Testing
  • Developed Automated Test Scripts to perform Functional Testing, Performance Testing, Integration Testing, Stress Testing, System Testing, User Acceptance Testing, Regression Testing and Volume testing.
  • Written SQL queries and Database Checkpoints to verify data quality and calculations, reviews
  • Performed data validation testing writing SQL queries.
  • Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.
  • Used Teradata utilities (MLOAD & FLOAD) to load the source files in to test region. And did the querying on the same data.
  • Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
  • Used Quality Center for creating and documenting Test Plans and Test Cases and register the expected results
  • Associated testing processes, creating and implementing testing strategies in UAT phase.
  • Used HP Quality Center for storing, maintaining the test repository, bug tracking and reporting
  • Prepared documentation for some of the recurring defects and resolutions and business comments for those defects
  • Developed UNIX scripts to validate the flat files and to automate the manual test cases.
  • Developed Test Matrix to give a better view of testing effort.
  • Wrote and modified SQL validation scripts, and writing scripts in SQL to validate the outputs.
  • 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.
  • Created some macros in Teradata to load the test data in to Target tables.

Environment: IBM DataStage 8.7, Informatica 9x, TOAD, Teradata V2R6.0.1, DB2 V8.1, HP Vertica SQL Assistant, PL/SQL, Erwin 3.5.2, Tableau Business Object, UNIX, Linux, HP Quality Center,TWS, Selenium, PL/SQL and shell Script.

Confidential, India

Confidential, Middletown, NJ

ETL Tester

Roles & Responsibilities:

  • Extensively experienced with Telecommunication, Service Assurance, computer security applications and analysis of its business, technical, and functional requirements.
  • Created Test Cases, Test Plan and developed Tractability Matrix and Test Coverage reports.
  • Analyzing System & Functional Specifications, creating Use Cases, understanding Business Requirements, Business Rule and identifying Test Requirements.
  • Manage Defect life cycle using defect tracking tools such as HP ALM/Quality Center/Test Director by identifying, analyzing defects.
  • Experienced in Black box testing like Acceptance UAT, Sanity, Functional, Integration, Regression, Data Validation, System testing
  • Verifying and validating GUI reports.
  • Monitor production environment, support production/live deployment
  • Verify the data received from LABS is successfully processed and sent down to downstream systems for generating alerts
  • Verify that data is transformed correctly according to various business requirements and rules.
  • Make sure that all projected data is loaded into the data warehouse without any data loss and truncation.
  • Make sure that data is loaded in data warehouse within prescribed and expected time frames to confirm improved performance and scalability.
  • Experienced in designing and developing automated test scripts using perl/shell script.
  • Internal audit of System Test document to ensure the document are in compliance with the process
  • Automating test cases using selenium
  • Analyzing test cases written by the team members and providing technical details and input on the same.
  • Reviewing test results, and doing spot checking to assure 100% efficiency and coverage in testing the application
  • Verifying the CDR data generated by LABs is as per the design specification
  • Verify the CDR data received by LABS is forwarded to ETL, for processing and loading in Database.
  • Possessed high technical aptitude and high level of analytical ability.
  • Good Leadership and team building qualities with excellent verbal and written communication, analytical, interpersonal and presentation skills.
  • Created LAB request data forms and attending various meetings with the LAB team in regard to the data that is required from the LAB team for carrying out test execution

Environment: IBM DataStage 7.5, Oracle 9.0.2, TOAD, Teradata V2R5, DB2 V8.1, Teradata SQL Assistant, SQL, PL/SQL, UNIX, Clear Quest, TWS

Confidential

Senior Test Engineer

Roles & Responsibilities:

  • Responsible for leading QA team on various projects.
  • Installing various flavors of Linux, and also creating images of several flavors of Linux OS
  • Testing involved testing Softswitch on Linux/Unix operating system for functional, Maintenance/Regression testing, browser compatibility testing, software upgrade/downgrade testing.
  • Created and reviewed Detailed Functional Requirements (DFR) to understand the business requirements and enhancements requested by the client.
  • Documented Test plans and Test cases based on the solution definition documents and use case documents.
  • Exported Requirement Traceability Matrix (RTM) into HP Quality Center.
  • Analyzed modules and designed Test scenarios and Test scripts in UNIX environment.
  • Interacted with Business Analyst and developers for bug review using ALM/Quality Center.
  • Interacted with development Teams for timely closure of bugs reported & in meeting the requirement specification using ALM/Quality Center.
  • Tracked and monitored defects using ALM/Quality Center.
  • Worked with development members on bug reproduction and fixes; and updated management on testing results, activities and planning using ALM/Quality Center.
  • Created Regression suite for various test scenarios; Tested and executed the suite whenever a code was changed using Perl scripting
  • Participated in bug review meetings on behalf of the QA team.
  • Involved in implementation and documentation of standard procedures for setting up and configuration of the test.
  • Attended weekly meetings on project status.

Environment: Team Track, Linux, Shell scripting, Perl Scripting, postgresql, DSL, TR-069, Clearcase

Confidential

Test Engineer

Roles & Responsibilities:

  • Participate in Requirement Analysis document review, to understand business needs and to develop efficient test Strategy.
  • Participated in reviewing the Test Plans and Test Case Templates for the functional testing.
  • Involved in writing the high level and detailed Test cases for Functional and Regression testing.
  • Tracked and documented the defects in Team Track and reported the defects to the developers through Quality Center.
  • Involved in Functional, Integration, Regression, System and User Acceptance testing of the application.
  • Responsible for preparing and sending the deliverables like weekly status reports to the QA managers and project lead.
  • Attended review meetings and walkthroughs to discuss the status of the project.
  • Involved in going through System Requirement specification, writing and executing test cases, raising and verifying defects using the tool team track and, documenting the test status report.
  • Actively participated in technical discussions with the team.
  • Actively took part in discussion with the developers through teleconference/email for any technical queries/suggestions related to project.
  • Configuring router/devices for testing purpose

Environment: Environment: Bugzilla, Linux, Shell scripting, Perl Scripting, C, Unix Internals, VOIP

Hire Now