Hello, Please share your consultant resume to tah...@usmsystems.com SQL BI Developer Location: Boise, ID Duration: 12 months
SKILLS: Experience using SQL Server for ETL CDC ETL experience in SQL Server Skills required: 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 Best Regards, Mohd Taher US IT Recruiter Direct: 703-565-2354 USM Business Systems Chantilly, VA 20151, USA. -- You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-abap+unsubscr...@googlegroups.com. To post to this group, send email to sap-abap@googlegroups.com. Visit this group at http://groups.google.com/group/sap-abap. For more options, visit https://groups.google.com/d/optout.