Data Engineer Quality Assurance

Location:

Frederick, MD

Posted:

September 10, 2024

Contact this candidate

Resume:

Hemanth Kale

ETL-Tester/Data Engineer

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

Ph: 443-***-****

Summary:

I have more than 18 years of overall experience in Software Testing, ETL Testing, API testing, Automation Testing, And ETL development, Quality Assurance of Client/Server and multi-tier applications deployed on various platforms

Experience in Insurance, Health domain, sales and banking sector

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

Experience on Unit Testing, Smoke Testing, Functionality Testing, Integration Testing, GUI Testing, System Testing, Regression Testing, Sanity Testing, Performance Testing, Database Testing, User acceptance testing (UAT), Compatibility Testing and Product Assurance Testing for Web based and Client/Server applications.

Highly experienced in performing data quality test, data correctness test, data consistency test, and process interdependency tests to determine whether processed data is correctly extracted, transformed, and loaded.

Strong skills in data analysis, data requirement analysis and data mapping for ETL . And experienced in testing Data Migration processes and large projects

Extensive experience in writing complex SQL queries and PL/SQL scripts to validate the database systems and for backend testing.

Experience in snow flake testing using SNOW SQL

Extensive ETL testing experience using Informatica Power Center/ Data Stage (Designer, Workflow Manager, Workflow Monitor and Repository Manager)

Experience in Glue ETL jobs run as expected. checking And that the job script correctly performs data transformations and loads the data into the target data store.

Experience in writing and executing UNIX shell scripts to schedule and automate tests.

Designing, building, and maintaining test data for extract, transform, and load (ETL) data from various sources into data warehouses or data lakes.

Experience in Integrating data from multiple sources, including databases, APIs, and third-party services, ensuring data consistency and quality.

Experience in Implementing data quality checks to ensure the accuracy, completeness, and reliability of data. This often involves data cleansing and validation processes

Excellent working knowledge of designing & implementation of test strategy plans manually and automate test solutions for client/server and Web applications with Manual Testing.

Experience in bug tracking using Bug Tracking Tools -Mercury Quality center, Test Director, and Jira(SCRUM/AGILE methodology)

Experience in python tests for individual functions or methods. Use assertions to verify that the output of your functions matches expected results.

Experience in creating manual test cases from requirements, design, specifications and process flow diagrams.

Experience in automate tests using DB Fitnesse

Experience in creating test pages using DB Fitnesse

Experience logging defects and tracking to resolution

Extensive knowledge with dimensional data modeling, star schema/snowflakes schema, fact and dimension tables.

Worked on report level testing Business Intelligence tools like Business Objects and OBIEE.

Ability of mentoring and providing knowledge transfer to team members, support teams and customers. Excellent Communication, Analytical and Interpersonal skills.

Validate the API (Upload, Status, List, Download, Mfd, downloadpresignurl, Delete) Services

Create the Regression Suite for API Services

Education:

Master’s in computer applications- 2000

CERTIFICATIONS:

Certified SAFe 5 Agilist.

Certified SAFe 5 Scrum Master

TECHNICAL SKILLS:

Databases: MS SQL Server Oracle, IBM DB2, Teradata, Informix, SQL Server, Postgres, Hadoop

Client-Side Skills: SQL, T-SQL, PL/SQL, UNIX shell scripting

ETL & BI Tools: Informatica Power Center 9.x/8.x/7.x/6.x, Data stage, AWS Glue, BOXIR2(BusinessObjects), Cognos, Tableau, MicroStrategy

OS: Windows 7, UNIX/Solaris, Red Hat Linux

Methodologies: Data Modeling Logical / Physical, Star/ Snowflake Schema, FACT & Dimension Tables, ETL, OLAP,AWS,AZURE

Agile, RUP, Software Development Life Cycle (SDLC), SOAPUI, Postman

Office Tools: MS Office suite (Word Excel, PowerPoint, Access)

Tools: HP Quality Center, Test Director, JIRA, Bugzilla, Toad, Java,Python

