We provide IT Staff Augmentation Services!

Etl Db Qa Tester Resume

TX

SUMMARY

  • Experience:14+years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.
  • Self - Motivated, Flexible to adapt to changing priorities and deadlines. Systematic and organized approach.
  • Believe in Commitment to Excellence and Team Spirit.Multi-tasking projects Handling, Team handling, People management Capabilities.
  • Excellent Presentation, Communication, Writing & Interpersonalskills.
  • Extensive IT experience in various capacities including Analysis, design, development, Testing & implementation in client server environment using various S/W tools including Reporting Applications.
  • Extensive experience in Actuate erd Pro, software quality assurance, Manual Testing, ETL Testing, Data Analysis, Data Migration Testing, SOA Testing, Web Method /API Testing using POSTMAN and Ready API, BI Report Testing, Big Data Hadoop Hive, HQL.
  • Worked with large Databases in Testing and Production environments, Data warehousing and ETL process usingInformatica.
  • Developed and designed Mappings usingInformatica ETL toolfor testing the data flow from Data Warehouse to data marts to compare data migration, data transformation & the totals at summary level.
  • Good experience in working withonsite-offshoreteam model projects
  • Proficient in analyzing and translating business requirements to technical requirements and architecture.
  • Strong database skills, Object Oriented Programming and development knowledge. Good Exposure to database like Oracle, DB2, Teradata and MS SQL Server
  • Good understanding of Reporting BI Tools like Actuate, Crystal report and ETL Tools like Informatica
  • Involved in testing the Text Files, CSV Files, XML files, JSON Files and checked whether data is parsed and loaded to staging tables in Hadoop Hive using HQL
  • Excellent Understanding and working experience in Agile Methodology, Waterfall Methodology
  • Excellent experience in Quality Assurance, QA processed, Manual Testing, ETL Testing & Informatica DVO, POSTMAN, SOAP UI, Ready API, HP ALM Quality Center,Control-M
  • Experience in leading and managing teams. Handled multiple roles - Project Lead, Team Lead, Technical lead, Application developer, Application tester
  • Executed software projects for Financial, Banking, Healthcare, Retail, Education, Insurance, Healthcare, credit Card and Telecom Domain
  • Expertise in RDBMS backend testing for data validation and data integrity using SQL.
  • Good experience onTeam Management, People Management, Estimation, Stakeholders communication for different projects.

TECHNICAL SKILLS

Languages: C++, VB

Databases: DB2, SQL Server 2008, 2010, 2012, My SQL, Oracle 8, 9i

Reporting Tools: Actuate erd pro, Actuate e spreadsheet, Crystal Report 11.0

Testing Tools: HP ALM Quality Center, JIRA,Informatica DVO, POSTMAN, SOAP UI, Ready API, AcceLQAutomation,Control-M

ETL: Informatica 8.5/9.1/9.6/10 , Informatica Cloud, Hadoop-Hive

Quality Assurance: Manual testing, Web Testing, ETL testingBackend testing, Data Testing, testing Processes, Informatica DVO, SOA TestingWeb Method/ API Testing, BI Report Testing Informatica Cloud/ SharePoint Cloud testing,CICD

PROFESSIONAL EXPERIENCE

Confidential

ETL DB QA Tester

Responsibilities:

  • Create Automated testing framework for ETL Software Applications and Data Service Layer using Informatica, Informatica DVO for testing Data Warehouse, CSIM technology and integrations
  • Create, design and develop strategy for ETL Validation, Data Validation, Backend Validation usingETL Automation tools and MS SQL Server database with XML, CSV and JSON
  • Design, implement and execute Testing Strategy, Test Plans, Test Cases in Test Management using defect tracking tools JIRA
  • Write Complex SQL queries and Stored Procedures against RDBMS to validate ETL processes
  • Identify discrepancies/inconsistencies in ETL Data migration and Data Load through data Sources MSSQL Server database, XML, CSV, JSON files and perform root-cause analysis, bug prevention strategies, and quality measures.
  • Work in Agile Software Development methodology, attend SCRUM meetings and implement new interfaces and integrations to third party systems

Environment: Informatica, Informatica DVO, SQL Server, XML, CSV, JSON, API, AGILE, Test Automation Framework, SCRUM, Web Services, SQL, JIRA,CICD, Control-M

Confidential

Sr. Software System Engineer Quality

