SUMMARY

• Around 3 years of extensive experience in Quality Assurance testing of SQL, Data, ETL and Business Intelligence processes, Web Based and Client/Server applications.
• Excellent knowledge in implementation of different QA methodologies/policies, strategies and plans in all stages of SDLC.
• Excellent knowledge in test planning, coordinating, execution and leading the testing process.
• Experience performing all types of testing like smoke, system, integration, regression, and User acceptance retesting.
• Extensive experience performing Root cause analysis on defects and conducting review meetings on defects for open defects.
• Excellent knowledge of defect management and tracking using Quality Center, JIRA and Mission Control
• Tested various ETL processes developed using ETL tools like Informatica Powercenter, Ab Initio and Datastage.
• Tested various reports generated by Business Objects, Hyperion and Cognos.
• Proficient in querying various databases like Oracle, Teradata, DB2, SQL server, MySQL, MongoDB, Hadoop and Flat files. Excellent knowledge of defect management and tracking using Quality Center.
• Adept at backend testing and data validation testing using SQL queries
• Experience in performing data validation and preparation of test da in UNIX environment using various UNIX commands and editors.
• Excellent Domain Knowledge in Financial, Retail, Healthcare and pharmaceutical. Hands on experience in Waterfall, Agile and adaptive delivery methodologies.
• Coordinated testing efforts and effectively managed Off - Shore teams.
• Self-conscientious starter, strong team skills and ability to lead a team toward achieving organizational objectives

TECHNICAL SKILLS

Testing Tools: HP ALM/Quality Center, Test Director, QTP, JIRA, Mission Control

Environment: Windows 98/2000/NT/XP, IBM Mainframes, Unix, Linux.

Languages: SQL, PL/SQL

RDBMS: Oracle 8i/9i/10g/11g, SQL Server 2008/2012/2016 , Teradata, Sybase, DB2, Hadoop

ETL Tools: Informatica PowerCenter, DatastageAb Initio, and SSIS

BI Tools: Business Objects XIR2/XIR3, Cognos, Microstrategy, SSRS and Hyperion

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

ETL QA Engineer /Database Tester

Responsibilities:

• Responsible for managing the entire test lifecycle for the test service requests from the respective functional Area by coordinating with offshore Test Leads and Test Analysts.
• Experience in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center/ALM and performing end to end testing and created Reports.
• Experience with Autosys job scheduler including jil scripting, virtual machines and custom calendars.
• Extensively used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica.
• Ensured that the mappings are correct and Conducted data validation testing. Worked with business analyst and developers in setting up test data
• Created and maintained test documentation and test plans. Development and Execution of Test Cases for Informatica ETL components.
• Worked in Agile methodology with developers and testers for development and testing on timely manner.
• Extensively test the reports for data accuracy and universe related errors. Used Toad for query Oracle, SQL Management studio for SQL Server.
• Data migration of raw data to excel documents for clients. Participated in defining and executing test strategies using agile methodology
• 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.
• Responsible for collaborating with the subject matter experts to understand the business/functional aspects of the system in scope and analyzing/reviewing the requirements for testability and providing estimates to the Service Delivery Lead - Testing.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Responsible for collaborating with the deployment team and ensuring the test environment readiness and coordinating with the development teams and tracking the defects to closure.
• Responsible for defect management and test management.
• Responsible for consulting with teams on set-up and maintenance of HP ALM/Quality Center projects and administer team access to applicable Quality Center/HP ALM projects

Environment: : ETL Informatica PowerCenter, ALM/HP Quality Center 11.0, Agile, SQL, PL/SQL, XML, XSLT, Oracle, UNIX, Toad for Oracle, MS Office, QTP, UNIX.

Confidential, Freeport, ME

ETL QA Engineer/Database Tester

Responsibilities:

• Analyzed the Business Requirements Specification Documents and Source to Target Mapping Documents and identified the test requirements.
• Tested Informatica mappings, and also the data from different sources whether it was formatted, Cleansed, summarized, aggregated, transformed and loaded into target database
• Attended daily Scrum Stand-ups for QA updates and defect status.
• Tested the ETL process that loaded the data into target database after performing all the transformations according to the business requirements.
• Writing complex SQL queries for checking the counts and for validating the data at field level. Prepared sample test data by inserting data into staging tables.
• Tested the format of the reports according to the specifications provided and also compared the data in the reports with the backend Datamart through SQL and also using excel for data comparison.
• Was involved in running the Informatica jobs from UNIX box for loading the test data into the target and also modified the shell scripts for scheduling purposes.
• Co-ordinated with the offshore counter-part for testing needs and also gave KT sessions on the business requirements.
• Was responsible for maintaining all the test cases and defects in HP Quality Center for all the team members to review. Prepared all the test scenarios and shared across the team. Involved in testing all the reports that were generated through Business Objects
• Was the point of contact for the QA team for escalations and lead the bug triage meetings.
• Validated the production tickets assigned and once confirming the defect assigned it to the developer for fix.

Environment: : Informatica Power Center 9, Oracle, Unix, Business Objects, HP Quality Center, Toad for Oracle, MS Office, Windows XP

Confidential, Albany, NY

ETL QA Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center/ALM for Functional and Regression Testing.
• 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.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing) Written several complex SQL queries for validating Reports.
• Worked closely with developers and report planners/analysts to ensure that an acceptance criterion is complete and accurate for desired report capability.
• Extraction of test data from tables and loading of data into SQL tables.
• Used Quality Center for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Conducted manual back-end testing on a reconfigured sales application system.
• Performed extensive Back-End testing by writing and executing SQL queries on the database-using SQL Query Analyzer.
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Provided the Test status to the Tech lead, Project lead and the team mates. Effectively communicated testing activities and findings in oral and written formats.
• Validated the reports to make sure all the data is populated as per requirements.

Environment: Informatica Power Center, Business Objects XIR3, SQL, PL/SQl, SQL Server 2008, QTP, Quality Center, Oracle 10g, UAT, UNIX and TOAD.