SSIS/SQL Server Developer/Solutions Architect

5 years of experience in logical and physical data modeling

5 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 plus

Very strong SQL development skills

Performance tuning

Knowledge of the latest releases of SQL Server

2 years of development or maintenance of Oracle PL/SQL packages

Experience 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 skills

Financial Services Industry experience

BS/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 Time

Eligibility: EAD GC or GC or US Citizens

Share the Profiles to mkonni(at)1stitsolutions.com

Contact: 703-349-1214

Keep the subject line with Job Title and Location