SSIS/SQL Server Developer/Solutions Architect

SSIS/SQL Server Developer/Solutions ArchitectFirst IT SolutionsJob Description5 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 developmentExperience with SQL/Server 2008R2; 2012 a plusVery strong SQL development skillsPerformance tuningKnowledge 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, etcExcellent oral and written communications skillsFinancial Services Industry experienceBS/MS in Computer Science or equivalentQualificationsBachelor'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 programComprehend Source to target mapping specifications, design, code and testingParticipate in code reviews of ETL, SQL processesPerformance tuning and optimizationLead design and analysis sessions with developers to ensure sound team decision-making, and come up with the best appropriate solutionsStandardize all design and development processes across the ETL frameworkLead smaller on and offshore project teams to accomplish given project deliverablesAdditional InformationJob Status: Full TimeEligibility: EAD GC or GC or US Citizens