etl(ssis) testing in Bengaluru
?Should understand Business requirements specifications and use case reviews, Technical design document and test case reviews with business users, development team and testing team.
?Global In-house Center (GIC) of the Financial Corporation (NYSE: ) family of companies. Client provides comprehensive title insurance, closing/settlement, property data and technology solutions.
IT creates quality solutions for its customers by combining software, back office and knowledge processing operations to fulfill client�s business requirements.
? Should be able to write Complex sql queries for validating business rules using Sql server
� Analyze and understand and debug packages developed in SSIS
� Validate Data Transformation Logic (including testing of Dimensional Model � Facts, Dimensions)
� Validate Data Loading
� Data warehouses Validation over existing information with cumulative and incremental .
� Test end to end data flow from source to mart to reports (including calculation logics and business rules)
� Check for accuracy, completeness (missing data, invalid data, duplicate data) and inconsistencies.
� Should perform data quality analysis using advanced SQL skills.
� Should be able to test ETL Data Stage jobs and other ETL Processes (Data Warehouse Testing).
� Able to test SSIS packages single tasks or precedence constraints possible.
� Should write SQL queries to validate whether actual test results matched with expected results
� Have Knowledge of views for complex joins queries involving multiple tables from different databases.
� Develop test strategy, test plan/Design, execute test cases and defect management for ETL
� Should be strong in t-sql scripting and possess good knowledge
� Should understand Business requirements specifications and use case reviews, Technical design document and test case reviews with business users, development team and testing team.
� SSIS / MS SQL Server