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