SUMMARY:

9+ years of experience as a Software Quality Analyst & and ETL Tester with experience in performing ETL, BI, backend manual testing with a solid understanding of SDLC lifecycle. Experienced in API Testing, Black Box testing, Integration, Regression, Data warehouse testing, Functional and Front - End testing.

SKILL:

Scheduling: Control-M, Tivoli, Autosys.

ETL: Talend, SSIS, Azure Data Factory, DataStage, Informatica, Ab Initio.

Cloud Technologies: Microsoft Azure, MS Office 365, AWS - Amazon Web Services,Azure Devops.

Jira Test Management Plugins: Golive, Zephyr, Xray and TestFLO, QMetry, QAlity.

Databases: SQL Server, Oracle, DB2, MySQL, Teradata.

Real-Time Data Streaming: NIFI, Kinesis, Kafka, Flume.

Methodologies: Waterfall, Agile Scrum Methodologies, Kanban

Big Data: HIVE, Cassandra, MongoDB, MarkLogic, SnowflakeHadoop.

Python Libraries: Selenium, Numpy, FakerPandas.

Reports: Business Objects, Cognos, Microsoft Excel, Crystal Reports.

Business Intelligence: Microsoft Power BI, Alteryx, Tableau.

EXPERIENCE:

Quality Analyst

Confidential, Chicago, IL

Responsibilities:

• Generated Test Strategy, Test Plan, Test Cases, and Test Scripts according to business requirements and recorded them.
• Coordinated with QA Manager and Head weekly with the testing standing, concerning Test Task Plan, Defect Management.
• Examined Oracle PL/SQL Stored Procedures, Packages, Triggers, Cursors, and backup - recovery for the various tables.
• Validated the source to target data migration and check the target data by documenting SQL queries.
• Participated in generating UNIX and VB scripts for testing and recorded entire software testing processes.
• Performed shell scripts to run PL/SQL programs, Cognos reports from Autosys, and jobs.
• The project scope included developing an enterprise data warehouse for the client incorporating its Stocks and Sales.
• Performed Functional and Integration testing TOAD to execute a manual test periodically.
• Performed data verification testing and generated the Test Plan, Testing Strategy, RTM, and Test Cases.
• Developed automation scripts in python for ETL applications.
• Controlled test outcomes and weaknesses by the Quality center.
• Rendered on-call assistance to the UAT team and the business teams associated with the UAT testing.
• Generated ETL test data for all ETL graphs based on conversion rules to examine the application's functionality.
• Examined DataStage jobs to obtain data utilizing IDoc Extract Stage, refined the data, and loaded them into the data mart.

Quality Analyst

Confidential, Philadelphia, PA

Responsibilities:

• Developed and implemented automated test scripts according to business requirements and Requirements specifications Document.
• Business process and generated test cases by analyzing Business Requirement Document.
• Proficient in generating test designs by utilizing ALM/quality center tracked the defects and reported the QA lead defects.
• Attended daily SCRUM meetings and provide the team with test results and performance improvements needed.
• Examined complicated business scenarios by examining data across various databases using SQL Queries, Stored Procedures, and user - defined functions.
• Utilized Quest Software's Toad application to set up data, design, and perform SQL script on Oracle 11g database.
• Created the Perl and UNIX Shell script to match the flat file with the database content as per the Business requirement.
• Served extensively with SQL, ANSI SQL, and PL/SQL queries to test database functionality.
• Conducted data validation against the Data warehouse.
• Conducted comprehensive Report Testing of the reports generated by COGNOS using Query Studio and Toad.
• Conducted browser compatibility testing on various platforms and data validations for all reports.
• Ran automation scripts and updated the scripts according to enhanced requirements using selenium WebDriver and Python.
• Administered variance management by examining and verifying test results, presenting status and progress reports using Quality Center.
• Served with UAT(User Acceptance Testing) activities and administered connectivity tests with interfacing applications and end-users.
• Approved complex ETL DataStage jobs based on Business requirements and Business rules to load data from source files to target tables.
• Utilized DataStage to move data to the warehouse utilizing the Stored Procedure, thereby enabling faster moments of data.
• Experience with Risk-Based Testing during which identified critical areas of business risk and modified the business process.

QA ETL Tester

Confidential, Manhattan, NY

