SSIS SQL Server T SQL Stored Procedures ETL Error Handling TryCatch And TRANS Based   Requirement id 46117 Job title Specialist Job location in Boise, ID Skills required Data Cleansing Projects, SQL Server 2008 & 2012, SSIS, SQL Server T SQL Stored Procedures ETL E Open Date 28-May-2015 Close Date Job type Not specified Duration 1 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Specialist: Data Cleansing Projects, SQL Server 2008 & 2012, SSIS, SQL Server T SQL Stored Procedures ETL E Description: The Client is requesting 2 ETL developers. The ETL developer is a person who has proven themselves using a structured and formalized approach, experience with standardized nomenclature and documentation, and at least journeyman experience Required Skills: * A minimum of 5 years experience in implementing, running and troubleshooting SQL Server ETL mechanisms * Specific experience with using SQL Server 2008 and 2012 SSIS for ETL * Experience with ETL in SQL Server 2012, 2008 or prior versions using SSIS or its predecessor DTS * Advanced experience (5+ years) with design and development of complex SQL Server T-SQL, stored procedure, and ETL package/component including: * Error handling, try/catch and TRANS-based structures * Use of multiple schema in a database * Multiple data sources for input * Multiple outputs depending on error or success of steps * Use of custom- and third-party SSIS add-in components; knowledge or use of MatchIT would be a plus; knowledge or use of Lysine would be nice * Use of fuzzy-logic for data matching and transformation determinations * Data type and value conversions and transformations * Data type and value standardizations * Data type- and value-based validations, including complex dependencies between data field values * Advanced experience with SQL Server database and table modifications (i.e., schemas, tables, fields) * Experience (2+ years) with .NET (C#) programming; knowledge of CLR would be nice * Experience (2+ years) with SSRS and Visual Studio for report development, deployment and delivery * Understanding of basic mainframe concepts * Reading and understanding COBOL copybooks and data dictionaries * Understanding of data type storage concepts (e.g., EBCDIC, COMP, COMP-3, etc.) and conversions to server-based concepts (e.g., ASCII, decimal, etc.) * Understanding of Change Data Capture (CDC) implementations and customizations * Ability to communicate technically (verbally and in writing) with technical DBAs, legacy system developers, and system architects is crucial * Ability to communicate (verbally and in writing) with non-technical business subject matter experts, stakeholders and project managers for clarifications, to elucidate rules, and to provide explanations is critical * Though not mandatory, prior experience with data cleansing projects would be a plus * Prior experience with working as a member of a development team would be a plus   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 46117 while calling.   Other jobs in ID: Boise (11),         (Specialist: Data Cleansing Projects, SQL Server 2008 & 2012, SSIS, SQL Server T SQL Stored Procedures ETL E in Boise, ID)

Featured Jobs Windows Engineer (Jobs in Clifton Forge, Virginia) Stakeholders AGILE Manager (Jobs in Richmond, Virginia) JavaScript Power Consultant (Jobs in Richmond, Virginia) Cybersecurity IT Analyst (Jobs in Richmond, Virginia) Peripherals IT Consultant (Jobs in Petersburg, Virginia) Filing Consultant (Jobs in Winchester, Tennessee) MS Office Consultant (Jobs in COLUMBIA, South Carolina) - - Consultant (Jobs in Bismarck, North Dakota) Scheduling Written Consultant (Jobs in Murfreesboro, Tennessee) GPO Brocade Manager (Jobs in COLUMBIA, South Carolina)