We provide IT Staff Augmentation Services!

Etl/system Test Lead Resume

3.00/5 (Submit Your Rating)

Mclean, VA

PROFESSIONAL SUMMARY:

  • Over 9 years of diverse IT experience in Quality Assurance and Testing.
  • Extensively wrote SQL for Back end testing ETL related complex business processes on UNIX batch applications and interfaces.
  • Expertise in Informatica work flow execution and validation.
  • Excellent understanding of the SDLC, its constituent Activities & steps, Models & the supporting Disciplines.
  • Extensive experience in all steps of STLC; performed Requirements Analysis, Test Preparation, Test Execution, UAT, Defect Management and Reporting.
  • Thorough hands on experience with all levels of testing namely Smoke, Sanity, Integration, Interface, Functional, End to End, Regression, Backend and Front - end testing,
  • Prepared and maintained RTMs, FRMs and PR reports to ensure comprehensive test coverage of requirements.
  • Expertise in Path Analysis &Data Flow Analysis and writing test cases from the basic, alternate, and exceptional flows of the Use cases.
  • Extensive experience in both Manual and Automated testing using QTP, WinRunner, Quality Center/Test Director and Clear Quest.
  • Extensive experience in tracking bugs using Bug tracking tools such as Test Director/ Quality Centre, Remedy and Clear Quest.
  • Coordinated and prioritized outstanding defects and enhancement based on business requirements, allowing sufficient time frame to ensure accuracy.
  • Performed Gap Analysis through interactions with both the client and the technical team to ensure key financial and business data is managed and delivered in line with the business requirements.
  • Ability to multitask, flexible in adjusting to people, hard working with a realistic attitude, good interpersonal skills and a team player.

TECHNICAL SKILLS:

ETL Tool: Informatica PowerCenter 9x/8x, Data Stage

Database: Oracle 11g/10g/9i, SQL Server 2008, DB2 UDB 7.2, My SQL 5.0/4.1, MS-Access.Editors (SQL Navigator, Toad), Teradata 13/12/V2R5

Testing Tools: SQL Data Compare, Toad data compare, MS-Excel, QTP, SOAPUI

Tracking & Version: HP Quality Center, Clear Quest, Remedy, VSS, Doors, Clearcase

Data Modeling: ERWIN 7.1, Visio

Reporting Tools: Tableau, Microstrategy, OBIEE 10g, Business Objects XI MS-Excel

Operating Systems: Windows (9x, 2000NT, 2000, XP, 2003), AIX, HP UX 9000, Linux, UNIX

Languages: TSL, C/C++, Visual Basic 6, SQL, PL/SQL, Bourne Shell, Java,J2EE, HTML

Web Tech: HTML/DHTML, VB Script, J2EE, XML, Java Script, WML, CSS,XSLT, ASP, JSP

Web/Appl. Server: SOA, SAP Web AS, Web Logic Application Server, Tomcat 5.0 Web, Web Server, Microsoft IIS Web Server

EXPERIENCE:

Confidential, MD

ETL/System Test Lead

Responsibilities:

  • Created and presented the over all Test Strategy and Test Process for Confidential testing to the team and higher management.
  • Analyzed business/solution requirement document for both ETL and BI.
  • Set-up functionality walk-through workshops with business analysts and developers.
  • Reviewed the mapping documents for STAR Schemas and Conformed Dimensions to create complex Informatica ETLs, SQL Views, Procedures, Tables and Synonyms for the test framework
  • Thoroughly conducted data analysis and gap analysis between source systems for Confidential model.
  • Created combined ETL and BI test plan and test strategy document for entire Confidential and CSPMI projects.
  • Provided testing Level of Effort (LOE) for all releases for Confidential and CSPMI projects.
  • Implemented the test process and test framework along with team members for Confidential
  • Designed and developed the Test Suite in the HP Quality Center
  • Created the Defect Management process using HP QC and provided to the entire team.
  • Distributed work among team members to create test cases and execute them in Quality Center
  • Wrote intuitive test cases and scenarios for functional, usability, browser compatibility, data, and regression testing in Quality Center
  • Responsible for work allocation, monitoring test team and their activities
  • Created complex SQL scripts to test the transformation logic from source database to target database as part for ETL
  • Develop and execute test strategies for ETL testing in complex, high volume data warehousing projects
  • Written SQL queries for checking the Data Transactions and Database Integrity in Oracle and SQL Server. Also developed SQL scripts to run complex data integrity test cases and to extract data from the tables.
  • Wrote complex SQL on Oracle, SQL server and DB2 databases to test ETL
  • Executed workflows in Informatica to migrate the data from source to target
  • Monitored workflows in Informatica and send out success/failure email notification to entire team for daily, weekly and monthly loads for different subject areas.
  • Updated schedules and added business users for various reports in production using BO info view.
  • Monitored BI reports in production every morning and sent out success/failure email notification to business.
  • Worked with developers in De-bugging the issues for workflows failures by analyzing the data and logs.
  • Performed smoke testing, functional testing, Back end Testing, Front end Testing, Integration testing, End to End testing, regression testing, positive and negative testing
  • Worked with Business Intelligence team to coordinate integration between BO universe and Confidential
  • Opened all defects according to their severity for every test cycle inHP Quality Center
  • Attended daily defect review meeting
  • Created user document for business users
  • Participated in UAT with business users
  • Created test scripts and test cases for business users to execute as part of user acceptance testing (UAT)

