Job Description :
Our client is looking QA Analyst with ETL for a Long term project in San Francisco, CA below is the detailed requirement.

Job Title: QA Analyst with ETL
Location: San Francisco, CA
Duration: Long term

Job Description:
Bachelor’s degree in Computer Science or equivalent with minimum of 10+ years of experience.
10+ years of experience in QA with 6+ experience with ETL/ Data Warehouse writing complex SQL & PL SQL statements to test ETL code based on the data mapping & requirements provided and perform extensive data analysis to identify the defects.
Strong Data ware house and BI concepts with experience in testing through Informatica or related ETL tools, Oracle database, BI tools like OBIEE, etc. and has experience working with UNIX/LINUX.
Experience with BASEL, CCAR reports testing is a huge plus.
Experience in working with large scale Enterprise Data Warehouse, Data Integration, Data Migration and upgrade projects.
Experience in testing data warehouses systems with building test approaches for data warehouse projects.
Experience in creating test plan, test cases and engineering best practices related to software test engineering, both manual and automated testing.
Experience coordinating testing activities and optimizing test cycles working with the project team.
Defect tracking and management in HP ALM
Creation of Test Status reports - Daily/Weekly as agreed
Test Sign off Document including approval tracking (Test Env and Post Production Env)
Experience with conducting and running defect triage meeting with project teams.
Experience of working with financial services applications.
Strong in STLC process, Test Strategy/Plan, Test Estimation
Effective Project & People Management Skills, exposure to Knowledge Management. Solid time management and prioritization skills.
Excellent verbal and written communication skills.
Experience in running ETL Jobs and monitoring it.
Experience in analyzing and finding the Impact to business for the Defects raised.
Excellent understanding of Data Model and Data Mapping.
Very good at Data Profiling.
Demonstrate excellent communication skills including the ability to effectively communicate with internal and external customers.
Ability to use strong industry knowledge to relate to customer needs and dissolve customer concerns and high level of focus and attention to detail.
Strong work ethic with good time management with ability to work with diverse teams and lead meetings