Responsibilities:

• Wrote and processed quick test scripts through the expert view by adding conditional statements, loops, and other user - defined functions.
• Generated Test cases, Testing Strategies, and RTM to guarantee proper coverage of requirements and business processes.
• Supported QA execution to guarantee the accuracy of data flowing through each stage of the ETL process.
• Utilized Shell scripts significantly for automation of file manipulation and data loading procedures.
• Shipped data from tables in one schema to CSV files and exported to tables from another schema utilizing SQL* Loader.
• Generated Jobs to Written several UNIX Shell Scripts for cleanup, logging, file manipulation, and transferring the files.
• Presented design direction and oversight of code development in Ab Initio, KSH, and PL/SQL.
• Examined loaded data warehouse components like ODS (Stage), EDW, and data marts tables following the jobs run.
• Test Business Objects reports for data validations and examine results with TOAD.
• Conducted additional data validation using custom SQL scripts.
• Develop automation test scripts for data created using a Python library called Faker
• Launched and Involved in Test Design, Test Plan, conduct audits, Test Development, and analyzing Test Results.
• Conducted UAT (User Acceptance Testing) and administered to verify the applications' requirements, look, and feel.
• Worked closely with Test Lead for managing three ETL testing teams.
• Worked with DataStage Shell Commands and reviewed the job status.

QA ETL Tester

Confidential, Salt Lake City, UT

Responsibilities:

• Generated manual test scripts including various scenarios and documented them in Jira Plugins like Zephyr, Xray, QMetry, QAlity, Golive, and TestFLO.
• Examined Business Requirements, System requirements and manage Business process impacts.
• Mentored and led the QA team members to review specifications, technical designs, test cases, and defect tracking.
• Served closely with application development teams to guarantee adherence to design specifications, proposed procedures, practices, and standards.
• Built the Unix Shell script to load the high - volume flat files data into staging tables utilizing Oracle SQL* Loader.
• Examined various UNIX Shell Scripts and PERL scripts for data loading, data parsing, file manipulation, and text processing needs.
• Participated in writing SQL scripts and analyzing PL/SQL scripts for effective Data validation.
• Generated Data warehouse test plans, UAT plans, test cases based on the ETL mapping document and functional design documents.
• Utilized Toad and SQL Plus for test execution of ETL Processes for business rules.
• Examined several data validation jobs developed in the Data Stage environment.
• Overhauled a continuous coding algorithm for data collection and analysis from sterilization equipment using Python libraries
• Worked with Release coordinators in guaranteeing the timely transfer of test environments and test results.
• Participated in Integration testing, UI, User Acceptance Test (UAT), Functionality testing & Performance testing.
• Designed and performed ETL test plans, ETL functional test cases (Manual Testing), and Coordinating Integration for DWH.
• Produced various test Batch jobs to run and monitor a group of jobs with the DataStage Director.

Manual Quality Analyst

Confidential, Long Island City, NY

Responsibilities:

• Corresponded Essentials to test scripts in Jira Plugins like Zephyr, Xray, QMetry, QAlity, Golive, and TestFLO.
• Participated in systems design and execution of standardized business processes.
• Throughout the test on the Quality center, documented bugs and communicated, recorded issues to the responsible QA or development personnel.
• Committed to producing and regulating Modeling standards, Operation procedures, and new development areas.
• Designed and managed SQL Scripts using SQL Developer to verify data in the database matched date in the front end.
• Planned and produced UNIX commands as part of the ETL process, automated loading, and pulled the data.
• I authenticated the creation and maintenance of the data warehouse using PL/SQL.
• Controlled SCD Type 1/ Type 2 to populate prevailing and historical data to Dimensions and Fact tables in the data warehouse.
• Utilized TOAD for Oracle in generating and completing SQL queries for testing the ETL process.
• Presented data validations and data profiling in the staging area.
• Created Selenium web - driver automation scripts using Python to validate functionality on various browsers.
• Handled Functional and Back End testing, demonstrated the test results for completed user stories, and got approval from product owners.
• Associated with various UAT process flows between the two systems and reporting to the PMO of all findings.
• Examined the data acquisition process (ETL - IBM DataStage 7.8) within the Status-one to confirm the data load.
• Engaged with using Job Parameters, Parameter Sets while devising DataStage jobs.