Job Description:

• Over 7+ years of experience, worked on data warehousing project with good hands on exp. in ETL testing
• Hands-on experience required into ETL Testing tools .
• Creating test cases for ETL mappings and design documents for production support.
• Testing strategy development for large programs involving data mapping, data flow validation.
• Test Scenario, Test Case creation, Test Design, Defect management, Status report creation, Performance report creation, Test Results documentation.
• RDBMS systems like Oracle/Teradata/Sql Server/DB2 (Any One). 
• Writing complex queries using Joins and Sql Server special functions.
• Analyzing the Technical and Functional Business Requirements. 
• Design and implement Database objects such as stored procedure, Functions and Complex Queries. 
• File to file, file to DB and DB to DB validation experience. 
• Understanding the flow of data between the systems and its Data model. 
• ALM tool experience and RTM creation and defect life cycle. 
• Understanding project documents, customer demands, and product objectives to create the Test Plan, create and execute test cases. 
• Performing System Integration Testing (SIT/QA) at all the transformation layers which includes Source Data Check, Data Mapping between different systems 
• Mapping Stored Procedures experience. 
• Domain Knowledge - Wealth insurance 
• High risk handling with other stake holders on production call support. 
• Confluence documentation experience