PROFESSIONAL SUMMARY:

• 7 years of IT experience in providing Quality Assurance (QA) services for Data Warehousing/ ETL, Business Intelligence, Big Data/Hadoop, Java, Web - based, Mobile, Cloud, ERP applications in Healthcare/Hospital Management, Financial/Mortgage, Banking.
• Has experience in preparing Master Test Plans, Test Strategy documents, reviewing Test cases, Test scripts, Test execution check list.
• Excellent experience in writing and executing Test Catalogs (Scenarios), and Test Cases/Test Scripts based on business requirements, rules and system specifications.
• Experience working wif different SDLC Methodologies like Agile/Scrum, and Waterfall.
• Experience in Functional testing, ETL Testing, Data Migration Testing, Database Testing, System testing, Regression testing, Integration testing, GUI testing,Automation testing, Load testing, Interfaces testing, BOTs Validation (RPA), testing, Performance Testing, System Integration Testing (SIT), and UAT (User Acceptance Testing).
• Experience in Test-Driven Development frameworks to deliver quality application.
• Excellent experience in creating and using automation frameworks on Python, Cucumber, SoapUI.
• Excellent experience working wif cloud technologies such as AWS S3, EKS, Azure Data Factory, Databricks, Snowflake.
• Experience in testing Web Services, Micro Services, APIs using Postman, Swagger, SoapUI.
• Excellent experience working wif different ETL tools such as Informatica, DataStage, Azure Data Factory, Airflow, Talend, SSIS, Ab Initio
• Experience in Data Analysis, Data Profiling, Data Validation, Data Cleansing, Data Verification, Data Mining, Data Mapping and identifying Data Mismatches.
• Excellent experience working wif different reporting tools including Tableau, Cognos, SSRS, Business Objects, MicroStrategy.
• Experience working wif different data formats such as ORC, Parquet, Avro, Json files.
• Expert level skills in Testing Enterprise Data Warehouses and BI Reporting applications.
• Experience in preparing Requirement Traceability Matrix (RTMs), Defect Reports, Test Summary Reports, Burn down Charts, and Weekly Status Reports.
• Excellent skills in overall Defect Management/Problem Solving, which includes reporting and tracking bugs using HP ALM/Quality Center, Rational Clear Quest, Rally, JIRA, Microsoft TFS.
• Experience working wif Batch Scheduling Tools (Autosys & Tivoli).
• Has experience inmanaging DataMigration Projects.
• Excellent problem solving, troubleshooting and debugging skills.
• Excellent technical, documentation, communication and written skills. Quick learner wif an aptitude of taking responsibilities.

TECHNICAL SKILLS:

Cloud: AWS, Azure, Databricks, Azure Data Factory

Bigdata: Hadoop Eco System, Spark, HDFS, Kafka, Hive

Cloud DBs: MongoDB, PostgreSQL, Snowflake, redshift

Programming Languages: Python, SQL, PL/SQL, T-SQL, JIL

Scripting Languages: Unix Shell scripting, VB Script, Java Script

RDBMS: Oracle, DB2, Teradata, SQL Server

DBMS Tools: TOAD, Oracle SQL Developer, Rapid SQL, SQL Navigator, WinSQL, Teradata SQL Assistant

Test Management/Agile Tools: HP ALM, HP Quality Center, TFS, Rally, Jira

QA Automation Testing Tools: HP UFT, Selenium

Defect/Bug Tracking Tools: IBM Rational Clear Quest, Jira

Version Control / Requirements Tracking Tools: IBM Rational Clear Case, BOX, MS SharePoint Rational Requisite Pro, Teleologic DOORS

Incident/Change Management Tools: BMC Remedy, Ticket Tracker

Data Modeling Tools: Erwin, MS Visio

ETL Tools: IBM Data Stage, Informatica Power Center, Ab Initio, SSIS, Talend, Airflow, Azure Data Factory

BI/Reporting Tools: IBM Cognos Reports, SSRS Reports Business Objects BOXI, MicroStrategy, Tableau

ERP Tools: PeopleSoft Financials/HRMS/CRM, SAP

