BI/DWH- testing

BI/DWH test Engineer in largest financial cooperation "Clal" .
Proven Experience in ETL, Data warehouse, Client/Server and web applications.
Expertise lies in Functional testing, Manual Testing and Automated Testing, Regression testing, User Acceptance testing (UAT), System testing, Integration testing and Black Box Testing.
Extensively used HP Quality Center ,Jira ,Bugzilla for Test Estimation and Execution, Defect Tracking and Test Result.
Experience in ETL methodology for supporting Data Extraction, Transformations and Loading process in a corporate-wide-ETL solution using Informatica & SQL Server Integration Services(SSIS )
Experience in Testing BI applications
Experience in writing complex SQL, Oracle PL/SQL queries including calling stored procedures by passing parameters, functions using SQL Developer as development tools.
Familiar with SQL Server, Oracle PL/SQL Packages, Stored Procedures, Functions & Triggers.
Experienced in dealing with clients to gather requirements, understanding the Business requirements, product demonstrations and providing product support.
Experience in data analysis and problem solving with large amounts of data
Extensively used a waterfall And agile methodology
Hands on experience with analysis of business, technical, and functional requirements and Developed, Executed & Tested the test plans, test cases and test strategies.
Experience with software change management tool Rational
Familiar with the use and working of Rational RequisitePro for requirements management.
Expertise in Data Warehouse, ETL Verification, BI reports.
end-to-end testing & back-end testing.

Web / mobile

Automation testing

ee

8 + years experience in rdbms structure modeling DWH & bi semantic layers modeling , experience in writing complex sql query's

1