We provide IT Staff Augmentation Services!

Etl Test Analyst Resume

Charlotte, NC

SUMMARY:

  • 9 years of testing experience in various domains as Test Analyst and Lead.
  • In - Depth knowledge on various Testing Methodologies and Test Management.
  • Through experience in Test Planning and Strategizing involving all phases of testing life Cycle
  • Experience in testing application from various domains like Banking, Retail and Insurance.
  • Extensive Working knowledge in tools like HP Quality Center, Teradata SQL Assistant,Netezza, Toad SQL Server, Version One, SQL Server management studio 2012, IBM Metadata Workbench tool, Rapid SQL, Microstrategy, Beyond Compare, Confidential, IBM Metacenter.
  • Ability to quickly master new concepts and capable of working in-group as well as independently.
  • Excellent communication, analytical, inter-personal and presentation skills.
  • Good experience in mentoring offshore and onshore team members as a lead and coordinator.
  • Extensive experience in manual testing ETL.
  • Experience in developing the Manual Test Suites.
  • Wrote extensive SQL scripts to test the ETL flow, Data migration and Change Data Capture.
  • Experience in basic UNIX Commands PUTTY Environment.
  • Experienced in kicking off ETL jobs and validating using Confidential, UNIX,Netezza and Teradata.
  • Worked on Waterfall and Agile methodologies.

TECHNICAL SKILLS:

Business Intelligence Tools: MicroStrategy

Programming Languages: SQL, UNIX

Databases: Teradata, TOAD for SQL server, Rapid SQL, Netezza, SQL Server Management

Testing/Bug Tracking Tools: HP Quality Center, ZEPHYR on JIRA, Excel

Others: Confidential, Beyond Compare, IBM Metadata workbench tool, IBM Metacenter, Jira, Version One, MS Office, Version One

O/S: Windows XP/Vista/2007

PROFESSIONAL EXPERIENCE:

BI QA

Confidential,Charlotte,NC

Responsibilities:
  • Business Requirements Analysis, Test case preparation & Execution for data analysis,functional testing,Front end testing, Uploading & running test scripts in Quality Center/Zephyr, Defect Reporting .
  • Validating the data between database and microstrategy datasets.
  • Functional and format testing of dashboards against requirements.
  • Attending daily stand up meetings with developers, architects.
  • Attending Sprint Planning meetings and all other Scrum ceremonies.
  • Writing SQL queries and executing them using Teradata, Results validation at the database and microstrategy report levels.
  • Creating and Updating sub-tasks in JIRA and linking them to testcases in Zephyr.

ETL Test Analyst

Confidential,Charlotte, NC

Responsibilities:

  • Business Requirements Analysis, Test Scenario Preparation, Test Plan Preparation, Test case preparation & Execution for data analysis, Uploading & running test scripts in Quality Center, Defect Reporting and follow-up until closure, Status reporting.
  • Validating the data between database and cubes using the data flow.
  • Validating data based on the transformation logic and mapping documents and ensuring the correctness of the data flow.
  • Attending daily status update calls or scrum meetings with Business Analysts and IT Project Manager.
  • Writing SQL queries and executing them using SQL Server Management, Results validation at the database and Cube levels.

Technologies Used:SQL Server Management, Teradata, Ms Excel, Quality Center, Version One

ETL Test Analyst/Lead

Confidential,Charlotte, NC

Responsibilities:

  • Requirement analysis, test planning, preparation and review of test cases, performing functional testing, defect analysis and reporting, preparation of test completion reports and coordinate User acceptance testing support.
  • As a Lead, was involved in weekly status or daily hand off calls, following up the offshore/Onsite Testing teams.
  • Supervising the QA team in accomplishing their tasks as per the deadlines.
  • Conducted Training & Knowledge Transfer Sessions on new/existing applications to fresher’s joining the team.
  • Interaction with Client and Offshore team members on daily basis.
  • Creating SQL queries and executing them in Netezza and Teradata, Results validation at the database levels.
  • Execute Confidential Jobs,monitor data flow and logs from Linux Server and validate the data using SQL.
  • Evaluation of critical problems/issues during testing and reporting them in Quality Center.
  • Preparation of various test documents for ETL process in Quality Center.
  • Report job failures and reason for job failures and fixing it or communicating to developers to fix it.
  • Created detailed testing results for the Disaster recovery exercise.
  • Updating JIRA on a daily basis based on the tasks completion or status.
  • Development of testcase sets for the development team to meet the pre requisites before the actual load.
  • Creating run book and lessons learnt document for the end to end run to reduce the run time for offshore and other team members.
  • Major role in developing automation tool for comparing data between 3 environments.
  • Compared UAT vs. PROD data to verify that is identical.
  • Checking the status of ETL jobs in UNIX/ Confidential .
  • Interacting with senior peers or subject matter experts to learn more about the data.

Technologies Used:Quality Center,Netezza,Teradata, TOAD SQL Server,MS Excel, MS Excel Macros

Confidential

Responsibilities:

  • Business Requirements Analysis, Test Scenario Preparation, Test case preparation & Execution for data analysis, Uploading & running test scripts in Quality Center, Defect Reporting and follow-up until closure, Status reporting.
  • Validating the data between databases using the data flow.
  • Validating data based on the transformation logic and mapping documents and ensuring the correctness of the data flow.
  • Analyzed theMeta Center tool and reported defects or improvements for better performance of the tool.
  • Writing SQL queries and executing them using Netezza, Results validation at the database levels.

Technologies Used:IBM Metacenter,Ms Excel, Quality Center,Netezza,Teradata, TOAD SQL Server.

Test Analyst

Confidential,San Antonio, TX

Responsibilities:

  • Analysis of business requirements.
  • Scope discussion with the Business Analysts and IT Project Manager.
  • Daily Scrum meetings for SPRINT updates.
  • Preparation, review & submission of estimates & scheduling.
  • Project planning.
  • Preparation, review & submission of test plan document.
  • Interacting with business users for issue clarifications.
  • Preparation and Review of test cases.
  • Defect Management.
  • Attending daily status update calls with Business Analysts and IT Project Manager.
  • Creating SQLs with various joins and time frames for Performance testing for checking retrieval time of data.
  • Data quality testing between the dashboard table and actual table.
  • Created Complex SQL involving number of tables to get the required result and testing the data.
  • Created Micro strategy reports of the shareholders for the business users.

Technologies Used:Rapid SQL, Micro Strategy,Quality Center,Agile, MS Excel

Hire Now