Sr ETL Tester

HIMAJA CH

Senior ETL Tester

Email: ********.*****@*****.***

Contact: 469-***-****

Professional Summary:

·7+ years of experience in QA Testing of software systems in Data Warehouse/ETL Testing for Client Server applications.

·Expertise in testing Complex ETL Mappings based on business user requirements and business rules to load data from source flat files and tables to target tables

·Extensively worked on the entire QA Life Cycle, which includes designing, developing and execution of the entire QA Process.

·Strong knowledge of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and QA Methodologies like Agile, Waterfall, and Iterative process.

·Strong Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.

·Strong experience in testing Data Warehouse (ETL) and knowledge on Business Intelligence (BI) applications.

·Extensive experience with ETL tools Informatica Power Center, Knowledge on IBM Data stage Ab Initio and DBeaver.

·Strong working experience in the Data Analysis and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)

·Extensively use of ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide- ETL Solution using Informatica

·Experience in maintaining Full and Incremental loads through ETL tools on different environments.

·Involve in preparing the Test Plans, Test Strategy documents, Test Cases & Test Scripts based on business requirements, rules, data mapping requirements and system specifications.

·Expertise in designing the test scenarios and scripting the test cases in order to test the application and Test Data Management Plan.

·Creation of test data and analyzing bug tracking reports

·Experience on Functional testing, System Testing, Regression Testing, Integration testing, GUI Testing, Smoke testing, System Integration Testing (SIT), Software Validation testing, UAT, Batch Testing, Interface testing, and Performance Testing.

·Working experience on ICEDQ tool.

·Extensive experience in writing complex SQL Queries.

·Expertise in test management using HP Quality Center, ALM and JIRA.

·Knowledge on Tidal Scheduling tool.

·Experience in preparing Requirement Traceability Matrix (RTM) documents.

·Aware of Slowly Changing Dimensions (SCD).

Technical Skills:

ETL Tools: Informatica Power Center 9.x/8x, 8/7.1.2 Data Stage, Ab Initio, ICEDQ

Analytics Tools: SQL

Others: MS Office Suit (Word, Excel, Power Point), MS Project)

Operating Systems: Windows 95/98/2000/NT/XP, UNIX

Languages: Basic Java, SQL

Bug Reporting: QC, ALM, JIRA

Data bases: Oracle 10g/11g, MS SQL, DBeaver.

Database Tools: TOAD 9.7.2, SQL Developer.

Education Details:

Bachelor of Computer Science and Technology, JNTU, 2012

Professional Experience:

E*TRADE- Alpharetta, GA Oct 2021 to Present

Sr. ETL Tester

ETrade is a financial services company headquartered in Arlington, Virginia, U.S. At ETrade, for any project execution, the team should follow secure SDLC process. The testing would be done here in ICEDQ tool.

Responsibilities:

·Established and documented ETL QA standards, procedures, and QA methodologies. Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.

·Analyzed business requirements, system requirements, data mapping requirement specifications, Tested ETL jobs as per business rules using ETL mapping document.

·Prepared the Test Plans, Test Strategy documents, Test Cases & Test Scripts based on business requirements, rules, data mapping requirements and system specifications.

·Extensively tested several ETL Mappings developed using DBeaver.

·Analyzed application data using SQL to identify ETL processes.

·Worked on Kanban framework in Agile Methodology.

·Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements.

·Validation of Metadata and Data Mapping.

·Validation done in ICEDQ tool and executed query in DBeaver tool.

Wells Fargo- VA May 2020 to Sep 2021

Sr. ETL Tester

Wells Fargo & Company is an American multinational financial services company with corporate headquarters in San Francisco, California. At Wells Fargo, for any project execution, the team should follow secure SDLC process. The team member must get approval of his design and other documents with Architect and the whole process should be reviewed with CFSR team. As part of compliance, this process must be automated.

Responsibilities:

·Established and documented ETL QA standards, procedures, and QA methodologies. Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.

·Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.2 Tested ETL jobs as per business rules using ETL design document.

·Prepared the Test Plans, Test Strategy documents, Test Cases & Test Scripts based on business requirements, rules, data mapping requirements and system specifications.

·Extensively tested several ETL Mappings developed using Informatica.

·Analyzed application data using SQL to identify ETL processes. Analyzed and tested ETL Informatica Mappings with source data, staging and target data.

