Job Description
Key Responsibilities:
* Write ETL test data scripts, based on E2E mapping artifacts
* Execute data scripts and detailed analysis on the scripts
* Create strategies and test cases for applications that use ETL components
* Data mining and detailed data analysis on systems in scope for migration.
* Execute the governance process in the Data migration project
* Experience in ETL Testing and defect management progress
* Document all problems and assists in their resolution
Skills
* 5 + years of ETL work experience testing backend, focusing on complex SQL queries
* Experience in ETL and Database Testing, Data Migration Testing, and BI (Business Intelligence) reports.
* Experience analyzing ETL mapping documents
* Create Complex SQL scripts based on ETL mapping documents
* Create and execute strategies and test cases for applications that use ETL components
* Expert in Database testing with excellent SSIS SQL skills and queries
* Testing the cleansed data and experienced in data cleansing testing experience
* Experience testing in Agile Development Projects
* Experience testing CRM, Insurance, Claims, and DW application
* Hands-on experience interpreting and understanding data models and ER diagrams
* Experience testing Salesforce.
* Strong Understanding of SSIS & good exposure to tools such as JIRA, Experian and Querysurge