Scheduling Tools: Autosys, Control-M, Tivoli

Other Tools: PuTTY, WinSCP, TextPad, Notepad ++, SnagIT

Operating Systems: Microsoft Windows, Linux, Apple iOS, HP-UNIX, Solaris UNIX, IBM-AIX

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. ETL Tester/QA | BI Reports QA

Responsibilities:

• Analyzed and reviewed business requirements (or user stories) and rules and determine teh project scope, effort estimation, timeline, and QA strategy.
• Compared teh data being loaded from Oracle and DB2 into Hive and then into Snowflake using Python and SQL.
• Developed Test automation frameworks by using Python to compare data between different sources and targets.
• Performed all teh activities related to Quality Assurance during sprint cycles.
• Validated teh Talend ETL jobs for teh initial and incremental loads.
• Developed test cases and test scripts according to data mapping documents and functional specification documents for ETL/Data Warehousing and Data migration projects.
• Validated Tableau BI reports/dashboards according to teh BI reporting specification documents and wif respect to teh source data in Data warehousing applications.
• Developed complex SQL queries or scripts to validate teh completeness, integrity, and accuracy of data.
• Performed web service, API testing by using Postman and Soap UI.
• Validated teh ETL data being loaded from Hive tables into S3 and then into Snowflake.
• Perform defect tracking and reviews, verify test results, and document teh defects.
• Validated teh data migration from SQL server to Snowflake performed using Talend.
• Validated teh informatica mapping and workflows for batch, ETL and data migration testing.
• Worked on validating teh data from different sources such as Oracle, SQL server, XML/Flat files loaded into HDFS and Hive in Parquet and ORC formats.
• Validated teh migration of Talend jobs from on premise to cloud.
• Ensure dat all project deliverables meet quality objectives in data, functionality, performance, and stability.

Environment: Python, Talend ETL tool, Tableau, SQL, XML, Excel, Oracle 19c, Toad, PostgreSQL, Web Services, Postman, Jira, WinSCP, Git, Snowflake, HDFS, Hadoop, Data Lake, AWS, S3, EKS, Informatica, Cognos, PyCharm, Jupiter notebooks

Confidential, Richmond, VA

Sr. ETL QA Analyst/API Testing

Responsibilities:

• Analyzed business requirements and identified gaps, determined ETL QA Testing effort estimates.
• Prepared ETL Test Strategy documents according to teh data flow, data mapping requirements, technical and functional specification documents.
• Involved in extensive data validation using SQL queries for ETL/ back-end testing.
• Provided updates in daily Scrum call and Ensure team updated hours in Rally.
• Validated teh ADF control flow and data flow activities for data integrity, completeness and accuracy.
• Involved in assigning teh Story Points during back log grooming and provided/reviewed teh time estimates on teh tasks for iteration planning.
• Validated teh data between source and target databases by writing SQL statements.
• Actively participated in sprint meetings such as Daily Standup meetings, Sprint Planning, Backlog Grooming, Sprint Demos and Sprint Retro.
• Validated teh SSIS packages wif teh data mapping specification documents.
• Constructed SQL queries wif multiple joins, indexes, temporary tables, analytical functions, and sub-queries linking by unions, intersection, and minus operators etc.
• Validated teh data loaded from SQL Server, Oracle into Azure Delta Lake.
• Validated several jobs in Databricks. Verified teh cluster configuration, schedule, execution and teh data processed for each of teh jobs.
• Created python scripts for data comparisons between databases, delta lake and files.
• Scheduled and monitored teh test cases execution.
• Scheduled triage meetings to keep track and level of severity defects and communicating it wif Project Managers.
• Validated teh SSRS reports for data and layout according to report specification documents.
• Worked closely wif development team, release engineers, business analysts, database developers and product owners to diagnose technical and quality issues, identify potential software limitations, resolve defects and verify corrective actions.

Environment: Python, Azure Data Factory (ADF), Azure, Delta Lake, Databricks, SSIS, SSRS, Microsoft SQL Server, SQL, VS Code, PyCharm, Agile/Scrum, Rally, Oracle, Autosys, MicroStrategy, XML, XML Spy, PeopleSoft, Postman, WinSCP

