SSIS/SQL Server Developer/Solutions Architect

Company Description

First IT Solutions

Job Description

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 

Qualifications

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

Additional Information

Job Status: Full Time

Eligibility: EAD GC or GC or US Citizens

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

Contact: View phone number on jobs.jobcopilot.com

Keep the subject line with Job Title and Location