• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentations in ALM.
• Invloved in business requirements gathering and understanding them from a data perspective.
• Performed back end testing on Ambari Hadoop by writing HQL quires.
• Performed back end testing on Ambari Hadoop by writing Pig Scripts.
• Strong ability in developing advanced HQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements, including identifying the tables and columns from which data is extracted.
• Writing Pig scripts to implement/automate complex testing strategy
• Proficient in Informatica power center.

Roles & Responsibilities.

• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentations in TFS.
• Performed back-end testing on the DB2 database by writing SQL queries.
• Prepared ETL test data using TOAD for both positive and negative scenarios
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Performed back-end testing on the SQL server database by writing SQL queries.
• Prepared ETL test data using Excel and for both positive and negative scenarios
• Written Complex SQL queries to validate the data conditions for ETL.
• Verified that data is transformed correctly per various business requirements and rules.
• Verified that all Reports/Dashboards are presenting proper data/information per specified requirements and user access permission.
• Writing complex SQL queries for data validation, verifying SSIS Packages

Proficient in Informatica PowerCenter Client Tools.

Tested ERT’s EDC, EDMD, and EDMR applications.

• Created SQL queries to correct the data in the clinical table.
• Helped clients with their edit checks and consistency checks coding.
• Identified and documented work orders for developers to ensure a timely repair.
• Performed back-end testing using Toad
• Verified resolved work orders each new release
• Wrote PL/SQL scripts to implement/automate complex testing strategy

Identified and document defect reports to developers to ensure a timely defect repair

Handled back-end testing for new and enhanced web applications, API testing using JAVA 1.5 and installation testing for IBI’s report caster.

• Developed detailed test cases, scripts and scenarios for newly developed or enhanced web functionality.

Confirmed that the delivered software met customer expectations in concepts as well as function.

Provided tech support to internal clients.

• Created service tickets for tier three engineers.
• Installed and configured customers’ home networks

Responsible for meeting customer expectations through the analysis of customer business requirements.

• Created data driven test using WinRunner.
• Performed functional and regression testing for new and enhanced web applications.
• Performed functionality testing, system testing, integration testing, regression testing, data flow tests and GUI testing for new and enhanced web applications to ensure coding completeness and accuracy

Created automated test programs using Winrunner and Team test. Tested Oracle applications CAI Interface with Clear Cross’s GLS (Export Trade Management system). Designed, implemented and maintained test plans in Client/Server and Internet applications.

• Performed back-end testing using SQL Plus.
• Created Korn Shell scripts to test SAP interface with Clear Cross’s GLS export trade management system. Tested multiple SAP interfaces to and from systems

New York Life, Clinton ,NJ 05/2018 to Present

ETL Test lead

• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentations in ALM.

• Invloved in business requirements gathering and understanding them from a data perspective.

• Performed back end testing on Ambari Hadoop by writing HQL quires.

• Performed back end testing on Ambari Hadoop by writing Pig Scripts.

• Strong ability in developing advanced HQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements, including identifying the tables and columns from which data is extracted.

• Writing Pig scripts to implement/automate complex testing strategy

• Proficient in Informatica power center.