SUMMARY:

• 8+ years of experience in ETL / Data Warehousing / Business Intelligence Quality Assurance Testing of various business applications in Client /Server environments and Data Warehousing solutions.
• Expertise in Writing, Executing and Maintaining Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases .
• Strong knowledge of SDLC and Software Test Life Cycle and highly proficient in SQA methodologies for Waterfall, Agile.
• Have solid experience on database query tools such as TOAD, SQL Navigator, SQL Assistant and SQL Plus.
• Involved in all testing phases of a Data warehouse projects that includes Requirements Gathering, Analysis, Testing Estimations, Testing for end - to-end IT solution offerings.
• Extensive Experience in Quality Center which includes Uploading Requirement, Preparation of Test cases and uploading, Execution of Test Cases, Logging & tracking Defects, Preparation of Metrics and Preparing Status reports for test design Phase and Execution Phase.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing in a corporate-wide-ETL solution using ETL tools like Informatica, SSIS, Abinitio
• Strong in databases including Oracle, MS SQL Server.
• Performed Functional testing, Integration testing, System testing, Regression testing, and Smoke Testing.
• Extensive experience in writing SQL to validate the database systems and for backend database testing.
• Experience in Manual Testing & Knowledge of QTP& Selenium .
• Good knowledge in Data Warehousing concepts, SQL, UNIX.
• Experience in testing of Big data.
• Well versed with MS Office Word, Excel and Power point.
• Well versed with SharePoint usage.
• Proficiency in understanding of business processes involved in testing of projects.
• Excellent analytical, problem-solving, communication and interpersonal skills.
• Self-motivated, energetic team player with demonstrated proficiency for learning new tools and business environment.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.6/9.x, SSIS, Ab Initio

QA Tools: ALM 12

DBMS/Query Tools: TOAD, SQL Developer, SQL Navigator

Languages: SQL

Databases: Oracle11g, MS SQL Server 2008, DB2, Sybase, Redshift (AWS)

Operating Systems: Microsoft Windows, UNIX - Sun Solaris, HP-UX

Scheduling Tools: CA7 Autosys, Control M

Technologies: Hadoop, Pig, Hive, Map reduce, Scala and Casandra Amazon web services (AWS)

PROFESSIONAL EXPERIENCE:

Confidential, Buffalo, NY

ETL Tester Amazon web services

Responsibilities:

• Tested mappings developed by expressions, aggregators, filters, lookup and other transformations.
• Performed functional testing of web application.
• Tested several ETL routines and procedures.
• Identify the primary key and put update or insert logic.
• Design and execute the test cases on the application as per company standards.
• Expertise in SQL queries for the cross verification of data.

Environment: Informatica 10, SQL Server 2008, AWS Redshift, ALM 12, SQL, TOAD, Oracle 11g, PL/SQL, Agile, MS Access/Excel, Amazon web services, Tableau reports, Business objects

Big Data ETL Tester

Responsibilities:

• Prepared the test case documents with the help of BRD, FRD and other supporting documents.
• Attended walkthrough meetings with the Business Analysts and DEV team to get a clear understanding of the business and the applications being used.
• Created test cases and queries to test the data move for business data to load from source to stage and to target.
• Developed and designed test cases based on the Business Rules and Mapping Documents

Environment: Abinitio 3.2.6, REDHAT-LINUX, Hadoop Cluster (Cloudera) - version CDH 5.3.2, Control center, HUE, CA7 Autosys, ALM 12, TOAD, SQL Developer.

QA Analyst / ETL Tester - Prime Brokerage

Responsibilities:

• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Involved in preparing of project Test cases for Functional Testing, Regression testing, Integration testing/End to End Testing.
• Prepared and Maintaining Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases.
• Performed Functional testing, Integration testing, System testing, Regression testing, and Smoke Testing.
• Managed multiple OLAP and ETL projects for various testing needs.
• Performed extensive Data Validation, Data Verification against Data Warehouse.
• As an ETL Tester responsible for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project using Informatica.
• Written Test Cases for ETL to compare Source and Target database systems.
• Helped the testing team documenting the system requirements and testing system development. Designed and implemented basic SQL queries for QA testing and report / data validation. Set up definitions and process for test phases including Product, Integration, System and User Acceptance testing (UAT).