Environment: Oracle 11G, SQL Server 2008, DB2, Unix, Dot Net 2.0, Csharp, VB Dotnet, Java, J2EE, Mercury Quality center 10.0, Door, Clear case, BO Info View, Pl/SQL, Toad 10.6, SQL server management studio, Informatica 8.6.1, Business Objects

Confidential, Cranston, RI

ETL Tester

Responsibilities:

  • Initiated the Test Activity Planning and Test Resource Management on the project.
  • Created Test Plan and Test Strategy documents for the project.
  • Worked with the SMEs of various source systems to understand the project requirements.
  • Involved in the creation of use cases and verifying them with the project team.
  • Worked with the onsite and offshore testing teams to identify gaps and resolve them to closure.
  • Responsible for designing test scenarios for the project based on the requirements and use cases.
  • Involved in base lining Test Scenarios, Test Cases and Test Scripts.
  • Responsible for maintaining Test Reports and Defect Metrics.
  • Developed and validated SQL scripts for both ETL and DataMart testing.
  • Conducted peer reviews with the offshore testing team to finalize the test cases, test scripts for ETL and Cube validations.
  • Conducted sessions with the Development team to verify any additional testing scenarios required based on the ETL specs.
  • Responsible for creating projects in Quality Center / ALM and maintaining project folders and structures.
  • Used Quality Center/ ALM to load the test cases, track execution against the plan during the testing phase.
  • Responsible for tracking defects in QC / ALM from validating the defect, assigning the defects to the development team and closing the defect after successful retesting.
  • Verified Test cases scripts based on the functional specifications and maintained traceability with the requirements.
  • Validated SSIS reports after ETL and Cube deployments to make sure the values in the database tie out to the reports.
  • Responsible for maintaining repository for testing activities for future use.
  • Interact with the users to walk them through the functionality of the reports that they request before UAT.
  • Conduct war room sessions with the users for UAT.
  • Co-ordinate the UAT efforts between the Business and Development teams for efficient defect tracking and closure.
  • Conducted daily status calls during IT and UAT for test execution and defect tracking.
  • Responsible for maintaining the QA SharePoint for projects.
  • Conducted knowledge transfer sessions for new hires and get them to speed on the projects.
  • Communicate testing activities to the project teams and high-level management on a daily basis including the test execution progress, defect summary and burn down charts.
  • Responsible for setting up databases for the QA environment and working with DBA’s to assign proper privileges for the testing team for testing.
  • Facilitate meetings with the business and source owners to mitigate risks and resolve issues.
  • Organize daily triage calls with the testing team and the development teams to facilitate progress review, defect discussion and issue resolutions.
  • Attended daily status meetings for Data quality issues and also technical review meetings.
  • Schedule UAT readiness meetings and Production readiness meeting to mitigate issues and outline defect deferral process to facilitate progress.

Environment: Data Stage 8.5 / 9.1, Teradata, SQL Server, MDM, Informix, Flat Files, XML Files, SAS, Teradata SQL Assistant, TOAD, SQL, PL/SQL, HP Application Lifecycle Management (ALM),QTP, UNIX, Microsoft Office Suite 2010, Windows 7, MS Outlook.

Confidential, McLean, VA

ETL Tester

