We provide IT Staff Augmentation Services!

Sr.qa Analyst (etl Tester ) Resume

SUMMARY:

  • Over 9+ years of experience in Development and Quality Assurance in Information Technology.
  • Extensive experience in ETL/ Data warehouse/Database testing/Big Data Testing and BI Intelligence reports testing.
  • Strong Quality Assurance experience within Agile environment (Scrum/Kanban)
  • Strong knowledge in Software Development Life Cycle and QA process.
  • Expert knowledge in creating Test Plans, Test Cases, Test Scenarios and Test Strategies.
  • Experience in Unix Scripting and Unix - Batch Testing
  • Extensive Automation Testing Experience in ATDD Framework using SQL, Ruby, Cucumber.
  • Extensive ETL experience in Ab Initio / Cygwin Meta Data Framework /Informatica 8.1.
  • Expert in Ab Initio Upgrade Testing (Ab Initio 2.15 to Ab Initio 3.1 Migration)
  • Extensive experience on Ab Initio Graphs utilizing the GDE environment and EME
  • Extensive used Web-EME to verify the Ab Initio Plans, Monitoring Jobs status.
  • Extensive experience in Teradata MLOAD Script and Data Load.
  • Extensive worked in Ab Initio Multi-file System (8way Partition) in UNIX Platform
  • Expert in using all M* commands in Unix Platform and converting serial files into Multi-File.
  • As an innovation, developed a UI based - Automation tool to validate Metadata Hub (MDH) data lineage correction.
  • Expert in Test Data Management / Data Mock-up /Data Profiling and Data Scrubbing.
  • Excellent Knowledge of Database Systems - Teradata,Netezza,Oracle 10g, SQL server, DB2 and Data ware house concepts.
  • Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing.
  • Experience in preparing test reports from ALM and prepared daily test status reports to communicate the test status with the team.
  • Experience in RDBMS and associated SQL Programming Knowledge.
  • Assist in Vendor contract, Resource Management and Project Billings.
  • Excellent Knowledge in Ms-Office (Word, Excel, PowerPoint), Ms-Access, MS Visio.

TECHNICAL SKILLS:

Data Warehousing Tools: Ab Initio 3.1, Informatica, SAP-BODS, Talend, Cygwin MDH

Data Base: Oracle 9i, SQL Server 2008,Teradata 12.0, ASA9.0,DB2,Netezza

Data Validation Tool: Platinum (Client owned tool)

Operating System: Windows, Unix

Test Management Tools: Application Lifecycle Management (ALM), Bugzilla, Test Manager

Test Automation Tools: Ruby,Cucumber (ATDD Framework), HP QuickTest Professional

Data Base Access Tools: Query Tool, Win SQL,TOAD

Reporting Tools: Cognos, MSBI (SSRS, SSAS)

Others: Tidal Scheduler, Control - M, MS-Excel Macro

Scripting: VB-Script, Unix Script

PROFESSIONAL EXPERIENCE:

Confidential

Sr.QA Analyst (ETL Tester )

Responsibilities:

  • Developed high level test matrix based on business requirements, functional and technical specifications, and development standards for assigned projects/applications
  • Developed test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability.
  • Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
  • Validated Business Transformation logics /Rules.
  • Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
  • Verified Ab initio Graphs and Wrapper Script Execution and Teradata Loads.
  • Created M-load script to load the intermediate files in to Teradata table and perform data validation.
  • Performed Ab initio Graphs Code checker (CC)& Data Lineage (DL) Validation.
  • Performed Web-EME - Metadata Hub Validation.
  • Created Automation tool to validate MDH correction.
  • Created Automation script to Run all Ab initio wrapper Scripts.
  • Performed Test Data Mock-up and Lookup file Data Mock-up.
  • Experience in all Ab inito - M * commands
  • Created MS-Excel Macro for Data Validation between source and Target.
  • Created Macro to validate Table structure between PDM document vs Target Database.
  • Walk through the test strategy and Test case to customer and gets their sign-off.
  • Attend Daily Stand-up calls and Sprint - Retrospective meetings.
  • Identify/request test data for System integration testing (SIT) as well as User acceptance testing (UAT).
  • Preformed Data-mock with all positive and negative scenario.
  • Capture the defects and log into the defect management tool (HP - ALM) till closer
  • Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
  • Tracking and reporting the issues to project team and management during test cycles.
  • Updating and maintaining existing test Matrix and test cases based on code changes and enhancements to assigned applications.
  • Contribute in the development of knowledge transfer documentation.

Confidential

Sr.ETL Tester

Responsibilities:

  • Understanding the requirement from STTM Document.
  • Expertise in End to End Testing and Data validation and data comparison.
  • Compared each feeds staging / Target Table structures with production table structure.
  • Identified the correct source file name/path used to load into Production Table.
  • Copied identified source files to MDF Framework.
  • Verified each feeds node chain completeness and correctness.
  • Verified incremental data loads in MDF framework.
  • Validated Target table record count / data with production table record/ data.
  • Prepared the Test Plan and Testing Strategies for Data Warehousing Application
  • Preparation of technical specifications and Source to Target mappings
  • Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
  • Written test cases to test the application manually in Quality Center and automated using Quick Test Pro
  • Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director