Automation Tools: Selenium, Db Fitnesse

ETL-Tester/ Data Engineer – Freddie Mac VA Mar 24 - Till date

Project Name: SaaS Cloud Migration

Project Description:

Contacts & Counterparty MDM will provide contact and counterparty information that is extracted from multiple sources and then cleansed, standardized, mastered, and stored in Master Data Management repository to make it the new ‘best version’ authoritative source of truth of Contact data elements, validated by the data owners (for data quality purposes) and used by Single Family systems. Additionally, the data quality tool will be utilized to identify data irregularities and anomalies and prepare data for import into MDM and a workflow tool will be implemented to achieve controls and human task management.

Key Responsibilities include:

Involved in Business analysis and requirements gathering.

Validated transformations and load checks using Informatica tool for various file formats including error handling and notifications.

Validated data migration in On Prem and Cloud database built using IDQ & Informatica MDM.

Provided the client and stake holders with weekly QA documents via test metrics, and status reports.

Analyzed the business requirements and Functional Specs for developing Test Plan and the Test Strategy.

Wrote Test Cases for De dup & survival logic implemented the Business Rules as per the FRD’s and BRD’s provided.

Conducted Test plan reviews, Test case reviews.

Validated the source to target transformation mappings (ETL transformations) which extracts and loads from multiple sources and targets Postgres, Mango DB UI and Oracle databases and flat files, XML files, .csv files etc.

Validate that the output data from AWS Glue, matches the expected results. This could involve comparing the output data with known good data or running queries to verify correctness.

Validated data migration from On Prem base tables to Postgres.

Analyzed Functional Requirements, Data Models, use cases and developed Test Plans, Test cases and Test scripts and Traceability matrix.

Performed functional, integration, regression, system integration testing for this project.

Extensively used Sql Server/Oracle to write SQL Queries to verify and validate the Database Updates.

Written SQL queries to join tables and filter conditions to validate the data as per the Specifications documents checked for Referential integrity between tables in the Data warehouse.

Modified and maintained test cases as per the change requests.

Executing the SQL statements to extract data from tables to verify/validate the target tables as per the requirements.

Performed database backend testing by field level validation in SQL to verify data integrity and consistency.

Responsible for reviewing and modifying test scripts after initial iterations of testing phases to incorporate changes in project environment.

ETL-Tester /Data Engineer– Atlanta, GA (Remote) Aug 22 – Feb 24

PPL – First (www.pplfirst.com)

Description:

PPL First is Financial Management Services is Data Migration project. And provider for self-directing program participants, their families and workers based on programs covered, states and Managed Care Organizations served.

support individuals with disabilities or chronic illnesses and aging adults, eligible for public Medicaid assistance, to “self-direct” their own long-term home care. They have chosen to remain independent in their homes and active within their communities. This choice was made as an alternative to being admitted into restrictive long-term institutional care or using home-care agencies that offer them less choice and control over their support workers and services.

Responsibilities:

Gathered Functional Requirements from Business users.

Understand the requirements for ETL process.

Preparing test Plans for different modules in the Project

Participated in the Requirement understanding discussion with Business and IT teams. Scheduling Requirement Clarification meeting with BA team.

Responsible for proper test coverage of User Stories

Performed manual testing, functional testing and usability testing Responsible for Smoke Testing for the Build on Daily basis.

Prepared high level System Test Scenarios and Test Conditions for various functional segments. Worked on the Test schedules, Test estimates for the Test Script development and execution.

Written Test Cases for various functional segments based on the Detailed Business Requirement (DBR) documents, Detailed Technical Design (DTD) documents and Use Cases in Quality Center.

Responsible for Test Case Design, Test Scenarios walkthrough with Business and IT teams as part of review process and receive the Signoff approvals.

Manually performed Smoke testing for basic functionality checking as Entry criteria for the System Testing. Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Data Report testing in Business Objects

Involved in creating test cases based on business requirements and functional specifications.

