Job Description :
We are hiring “ETL TESTER/DEVELOPER” in CA for one of our direct client. I kindly request you to review the below job description and if you feel comfortable kindly share your updated resume along with contact details. We will get back to you to have further discussion.

Title: ETL TESTER/DEVELOPER
Location: San Ramon, CA
Duration: Long term
Start date: Immediate
Interview type: Telephonic followed by F2F
Need only locals

NOTE: For this position client is looking strong QA with ETL development and SSIS experience.

Summary
We are currently seeking a Senior Quality Analyst on a contract basis. This is a hands-on position requiring excellent SQL skills primarily in MS SQL Server. We are looking for a seasoned, quality-minded, data warehousing professional to test extracts, reform regression testing and setup QA and UAT test cases for Marketing Data Mart.

Primary Tasks
Design QA test cases from design document.
Design UAT test cases from business requirements.
Compose SQL queries to execute test cases.
Communicate any issues from testing with development team and assist in investigation
Record all test cases and results in a testing document and store in ticket folder on shared drive.
Ensure all QA tickets have proper installation instructions and comprehensive QA requirements.
Mediate all communication between QA team and Development team.
Manage all QA tickets on SharePoint.
Address ad-hoc concerns from business stakeholders.
Contribute to the documentation of the Marketing Data Mart.

Qualifications
5-7 years of enterprise level QA testing / ETL development – Must have.
Excellent SQL skills – Must have
Strong experience in MSSQL Server – Must have
Experience in SSIS packages – Must have
Strong knowledge of data analysis, test plans and test cases – Must have
Experience in Teradata environment and Teradata SQL – Nice to have
Strong knowledge of best practices around Data Warehousing and ETL development
Good knowledge of financial / banking / marketing data
Excellent communication and collaboration skills in corporate environment.

Education or Equivalent:
Bachelor''s Degree in Computer Science or Qualified QA experience