OBJECTIVE

• Seeking ETL Test Lead/Test Planner position in a professional environment, constantly learn new technologies and help the organization achieve its goals.

SUMMARY

• Over 10+ years of experience as ETL Test planner and participated in all SDLC/QA phases.
• Over 5+ years of experience as Mainframe Test Lead and participated in all SDLC/QA phases..
• Hands on experience with Informatica PowerCenter Data Validation Option (DVO).
• Hands on experience with Shell Scripts, VI Editor, AWK, SED, SQL and PL/SQL.
• Hands on experience with MicroStrategy dashboard and reports testing.
• Hands on experience with COBOL, JCL, REXX and FOCUS.
• Worked on IMS DB, IMS DC, Oracle and DB2 Databases.
• Hands on experience with DFSORT, IDCAMS, Sync Sort utility/tools.
• Experience with .NET Frameworks, JAVA, C and C++.
• Operating system worked on: UNIX, LINUX, MVS, OS/390 and z/OS.
• Strong skills in Load/Stress/Regression/Integration/system Testing.

PROFESSIONAL EXPERIENCE

Confidential, Saint Louis MO

ETL Test Lead

Responsibilities:

• Prepared Test Plan, Test scenarios and Test Cases based on Business Requirement Document (BRD), Functional Specification Document (FSD) and Technical Design Document.
• Execute ETL jobs and validate data extraction.
• Worked with Business Analysts and analysed business requirements, system requirements, data mapping requirement specifications, FSD’S and TDD’s, transformation logic and business rules.
• Analyse complex SQL queries and create the test scenarios as a part of white box testing.
• Extensive involvement in validating inbound files, data mapping, data in staging tables and target tables to ensure data flows correctly through the ETL process.
• Validate several reports and attributes, metrics, prompts, filters, aggregations, conditions etc. defined in the report.
• Validate business rules & data in reports against backend to ensure data integrity.
• Extensively worked on Unix environment to run jobs, analyse log files and modify environment & setup files, shell scripts.
• Developed complex SQL Queries using TOAD for Data validations and tested PL/SQL Procedures, Triggers and Functions.
• Validate MicroStrategy dashboard and reports as per the requirements using the data fetched from database using SQL queries.
• Collaborated with DW team to understand the mapping document and the extract, transform rules and load ETL process data dictionaries, Metadata descriptions, file layouts and flow diagrams.
• Expertise in Using Quality Center for maintaining the Requirements, Test Plan, Test Cases, Test Lab, Defects and generated graphs and reports based on the user needs or test metrics.
• Actively participated in the daily testing calls and discuss issues with the development team.
• Identified defects during test executions, logged them into Quality centre’s Defect module for bug tracking and generated defect reports.
• Performed regression testing on every build to check if the defects identified in the previous release are corrected according to the business requirements.
• Generated Daily and weekly Status Reports to the team manager & participated in weekly status meeting with Project Manager, Business analyst and Development team.

Confidential, NYC, NY

ETL Test Lead

Responsibilities:

• Extensively involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from the assigned Business Analysts.
• Extensively used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL solution using ETL tools like Informatica
• Developed test scripts based upon business requirements and processes, in line with defined workflows and use cases. Tested functionality across applications and workflows.
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
• Performed data analysis and data profiling using SQL.
• Wrote Complex SQL queries to validate the standard reports, Dashboards and Business objects Universes.
• Extensively tested the extracting, transforming and loading databases from sources to target in Oracle, DB2 and Flat files.
• Collaborated with DW team to understand the mapping document and the extract, transform rules and load ETL process data dictionaries, Metadata descriptions, file layouts and flow diagrams.
• Tested various types of keys and slowly changing dimensions in star and snowflake schema.
• Tested Surrogate Keys for the dimensions and fact tables for indexing and faster access of data in Data Warehouse.
• Tested the extracted data from flat files and then transformed according to the requirement and Loaded into target tables using various stages like sequential file, Look up, Aggregator, Transformer, Join, Remove Duplicates, Change capture data, Sort, Column generators, Funnel and Oracle Enterprise.
• Extensively tested Change Data Capture for DB2 and Oracle files and employed change capture stage in parallel jobs.
• Tested Pre and Post session commands on Source and Target database using Shell scripting.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Collaborated with BI teams to kick off the data tests for reports affected by a change to the corporate data model.
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and documenting both immediate and long-term issues.

Confidential, Saint Louis MO

ETL Test Lead

Responsibilities:

• Assisted in preparing test plan, prepared test cases and test procedures using business requirements document (BRD) and functional requirements document of the system.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Written complex SQL statements for data reconciliation.
• Performed regression test after each and every code drop.
• Prioritized and reported defects using Quality Center, to present documents and reports in weekly team meetings.
• Performed End-to-End testing after bug fixes and modifications.
• Prepared detailed Test and Defect summary reports after completion of testing effort.
• Prepared QA sign off document before the application push into the production environment.

Confidential, Cincinnati OHIO

Mainframe Test Lead

Responsibilities:

• Review the Business Requirement Document (BRD) and discuss the understanding and ambiguities with the business team.
• Prepared test plan, test scenarios and test cases based on Business Requirement Document (BRD), Functional Specification Document (FSD) and Technical Design Document.
• Performed data analysis and data profiling using database queries.
• Prepare test scripts and set-up the test data for the functional and regression testing.
• Setup the environment for the testing, mock-up the data and run the jobs to perform the testing.
• Log the defects in the system and keep the track of it. Update the status of the defects till it is reviewed, retested and closed.
• Validate the test results with the team members and discuss it with business. Validate several reports and attributes, metrics, prompts, filters, conditions etc. defined in the business requirement.
• Generated Daily and weekly Status Reports to the team manager and business.
• Create the release document and pass it over to business for UAT and code deployment.
• Help business users during UAT execution and to analyse the issues and results.