We provide IT Staff Augmentation Services!

Etl Qa Lead Resume

UsA

PROFESSIONAL SUMMARY:

  • Around 10 years of Experience Quality Assurance, testing process, Testing methodologies and strong experience on STLC and overall testing approaches
  • More than 6 years of experience in Data Warehouse/Data mart implementations teamed with Analysis, requirements gathering, Effort Estimation, ETL Design, development, System Integration testing, Implementation and UAT support
  • Strong in Data Warehousing concepts as well as methodologies, Star Schema and Snowflake Schema dimensional models .
  • Experience in Insurance and Healthcare domain.
  • Experience in testing of various data sources like database,Teradata, xml, Excel and Text files.
  • Experience in ETL automation using QuerySurge/DVO.
  • Worked on Liberty Mutual Insurance’s inhouse ETL automation tool DVR tool
  • Good Knowledge on Oracle, Teradata, SQL Server Database and Greenplum
  • Experienced in testing reports using Business Intelligence (BI) Tools like MicroStrategy, Cognos, SSRS.
  • Expertise level knowledge in entire software development life cycle (SDLC) process from business analysis to development, testing, deployment, documenting, maintaining and user training, experience on AGILE and SCRUM design methodologies
  • Strong ETL testing experience and SQL testing experience.
  • Excellent experience in preparing Test plan document which includes test strategy.
  • Expertise in creating the test data for Extraction and Transformation processes and resolved critical data issues by following the data standards of the project.
  • Involved in end to end QA artifacts Preparation from Master Test Plan to Test Closure Summary
  • Working closely with Business team for deploying solutions and sound experience in working closely with client for UAT validation.
  • Woked on a POC of Big Data.

TECHNICAL SKILLS:

Databases: Oracle 10g, Oracle 11g, SQL Server 2005, SQL Server 2008, Greenplum

ETL Tools: Informatica, Micro strategy and MSBI

Reporting Tools: Cognos, Microstrategy

MS Office: Word, Access, Power Point, Excel

Operating Systems: Windows 95/98/2000/XP

ETL Automation Tools: Platinum ( Confidential in - house tool)

Testing Management Tools: HP Quality Center, ALM

PROFESSIONAL EXPERIENCE:

Confidential, USA

ETL QA Lead

Responsibilities:

  • Excellent Coordination in managing multiple project teams from onshore.
  • Providing QA estimates for all the Test deliverables
  • Expertise in QA artifacts preparation from Master Test Plan (Contains the overall Testing Activities and testing strategy to be covered) till Test Closure Summary.
  • Extracting Data from Heterogeneous Sources and processing them to staging layer.
  • Extensively tested ETL part, using SQL queries for consistency and errors while extracting and transforming/ loading the data.
  • Validated the data at each stage, from source table to staging tables and then finally to destination tables.
  • Worked in both Data Warehouse Models (Star and Snowflake Schema)
  • Sound Experience in implementing ETL automation using QuerySurge
  • Validating the data by applying all business rules and processing data till the BASE layer.
  • Creating SQL scripts to be executed on SQL Developer and doing a source to target validation
  • Posting the issues identified to all the stakeholders
  • Keeping Track of Defects
  • Communicating with Dev. Leads, BA’s, Project manager, offshore team and onshore regularly and ensuring project deliverables or on Track
  • Good experience of working in onshore offshore model
  • Participation in daily QA scrum meetings.
  • Preparing the daily status, defect reports and reviewing them with stake holders
  • Experience in all QA life cycle testing.

Environment: Teradata, Informatica, JIRA.

Confidential, USA

ETL QA Lead

Responsibilities:

  • Coordination in managing multiple project teams.
  • Providing QA estimates for all the Test deliverables
  • Expertise in QA artifacts preparation from Test Plan (Contains the overall Testing Activities and testing strategy to be covered) till Test Closure Summary.
  • Involved in all phases of testing (System, UAT, Prod checkout)
  • Extracting Data from Heterogeneous Sources and processing them to staging layer.
  • Extensively tested ETL part, using SQL queries for consistency and errors while extracting and transforming/ loading the data.
  • Experience in ETL automation using DVO
  • Validated the data at each stage, from source table to staging tables and then finally to destination tables.
  • Worked in both Data Warehouse Models
  • Sound Experience in validating high volume of XML data.
  • Validating the data by applying all business rules and processing data till the BASE layer.
  • Creating SQL scripts to be executed on SQL Developer and doing a source to target validation
  • Posting the issues identified to all the stakeholders
  • Keeping Track of Defects
  • Good experience of working in onshore offshore model
  • Preparing the daily status, defect reports and reviewing them with stake holders
  • Experience in all QA life cycle testing.
  • Participated in Daily QA Scrum with QA manager to discuss the QA updates.
  • Experienced with ALM for managing the defects and querying the ALM for pulling Defect status reports.

