Junior ETL QA Tester

This is Kiran Akki from Kaizen Technologies,We are looking to fill the position with right consultant.

• Create and execute test plans and scripts that will validate the projects data quality and data integrity as the data is transitioned through the ETL data warehouse process.
• Analyze documentation and technical specifications to ensure that quality assurance activities allow the ETL process to meet business requirements and systems goals, fulfill end-user requirements, and identify existing or potential issues
• Test the compliance of information flows and data stores against data quality standards.
• Provide risk assessment during project planning and development.
• Create and maintain test documentation and test plans, plus work with the project team to create a suite of test data to exercise data validation and ETL functionality
• Create and execute SQL queries as needed to validate that test results match expected results
• Identify and log defects and when necessary, use SQL to narrow down the root cause of the defect issue
• Work closely with the scrum team to analyze, debug and resolve any issues
• Effectively communicate test progress, test results, and other relevant information to project stakeholders and management
• Enforce and monitor adherence to quality standards.
• Create and execute regression test scenarios
• Other duties as assigned.

• Bachelor’s Degree in information technology, computer science, statistics, or similar technical degree
• Five + years of testing/development experience using SQL Server with the following highly desired
• Data warehousing and data modeling
• Strong knowledge of aspects of Data validation testing
• Strong experience testing data exchanges with XML
• Strong knowledge of aspects of ETL program testing
• Experience writing and executing complex SQL queries using views/tables
• Detail-oriented, with excellent organizational skills and able to manage multiple issues simultaneously
• Excellent diagnostic, problem-solving and debugging skills.
• Knowledge of applicable data privacy practices and laws a plus.
• Experience with the Altova Suite of products
• SSIS (SQL Server Integration Services) development and testing experience
• Exposure to and experience using automated data test tools such as Selenium and Eclipse
• Strong written and oral communication skills; strong interpersonal skills.
• Self-directed and proactive; thinks beyond the immediate problem.
• Experience in Healthcare IT or Support environment a plus