| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Data Engineer Quality Front Royal, VA Project Management, Systems Engineer, Testing,Quality and Acquis Upper Marlboro, MD Data Engineer Big Herndon, VA Data Engineer Big Herndon, VA Software Quality Assurance Engineer Centreville, VA Sr.Data engineer. Baltimore, MD Data Engineer Human Resources Reston, VA |
|
Click here or scroll down to respond to this candidateCandidate's Name
ETL-Tester/Data EngineerEmail: EMAIL AVAILABLEPh: PHONE NUMBER AVAILABLESummary: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 platformsExperience in Insurance, Health domain, sales and banking sectorExcellent 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 projectsExtensive 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 SQLExtensive 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 processesExcellent 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 FitnesseExperience in creating test pages using DB FitnesseExperience logging defects and tracking to resolutionExtensive 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) ServicesCreate the Regression Suite for API ServicesEducation:Masters in computer applications- 2000CERTIFICATIONS:Certified SAFe 5 Agilist.Certified SAFe 5 Scrum MasterTECHNICAL SKILLS:Databases: MS SQL Server Oracle, IBM DB2, Teradata, Informix, SQL Server, Postgres, HadoopClient-Side Skills: SQL, T-SQL, PL/SQL, UNIX shell scriptingETL & BI Tools: Informatica Power Center 9.x/8.x/7.x/6.x, Data stage, AWS Glue, BOXIR2(BusinessObjects), Cognos, Tableau, MicroStrategyOS: Windows 7, UNIX/Solaris, Red Hat LinuxMethodologies: Data Modeling Logical / Physical, Star/ Snowflake Schema, FACT & Dimension Tables, ETL, OLAP,AWS,AZUREAgile, RUP, Software Development Life Cycle (SDLC), SOAPUI, PostmanOffice Tools: MS Office suite (Word Excel, PowerPoint, Access)Tools: HP Quality Center, Test Director, JIRA, Bugzilla, Toad, Java,PythonAutomation Tools: Selenium, Db FitnesseETL-Tester/ Data Engineer Freddie Mac VA Mar 24 - Till dateProject Name: SaaS Cloud MigrationProject 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 FRDs and BRDs 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 24PPL 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 ProjectParticipated in the Requirement understanding discussion with Business and IT teams. Scheduling Requirement Clarification meeting with BA team.Responsible for proper test coverage of User StoriesPerformed 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 ObjectsInvolved 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 frameworkImplementation 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 DeliverablesFixing 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 basisPerformed 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 processWorked 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 notificationsResponsible for proper test coverage of User StoriesPerformed in creating test pages using DB FitnessePerformed automation testing using DB FitnesseAutomated test scenarios using SQL queries in DB FitNessePerformed 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 andproviding linkage to the respective Test Scripts.Prepared high level System Test Scenarios and Test Conditions for various functional segments. Workedon 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 ofreview 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 Reporttesting in Business ObjectsWritten 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 ofreview process and receive the Signoff approvals.Responsible for proper test coverage of User StoriesManually performed Smoke testing for basic functionality checking as Entry criteria for the SystemMonitor Daily smoke test reports. And tested manually, If any scenarios failedContributing to Daily releasesCreated 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) ServicesInvolved in Regression Testing using SeleniumRun your test suite using the chosen testing framework. For pytestPrepared 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 servers maintenanceMaintaining Test case document and enhancing whenever additional scenarios neededEnvironment: Informatica, AWS S3, Postman, DB Finesse, Selenium, Microsoft Office Outlook, Python,Oracle, SQL, PL/SQL, Web logic Server, Linux, WindowsETL- Senior QA (Jun 16-Aug18)NSCH (National School Clearing House), Herndon, VAResponsibilities:Understand the requirements for ETL process.Preparing test Plans for different modules in the ProjectParticipated in the Requirement understanding discussion with Business and IT teams. Scheduling Requirement Clarification meeting with BA team.Responsible for proper test coverage of User StoriesPerformed 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 ObjectsAutomated 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 FitNesseExperience in creating test pages using DB FitNesseExperience 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 reportsMaintained 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 FitNesseETL- Senior QA (Jan 16 - May16)MERKLE, Columbia, MDResponsibilities:Understand the requirements for ETL processResponsible for proper test coverage of User StoriesPerformed 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.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 ObjectsInvolved in validating the reports using HIVEQL Hadoop toolAutomated 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 sources and target for validating ETL jobs.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 parametersMaintained 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- Oct15)AVIVA (TCS-UK)Responsibilities:Preparing test Plans for different modules in the ProjectParticipated 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.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 ObjectsAutomated 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.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-MExperience 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 parametersMaintained 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 (Dec12 Feb14)AVIVA (TCS-IND)Responsibilities:Tested the database schema with help of data architects using ERWIN Involved in the testing of Data Marts using Power CenterIdentified 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 manipulationOptimizing/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-MProcessed 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 applicationExtensively 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 (Mar11 Nov12)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 ScriptsWritten 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 CenterWrote 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 TeradataManually performed Back-End testing by writing SQL queries and validating the database using Complex SQL Joins and FunctionsUsed 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 problemsCreated 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 ScriptsWritten 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 CenterWrote 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 TeradataManually performed Back-End testing by writing SQL queries and validating the database using Complex SQL Joins and FunctionsUsed 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 problemsCreated 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.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 EDWAnalyzed 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 flowConducted 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 |