Environment: Oracle, SSIS, Microstrategy, HP ALM.

Confidential, USA

Senior ETL tester

Responsibilities:

  • As an ETL QA Analyst, tested ETL (Informatica) mappings for each extract in the Informatica Designer
  • Extensively tested ETL (Informatica) part, using SQL queries for consistency and errors while extracting / transforming / loading the data.
  • Validated the data at each transformation. From source table to staging tables and then finally to destination tables.
  • Developed SQL queries to validate data in IODS, Data warehouse and Data mart.
  • Validated report data by writing and executing SQL queries against the data base.
  • Created Test Plan, Test cases and Test Scripts using Rational Test Manager.
  • Validated the data at each stage, from source table to staging tables and then finally to destination tables.
  • Worked in both Data Warehouse Models (Star and Snowflake Schema)
  • Developed SQL queries to validate data in Data warehouse and Data mart.
  • Validated reports generated from Hyperion Essbase.
  • Validated report data by writing and executing SQL queries against the Mart data base.
  • Performed System Integration, User Acceptance and Regression Testing.
  • Tested the drill through functionality by writing SQL queries and match it against the fact tables

Environment: Teradata SQL Assistant, HP ALM, Informatica and Microstrategy.

Confidential

Senior ETL tester

Responsibilities:

  • Expertise in QA artifacts preparation from Master Test Plan (Contains the overall Testing Activities and testing strategy to be covered) till Test Closure Summary.
  • Extracting Data from Heterogeneous Sources and processing them to staging layer.
  • Validating the data by applying all business rules and processing data till the BASE layer.
  • Creating SQL scripts to be executed on Teradata SQL Assistant and doing a source to target validation
  • Posting the issues identified to all the stakeholders
  • Keeping Track of Defects
  • Communicating with Dev. Leads, BA’s, Project manager, offshore team and onshore regularly and ensuring project deliverables or on Track
  • Participation in daily QA scrum meetings.
  • Writing the test cases covering the complete requirement logic.
  • Preparing the daily status, defect reports and reviewing them with stake holders

Environment: Teradata SQL Assistant, Greenplum, Microstrategy, HP Qulaity Center, Cognos and Informatica.

Confidential

ETL Tester

Responsibilities:

  • Designed Test cases based on the Business functional definition documents and also reviewed the test cases written by the peers. (Also referred Source to Target Detailed mapping document & Transformation rules document).
  • Extensively performed DATA validation using SQL queries and back-end testing
  • Used SQL for Querying the database in UNIX environment
  • Developed test cases for ETL process and reporting.
  • Performed various levels of testing in all stages of the SDLC, Involving Requirements, Design, and Development teams to implement the requirements.
  • Developed and Performed execution of Test Cases manually to verify the expected results
  • Used Quality Center for creating defect and reviewing defects. Also pulling the defect report status and analyzed it.
  • Preparation of various test documents for ETL process in Quality Center.
  • Optimizing/Tuning several complex SQL queries for better performance.
  • Created and executed test cases for ETL jobs to upload master data to repository.
  • Involved in providing training to the team members on the enhancements in the application
  • Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.

Environment: SSIS, SSRS, SSAS, SQL Server 2008, HP Quality Center.

Confidential

Test Analyst

Responsibilities:

  • Writing test plans and test scripts
  • High Level Test Case Design and writing detailed test cases
  • Involved in extensive DATA validation using SQL queries and back-end testing.
  • Involved in functional, system, integration and regression testing.
  • Used JIRA for creating defect and reviewing defects. Also pulling the defect report status and analyzed it.
  • Defined the Scope for System and Integration Testing
  • Prepared Test summary documents from the test results recorded and escalating and troubleshooting if any issues.
  • Reported periodic project status and updates to the QA Lead and QA Manager

Environment: Windows XP, SQL Server 2003, Manual Testing.

Hire Now