SSIS/SQL Server Developer/Solutions Architect

5 years of experience in logical and physical data modeling5 years of SSIS development in the more recent versions of SSIS. 7 years of SQL Server database development Experience with SQL/Server 2008R2; 2012 a plusVery strong SQL development skills Performance tuning Knowledge of the latest releases of SQL Server2 years of development or maintenance of Oracle PL/SQL packagesExperience in developing of small to large data applications. Experience with leveraging 2008 R2 features such as partitioning, indexing schemes, table compression, etc Excellent oral and written communications skillsFinancial Services Industry experienceBS/MS in Computer Science or equivalent

Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.

At least 7 years of experience with Information Technology.

**Essential Duties:

Participate in the ETL development function for a small data management program

Comprehend Source to target mapping specifications, design, code and testing

Participate in code reviews of ETL, SQL processes

Performance tuning and optimization

Lead design and analysis sessions with developers to ensure sound team decision-making, and come up with the best appropriate solutions

Standardize all design and development processes across the ETL framework

Lead smaller on and offshore project teams to accomplish given project deliverables

Job Status: Full TimeEligibility: EAD GC or GC or US CitizensShare the Profiles to mkonni(at)1stitsolutions.comContact: 703-349-1214Keep the subject line with Job Title and Location