Previous Job
Previous
SSIS Developer Team Lead/Lake Forest, CA 24 mth+ contract (NTTJP00001447)
Ref No.: 18-00652
Location: Lake Forest, California
Position Type:Contract
 USC, GC, EAD-GC Required
No H1 or OPT

The SSIS developer will be responsible for development and testing of processes to move data from various sources to various destinations based on requirements. 
This person must be able to apply company standards and best practices while providing efficient, well-formed, and highly documented code. They will be part of an agile team whose primary purpose is the population and maintenance of various data marts.
Responsibilities Create and maintain SSIS packages to support ETL processes. Convert legacy ETL processes to utilize SSIS Framework. Be able to produce code that is well-formatted, documented and highly efficient. Take part and contribute to code reviews. Apply standards and best practices.
Perform data analysis and quality assurance Unit testing of SSIS and TSQL code. Collaborate with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.
Work closely and be an active member of a scrum team.
 
Skills Required 5+ years' experience with SQL Server Integration Services (SSIS).
5+ years' expertise in SQL programming. Ability to manipulate data using SSIS and TSQL.
Ability to write complex stored procedures and TSQL code. Experience in performance tuning SQL Server and SSIS Packages.
Ability to write efficient TSQL and ETL Code. Experience with the process of loading Data Warehouse Systems.
Successful candidates will be quality oriented and demonstrate great attention to detail.
Must have excellent written and verbal communication skills and be able to interact with multiple IT teams. Read, Write, and Speak fluent English.
Experience in an Agile environment. Experience with source control tools and processes.
Work on multiple assignments concurrently under aggressive deadlines.
Report writing experience is a plus. Data Modeling tool experience is a plus (ER_Studio or ER_Win)