ETL Test Engineer - SQL (3-5 yrs)

Write an effective ETL tester job description, begin by listing detailed duties, responsibilities and expectations. We have included ETL tester job description templates that you can modify and use.

Sample responsibilities for this position include :

- Knowledge of dimensional modeling and data warehouse concepts, such as star schemas, snowflakes, dimensions, facts

- Ensure all sign offs on deliverables (overall test strategy, test plan, test cases, ) and that testing meets governance requirements

- Responsible for ensuring quality of their work the work of the entire development team

- Strong experience in of the following technologies preferred - Web API (MS ASP.Net), MVC, WCF, HTML5, CSS, JavaScript, JSON, SOAP, REST, JQuery, Java , .Net Framework, C#, Ab Initio

- Create SIT test cases/test data and perform Test execution

- Review Data Models, Data Mappings, Architectural Documentation to create/execute effective SIT Test Plans and SIT test cases

- Validates data by running queries in the database and verify that the results match the expectations

- Analyzes and troubleshoots erroneous results, determines the root cause of defects, logs the defects in HP Quality Center/ALM and enables defect management, including working with the development team on the resolution of Software related defects

- Works closely with software development team (Business Analysts, Developers & other testers) to ensure timely and effective testing effort

- Writing queries to extract data for test case data comparison

Key Skills :

Skill : ETL Testing (Must) + Strong SQL + Automation (Unix scripting or Python)

- ETL testing experience is must to have, preferably Informatica.

- Any automation experience with either Shell scripting or Python.

- Must have strong hold on SQL.