Environment: Informatica 9.5, JAVA, PERL, SQL Server 2008, ALM/HP Quality Center 11, T-SQL, SQL, TOAD, Oracle 11g, PL/SQL,Agile, MS Access/Excel

QA Analyst / ETL Tester

Responsibilities:

• Prepared the test case documents with the help of BRD, FRS and other supporting documents.
• Attended walkthrough meetings with the Business Analysts and DEV team to get a clear understanding of the business and the applications being used.
• Created test cases and queries to test the data move for business data to load from source to stage and to target.
• Developed and designed test cases based on the Business Rules and Mapping Documents.
• Validated the data coming from various sources using complex SQL queries.
• Prepared Traceability Matrices to track the requirements with the test cases and make sure none of them have been missed.
• Logged defects using HP Quality Center 10, linked defects with requirements.
• Developed Test Plan, Test Cases, Test Data and Test Summary Reports and followed Agile/Scrum process.
• Worked with other members of the QA and Development teams and managed efforts with offshore team in improving the processes, methods, effectiveness and efficiency.
• Used Toad, SQL developer tools for Querying source Database.
• Participated in walkthrough and defect report meetings periodically.
• Documented and reported various bugs during the Testing process.
• Retested the resolved defects/issues after the developers fix the defects.
• Involved in preparing test data/ Test script for UAT and participated in UAT signoff
• Updated the status of the testing to the QA manager, and accomplished tasks for the assigned work to the Project Management team regularly.

Environment: Informatica 9, JAVA, HP Quality Center 10.0, Agile, Oracle 11g, PL/SQL, TOAD, SQL, UNIX, selenium

QA Analyst / ETL Tester

Responsibilities:

• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application.
• Managed multiple OLAP and ETL projects for various testing needs.
• Tested several packages developed using Informatica.
• Involved in importing Flat files into Oracle database and involved in writing complex SQL queries to validate the loads and extracts. .
• Performed extensive Data Validation, Data Verification against Data Warehouse
• As a ETL Tester responsible for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project using Informatica.
• Written Test Cases for ETL to compare Source and Target database systems.
• Performed functional testing of web application.
• Helped the testing team documenting the system requirements and testing system development.
• Designed and implemented basic SQL queries for QA testing and report / data validation. Set up definitions and process for test phases including Product, Integration, System and User Acceptance testing (UAT).
• Tested the different sources such as Flat files, Main Frame Legacy Flat Files, SQL server 2005 and Oracle to load into the warehouse
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.

Environment: Informatica 9.1, SQL Server 2008, QTP, ALM/HP Quality Center 10, SQL, TOAD, Mainframes, Oracle 11g, PL/SQL, MS Access/Excel/Visio

QA Analyst / ETL Tester

Responsibilities:

• Interacting with Business Analysts for Business Requirements, testing scope reviews, inspections and test planning.
• Participated in review meetings for creating Test plan and test results summary.
• Effort Estimation for the project and preparation of the staffing plan.
• Test case review and Test scenario matrix review.
• Performed functional testing of web application.
• Managed defect review meeting for applications thereby ensuring timely closure of the defects.
• Tested source data for data completeness, data correctness and data integrity.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Analyzed the data by performing Hive queries.
• Ran the ingest job, publish job, archive job and profile job in mainframe CA7 and check data at source, at ETL cluster & at HIVE location.
• I have used Hadoop commands to see the list of files, to take counts of the HDFS files.
• Performed Meta Hub Validations like checking Lineage and Data profiling.
• Data profiling is applied on source data to examine the data and collecting statistics and information about that data.
• As part of Ingest process data profiling results are loaded into Metadata Hub so that business users/data analysts are able to access the information.
• Performed Header, Trailer, Empty file, Delimiter check for Flat file & Mainframe files.
• Performed audit log check validations
• MINUS queries used with appropriate filter conditions to validate the data between source and target.
• Coordination with the Offshore Team.
• Created Test metrics using Dashboard module in ALM and participated in status meetings and reported the progress in the form of daily status report to the manager.

Environment: SSIS, Oracle 7.0, SQL, Test Director, Windows, UNIX,JCL, VSAM Files, .Net