Confidential, Charlotte, NC

Sr. ETL QA Engineer/ BI Tester

Responsibilities:

• Performed functional and exploratory testing for new features wif expanded test coverage.
• Tested teh data ingestions from different data sources including Parquet files, XML files, JSON, different databases such as Oracle, DB2, SQL Server and flat files.
• Responsible to verify web services API request, response data validations in REST, SOAP protocols. Performed API testing wif Postman and Swagger.
• Written SQL for validating teh data from staging tables to EDW and then to reporting layer.
• Ran IBM Cognos reports and validated report data as per teh business user requirements.
• Validated teh ETL jobs for initial and incremental loads according to teh user stories and data mapping documents.
• Validated teh cognos reports for teh data shown on them, along wif teh report layout and other features on reports.
• Validated teh data between source Oracle and target MongoDB using python scripts.
• Evaluated business requirements and technical specification documents to craft test strategies and LOE assessments which would account for durations, constraints, assumptions, etc. dat are required to accomplish test objectives.
• Validated teh data between files and database using python scripts.
• Involved in assigning teh Story Points during back log grooming and provided/reviewed teh time estimates on teh tasks for iteration planning.
• Wrote test scripts for new mobile functionality as well as new test cases to fill gaps in teh testing process when defects were found.
• Attended triage and cross functional meetings to facilitate direction, discuss teh priorities of defects logged and delivery time.

Environment: IBM Data Stage, Jira, MongoDB, IBM DB2, Oracle 12c, SQL, PL/SQL, Toad, Teradata 15, Teradata SQL Assistant, AWS, S3, Python, PyCharm, Agile/Scrum, Cognos, XML, Mobile App Testing, Soap UI, Autosys, Web Services, Unix

Confidential (Healthcare), Nashville, TN

ETL Tester

Responsibilities:

• Understood teh business process and validated ETL jobs according to teh data mapping.
• Involved in validating BI Report and Dashboards according to teh report specification documents.
• Written several SQL scripts for validating ETL jobs and BI Reports.
• Generated Bug Reports and Test case coverage reports for status meeting and also involved in resource planning for test cases coverage
• Performed regression testing by repeated execution of test cases in each build by logging defects using Jira.
• Verified teh session and workflow logs in Informatica Workflow Monitor.
• Performed Data Migration testing by writing queries to run against both teh source as well as teh target databases.
• Tested teh different sources such as Flat files, Main Frame Legacy Flat Files, SQL server 2005 and Oracle to load into teh Oracle data warehouse.
• Validated teh Informatica workflows using Informatica DVO by creating table pairs and generating teh tests.
• Has tested different Informatica transformations like Source Qualifier,Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations.
• Validated teh data, prompts, filters and layout of teh business object reports.
• Worked in agile development process and was involved in daily stand up meetings, story reviews, sprint planning and retrospectives.
• Executed teh Ab Initio graphs from GDE and validated teh data according to requirements.
• Tested data migration to ensure dat integrity of data was not compromised.
• Verified teh ETL log files to identify teh errors whenever their are issues wif execution.
• Was responsible for teh project management, supervision, and coordination of system testing for all assigned releases.
• Developed and reviewed teh software test cases, scripts and other documents surrounding testing activities and ensured dat all teh testing activities and deliverables are conducted or produced in compliance wif company standards.
• Verified entrance exit criteria are met for different types of QA testing such as functionality testing, regression testing, performance testing, and volume testing.
• Performed teh impact analysis and gap analysis for resolving Change Request issues.
• Attended teh daily scrum meetings, documented teh test activities.

Environment: Ab Initio, Teradata, Informatica Power Center 9.5, DVO (Data Validation Option), GitHub, Python, HP ALM 11, Oracle 11g, SQL, PL/SQL TOAD, Unix, Business Objects, Putty, SharePoint, WinSCP, XML, XSD, XML Spy, SOA, Soap UI, Jira, Agile/Scrum, Windows.