Lead ETL QA (Informatica)

Job Responsibilities:Candidates need to have recent 5+ years in testing ETL/Informatica and must be hands-on with SQL scripting.Solid understanding of Data Warehouse concepts.Overall 8-10 years of IT experience, with a minimum of 4 years in Data Warehouse testing.Experience testing data warehouse systems and defining test approaches for these projects.Experience writing complicated SQL statements and PL/SQL code to test data flow and perform data analysis.Experience in creating testing strategies and engineering best practices related to software test engineering, both manual and automated testing.Experience in root cause analysis and defect diagnosis techniques.Experience working with Oracle databases and BI tools like OBIEE, Microstrategy, etc.Experience with Informatica and UNIX/Linux.Experience coordinating testing activities and optimizing test cycles with the project team.Experience leading and guiding QA engineers on the project if required.Experience utilizing appropriate test methodologies and using test management tools like Client ALM.Experience conducting and running defect triage meetings with project teams.Experience with the implementation of test automation for Data Warehouse testing (nice to have).Develop test plans, test strategies, and estimate QA effort for projects.Develop test scripts, test conditions, input test data, and expected results for one or more test plans, including all types of data validation testing, data transformation testing, and data load process testing as appropriate.Develop, update, and maintain testing standards and procedures.Execute test scripts and validate defect fixes as part of the project.Record defects and issues in accordance with the project's defect and issue management plans.Work with the application team to resolve any defects/issues that arise during the testing process.Participate in the release control process to ensure that solutions meet business requirements.Inform QA Manager and Project Manager of any issues that may affect the schedule, budget, or quality of the product or the testing process.Be responsible for test activities including test planning, development of test artifacts, execution of tests, reporting issues/defects to the project team, and follow-up on issues for the assigned projects.Develop a test summary report based on the defined template to close the testing phase on the project.

#J-18808-Ljbffr