ETL/Data Migration Test Analyst

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