Innovations technological

ETL  LEAD TESTER  

Irvine, CA

6months - 1year

Interview Mode: Phone or F2F

Must be willing to work on site.

Note:  candidate must be well verse on the Informatica specific testing side?  It's necessary to know how to navigate Informatica to not only run the jobs but also look at the SQL and review the errors and walk through every piece of code to test it for quality before doing the data qa testing outside of Informatica.  This is required because of the agile nature of the client and that they are testing user stories and have no requirements or specs. 

Position Summary: Working in a team environment, contributes to quality releases of company data and products. This position requires continuous involvement and participation with development teams to design, build, and test software products and data validation. Review, verify and validate requirements, designs and functionality of software. Creates automated test scripts and contributes to the automation library. Coordinates and tracks test activities.

 Position responsibilities:

• Review, verify and validate requirements, designs the data validation test suite.
• Design, implementation and documentation of test cases and addition of these test cases to the automated test scenarios.
• Design, develop, implement, and maintain Automation Testing Framework for data validation.
• Define, review and implement data validation improvement processes across the Enterprise Data Warehouse Organization.
• Develop, execute and maintain test plans for the company product releases.
• Design, develop and maintain/enhance the QA automation scripts.
• Track and report on test status for project.

Essential skills, knowledge and abilities:

• Must have a minimum of 4-6 years of experience testing data warehouse components and data applications
• Strong command on data validation and automation concepts
• Lead experience of 2 years in recent project.
• Strong command on data warehouse/ETL testing
• Must have a strong experience with SQL and related functions.
• Experience in Informatica mapping testing and validation
• Good understanding of MicroStrategy or similar reporting tool
• Experience in data validation tools is a plus.
• Strong experience with QA processes and methodologies required; automated and manual test processes, black box, white box and gray box testing, test cases design, scripting, execution, and automated test tools.
• Must be familiar with the Software Development Lifecycle.
• Must be a self-starter who can work independently without direct supervision.

• Experience with Agile/Scrum Development Methodologies
• Hands-on experience with ETL