Job Description

Hello,

Hope you are doing well!

I came across your resume on Job board and am reaching out to you because I feel you might be a great match for a “SSIS Developer/Team Lead”  opening that I am looking to fill for my client in “Lake Forest, CA”. “This position is with a  high growth company”  the project duration is for approximately 24+ months with a “High possibility of extension”, I would appreciate a few moments of your time to go over the job description and see if this position might be a mutual fit

Job Description:

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)

Regards

Ronny Dsouza

APN Software Services INC

39899 Balentine Drive, Suite 385, Newark, CA 94560

ronny@apninc.com

Phone: 510-870-8707