Confidential

Tester

Project Specific Skills: SAP - BODS, SSRS, SSAS, SQL Server 2008, Quality Center

Responsibilities:

  • Managed the entire QA team.
  • Analyze and understand the Business requirements & functional specifications.
  • Prepared Test Plan, Test Script and Test Cases.
  • Prepared Mock Test data with all possible Business Scenario to test the Business rules.
  • Performed Data Validation between STG and DWH Layers.
  • Performed SSAS - Cubes Data Validation.
  • Performed SSRS - Reports Validation.
  • Performed Data Model Comparison Between Legacy System and Current System.
  • Reporting and tracking the defects using Quality Centre Bug Tracking Tool.
  • Sent Daily basis Status Reports to entire QA team.

Confidential

Test Engineer

Project Specific Skills: .Net, Oracle, Quality Center V 10.0,SQL

Responsibilities:

  • Prepared Sample Test Data with all possible business scenarios.
  • Preformed Data Profiling process.
  • Preformed Data Model and Schema Validation.
  • Verified the Data validation between Legacy system data and Extracted Data.
  • Verified Bulk Loaded Data Validation.
  • Assist to design Business Validation Rules / Data Transformations Rules.
  • Prepared Mapping document.
  • Prepared SQL Scripts using data transformations rules.
  • Once build released for Testing - Performed Smoke & Sanity Testing.
  • Performed Usability and Negative Testing.
  • Reporting and tracking the defects using Quality Centre Bug Tracking Tool.

Confidential

Software Engineer

Project Specific Skills: Talend, Oracle 9i,SQL

Responsibilities:

  • Analyzing the functional specifications and user Requirement.
  • Participated in different Review Meetings.
  • Performed Browser Compatibility testing, Data Base Testing and Graphical User interface (GUI) testing.
  • Prepared Test Plan and SQL Scripts.
  • Executed Test cases manually.
  • Involved SIT Testing, Regression Testing & Acceptance Testing stages.
  • Reporting, Analyzing, Tracking and verifying bugs.
  • Papered Proof of Testing Document (POT) for reported Issue’s.
  • Performed Schema Validation in-between Securian ver 5.0 and ver 5.1.9
  • Entered all the issues to Issue Tracking System with proper Issue status.
  • Follow-up all the Issues up to Close status.
  • Prepared final test documents with Overall test status.

Confidential

Sr. Quality Assurance Professional

Project Specific Skills: Informatica, ASA, Oracle 9i,SQL

Responsibilities:

  • Managed the entire QA team.
  • Understanding Requirement from HLD & LLD.
  • Prepared Test Plan and Test Case.
  • Generated/Inserted Test data into Blank Database using DTM Data Generator tool.
  • Performed Load Testing and Stress Testing.
  • Executed Test cases manually.
  • Involved Database testing, System Testing, Regression testing stages.
  • Papered Proof of Testing Document (POT) for reported Issue’s.
  • Entered all the issues to Issue Tracking System with proper Issue status.
  • Follow-up all the Issues up to Close status.
  • Performed DATABASE Testing, to check the converted data.
  • Verified Extracted data details though back-end.
  • Verified Loading Process through back-end.
  • Verified Mapping information converted data with Source DB and Target DB.

Confidential

Quality Assurance Professional

Project Specific Skills: Ezlink, ASA, Oracle 9i, SQL

Responsibilities:

  • Analyzing the functional specifications and user Requirement.
  • Participated in different Review Meetings.
  • Prepared Test Case and SQL Scripts.
  • Executed Test cases manually.
  • Involved in Database Testing, Regression Testing & Acceptance Testing stages.
  • Reporting, Analyzing, Tracking and verifying bugs.
  • Papered Proof of Testing Document (POT) for reported Issue’s.
  • Performed Schema Validation in-between Securian 4.1.3 to SO 5.1.9
  • Entered all the issues to Quality Center with proper Issue status.
  • Follow-up all the Issues up to Close status.
  • Prepared final test documents with Overall test status.

Confidential

Quality Assurance Professional

Project Specific Skills: Ezlink, ASA, Oracle 9i, SQL

Responsibilities:

  • Analyzing the functional specifications and user Requirement Documents.
  • Performed Data Base Testing and Graphical User interface (GUI) testing.
  • Prepared Mapping Document and Test Case.
  • Test case Execution.
  • Data Validation between Current system and legacy system.
  • Performed the Sanity & Smoke Testing.
  • Performed Data Comparison in-between Metlife CDS 4.3 and SmartOffice 5.1.3
  • Prepared Proof of Testing Document (POT) for reported Issue’s.
  • Regresses existing bugs on previous software builds.
  • Reporting and tracking the defects.
  • Prepared final test documents with Overall test status

Hire Now