Data Warehouse Etl Qa Analyst resume example

Environment: Informatica 8.6.1/9.1, SAP Business Objects , Oracle 11g, SQL, PL/SQL, UNIX, Shell Scripting, Microsoft SQL Server 2008, Control Version System, Data Center Manager, TOAD, Quality Center 10.0, Agile, Scrum, Abinito.

Description: Capital One is the Group's brand for a branchless direct bank. Its products include savings accounts, tax-free savings accounts (TFSAs) mortgages, retirement savings plans (RSPs), guaranteed investments (GICs), mutual funds, business accounts and no-fee daily checking accounts. Worked on different Projects like Home loans life cycle (measures the overall life of the loans from opening to funding), Money Saving Account (mapped related attributes into data warehouse), Mortgage Service Platform) conversion of Purchase loans into existing MSP Platform.

Responsibilities:

•  Worked in Agile Methodology consisting of daily stand up sessions, four week Sprints, Poker planning sessions and task cards.  
• Involved in functional, exploratory and Integration testing.
• Performed Data validity testing for Business Objects reports and feeds based on client's requirement.
• Validated format of the reports and feeds.
• Written SQL queries to access the data in SQL Server and Oracle database to execute back-end testing.
• Worked on SQL tools like TOAD, Oracle SQL Plus, and Rapid Sql to run SQL queries to validate the data.  
• Extensively used Informatica Designer, WorkFlow Manager, and Workflow Monitor for testing the mapping logic during functional Testing. Performed integrated testing, end- end testing and validated results with Business Analyst and/or customer.  
• Transformed and loaded the data into target database using Informatica Power Center.  
• Involved in migration of Informatica Mappings, Sessions and Workflows from development to System Test environment and execute the code in System Test Environment.  
• Validated Universes and Reports based on requirements documents, for supporting Reports creation using BI tool SAP Business Objects.  
• Creation of the special SQL Script files for Automation.
•  Updated weekly status on the testing progress and other concerned issues.
• Involved in Formal Reviews and walk through for preparing test plans and test cases.
• Test Case Management using Quality Center.  
• Written Test Cases for ETL to compare Source and Target database systems.
• Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Conducted regression testing on the application under test.

Environment: Datastage 9.1, Oracle 11g/10g, SQL, OLAP, PL/SQL, UNIX, Java, HTML, HP Quality Center 9.2.

Description: Citizens Bank, through its subsidiaries, provides retail, commercial, and corporate banking services principally in the United States. The company operates through three segments: Community Banking; Wholesale Banking; and Wealth, Brokerage, and Retirement. Plan sponsors are being reminded of their fiduciary responsibility to accurately determine and evaluate their plan fees. because of the multiple providers involved and the various ways fees are assessed, it can sometimes be difficult to determine who is receiving how much, and for which services, yet that information is necessary to determine if plan costs are fair and reasonable. Expense Project is based on calculating expenses over maintaining different retirement plans. It involves calculation of different Itemized, participant based and Asset based fees calculation and their distribution over the different retirement plans (FTE, FTE-Related, and Non-FTE).

Responsibilities:

• Involved in Test Requirement Analysis using Technical & Functional Specification documents.
• Participated in Business Walkthroughs to understand the Business functionality and its impact.
• Coordinated system test activities and necessities with business, development & pre-production groups.
• Prepared Test Plan, Test Cases based on BRD and Data Architecture Design for process and data testing.
• Developed complex test scripts / SQLs to perform data validations.
• Conducted test plan and test case reviews with project team and users. 
• Supported the code migration from System test to Production environment during deployment process.  
• Performed data analysis to understand the data transformation from source to target.
• Worked with software testing methodologies with all phases and stages of testing desired Functional, System, Integration, Regression, Data Validation, User Acceptance and Performance testing.
• Developed Traceability Matrix to match requirements.
• Participated in System specification and Design sessions.
• Reviewed System Specification and Design Documents.
• Prepared various documents like Validation Rules and Mapping Document.
• Documented Use Cases and Test Cases in Quality Center.
• Configured various SQL queries for validating Customer Profile and COPT Migration.
• Automated Query Validation using QA Framework.
• Created Stored Procedures to support QA Framework.
• Executed Test Cases and Validated Migration using the SQL queries.
•   Worked with Data warehouse developers who extensively used Informatica, ETL tool to design mappings to move data from source to target database-using Stages to understand the functionality.
• Used HP Quality Center for defect tracking and versioning documents. ·       Created ETL test data for all ETL mapping rules to test the functionality of the Mappings
• Tested the ETL Workflows and other ETL Processes (Data Warehouse Testing)
• Worked with workflow manager in scheduling workflows, worklets and tasks.
• Casual Analysis and Reporting of the Defects using Quality Center and Tracking defects through the closure.
• Analyzed the defects found during all the phases of testing and proposed Defect Prevention plans.
• Prepared defect status documents for daily review meetings.

Environment: Datastage 8.5, Oracle 10g, SQL, OLAP, PL/SQL, UNIX, Java, HTML, XML, Windows, DB2,HP Quality Center 9.1,Microstrategy,FTP.

Description: EmblemHealth, Inc., through its companies Group Health Incorporated (GHI) and HIP Health Plan of New York (HIP) provides affordable, quality health care coverage and administrative services to approximately 2.8 million people. Groups and individuals can choose from a variety of PPO, EPO and HMO programs as well as prescription drug, dental and vision plans. The project goal is to create data mart for analysis of current information on various Health Plans & doctors listed under these plans.

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads. ·       Written several shell scripts using UNIX Korn shell for file transfers, error log creations and log file cleanup process.
• Executing test scripts to verify actual results against expected results by using Datatsgae for different source validations.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity. ·       Involved in Development, Unit Testing, White box, Integration, Regression and Performance Tuning
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables. ·       Created ETL test data for all ETL mapping rules to test the functionality of the Mappings
• Tested the ETL Workflows and other ETL Processes (Data Warehouse Testing)
• Written several complex SQL queries for validating/verifying the business rules for Data.
• Worked with complex stored procedures and functions as per the requirements.
• Experienced in testing Mappings, Mapplets and Complex Transformations using Informatica Designer.
• Worked with workflow manager in scheduling workflows, worklets and tasks.
• Worked with Workflow monitor in order to monitor and troubleshoot the sessions.
• Responsible for Data mapping testing by writing complex SQL Queries using Query Studio
• Experience in creating UNIX scripts for file transfer and file manipulation.
•   Worked with Data Extraction, Transformation and Loading (ETL).
• Worked with business team to test the reports developed in OLAP
• Tested whether the reports developed in OLAP are as per company standards.
• Used Quality Center to track and report system defects
• Involved in raising bugs and bug tracking analysis to resolve issues.