Etl Quality Assurance Resume
SUMMARY
- Quality Assurance Lead with 14 Years of diverse experience in Information Technology with emphasis on implementation of User/Business/Functional requirements to enable the product as a defect free product.
- Extensive business knowledge of global Financial services, Insurance and CRM domains with aim of promoting transparency of code quality across developers, product owners and senior management.
- Expertise in Manual, ETL, Automation, and Database testing. Adept liaison among functional and technical teams, capable of managing and mentoring cross cultural staff and vendors.
- Strong understanding of QA Principles and Process, Software Testing Life Cycle (STLC), Bug life Cycle and QA development methodologies like Waterfall, AGILE/Scrum, V - Model.
- Has Strong Experience in leading 15 member team in both the onshore/offshore model
- Has strong experience in translating Business requirements into System Functional Specifications and System Design Specifications and thus mapping the Functional Test cases to the Requirement Traceability Matrix
- Has proficiency in ETL/BI tools like Informatica power center, SQL Server Integration Service (SSIS) and Reporting tools like BOBj, Tableau, Actuate eReports, SSRS and AXIOM
- Extensive experience in ETL/ Data warehouse backend testing (Execution of ETL Process and Data Validation of Source to Stage and Stage to Target)
- Good experience in data warehouse concepts and technologies like OLTP, OLAP, Data Models (Star/ Snow Flake Schemas), DataMart’s (Dimensions and Facts) and Reporting.
- Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing.
- Proficient in troubleshooting database issues and experienced in using performance monitor/profiler to solve dead locks/ long running queries.
- Expert in creating Test Plan, Test Scenario, Test Scripts, Traceability Matrix, Test Strategy, Test Estimation, Test Effort, Scheduling, Defect Tracking and Executing Test cases.
- Familiar with Excel for developing Requirements Traceability Matrix (RTM) and Capturing and Updating Change Requests.
- Experience in preparing test reports from HP ALM and prepared daily test status reports to communicate the test status with the team.
- Excellent verbal and communication skills, has clear understanding of business procedures, adapt new environment quickly, Team building, Leadership and Project Management Skills.
TECHNICAL SKILLS
Primary Skills: ETL, Automation, Database and Manual testing
Programming Skills: VB, Java
Databases: SQL Server 2005/2008, Oracle 10g/9i/8i, Teradata
Databases Tools: Toad, Oracle SQL Developer, Query Builder, Query Analyzer, DBeaver
Testing Tools: Quality Center - 10.X, Application Lifecycle Management, Bugzilla, Eclipse, IntelliDb 8.3,Jira
Source Control Tools: Visual Source Safe, Tortoise SVN, Star Team, Rally
ETL and Reporting Tools: Informatica 8.1, SQL Server Reporting Service, SQL Server Integration Service, Actuate, Erwin data modeler, AXIOM, BOBj and Tableau reports
Domain Skills: Banking, Insurance and CRM
Techno-Functional: Team Building, Planning & Prioritizing Skills, Time Management, Cross Cultural Skills, Customer Orientation
PROFESSIONAL EXPERIENCE
Confidential
ETL Quality Assurance
Responsibilities:
- Conduct testing and quality control on design andprocesses for the system including support UAT, planning and execution.
- Validated the ETL mappings and executed the workflows
- Validated the BOBj reports and compare the data in database
- Validated the Tableau reports and compare the data in database
- Co-ordinate with Development Team and all stakeholders to discuss defects/issues.
- Helping Business team with required information for UAT in QA environment.
Environment: Informatica, BOBj reports, Tableau reports, Redshift, SQL Server, HP ALM, SharePoint
Confidential
Lead ETL Tester
Responsibilities:
- Gain an understanding of the testing requirements, analyze moderate to highly complex requirements documents, design specifications, functional specifications, and changed or modified code.
- Attending the daily standup meeting with Development and Business teams to review current changes in each release cycle.
- Ensure all documentation and scripts are maintained and kept up to date with application changes.
- Executing daily Batch/Jobs, which load/move the data to target tables.
- Preparing test strategy document and get approval from the Project manager, Change the bank and run the bank teams
- Preparing the Test Results Summary Document after the completion of testing in both SIT and QA testing before prod implementation and get approval
- Validation of data transformations and perform End-to-End data validation for ETL & BI systems.
- Scheduling daily meetings with offshore team and discuss daily updates on the ongoing releases
- Executing and monitoring the RRX Calculator batches and validating the FFIEC, 9C, 14Q Reports
- Validate the MDE/MDA functionality, Validate the Categorization process, where the business rules are applied to categorize the data accordingly. This process is done as part of batch process
- Validate the Data quality that is loaded to RRW environments before processing
- Validate the GL Reconciliation functionality. Calculation of GL balances and exposure balances and validation of GL Recon report, this is also a part of batch process to check completeness of data.
- Validated all the Federal submitted Finance reports such as FRY 9C, FFIEC 031 and Risk reports such as 14Q using Axiom Regulatory tool
- Axiom - Cross checking the different components of Axion like Data Source, Data Models
- Axiom - Executing the workflows using Workflow module
- Axiom - Comparing the reports generated by the Axiom tool with the results from queries written based on the Business requirements
- Axiom - If any differences found raising bugs and analyzing the differences using Drill down options in Freeform report, Aggregation and Portfolio Modules
- Validation of the RRX amounts comparing the results from complex SQL queries with the FFIEC 101 … generated from the Batch processing
- Tested the modified STMs due to source system updates as a part of ETL validation
- Finding Feasibility for automation and impact to existing automation.
- Traceability of Defect or Requirement with Test Case.
- Co-ordinate with Development Team and all stakeholders to discuss defects/issues.
- Helping Business team with required information for UAT in QA environment.
Environment: Informatica, AXIOM, OBIEE, Oracle 10g/9i, SQL Server 2008, Teradata, HP ALM, SharePoint
Confidential
Sr. ETL Test Lead
Responsibilities:
- Thorough out the project in various iterations/Sprints - conducted system testing, integration testing, functional testing and integration testing.
- Designed and developedETL test cases, scenarios, and scripts to ensure quality Data warehouse / BI applications
- Created complex SQL scripts for source and target following the mapping document guidelines.
- Strong in ETL data validation developed using Informatica /SSIS ETL environments
- Created the Testing Document for all the involved tables by identifying the unique data for performing data validation.
- Test extract, transform and load (ETL) processes to assure that the data has correctly moved from source to staging and staging to target.
- Experienced in Agile Methodology and expertise in JIRA software
- Performed UAT and Regression Testing.
Environment: Informatica, Oracle 10g/9i, SQL Server 2008/2005, HP ALM, Confluence, Java
Confidential
Sr. ETL/Automation Test Lead
Responsibilities:
- Established QA process framework and management process for software delivery in MSP projects.
- Thorough out the project in various iterations/Sprints - conducted system testing, integration testing, functional testing and integration testing.
- Created complex SQL scripts for source and target following the mapping document guidelines.
- Created the Testing Document for all the involved tables by identifying the unique data for performing data validation.
- Test extract, transform and load (ETL) processes to assure that the data has correctly moved from source to staging and staging to target.
- Performed thorough validations (data correctness, datatypes, constraints, historical, data counts, integrity etc.) required both from the data point of view as well as the business point of view.
- Created testing scripts to validate all the data columns for all the dimensions, facts as well as standalone tables in their respective data loading format.
- Created a series of testing scripts with the typical format of count validation followed by data columns validation and finally null column checks and primary, foreign and surrogate key validations of all the dimension and fact tables.
- Executed automation scripts on different browsers/environments & reported defects to the team
- Created Automated Regression test suit. Involved in design and implementation of Selenium WebDriver automation framework for smoke and regression test suites (TestNG and Maven).
- Maintained the Selenium & JAVA automation code and resources in source controls like CVS, SVN over the time for improvements and new features
- Automated the testing of the whole script by IntelliDB bank tool.
- Created Automated Regression test suit to provide up to 65% efficiency in QA process.
- Created the Test Plan and Test Cases in HP ALM, identified issues and created defects in HP ALM
- Provided daily updates regarding the progress of the project to the Client Manager.
Environment: Oracle 10g/9i, SQL Server 2008, HP ALM, IntelliDb 8.3, Tortoise SVN, Rally
Confidential
ETL Test Lead
Responsibilities:
- Closely involved in gathering requirement, design, development and implementation of the project
- Developed high level test matrix based on business requirements, functional and technical specifications, and development standards for assigned project/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 to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
- Performed Count Validation, data validation, data scrubbing, data cleansing for data coming from sources during data migration/conversion.
- Extensive SQL querying on Staging, Data Warehouse and DataMarts.
- Ensured Error logs and audit tables are generated and populated properly
- Have active interaction with DBAs' related to the schema, dblink creation, data refresh for multiple rounds of testing and other tasks.
- Participating in defect triage meetings to work closely with developers to inform them about defects. Experience in defect management cycle.
Environment: Oracle 9i/8i, SQL Server 2005, HP ALM, Tortoise SVN, Rally
Confidential
DWT/ETL Tester
Responsibilities:
- Closely involved in gathering requirement, design, development and implementation of the project
- Reviewed the requirements document created by the BA and prepared a thorough test plan.
- Involved in rigorous meetings with the product owner and DWH Lead to prepare a roadmap for implementing the test plan on a sprint basis as part of the agile model.
- Reviewed test cases, validation steps and test scripts prepared by the testing engineer with the product owner.
- Created test plan and test cases from the business requirements to match the project's initiatives in Quality Center.
- Developed SQL Queries and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.
- Written complex Oracle SQL queries and executed them to validate the incremental ETL Loads.
- Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage.
- Involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and Test Data.
- Maintained the test logs, test reports, test issues, defect tracking using HP ALM
Environment: Oracle 9i/8i, SQL Server 2005, HP ALM, Tortoise SVN, Rally, Visual Source Safe
Confidential
ETL Test Analyst
Responsibilities:
- Attended meetings with architects, developers and business analysts to understand data model, data flow and warehouse design.
- Worked in Client location (USA) as an Onsite Lead.
- Written test cases developed the validation steps and reviewed them with testing team manager.
- Developed test scripts using SQL according to the mappings and rules specified in mapping document.
- Performing different data quality checks like null check, length, validity, alphanumeric on all different fields and columns.
- Researching more on bad data/defects and categorizing them as source issue, ETL issue or historical issue.
- Experienced with data models Start Schema and Snow-Flake Schema
- Extensively tested several BO reports for data quality, fonts, headers & cosmetic.
- Created test plan and test cases from the business requirements to match the project's initiatives in Quality Center.
- Maintained the test logs, test reports, test issues, defect tracking using Quality Center.
- Good working experience in creating Test Plan, Test Scenario, Test Scripts, Traceability Matrix, Test Strategy, Test Estimation, Test Effort, Scheduling, Defect Tracking and Executing Test cases
Environment: Oracle 9i/8i, SQL Server 2005, Quality Centre, Informatica 8.1, Business Objects XI, Visual Source Safe, Tortoise SVN, Star Team, Erwin data Modeler