Performed Integration testing, Smoke Testing, Functional testing, System testing and Regression testing, both manual and automated as applicable.

Performed End to End Testing, Group testing, UAT Testing, both manual and automated.

Updating and maintaining the defect reports in Jira for all the Defects found during Different stages of testing and followed the bug life cycle.

Written Test Cases for various functional segments based on the Detailed Business Requirement (DBR) documents, Detailed Technical Design (DTD) documents and Use Cases.

Written SQL queries and test cases for Back-End testing using SQL queries and executed them for Data Conversion using mapping documents.

Upload test cases in Test rail and generated Test Case Detail and Summary Reports.

Automating Web application using Selenium Web Driver with TestNG framework

Implementation of Automation framework using selenium. Implemented Data-Driven, Keyword Driven, Hybrid, Modular and BDD framework.

Writing Test cases, Test Scenarios, Test features using TypeScript in Gherkin language, Step definitions using TypeScript, Element locators, WebDriver methods, Java programming features and TestNG Annotations.

Analyzing the daily smoke test and weekly Regression test suites and reporting the same if any issues occur.

Wrote and execute complex SQL queries using Analytical functions (Rank, Dense_Rank,Row_number, Lead,Lag)

Triggering Automation test suite on demand and on Release process both Smoke and Regression suites analyzing and updating the same in Test Deliverables

Fixing the Automation failures if any in smoke and Regression suites in local and merge request in Repository.

Provide automation support for multiple streams during daily/interim/patching deployment.

Attend Lead and Managers meeting and update the tasks completed over the past fortnight.

Participate and improve the process of deployment in more optimized method.

Maintained daily and weekly System Testing status reports.

Performed multitasking and able to solve problems within team.

Mentor team members in Manual / Automation and help in reviewing scripts on regular basis

Performed as a Manual Tester as well Automated Tester to ensure the quality of product by Performing various testing.

Execute the scripts regularly and identify defects and address critical workflow in the system impacted by change requests.

Environment: Informatica10.5.2., AWS Glue, workauto, Netsuite, Azure 2022-11-02, SQL Server, Python, Test Rail, Selenium,, Microsoft Office Outlook, Oracle, SQL, PL/SQL, Web logic Server, Linux, Windows.

ETL- QA Aug 18 – Jun 22(Data Migration)

Enterprise portal Contract EPS/EPC - CMS (Centers for Medicare & Medicaid Services)

Responsibilities:

Participated in the Requirement understanding discussion with Business and IT teams. Scheduling Requirement Clarification meeting with BA team.

Understand the requirements for ETL process

Worked extensively with Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapping and Mapplet Designers.

The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.

Translated the business processes into Informatica mappings for building the data marts.

Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.

Used Workflow manager to create reusable sessions. Incorporated mail tasks for failure alerts and successful notifications

Responsible for proper test coverage of User Stories

Performed in creating test pages using DB Fitnesse

Performed automation testing using DB Fitnesse

Automated test scenarios using SQL queries in DB FitNesse

Performed manual testing, functional testing and usability testing Responsible for Smoke Testing for the Build on Daily basis.

Responsible for documenting the functional requirements in Quality Center within Requirement module and

providing linkage to the respective Test Scripts.

Prepared high level System Test Scenarios and Test Conditions for various functional segments. Worked

on the Test schedules, Test estimates for the Test Script development and execution.

Responsible for Test Case Design, Test Scenarios walkthrough with Business and IT teams as part of

review process and receive the Signoff approvals.

Manually performed Smoke testing for basic functionality checking as Entry criteria for the System Testing.

Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Data Report

testing in Business Objects

Written Test Cases for various functional segments based on the Detailed Business Requirement (DBR)

documents, Detailed Technical Design (DTD) documents and Use Cases in Rally.

Responsible for Test Case Design, Test Scenarios walkthrough with Business and IT teams as part of

review process and receive the Signoff approvals.

Responsible for proper test coverage of User Stories

