Informatica Developer Qa Tester

Shweta Sahu Email: ******.******@*****.*** Mobile: 317-***-****

PROFESSIONAL SUMMARY

●5+ years of professional experience in ETL Datawarehouse, Database and API Tester on different platforms and environments

●Extensive experience of manual and automated testing of application and use of HP Quality Center, Informatica DVO, Postman, Informatica Designer and Informatica Developer.

●Involved in executing test plan test strategy and test scripts for Functional, Integration, UAT, Negative and Backend testing.

●Experience in Data Analysis, Data Validation, Data Cleansing, Data Standardization, Data Verification and identifying data mismatch, fuzzy matching.

●Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources, and scheduling.

●Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.

●Extensive experience in working with databases including Oracle MS SQL Server. BI reporting like Cognos and Tableau.

●Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements. Excellent communication, analytical and interpersonal skills.

TECHNICAL SKILLS

ETL Tools

INFORMATICA Power Center 9.1, 8.6

Testing Tools

Informatica DVO, Postman, HP Quality Center 10/ ALM 11, QTP 10.0,11, Manual Testing

Database

DB2, SQL Server, Oracle 8i/9i/10g, SQL Server 2000/2005, SQL Developer, TOAD, MS Access

Reporting Tools

Cognos, Tableau

Operating Systems

Windows 10, UNIX

Languages

XML, SQL, PLSQL

Scripting Tool

VB Scripting, VBA

EDUCATIONAL QUALIFICATION

●Master of Computer Applications (MCA), SATI Vidisha MP India

WORK AUTHORIZATION

●Green Card

PROFESSIONAL EXPERIENCE:

Liberty Mutual, Indianapolis, IN

ETL Tester / QA Tester

Duration: August 2018 – Current

Description: The Project is data conversion project where we converted data from Legacy to Oracle based application Guidewire Claim Center.

Responsibilities:

●Testing stage table file created from source upstream system, doing record count Check, reconcile records with source data

make sure no junk data loaded, assure key or mandatory key fields are not missing. Doing data quality check like duplicate data testing and data type and size check.

●Business transformation logic testing like business data check like telephone no can’t be more than 10 digit or character data. Record count check for active and passing transformation logic applied. Derived Field from the source data is proper. Check Data flow from stage to intermediate table. Surrogate key generation check if any

●Validating target table loading from stage file or table after applying transformation as record count check from intermediate table or file to target table. Mandatory or key field data not missing or Null. Aggregate or derived value loaded in Fact table. Check view created based on target table, truncate and load table check. CDC applied on incremental load table, dimension table check & history table check. Business rule validation on loaded table, check reports based on loaded fact and dimension table. Analyzed requirement updates and mapped them with the respective manual Test Cases using Informatica Power Designer.

●API/Service testing using Postman tool for the services developed as part of the project.

●Clear understanding of Cognos BI reporting, Cognos components such as Query, Analysis Report, Event Studios.

●Through knowledge of Cognos development and testing, Cognos BI reporting and planning. Monitor Cognos environments to provide usage and performance metrics. Responsible for creating weekly and monthly reports for management based on Cognos data.

●Creating Change ticket, Production support enhancements and coordination with DBA with long running queries and fixing and retesting the issues.

●Responsible for monitoring Cognos software and logging statistical results. Written several complex SQL queries for data verification and data quality checks. Writing queries for fuzzy testing using SQL functions and executing those in DVO

Americo Insurance, Kansas City, MO

Data warehouse/ETL /QA Tester

Duration: February 2017 – July 2018

Description: The Project is on Insurance project to manage portfolio, mergers and acquisitions, reverse mergers, turn-around, and restructuring. The project entailed maintenance, enhancement and production support for the team.

Responsibilities:

●Prepared Test Plan from the Business Requirements and Functional Specification. Developed Test Cases for Deployment Verification, ETL Data Validation, Test Scripts in DVO. Analyzed requirement updates and mapped them with the respective manual Test Cases using Informatica Power Designer.

●Involved in writing and maintaining Test scripts using Informatica Data Validation Option to perform Automation testing during the regression and integration testing phase. Reviewed the Business Requirement Documents and the Functional Specification.

●Through knowledge of Cognos development and testing, Cognos BI reporting and planning. Monitor Cognos environments to provide usage and performance metrics.

●Prepared Requirements Traceability Metrics (RTM), positive and negative test scenarios, detailed oriented Test Scripts, Test Kickoff documents, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use.

●Provided system analysis, design, development and deployment of Business Intelligence Applications. Written several complex SQL queries for data verification and data quality checks. Writing queries for fuzzy testing using SQL functions and executing those in DVO

●Worked with an offshore team also to improve process in the QA environment. In between Production implementation, execution of Back End testing and data retrieval for another project utilizing Informatica. Identified the bugs and interacted with the team lead and developers to resolve them.

Environment: SQL, Clear Quest, Informatica DVO, Agile/Scrum Methodology, Rational Tools, HP Quality Center, Informatica, Informatica Power Center, Informatica work flow manager.

Abn-Ambro, NY, USA

Functional Executive/ETL Tester

Duration: February 2016 – January 2017

Description: ABN-AMRO application is for commercial banking. This application used to maintain all commercial banking operations.

Responsibilities:

●Responsible for integrating with Facets .Designing test scripts for testing of Claims in Development, Integration and production environment. Collected requirements and tested several business reports.

●Analyzed the change detection process on Facets database tables to capture the daily changes done by Users through Online Facets Application. Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and Documenting the test results

●Performed Defect Tracking and Change Control Procedures using Rational Clear Quest, and Configuration Management and Version Control using Rational Clear Case. Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS. Involved in user training sessions and assisting in UAT (User Acceptance Testing). Written Test Cases for ETL to compare Source and Target database and Tested records with logical delete using flags

●Using Rational Clear Quest creating the defects which are related to Service plans and Service plan Ids and managing the same. Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center

●Prepared Test status reports for each stage and logged any unresolved issues into Issues log. Used PL SQL for Querying the SQL Server database for data validation.

●Involved with ETL test data creation for all the ETL mapping rules. Preparing and supporting the QA and UAT test environments. Tested different detail, summary reports and on demand reports. Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Contact this candidate