Job Description :
2-4 yrs SQL/ETL Developers with SQL Server 2008 and 2014 knowledge. Experience with creating and updating complex SSIS packages is needed.
SQL/ETL Developers may work on:
Escalated Requests:
o New/Update Data feeds
o Add new data fields to data feed file
o Import new fields into ACH data in the DW
o Import Fiserv report data into DW for Audit, Boarding and Special loans
o Letter Reconciliation – automate running API
o Letter Reconciliation – escalated items
o Add fields to QA Risk data feed
Backfill of Call Center fields in Call Center Data Mart
Update SSIS packages for API calls
E-mail Correspondence – bad e-mail addresses, call API to remove bad e-mail addresses from LoanServ
E-mail Correspondence – batching files to IVY delivery
Backlog of other client requests
Assist with setting up standards, templates, more efficient development (as part of Data Strategy)
Add jobs to Control-M with guidance