Responsibilities:

  • Worked as a System Analyst and a Data warehouse/ ETL tester.
  • Worked with the business teams to understand and interpret the project requirements.
  • Involved in writing Test Plan and Test Strategy for the project and getting signoffs from the relevant project members.
  • Monitored the Test Scenario Creation, assisted in the Test Case and Test Script development.
  • Developed SQL scripts and used Rapid Sql query tool to run the SQL scripts from Sybase and SQL Server databases.
  • Monitored the activities in Quality Center including executing the test cases, track execution against the plan during testing and managing defects from inception to resolution.
  • Created Test cases scripts from the functional specifications and maintained traceability with the requirements.
  • Created SQL queries to fetch data and validate application against the database
  • Performed functional, performance, regression and black-box testing on the payment and billing applications.
  • Creating the test batch data file by FTP thru UNIX.
  • Created Test execution, Defect Metrics for daily status meetings
  • Validated XML files for the web services triggered by the Java based application(OUS).
  • Tested reports developed using Business Objects and Crystal Reports.
  • Tested web intelligence reports developed from BO Universe.
  • Verified the BO reports as per the UAT document.
  • Validated data between different web applications and documented the test results.
  • Communicate testing activities and findings in oral and written formats.
  • Ran Sql queries to check if the data is loaded correctly into the database for the backend testing.
  • Responsible for maintaining RTM in DOORS.
  • Trained end users on the new application and conducted knowledge transfer sessions on the project.
  • Attended daily status meetings for Data quality issues and technical review meetings.

Environment: Sybase, SQL Server, Teradata V2R6, Java, .Net, Informatica 8.6.1, BO XI 3.0, Embarcadero’s Rapid SQL, XML, Lotus Notes 7.1.1, Clear case, Clear quest, UNIX, MS Excel 2007, MS word 2007, Windows XP, Unix, Quality Center 9.2, QTP 10/9.5, SOAPUI, IBM DOORS.

Confidential

ETL Tester

Responsibilities:

  • Confidential - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios).
  • Used SQL and PL/SQL scripts to perform backend database testing.
  • Defects tracking, review, analyze and compare results using Quality Center.
  • Defined the Scope for System and Integration Testing
  • Prepares and submit the summarized audit reports and taking corrective actions
  • Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.
  • Created reports using SAS/ODS.
  • Performed integration testing of Hadoop into traditional ETL, extraction, transformation, and loading of massive structured and unstructured data
  • Analyzed the Functional requirements using Scenarios & DDD (Detailed Design Document)
  • Create and ran the Informatica workflows to load the data into QA environment.
  • Accessed to Informatica session log files to find the root causes for logical bugs
  • Extensively worked on Backend using SQL Queries to validate the data in the database
  • Involved in Test Scheduling and milestones with the dependencies
  • Used SAS Proc SQL to extract data from different relational database management (Teradata) systems, used SQL Assistant to analyze and query from the Teradata database.
  • Tested Analytical Data Mart (ADM) of Oracle system and Stored Procedures
  • Identified & presented effort estimations related to testing efforts to Project Management Team
  • Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
  • Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
  • Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
  • Generated the detailed reports of the Bugs, go no go reports and comparison charts.
  • Involved in Manual and Automated testing using QTP and Quality Center.
  • Tested slides for data flow and process flows using PowerPoint and Microsoft Visio
  • Backend testing of the DB by writing SQL queries and PL/SQL scripts to test the integrity of the application Hadoop and Oracle databases.
  • Used AL utilities including Fast Load, Multi Load, Fast Export, SQL Assistant, BTEQ & TPUMP
  • Using Import Wizard deploying the reports from Dev system to QA box.
  • Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
  • Tested ad hoc and canned reports for Business objects.
  • Tested reports for various portfolios using universe as the main data provider.
  • Tested reports using Business Objects functionality like Queries, Slice and Dice, Drill down, @Functions, Formulae etc.
  • Used T-SQL for Querying the SQL Server2008 database for data validation and data conditioning.
  • Tested graphical representation of reports such as Bar charts, Pie charts as per End user requirements.
  • Worked with SSIS system variable, passing variables between packages.
  • Tested Desktop Intelligence and Web Intelligence reports.
  • Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
  • Check the naming standards, data integrity and referential integrity.
  • Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: Informatica, QTP, SQL Server, Quality Center, SAS, Business Objects, Hadoop, Oracle, XML, XSLT, XML Spy, SQL, PL/SQL, Stored Procedures, Shell Scripting, XPath, OLAP, MVS, Teradata

We'd love your feedback!