Post Job Free
Sign in

ETL Tester

Location:
United Counties of Stormont, ON, Canada
Salary:
100k/annum
Posted:
March 30, 2023

Contact this candidate

Resume:

Sri Vidya

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

Ph#: 704-***-****

Professional Summary:

Over 5+ years of experience in Web Services testing, ETL testing and manual testing on web based, Client/Server and data warehousing applications.

Good Experience with Software Testing Life Cycle (STLC): Requirements & Design Review, Test Planning, Test Execution and Test Reporting.

Expertise in analysis of User Requirement, Functional Specifications, Use Cases, Business Requirements to design Test Plan, Test strategy, Test Cases, Test Scripts etc.

Experience in Creating, Configuring and Fine-tuning ETL workflows designed between. Homogenous and Heterogeneous Systems using SSIS of MS SQL Server and MS SQL Server respectively.

Strong working experience on Extraction, Transformation, and Load (ETL) of data from Legacy systems using Informatica and Ab Initio.

Strong Data Warehousing ETL experience of using Informatica PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager, Teradata and Business Objects.

Extensive experience with Analysis, Test case plan designing, Metadata designing, designing Mapping sheet, ETL Designing, Testing, and Bug Analysis, Bug Reporting and Re-Testing and UAT.

Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion, and loading

Understanding of Data Models, Data Schema, ETL and created extensive store procedures, SQL queries to perform back-end data warehousing testing.

Experience in analyzing the error caused to failure of the ETL load with reference to the log file and report them to the corresponding team to get it rectified.

Expertise in logging and tracking defects using tools like VSTF/TFS, JIRA, HP Quality Center, Clear Quest, TrackWise, Test Director and other tools.

Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.

Experience in UNIX shell scripting and configuring cron-jobs for ETL Loads.

Strong expertise in STLC, GUI Testing, Functional Testing, System Testing, Integration Testing, Regression, Performance Testing, User Acceptance Testing and Back End Data Testing.

Ability to write and modify Complex SQL queries to identify ETL Processes.

Extensive experienced in Manual Testing and Database Testing (Oracle, SQL Server, Netezza).

Excellent analytical, problem solving, presentation, and interpersonal skills.

Good team player with excellent communication skills, vendor experience and ability to lead, manage, coordinate and work independently in a time sensitive environment.

Technical Skills:

Languages

SQL, PL/SQL, C JavaScript, Shell Scripting

ETL Tools

Informatica, Data Stage, Ab Initio, SSIS

Reporting Tools

Business Objects, Cognos, Crystal Reports, SSRS

Testing Tools

Quality Center, Jira, HP ALM. SOAP

Tools

TOAD, Win SQL, Teradata SQL Assistant

Tools

MS-Office suite (Word, Excel, Project and Outlook)

Databases

Oracle, MS SQL Server, MS Access, Teradata, DB2, Informix

Operating Systems

Windows, UNIX

Professional Experience:

Client: BBVA Bank, Birmingham, AL. Apr 2022 – Till Date

Role: ETL Tester

Responsibilities:

•Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.

•Tested the ETL process to automate the testing process and also load the test data into the testing tables.

•Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.

•Tested different detail, summary reports and on demand reports developed by Report Studio.

•Tested the Front-End Web Applications developed in J2EE for data portal for matching.

•Performed all aspects of verification, validation including functional, structural, regression, load and system testing

•Focused on Data Quality issues/problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.

•Written Test Cases for ETL to compare Source and Target database systems.

•Tested various ETL processes developed using ETL tools like Informatica Power center and Data stage.

•Responsible for verifying the log files using UNIX and database for the submitted application.

•Designed and developed UNIX shell scripts as part of the process, automate the process of loading, pulling the data.

•Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.

•Worked with Data Conversion projects for testing data quality after migration.

•Worked with High-Level Design of SSIS Packages for integrating data using OLEDB Connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.

•Utilized multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transforming and finally loading into the staging database.

•Implemented SSIS packages utilizing checkpoint, logging, breakpoint, and transaction options.

•Used SQL Loader for data retrieval and querying.

•Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.

•Production reconciliation was performed before the deployment of the developed application to the production systems to ensure that the data is being processed efficiently and to test the correctness of the data.

•Tested reports based on the statistical analysis of the data from various time frame and division using SQL Business Objects.

•Reported debuging using informatica and tracked defects using Quality Center/ALM.

•Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.

•Writing complex SQL queries for data validation for verifying the Informatica Packages and business Rules

•Written several complex SQL queries for validating Business Objects Reports.

•Tested all Business Objects Dashboards according to the requirement.

•Validate the business functionality using UAT Testing.

•Worked in AGILE Methodology and used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.

Environment: Informatica, SQL Server, Teradata SQL Assistant, Teradata, Business Objects, SSIS, Quality Center/ALM, Oracle, Agile and Windows.

