SSIS Developer :: Des Moines,IA :: Inperson required

Hi partners,

 

Please let me know your interest.

 

Direct Client :: In person interview is needed directly.

 

Location: Des Moines, IA

Duration: 12+ months

Rate: Open

 

Job Responsibilities will span ETL development/data transformation and database modeling with heavy data analysis skills. The candidate will be responsible for taking the project through the entire SDLC, working with the business users to determine the business requirements and apply the business rules to the data. 

 

This candidate should be an expert in creating, modifying and maintaining SSIS packages which will be used to move data from source systems to the data warehouse backend.  Advanced skills in writing complex Structured Query Language (SQL) queries are required.  

 

Experience working with a large variety of data, demographic, personal, numeric data and identify normal ranges, outlier data, typical and non-typical data results.

 

ETL developer that will make extensive use of data flow tasks that extracts large volumes of data from disparate data systems.  

•             Proficient in development of SQL Server Integration Services (SSIS) packages.

•             Proficient using MS SQL 2005 or later and writing relational database queries and stored procedures using SQL.

•             Experience extracting data from a large variety of sources, transforming and loading to a SQL data warehouse

•             Evaluate and address data quality issues

•             Developing error checking and resolution routines

•             Experience in interacting with customers regarding application requirements.

•             Strong business writing and interpersonal skills necessary for customer contact..

 

Skills Needed:

Develop, modify and optimize SSIS packages      Required             5              Years

SQL 2008              Required             5              Years

Experience building SSIS packages using built-in SSIS components            Required             5              Years

Experience writing complex T-SQL           Required             5              Years

Experience analyzing, profiling, manipulating data from a large variety of sources              Required             5              Years

Experience loading data into a SQL Data Warehouse        Required             5              Years

Troubleshoot abstract data, profile, analyze and optimize data   Required             5              Years

Develop error checking and resolution routines Required             5              Years

Data modeling experience           Required             5              Years

Analyze and optimize table design           Required             5              Years

Ability to work with end users to extract business requirements               Required             5              Years

Ability to analyze data and apply business rules and requirements            Required             5              Years

Agile project experience              Highly desired                   

 

 

Thanks

Avinash

Avinash Bhushan

Team Lead

Software People Inc.

www.softwarepeople.us

avinash.bhushan@softwarepeople.us

Gtalk- avinashofroorkee

Twitter: Software People @spincjobs

Ph: 631-739-8981.

Fax: 631-574-3122.

Certification: SBA 8a/SDB, NJ MWBE, NY MWBE, VA SWaM, DE OMWBE, MA MWBE.

NOTE: WE NEVER WORK WITH LAYERS