ETL SSIS TESTER

ETL SSIS TESTER – Irvine, CA – 6 Months+

 

Required

R: ETL

R: Expert is writing SQL Queries and stored procedures.

R: MS SQL Server, SSIS.

R: Experience testing data transformations from one data source to another data source.

 

Desired:

D: TFS

D: Mortgage, Title Industry

 

Duties include the following:

• Designing, developing, and executing test cases that exercise the ETL process for Apex.

• Analyze business requirements to help drive and develop test cases.

• Develop test cases in TFS.

• Execute test cases and provide feedback to Project Management and Development.

• Capture test results in TFS.

• Work with QA automation engineers to drive and capture test cases in automated tests.

Additional Info from our convo with Deb:

•ETL workflow, testing workflow activity

•Quality center rules

•Address scrubbing

•Checking logs

•Record logs, file logs, duplicate files

•SSIS

•Stored procedures

•ETL packages

•Migration from point a to point b

•Backend testing

•Joining 2 tables through SQL queries

•Test cases, test rules, test requirements

 

Andy
West Coast Consulting

9233 Research Drive, Irvine, CA 92618, USA

Work: 949-743-0065 Ext. 208
Fax: 714 844 9091
Email: Andy@westcoastllc.com

http://www.linkedin.com/in/andywestcoast