Responsibilities:

  • Participated in Scrum Meeting, Sprint Planning Meeting and Agile Manager Updates
  • Worked with Product Owner for creation of user requirement document for several components by extensive interactions with the user teams, development teams and management teams.
  • Developed a detailed Test Plan, Test Cases for the testing effort of the Data Migration.
  • Worked on Requirement Analysis, Data Analysis, Testing of various source systems sitting and coming from multi systems. Responsible for BI Data Quality.
  • Developed and maintained Stored procedures, User Defined Functions, Indexes, Views, Tables,
  • Identify discrepancies/inconsistencies and perform root-cause analysis as needed.
  • Manage encountered defects through resolution. Collaborate with development team and business analysts in the resolution of encountered defects.
  • Apply proven analytical and problem-solving skills to work on complex issues. Exercise strong judgment in selecting methods, techniques and evaluation criteria for obtaining results.
  • Assist in the planning and facilitation of User Acceptance Testing as needed.
  • Execute data validation process using SQL and ETL tools, and perform root cause analysis.
  • Write SQL against relational databases to validate ETL processes and BI reports.

Environment: ASP.NET 4.5, .Net Framework 4.5, C#, Web Forms, Visual Studio 2015, HTML5, CSS3, JavaScript, JQuery, Bootstrap, Entity Frame Work 5.0, WCF, IIS 7.0, SQL Server, TFS, SSIS, Tortoise GIT.

Confidential

Sr. Software System Analyst Quality

Responsibilities:

  • Lead the Agile test from planning and organization to execution and delivery.
  • Work with Product Owner, Scrum Master and Agile Developer team to design Test strategy, Design Test Approach & Test Cases and Validation & Execution of test cases for Identifi Product
  • Design the test approach, Test cases and Validate Web Services for EVH Portal, Microsites, Community portal using POSTMAN, SOAP UI Automation
  • Perform comprehensive test planning activities, including developing effective test strategies.
  • Create QA artifacts, including test strategy, test plan, detailed test cases, defect reports and final test summary report.
  • Perform various types of testing, including but not limited to the following: integration, backend data validation, usability, end to end system testing, performance/stress, and regression testing.
  • Participate in Various Agile ceremonies like Release planning, Sprint planning, Mid Sprint review, Sprint closure, Sprint retrospective & Demo.
  • Design HQL,SQL DB artifacts used for Data & ETL Validation as well as BI Report validation
  • Involved in testing the XML files, JSON Files and checked whether data is parsed and loaded to staging tables
  • Create Web and Automation suite for testing API as well as Web Applications

Environment: Test planning, ETL Data testing,SQL Server 2016, AcceLQ Automation, POSTMAN,JIRA,MS VSTS, GitHub, Hive, HQL

Confidential, TX

Sr. DW/BI Quality Assurance Analyst

Responsibilities:

  • Lead the test effort from planning and organization to execution and delivery.
  • Work with business analysts and the development team to develop a testing culture. Drive adoption of unit testing, metrics to monitor code coverage, bug prevention strategies, and other quality measures.
  • Analyze requirements to assess completeness and testability. Provide timely feedback and constructive recommendations to the Business Analyst.
  • Perform comprehensive test planning activities, including developing effective test strategies.
  • Create QA artifacts, including test strategy, test plan, detailed test cases, defect reports and final test summary report.
  • Perform various types of testing, including but not limited to the following: integration, backend data validation, usability, end to end system testing, performance/stress, and regression testing.
  • Identify discrepancies/inconsistencies and perform root-cause analysis as needed.
  • Manage encountered defects through resolution. Collaborate with development team and business analysts in the resolution of encountered defects.
  • Apply proven analytical and problem-solving skills to work on complex issues. Exercise strong judgment in selecting methods, techniques and evaluation criteria for obtaining results.
  • Assist in the planning and facilitation of User Acceptance Testing as needed.
  • Perform other job-related duties as assigned.
  • Execute data validation process using SQL and ETL tools and perform root cause analysis.
  • Write SQL against relational databases to validate ETL processes and BI reports.

Environment: Test planning, ETL testing, Informatica 10, SQL Server 2016, Cognos 10, HP ALM, Informatica Cloud, SharePoint Cloud and SQL

Confidential, Scottsdale, AZ

Sr. ETL API Tester

