SUMMARY:

Sr ETL Quality Analyst with over 7+ years of data warehousing experience in building and managing various data warehouses/data marts using ETL products along with hands - on experience of SDLC methodologies and Business Process Models (BPM) like Agile (Scrum and Kanban) Modelling and Waterfall model.

SKILLS:

Data Integrity

Data Transformation, database

Database Modeling

Data Model, db2

DBMS

MS SQL Server

SQL Server

SQL Server 2005

MySQL, OLTP

Oracle, Oracle 10, PL/SQL, SQL

SQL Queries, Stored Procedures

Big Data, Cassandra

Data Warehouses

Database Management System

Datastage, ETL

Flume,Hadoop

Informatica, Kafka, Marklogic, Metadata, Mongodb

Online Analytical Processing

OLAP, Power Bi, Teradata, Data Quality

Data Validation, HP Unified Functional Testing, QTP,Integration Testing

JIRA, QA Testing, Selenium,UAT, Agile, SCRUM, Hive, Natural,Python, Numpy

Pandas

Shell Scripting

Shell Scripts

Cognos

Tableau Software

Tableau, unix

Unix Shell

Data Warehouse

Data Warehousing

Ab Initio

Amazon Kinesis

Kinesis

Amazon Web Services

AWS

Asteradata

SDLC, crystal reports

SOA

Streaming

Web Services

Client-Server

CODA

Tivoli

Real-Time

QA

Test Scripts

Performance Testing

Test Cases

Test Plans

Validation Testing

TOPO

Mapping

Business Intelligence

BI, Cases, Documentation

Regression Testing, Offshore,Kanban, Scheduling, Golive, excel

EXPERIENCE:

Confidential

Sr ETL Tester

Responsibilities:

• Produced Test scripts, utilities, simulators, data sets, and different programmatic test tools as needed, performing test plans.
• Recognized important domains of business risk and revised the business process.
• Allotted work to offshore team members, know the status and coordinate with QA & Project Managers.
• Generated stored procedures to verify the data acquired.
• Proficient in database query tools for Oracle, SQL, and UNIX, like TOAD and SQL Plus.
• Utilized predetermined UNIX scripts for file transfer and file manipulation as part of the Test Data arrangement.
• Conducted Functional, Integration, and Regression testing, examining ETL sessions and PL/SQL scripts for multiple feeds and multiple LOB's.
• Proficient in interpreting the Data Model in the Data Warehouse that comprises of Dimension and Fact tables.
• Utilized Toad to communicate with Databases.
• Implemented metadata verification, performance testing, source to target data validation, and relevant error handling in ETL processes.
• Increased production reliability by writing automated tests in Python. Attended regular SCRUM meetings and presented the team with test outcomes and performance enhancements required.
• Performed Data Completeness, Data Transformation, Data Quality, Integration testing, UAT, and Regression testing.
• Utilized Quality Center for generating and writing ETL Test Plans and ETL Test Cases and register the demanded results.
• Implemented Tuning of DataStage Jobs for more reliable performance.

Environment: DataStage, Teradata, Oracle, Hadoop, HIVE, Business Objects, Tableau, Control-M, Agile Scrum

Confidential

Sr ETL QA

Responsibilities:

• Wrote test scenarios and test scripts for verifying end - to-end data and source and target in ETL flow design.
• Managed the requirements traceability matrix to check every condition was met according to the established business processes and specifications.
• Cooperated with QA team on utilizing documentation criteria to generate and evaluate Test plans and test cases.
• Refreshed Stored Procedures and Functions to produce reports depending on the downstream conditions (Naming Standards, data types).
• Recorded complex SQL queries to implement data validation for RI checks for history and incremental loads.
• Verified BI reports utilizing Business Objects
• Designed UNIX scripts for file transfer and file manipulation.
• Conducted backend testing for Database integrity by performing complex PL/SQL queries for verifying the data in the backend database tables.
• Participated in the testing of the source Database and the target Data warehouse to guarantee data integrity. Utilized TOAD, DB Artisan tools(9.0) to join to Oracle database to authenticate the data.
• Performed data validation, data comparison as per the business logic associates the source to the target. Performed automation testing of ETL flows using Python.
• Used QC to prepare test documents and document test outcomes, and follow the requirements.
• Generated Test Scenarios & Test Cases with the UAT Team and the Business Analysts.
• Worked with the development team depending on the mapping document to examine and sign off the ETL design document.
• Committed to Integration testing of DataStage mappings.

Environment: s: Informatica, Oracle, SQL Server, MongoDB, MarkLogic, Kafka, Crystal Reports, Power BI, Autosys, Agile Scrum

Confidential

ETL Quality Tester

Responsibilities:

• Administered both QA and UAT test cases and test scripts for outside and inside agents and implemented QA Testing.
• Directed walk - through with the Business Analysts and QA Managers to simplify crucial problems associated with the Business Requirement Document.
• Generated several PL/SQL stored procedures for producing a Natural Key Comparison, Surrogate Key checks between Production and Test environments.
• Engaged in testing and writing different reports and verification of the data by utilizing SQL queries.
• Examined UNIX Shell scripts to automate repeated database methods and managed shell scripts for data transformation.
• Automated commonly employed test cases utilizing QTP Extensively applied SQL and PL/SQL for data integrity examination at the backend.
• Tested and verified data from the data warehouse and transferred it to SQL Server 2005.
• Generated nested Queries and implemented data loss or truncation testing utilizing Oracle 10.g. Implemented Data Validation Testing utilizing TOAD.
• Served with the different teams for examining data quality, data integrity, data consistency, and data validation.
• Developed python script to enhance existing test automation framework.
• Verified the test outcomes with the team members and presented them with the business.
• Involved in recording bugs, fixed defects, and communicated with the UAT team to get sign-off for the application/project.
• Utilized STM- Source to target mapping document to learn ETL end-to-end flow of data in ETL design.
• Managed DataStage jobs and logged files to control the test runs. SOA testing was completed on a top-down approach basis.

Environment: SSIS, SQL Server, MySQL, Tableau, Control-M, Waterfall