Security Advice : Randstad India does not charge any fee at any stage of its recruitment process from the candidate nor allows their employees to collect any fees from any candidates.
Click here to know more

etl(ssis) testing in Bengaluru

posted:
location
bengaluru, karnataka
function
Information Technology
position type
permanent
reference number
921413
contact
randstad india
apply now

job description

?Should understand Business requirements specifications and use case reviews, Technical design document and test case reviews with business users, development team and testing team.

Benefits
?BFSI Domain

Client Introduction
?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.

skills

?ETL Testing

qualification

? 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
apply now