Manually performed Smoke testing for basic functionality checking as Entry criteria for the System

Monitor Daily smoke test reports. And tested manually, If any scenarios failed

Contributing to Daily releases

Created Test cases Using Element locators and Selenium Webdriver methods.

Execution of Selenium Test cases and Reporting defects.

Conducting Data driven testing, cross browser testing and parallel test execution.

Validate the API (Upload, Status, List, Download, Mfd, downloadpresignurl, Delete) Services

Involved in Regression Testing using Selenium

Run your test suite using the chosen testing framework. For pytest

Prepared high level System Test Scenarios and Test Conditions for various API services.

Worked on the Test schedules, Test estimates for the Test Script development and execution.

Supporting EPOR API testing for Enterprise server’s maintenance

Maintaining Test case document and enhancing whenever additional scenarios needed

Environment: Informatica, AWS S3, Postman, DB Finesse, Selenium, Microsoft Office Outlook, Python,Oracle, SQL, PL/SQL, Web logic Server, Linux, Windows

ETL- Senior QA (Jun ‘16-Aug’18)

NSCH (National School Clearing House), Herndon, VA

Responsibilities:

Understand the requirements for ETL process.

Preparing test Plans for different modules in the Project

Participated in the Requirement understanding discussion with Business and IT teams. Scheduling Requirement Clarification meeting with BA team.

Responsible for proper test coverage of User Stories

Performed manual testing, functional testing and usability testing Responsible for Smoke Testing for the Build on Daily basis.

Prepared high level System Test Scenarios and Test Conditions for various functional segments. Worked on the Test schedules, Test estimates for the Test Script development and execution.

Written Test Cases for various functional segments based on the Detailed Business Requirement (DBR) documents, Detailed Technical Design (DTD) documents and Use Cases in Quality Center.

Responsible for Test Case Design, Test Scenarios walkthrough with Business and IT teams as part of review process and receive the Signoff approvals.

Automated and scheduled the Informatica jobs using UNIX Shell Scripting Tested SQL queries to validate the data and performance of the database Wrote complex SQL queries between source and target for validating ETL jobs.

Automated test scenarios using SQL queries in DB FitNesse

Experience in creating test pages using DB FitNesse

Experience in creating UNIX scripts for file transfer and file manipulation.

Provided the UAT and Production support for End to End Test Script execution and Defect retest. Good experience in onsite model work. Schedule and Co-ordinate testing tasks in QC.

Organize defect triage calls Development and Business team to resolve outstanding issues. Worked on Informatica Workflow monitor to run workflows.

Validated the BO Reports by checking the summary records and aggregate reports

Maintained Test Logs and Test Summary Reports and prepared Weekly Status Reports. Developed test cases to accomplish ETL data migration.

Designed the data for interpreting the positive/negative Scenarios.

Environment: SQL, PL/SQL, Informatica Power Center 9.1,ODI, OBIEE, SQL Server 2005, Hadoop(HIVEQL), Jira/Zephyr (SCRUM/AGILE), UNIX, DB FitNesse

ETL- Senior QA (Jan ’16 - May’16)

MERKLE, Columbia, MD

Responsibilities:

Understand the requirements for ETL process

Responsible for proper test coverage of User Stories

Performed manual testing, functional testing and usability testing Responsible for Smoke Testing for the Build on Daily basis.

Responsible for documenting the functional requirements in Quality Center within Requirement module and providing linkage to the respective Test Scripts.

Prepared high level System Test Scenarios and Test Conditions for various functional segments. Worked on the Test schedules, Test estimates for the Test Script development and execution.

Written Test Cases for various functional segments based on the Detailed Business Requirement (DBR) documents, Detailed Technical Design (DTD) documents and Use Cases in Quality Center.

Responsible for Test Case Design, Test Scenarios walkthrough with Business and IT teams as part of review process and receive the Signoff approvals.

Involved in validating the reports using HIVEQL Hadoop tool

Involved in Functional Testing, Regression Testing and Acceptance Testing.

