Previous Job
Previous
SSIS Developer/Lake Forest, CA 24mth+ Contract
Ref No.: 18-01056
Location: Lake Forest,, California
 No H1's Or OPT's)
 
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)
 
- ETL Prod support Monitoring and SLA maintenance for both Datastage and SSIS.
- SOM incident SLA maintenance
- Weekend support – On -call rotation
- Daily Offshore co-ordination and mentoring
- Preparing weekly status and Monthly status reports
- Attending status meetings with clients
- Attending onsite meetings with clients
- Responsible for deliverables from Prod support team
- Customer interactions and follow-ups on incident resolution
- Follow-ups with REP1 team on incident resolution
- Representing ETL Prod support team
- Working on SSIS/Datastage defect fixes , enhancements or new developments.
SSIS Developer