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.