SUMMARY

• With 8+ years of experience in the Information Technology with the emphasis on end - to-end data integration/ETL and Business Intelligence BI projects.
• Experienced in writing Test Plans, Test Strategy, Test Data Management and application enhancements, maintenance releases and defect fixes for various applications.
• Experience in testing the applications Agile Methodology and Software Development Life Cycle (SDLC) testing methodologies including business requirement analysis, Regression, Functional, Usability, System and User acceptance testing debugging of existing ETL process in Informatica 9.x/8.x.
• Experience working on programming languages SQL for back end testing to ensure data integrity and validate business rules,
• Experience in source and target files validation in Unix environment and prepared and executed Unix shell scripts to validate source to target transformations
• Experience in writing test cases and executing, performed BUG reporting and tracking using tools like JIRA to create a story and task estimations, which includes uploading requirement, test cases, execution of test cases and logging defects.
• Self-motivated, willing to assume responsibilities, a strong team player as well as comfortable individual with excellent communication and analytical skills.
• Results oriented, self-starter looking for challenges, ability to rapidly learn, apply new technologies and good interpersonal skills and good project management skills

TECHNICAL SKILLS

ETL: Informatica 9.x/8.6

Reporting Tools: Business Objects, MS Access Reports, MS Excel 2007

Databases: Oracle 12c/11g/10g, SQL Server 2005, PL/SQL, DB2, SQL Developer, MS Access

Programming: Unix Shell Scripting, C, SQL, HTML, XML.

Database Tools: TOAD, SQL Developer, SQL Plus

Testing Tools: HP Quality Center 9.2, ALM (Application Lifecycle Management), JIRA

Environment: Windows 2000/XP, UNIX, MS DOS, RED HAT LINUX

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

QA Analyst

Responsibilities:

• Involved in requirement and understanding phase, test plan, test case preparation, reviews and system testing, user acceptance testing by validating the business acceptance criteria.
• Created bug report to log all defects encountered during manual validation and has worked with test management tool JIRA.
• Developed test cases for ETL coding and mapping standards based on design specifications document and warehouse metadata, naming standards.
• Perform data comparison and data validation for back end testing by using SQL queries and implemented database checkpoints for back-end testing, to ensure data consistency
• Worked ETL scripts using Informatica and validating the data in the Oracle target database and created, optimized, reviewed, and executed SQL test queries to validate transformation rules.
• Worked on data validation of reports, user interphase application validation and ad-hoc reports validation, and preparing master test plan, test estimations
• Executed all Test cases in different phases of testing like Smoke, Regression and System testing of the application.
• Validated the Informatica workflows according to business requirement documents, used Informatica workflow monitor to run the workflow and verify their status and logs.
• Validated the data warehouse (DWH) Table structure part of ETL testing, tested all the rules implemented during ETL job and data move from source to target
• Participated and involved in the Peer Reviews and Walkthroughs on the Test Case, and Preliminary test approach, which contains high-level test conditions for verifying the software solution.
• Maintained and updated requirements traceability matrix (RTM) having Business Requirements, Technical Requirements, Test Scenarios and Test Cases for test completeness

Environment: Informatica 9.6.1, Oracle Database 12c/11g, Jira, TOAD, SQL Developer, Windows Server 2003, LINUX

Confidential, Hartford, CT

ETL Tester

Responsibilities:

• Extensively involved in testing the application developed in Agile Methodology and detailed designs.
• Analyzed and optimized the use cases and created the Test cases based on them for Change Requests.
• Executed all Test cases in different phases of testing like Smoke, Regression and System testing of the application.
• Validated the Informatica workflows according to business requirement documents and used Informatica workflow monitor to run the workflow and verify their status and logs.
• Validated the Data Warehouse (DWH) Table structure part of ETL testing and executed batch processing and verify the ETL jobs status and data in database tables
• Tested all the rules implemented during ETL job and data move from source to target Data Warehouse (DWH)
• Developed complex SQL queries to test ETL jobs from source to target Data Warehouse (DWH)
• Involved in defining Test Scenarios for the applications and performed manual testing in HP Quality Center.
• Extensively tested OLAP applications and good knowledge on end to end testing of OLAP databases.

Environment: Informatica 9.1, Oracle Database 11g, OAD, SQL Developer, Windows XP, LINUX

Confidential - Washington, DC

QA Tester

Responsibilities:

• Performed various phases of testing to ensure an acceptable level of performance of the prudential product, phases included unit, regression, smoke, integration, system and acceptance testing.
• Involved in the preparation of test plan specifying an overview of testing approach, testing strategy, roles, and responsibilities and testing scope.
• Prepared SQL scripts for test data preparation for back end functionality testing and performing queries on the database to check successful transaction and to create particular test cases.
• Testing and Monitoring of load process of Informatica Jobs and performed UI validation for Plan view, test data Management by identifying various scenarios for Incremental execution
• Participated and involved in the Peer Reviews and Walkthroughs on the Test Case, and Preliminary test approach, which contains high-level test conditions for verifying the software solution.
• Involved in creating bench mark with the help of business User team to create Performance Base mark in writing, updating and executing functional and GUI Test cases, System Testing, User Acceptance Testing and Post Production Validation.
• Preparing Master Test plan, Test effort estimation, Test evaluation summary reports and created bug report to log all defects encountered during manual validation and has worked with test management tool Quality Center

Environment: Informatica 8.6.1, Oracle Database 11g/10g, UNIX, Windows XP, Xml, Oracle, Toad.