·Wrote Informatica ETL design documents, established ETL coding standards and performed Informatica mapping reviews.

·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.

·Tested the ETL process for both before data validation and after data validation process.

·Tuned ETL jobs/procedures/scripts, SQL queries to improve the system performance.

·Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL Test loads.

·Involved in data warehouse testing by checking ETL procedures. Performed the tests in both the SIT, QA, and contingency/backup environments

·Extensively worked on various types of testing like ETL Testing, Integration Testing, Functional testing, Regression testing, Back-End testing

·Conducted UAT to confirm that all derivative products can be successfully processed through stages of the trade life cycle.

Capgemini, Bangalore, India Apr 2018 to Dec 2019

ETL tester, Consultant

Plant Cockpit is an enhancement project. This project is to create new warehouse to maintain customer information including the new sites. As an ETL Tester, I used to run workflows in staging area monitor and execute the test cases to verify the source, Staging and destination data.

Responsibilities:

·Worked with Business analysts to understand Business/System requirements in order to transform business requirements into functional test cases.

·Analyzed business requirements, scope documents and detailed functional requirements and to propose feature changes, determine and provide ETL testing effort estimates.

·Used ALM/Quality Center for writing Test Cases development, test script writing, Test case execution & Defect Tracking Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the data warehouse project

·Tested different DWH ETL Informatica Mappings especially are used effectively to develop and maintain the database.

·Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide- ETL Solution using Informatica

·Tested the ETL mappings output with the back end by writing test cases and SQL test scripts.

·Responsible for testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.

·Involved in ETL process for a Data Warehouse from their legacy systems using Informatica Power Center.

·Tested the ETL Informatica transformation and other ETL Processes (DW Testing)

·Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements. Verified session logs to identify the errors occurred during the ETL execution.

·Worked on ETL tool Informatica Mapping Designer, Workflow Manager, and Workflow Monitor.

·Wrote Test cases and SQL queries to validate the data pulled in from the Data Marts and populated.

·Wrote SQL queries in order to data validation in migration as part of backend testing.

Quess Corp, Bangalore, India Jan 2016 to Mar 2018

ETL tester

Highmark Group is a complete Life insurance project, and it is a web based. It is mainly focused on Life insurance for a customer. This product reduces the financial vulnerability to natural disasters through Life insurance coverage. It covers entire functionality for a customer from the policy issued date till to the policy renewal date. It broadly consists of following modules like Agent management, New Business Management, Policy Management, Product Management, Accounts, Reinsurance and Underwriting.

Responsibilities:

·As an ETL Tester responsible for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project using Informatica.

·Tested ETL mappings to extract and load data from different databases such as Oracle, SQL Server and flat files and loaded them into Oracle.

·Involved in testing the ETL mappings, by validating whether the mapping adhere to the development standards and naming conventions, whether the mapping work correctly in relation to other processes in your data logistical flow.

·Developed test cases and scripts for ETL rules in Quality Center Test Plan. Involved in preparing detailed Business Analysis documents, ETL design documents, unit test plans for the mappings

·Testing the ETL data movement from Oracle Data mart to SQL Data mart on an Incremental and full load basis. Involved in the error checking and testing of the ETL procedures and programs Informatica session log. Responsible in testing Initial and daily loads of ETL jobs.

·Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.

·Developed data quality test plans and manually executed ETL and BI test cases. Involved in data warehouse testing by checking ETL procedures/mappings.

·Preparing documentation for some of the recurring defects and resolutions and business comments for those defects

·Developed UNIX scripts to validate the flat files and to automate the manual test cases.

·Developing Test Matrix to give a better view of testing effort

Indi Technology, India Jun 2013 to Dec 2015

Manual Tester

Edukul is a communication platform which connects all stakeholders of an educational system (coordinator-Teacher-Student-Parent) and bridges the gap between them to alleviate mundane difficulties of traditional educational system. Where you can Create/Add School, Take/View Attendance, Timeline to share post, apply leave, add marks/view marks, create media, add news/achievements, add staff etc.

Responsibilities:

·Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes

·Responsible for creating complete test cases, test plans

·Analyzing requirements and creating and executing test cases

·Performing manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.

·Working with the Development team for process improvement and release planning

·Defect Management Using ALM

·Involved in different phase of testing i.e., System, Integration Testing, Functional Testing, Regression Testing, and Smoke Testing.

·Preparation of Bug summary reports.

Contact this candidate