Latest Jobs  
Advance your technical career… Find a tech school and start an IT career!
Start your career in the fast-growing technical field – Get more info here »
Advance your technology career with the latest technology skills - Get more info here »
 
This job has expired.
 
Job Information
Job title

SQL Server DB / Developer

Company Kenda Systems
Wage between $0.00 - $0.00 Annually
Location United States, California, San Diego
Employment type Full Time
Education Bachelor
Year Experience 3 - 4 Years of Practical Experience
Travel None
Published on 4/17/2007
Description
Located in Beatuiful Downtown San Diego a very large financial company is in search of a SQL Developer.

SQL Developer primary responsibility will be to develop, test and implement automated
and recurring data loads from various source systems into an existing SQL
Server 2000 database. Depending on the banking experience of the potential
candidate (preferred but not required skill), this may or may not involve
researching bank systems which are external to our department and mapping
the source system tables and fields to our SQL Server database.
For example, we would like to add account data from our Installment Loan
department to our database. This means that we will need to request access
to their system, analyze their available data and determine which tables
and fields we would like to pull into our own database. Once that has been
accomplished, we will need to create a data load using DTS to pull the data
from their system into our staging database on a recurring basis. From our
staging database, we then need to cleanse the data, get surrogate key
details and create a migration script to populate our production database
using stored procedures, user defined functions, etc.. We will also need
to optimize and performance tune each of these new ETL process so the
potential candidate should have experience in this area as well.
Additionally, we are in the process of upgrading our servers to SQL Server
2005 so it is possible that this person would start out using SQL Server
2000 but then be required to quickly port over to SQL Server 2005.

Required skills:
SQL Server 2000 development in a very large database environment
Performance tuning and optimization
Stored Procedures
DTS
ETL

Preferred skills:
SQL Server 2005
SSIS
Banking or financial experience
df-tc

Experience/Skills
4-10 years expereience , SQL Server 2000, Stored Procedures, DTS, ETL

Other desired skills:
SQL Server DB / Developer
This job has expired.