Experience in creating UNIX scripts for file transfer and file manipulation.

Validated the BO Reports by checking the summary records in the cube equal the total of the detail records in the report when queried using the same parameters

Maintained Test Logs and Test Summary Reports and prepared Weekly Status Reports. Developed test cases to accomplish ETL data migration.

Designed the data for interpreting the positive/negative Scenarios.

Environment: SQL, PL/SQL, Informatica Power Center 9.1, Microstrategy,Business Objects, SQL Server 2005, Hadoop(HIVEQL), Jira/Zephyr (SCRUM/AGILE), Control-M,Quality Center 11, UNIX.

QA/ ETL Tester (Mar ‘14- Oct’15)

AVIVA – (TCS-UK)

Responsibilities:

Preparing test Plans for different modules in the Project

Participated in the Requirement understanding discussion with Business and IT teams. Scheduling Requirement Clarification meeting with BA team.

Prepared high level System Test Scenarios and Test Conditions for various functional segments. Worked on the Test schedules, Test estimates for the Test Script development and execution.

Performed manual testing, functional testing and usability testing Responsible for Smoke Testing for the Build on Daily basis.

Responsible for documenting the functional requirements in Quality Center within Requirement module and providing linkage to the respective Test Scripts.

Written Test Cases for various functional segments based on the Detailed Business Requirement (DBR) documents, Detailed Technical Design (DTD) documents and Use Cases in Quality Center.

Responsible for Test Case Design, Test Scenarios walkthrough with Business and IT teams as part of review process and receive the Signoff approvals.

Functional Testing, Regression Testing and Acceptance Testing.

Working with different customers and work with center of excellence groups in taking key decisions. Involved in extensive data validation using SQL queries and back-end testing.

Performed job monitoring testing using Control-M

Experience in creating UNIX scripts for file transfer and file manipulation.

Provided the UAT and Production support for End to End Test Script execution and Defect retest. Good experience in onsite model work. Schedule and Co-ordinate testing tasks in QC.

Organize defect triage calls Development and Business team to resolve outstanding issues. Worked on Informatica Workflow monitor to run workflows.

Validated the BO Reports by checking the summary records in the cube equal the total of the detail records in the report when queried using the same parameters

Maintained Test Logs and Test Summary Reports and prepared Weekly Status Reports. Developed test cases to accomplish ETL data migration.

Designed the data for interpreting the positive/negative Scenarios.

Environment: SQL, PL/SQL, Informatica Power Center 9.1, Business Objects, SQL Server 2005, Jira/Zephyr (SCRUM/AGILE), Control-M, Quality Center 11, UNIX.

QA/ETL Tester (Dec’12 – Feb’14)

AVIVA – (TCS-IND)

Responsibilities:

Tested the database schema with help of data architects using ERWIN Involved in the testing of Data Marts using Power Center

Identified and Documented additional data cleansing needs and consistent error patterns that could diverted by modifying ETL code.

Tested Business Objects reports migration and created Business Objects reports for defect tracking. Performed User Acceptance Testing and Regression Testing.

Participated in discussions with the business owners regarding rating test cases/results.

Wrote SQL and PL/SQL scripts to validate the database systems and for backend database testing. Wrote several UNIX scripts for invoking data reconciliation.

Created UNIX shell scripts for file transfer and file manipulation

Optimizing/Tuning several complex SQL queries for better performance and efficiency.

Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.

Performed job monitoring testing using Control-M

Processed a query to update a field in an Oracle database, to ensure that debt payments are allocated. Involved in System Analysis, Design and Development of the OLAP application

Extensively used Informatica client tools to extract data stored in database and for testing purposes. Environment: SQL Server 2005, SQL, Toad, Informatica Power Center 8.1, Unix, Windows XP/2000, Erwin, Business Object.

Environment: SQL, PL/SQL, Informatica Power Center 9.1, BusinessObjects, Jira/Zephyr, Control-M, Quality Center 11/HP-ALM, UNIX.

