Lead ETL QA (Informatica)

Jobsbridge; San Ramon (CA); On-site; USD 85,000 - 110,000; Full time

Job summary

A leading technology company based in San Ramon is seeking an experienced QA Engineer to join their team. The ideal candidate will have over 5 years of hands-on experience testing ETL/Informatica and strong expertise in Data Warehouse concepts. Responsibilities include developing test plans, executing scripts, and collaborating with application teams to resolve defects. Experience with SQL scripting, UNIX/Linux, and BI tools is crucial. This role offers a dynamic environment focused on quality assurance and continuous improvement.

Qualifications

• 5+ years of recent experience in testing ETL/Informatica.
• Solid foundation in Datawarehouse concepts.
• 8-10 years of overall IT experience.
• Minimum of 4 years in Data warehouse testing.
• Experience writing complex SQL and PL/SQL code.

Responsibilities

• Develop test plans and test strategies for projects.
• Create and execute test scripts for various test plans.
• Maintain testing standards and procedures.
• Record and validate defects during the testing process.
• Participate in release control process to ensure business requirements are met.

Skills

SQL Scripting

Datawarehouse concepts

Defect diagnosis techniques

Test methodologies

Informatica

Unix/Linux

BI tools

Test automation

Tools

Oracle Database

OBIEE

Microstrategy

Client ALM

Job description

Qualifications

• Candidates need to have recent 5+ years in testing ETL/ Informatica. need to be hands on SQL SCRIPTING.
• Solid in Datawarehouse concepts
• Overall 8 -10 years of experience.
• At least 8 years of IT experience with a minimum of 4 years of Data warehouse testing experience Experience testing data warehouses systems and have defined test approaches for testing data warehouse projects.
• Experience writing complicated SQL statements and PL/SQL code to test data flow and to 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 database and BI tools like OBIEE, Microstrategy, etc.
• Experience working with Informatica and has experience working with UNIX/LINUX Experience coordinating testing activities and optimizing test cycles working with project team Experience to lead and guide QA engineers on the project if required
• Experience with utilization of appropriate test methodologies and use of test management tool like Client ALM Experience with conducting and running defect triage meeting with project teams
• Experience with implementation of test automation for data warehouse testing (nice to have)

Responsibilities

• Develop test plans, test strategy 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 tests data validation testing, data transformation testing, 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 out of the testing process
• Participate in the release control process (when the application is transferred from the build team to the test team) 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 test summary report based on the defined template to close testing phase on the project.