Previous Job
SSIS Developer
Ref No.: 18-08867
Location: Santa Ana, California
Required Skills :

Basic Qualifications :

Job Description :
SSIS Developer
Contract to hire (Citizen or Green Card)
Sits in Santa Ana
Basic requirements:
- Load data from many different types of file sources including flat files, web services and logs - Write and maintain ETL packages that meet both the functional needs and meet auditability, scalability, performance, security and reliability requirements.
- Demonstrated ability to write excellent T-SQL queries in stored procedures and ad hoc as needed.
- Ability to debug and tune slowly performing queries
- Ability to use SSIS to load data both into staging and into Production tables
- Ability to use C# to write custom script components
Nice to have skills:
- Middle tier c# development skills
- Devops skills
Not looking for a reporting guy that populates datawarehouses, no SSRS developers. This is not a lead role.
- Ability to create high performance data packages and do data conversions.
- Write complicated queries and stored procedures – Needs a Microsoft stack background: SQL DB and SSIS, no informatica.
4 Must haves:
converting data creating SSIS packages
Experience with flat files,
Web services
Data warehouses