Client: Citizens Insurance Jacksonville, FL. Feb 2021 – Mar 2022

Role: ETL Tester

Responsibilities:

•Analyzed the Requirements from the client and developed Test cases based on functional requirements, general requirements and system specifications.

•Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan

•Tested complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.

•Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data using Informatica.

•Tested Netezza database for Data Validation, Data Verification using NZ SQL.

•Developed the Test Plan and Testing Strategy for Data Warehousing projects.

•Tested the data load process using the Informatica Power Center ETL tool.

•Prepared documentation for all the testing methodologies used to validate the Data Warehouse.

•Performed extensive Database Testing by writing complex SQL Queries in DB2 to test the different scenarios in the application.

•Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).

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

•Involved in data warehouse testing by checking ETL procedures/mappings.

•Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.

•Involved in developing detailed test plan, test cases and test scripts using TFS (Team Foundation Server)

for Functional and Regression Testing.

•Involved in Unit testing and integration testing of Informatica mappings.

•Matrix, Test Cases, Expected Results and Prioritized tests for the applications for various modules using ALM/HP Quality Center.

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

•Used Quality Center to state requirements, test plan, test cases, and update test run status for each iteration and to report the defects.

•Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application.

•Reviewing the database Test cases and performs the Database Testing when writing the SQL queries.

•Reviewed the test activities through daily Agile Software development stand-up meetings.

Environment: ETL, Informatica Power Center, Netezza, Quality Center/ALM, UNIX Shell Scripting, TFS, SQL Server, Oracle, Agile and Windows.

Client: Target Corporation, Minneapolis, MN. Nov 2019 – Jan 2021

Role: ETL Tester

Responsibilities:

•Participated in requirements gathering sessions along with the business teams.

•Developed test scenarios and test cases based on the requirements.

•Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.

•Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.

•Performed ETL Testing (on Informatica and Teradata) on Data Warehouse to validate source to target mapping.

•Prepared the Test Plan and Testing Strategies for Data Warehousing Application.

•Developed high level ETL test matrix based on business requirements, ETL functional and ETL technical specifications, and development standards for assigned projects/applications.

•Created test cases based on test matrix including test data preparation for Data Completeness, Data Transformation, Data Quality, Performance and scalability.

•Executed ETL Test Cases and ETL Test Scenarios, executed Quality ETL Test Plans and ETL Test Cases to verify reliability, accuracy and Compatibility of application.

•Updated and maintained existing ETL test Matrix and ETL test cases based on code changes and enhancements to assigned applications.

•Coordinated User Acceptance and Quality Assurance testing of mainframe and GUI applications, identified test data, prepared user manual and conducted training seminars, installed applications on users.

•Performance monitoring for ETL Solution using project parameters, connection manager, and SSIS packages.

•Tested web services by generating XML SOAP requests and validated the corresponding XML SOAP responses.

•Developing Test Matrix to give a better view of testing effort.

•Designed Test Plans, Scripts after analyzing various scenarios/requirements & performed defect tracking using Jira.

•Used JIRA for Sprint storing creating, tracking and update for entire sprint.

•Created and executed test Plans, Test cases, Test cycles with in JIRA.

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

•Used SQL queries to perform the back-end testing on Oracle. Co-ordinate in application setup for UAT Testing.UAT Testing done based on UAT Test Cases.

•Working in Agile methodology environment.

•Tracked and reported the issues to project team and management during test cycles.

•Prepared weekly status reports and participate in weekly software/project meetings.

Environment: ETL, Informatica, SSIS, UNIX Scripts, Data Warehouse, SOAP, Jira, SQL, Oracle, Agile and Windows.

Company: iConcept Software Services Pvt. Ltd, India. Aug 2017 – Oct 2019

Role: ETL Tester

Responsibilities:

Involved in test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.

Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.

Involved in understanding the Requirements of the end Users/Business Analysts and Developed Strategies for ETL processes.

Involved in ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide- ETL Solution using ETL tools like Informatica and Data Stage.

Responsible for the requirements/ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.

Tested Informatica ETL mappings that transfer data from Oracle source systems to the Data Mart.

Involved in generating Test Scripts for different transactions to execute Functional Testing, Regression Testing and Acceptance Testing.

Used various SSIS tasks such as conditional split, derived column on the data retrieved, performed data validation checks during staging, and then loaded the data into the data warehouse.

Performed Database testing (Data Warehouse/ ETL) on ETL applications validating the data in Sources/Targets using Data Stage Client Tools.

Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements.

Involved in testing and writing complex SQL, T-SQL and PL/SQL statements to validate the database systems and for backend database testing.

Provided weekly status report and discuss issues related to quality and deadlines.

Environment: ETL, Informatica, SSIS, SQL, TSQL, Date Warehouse, and Windows.

References: Will be provided upon request.



Contact this candidate