QA /ETL tester (Mar’11 – Nov’12)

ANZ (TCS-IND)

Responsibilities:

Functional and Technical understanding of the Claims domain data to validate the data obtained from the Healthcare insurance members.

Responsible for documenting the functional requirements in Quality Center within Requirement module and providing linkage to the respective Test Scripts

Written Test Cases for various functional segments based on the Detailed Business Requirement (DBR) documents, Detailed Technical Design (DTD) documents and Use Cases in Quality Center.

Performed the access check for all the databases, tools, servers and interfaces as Entry criteria for the System Testing.

Experienced in writing test cases, test scripts, test plans and execution of test cases Claims data reporting (Business Objects) using HP Quality Center

Wrote complex SQL queries between source and target for validating ETL jobs.

Used TOAD Software for Querying ORACLE, WinSQL for DB2, Teradata SQL Assistant for Querying Teradata

Manually performed Back-End testing by writing SQL queries and validating the database using Complex SQL Joins and Functions

Used Clear Quest to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems

Created test plans and performed unit testing for the Informatica mappings Involved in extensive data validation using SQL queries and back-end testing. Tested Business Object Reports for promps as well as for Data validation. Experience in creating UNIX scripts for file transfer and file manipulation.

Provided the UAT and Production support for End to End Test Script execution and Defect retest.

Environment: SQL, PL/SQL, Informatica Power Center 9.1, Cognos, Quality Center 11/HP-ALM, UNIX.

QA /ETL tester(Dec ‘08 – Feb ’11)

AUTODESK (CTS-IND)

Responsibilities:

Functional and Technical understanding of the Claims domain data to validate the data obtained from the Healthcare insurance members.

Responsible for documenting the functional requirements in Quality Center within Requirement module and providing linkage to the respective Test Scripts

Written Test Cases for various functional segments based on the Detailed Business Requirement (BRD) documents, Detailed Technical Design (DTD) documents and Use Cases in Quality Center.

Performed the access check for all the databases, tools, servers and interfaces as Entry criteria for the System Testing.

Experienced in writing test cases, test scripts, test plans and execution of test cases Claims data reporting (Business Objects) using HP Quality Center

Wrote complex SQL queries between source and target for validating ETL jobs.

Used TOAD Software for Querying ORACLE, WinSQL for DB2, Teradata SQL Assistant for Querying Teradata

Manually performed Back-End testing by writing SQL queries and validating the database using Complex SQL Joins and Functions

Used Clear Quest to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems

Provided the UAT and Production support for End to End Test Script execution and Defect retest.

QA/ETL Tester (May ‘07 – Dec ’08)

JPM Chase (WIPRO – IND)

Responsibilities:

Created Test Scenarios to Validate Data from source.

Validated data moving from source to ODS to EDW

Analyzed Functional Requirements and Use cases and developed Test Plans, Test cases and Test scripts and Traceability matrix.

Understanding the Star Schema and Snow flake Schema, relationship between Fact and Dimension tables.

Performed functional, integration, regression, UAT and end to end testing for this project.

Extensively used Oracle/Teradata to write SQL Queries to verify and validate the Database Updates.

Modified and maintained test cases with changes in application interface and navigation flow

Conducted weekly batch testing to incorporate changes in new builds.

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.

Provided the management with weekly QA documents like test metrics, reports, and schedules.

Prioritized and reported defects using Quality Center to present documents and reports in weekly team meetings.

Executing the SQL statements to extract data from tables and verify the output data with ref to user inputs from browser page.

Validated Adhoc Reports and Standard Reports.

Involved in testing reports and closely worked with operations, and Release teams to resolve the production issues.

Performed database backend testing by field level validation and stored procedures validation in SQL to verify data integrity and consistency.

Responsible for reviewing and modifying test scripts after initial iterations of testing phases to incorporate changes in project environment.

Worked extensively with mappings using aggregators, filters to develop and feed Data Mart.

Environment: Informatica

Contact this candidate