ETL Test Analyst
Cognizant Technology Solutions
Project : Astrazeneca Amazon Global Finance
Roles and Responsibilities :
- Developing complex SQL Queries from technical specifications to test the business logic and data transformations.
- Testing ETL effectively with no defect leakage.
- Developing ,reviewing and executing Test Scripts.
- Testing complex Business Object Webi Reports (both interface and data) using excel and SQL queries.
- Participate in full lifecyle of testing.
- Reporting bugs in sharepoint , following up defects and retesting of defects.
- Reducing the testing efforts using Excel VBA and PL/SQL.
- Work with developers and team lead to develop test plans, test scenarios and script through all part of testing cycle.
- Performing data reconciliation using SQL scripts.
- Effectively communicate testing activities and findings in oral and written formats.
- Defect management to ensure quality and to test all business requirements.
Oracle 10g/11g, Informatica Power Centre 8.1, SAP Business Objects 8.1, MS Office -2007.