We provide IT Staff Augmentation Services!

Etl/dw/bi Qa Lead Resume

New York, NY

SUMMARY

  • 10+ years of experience in the IT industry as ETL - DW-BI QA Test Lead/ETL Test Automation QA / Quality Assurance Tester
  • 10 years’ experience in Software Quality in ETL, DW, BI testing and ETL Testing Automation in DWH projects
  • 10 years’ experience in defect tracking and management tools like JIRA, TFS, ALM and Quality Center
  • 2 years’ experience in working in Agile environment
  • 8 years’ experience in database testing using SQL queries in Oracle, MS SQL Server, Cassandra
  • 4 years’ experience in ETL testing automation using Saturn (in-built) tool for Confidential
  • 1-year experience in Python for creating automated scripts for file comparisons
  • 6 years’ experience of managing offshore teams
  • 5 years’ experience of leading the team and managing resources on aggressive and ever-changing time schedule.
  • Expertise in defining Test Scenarios and developing Test Cases, analyzing bugs, coordinating with development team and track the bug fixes till closure
  • Expertise in designing and executing test cases for Regression and Integration Testing
  • Experience in Test Estimation based on functional requirements.
  • Understanding of the entire Software Development Lifecycle (SDLC)
  • Involved in the entire software test lifecycle - monitoring and improving the QA process, and making sure that any agreed-upon standards and procedures are followed.
  • Provided guidance on process improvements and optimization to the team members.
  • Involved in created automated Status reports using ALM

TECHNICAL SKILLS

ETL Tools: Informatica, Data Stage

BI tools: Microstrategy, Business Objects, Cognos, Actuate, Telerik

Databases: SQL SERVER 2012, Oracle 10g, Sybase, DB2, Teradata

Test Management tools: JIRA, HP Quality Center, TFS, ALM

Defect Tracking Tools: ALM, HP Quality Center, TFS

Operating Systems: Windows, Unix, Python

Project Methodologies: Agile-Scrum, Waterfall

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

ETL/DW/BI QA Lead

Responsibilities:

  • Validating the Data Vault process and the existing Data flow from the multiple source systems into the Data Warehouse
  • Validating the Legacy reports migration to the new Microstrategy reports by verifying the data completeness
  • Created the comparison scripts for comparison the reports using python
  • User story, Sub-tasks, test case and defect management in JIRA
  • Documentation management in SharePoint
  • Involved in creating the Test plan and Test approach for the project
  • Actively participated in Daily Standup meeting, Sprint Planning meeting, Sprint Review meeting and Retrospective meeting
  • Client Weekly Meetings to discuss the on-going testing status and to update the roadblocks.
  • Report test status and results to stakeholders, collect metrics around test effectiveness and user stories/test cases execution.
  • Work closely with management teams, development teams, business teams and other partner teams
  • Define and manage quality assurance processes such as error/problem identify, root cause analysis, risk management, complexity analysis
  • Expert in writing SQL queries through Oracle SQL Developer, SQL Server, Sybase

Environment: Oracle, SQL Server, Actuate, Cognos, Microstrategy, JIRA

Confidential, New York, NY

ETL QA Lead

Responsibilities:

  • Created the Test Approach, Test plans, Test Estimations for the various projects in HRDW.
  • Support the Project Stakeholders and involve in meetings.
  • Knowledge sharing and status updates with offshore team members.
  • Review the Test scenarios, Test cases and execution results done by the offshore team.
  • Involved in preparing Test Automation for Regression Suite and Data reconciliation using the Saturn tool
  • Involved in Test Data preparation to be entered in Workday
  • Worked in Data governance using Collabera on collecting the data of HRDW system and verified the workflow process on the creation and approvals
  • Involved in verifying the performance testing of the existing Informatica jobs
  • User story, Sub-tasks, test case and defect management in JIRA
  • Documentation management in SharePoint

Environment: Sybase, Workday, Business Objects, Unix putty, Collabera, Informatica

Confidential

ETL QA Lead

Responsibilities:

  • Created the Test Approach, Test plans for the various projects in HRDW.
  • Involved in preparing Test Automation for Regression Suite and Data reconciliation using the Saturn tool
  • Involved in Test Data preparation to be entered in Workday
  • Work with the offshore team members on the task tracking etc.
  • User story, Sub-tasks, test case and defect management in JIRA
  • Documentation management in Sharepoint

Environment: Sybase, Workday, Business Objects, Unix putty, Collabera, Informatica

Hire Now