Responsibilities:

  • Participated in Scrum Meeting, Sprint Planning Meeting and Agile Manager Updates
  • Worked with Product Owner for creation of user requirement document for several components by extensive interactions with the user teams, development teams and management teams.
  • Developed a detailed Test Plan, Test Cases for the testing effort of the Data Migration.
  • Worked on Requirement Analysis, Data Analysis, Testing of various source systems sitting and coming from multi systems. Responsible for BI Data Quality. .
  • Tested ETL jobs as per business rules using ETL design document (Mapping Sheet)
  • Created and Executed Test cases in Data Validator Option ( Informatica DVO)
  • Created projects in Ready API, Tested Web Methods/ API using Postman and ReadyAPI
  • Used HP QC to track Defects, analyze results and generate performance reports.
  • Participated in updating the Requirements Traceability Matrix (RTM)
  • Executed SQL Queries to verify the dataflow from the backend.
  • Performed user acceptance testing (UAT), and integration testing.
  • Worked on creating Test strategy, test plan and test scenario for E2E testing
  • Executed E2E testing successfully handled responsibilities of co-ordination with offshore team, estimation, status reporting

Environment: Informatica 9.1/9.6, SQL Server, Skybot, GoAnyWhere, Informatica DVO, My SQL, Hybris, PostMan, Ready API, Groovy Scripting

Confidential, Somerset NJ

Sr. DWBI ETL Tester

Responsibilities:

  • Participated to created user requirement document for several components by extensive interactions with the user teams, development teams and management teams.
  • Participated in created of User Stories with Business users, and Developers.
  • Developed a detailed Test Plan for the testing effort of the User Interface.
  • Developed Test Cases based on the requirement documents.
  • Worked on Requirement Analysis, Data Analysis, Testing of various source systems sitting and coming from multi systems. Responsible for BI Data Quality.
  • Performed Business Process mapping for new requirements.
  • Tested ETL jobs as per business rules using ETL design document
  • Used HP QC to track Defects, analyze results and generate performance reports.
  • Participated in updating the Requirements Traceability Matrix (RTM)
  • Executed SQL Queries to verify the dataflow from the backend.
  • Performed user acceptance testing (UAT), and integration testing.
  • Worked on creating Test strategy, test plan and test scenario for E2E testing
  • Executed E2E testing successfully
  • Worked as representative of IBM and handled responsibilities of co-ordination with offshore team, estimation, status reporting

Environment: Informatica, DB2, Control M, Unix, HP ALM QC, SQL Server, SQL

Confidential, Columbus, OH

Sr. DWBI ETL Tester

Responsibilities:

  • Analysis of Requirement, Mapping document and create MTD, RTM and Test strategy document
  • Developed a detailed Test Plan for the testing effort of the User Interface.
  • Developed Test Cases based on the requirement documents.
  • Tested ETL jobs as per business rules using ETL design document
  • Executed the Test Scripts in TOAD
  • Used HP QC to track Defects, analyze results and generate performance reports.
  • Participated in updating the Requirements Traceability Matrix (RTM)
  • Executed SQL Queries to verify the dataflow from the backend.
  • Performed user acceptance testing (UAT), and integration testing.
  • Worked on creating Test strategy, test plan and test scenario for E2E testing
  • Worked as a member of UAT team

Environment: Informatica, DB2, Control M, Unix, HP ALM QC, SQL Sever

Confidential, Phoenix, AZ

Actuate Developer and BI Report Tester

Responsibilities:

  • Analysis of new requirements.
  • Creating Design Documents based on the requirement.
  • Developing Reports in Actuate erdpro and e spreadsheet with version 8.
  • Integrating Main reports with Criteria reports.
  • Preparing test cases for reports.
  • Involved in Unit Testing and System Testing.
  • Installation of Reports on Production Environment.
  • Preparing detailed Test cases for report testing, data validation and look and feel changes
  • Testing the reports for individual report flow and cross report flow
  • Cross validation of report data with database values and validation of calculation

Environment: Actuate ERD Pro, Actuate e-Spreadsheets,DB2, HP Quality Center, Actuate iserver, Actuate Active Portal

Confidential

ETL BI Report Tester

Responsibilities:

  • Analysis of new requirements.
  • Creating Design Documents based on the requirement.
  • Preparing test cases for reports.
  • Prepare test strategy, MTD and test approach documents
  • Preparing detailed Test cases for report testing, data validation and look and feel changes
  • Testing the reports for individual report flow and cross report flow
  • Cross validation of report data with database values and validation of calculations

Hire Now