Hi, please share only USC GC or GC EAD consultant for below position.
Required skills: SQL , SSIS, SSRS The BICC supports the entire healthcare organization with data analytics capabilities extending from pure data delivery to highly refined and curated data models. The ETL/SQL Server developer will be delivering Data Warehousing solutions within Agile, Iterative, and Traditional SDLC methodologies. Duties and Responsibilities • Utilize SQL to create and alter tables, stored procedure, functions, indexing, trigger • Utilize T-SQL to create new stored procedures and analyze and modify existing stored procedures • Utilize SQL for query performance tuning, find and resolve technical issues • Utilize SQL to write complex SQL statements • Develop, maintain and support SSIS packages related to the extraction, transformation and loading (ETL) process with SQL Server Integration Services (SSIS) 2012 and 2014 • Design ETL audit control and scheduling processes • Read and understand reversed engineered data models Skills and Qualifications • Excellent knowledge of SSIS, TFS and SSRS • Excellent knowledge of Data Warehousing methodology and dimensional data modeling (specifically Ralph Kimball) • Good communication skills, must create deployment and coding documentation • Ability to work on multiple projects in parallel • Good knowledge of Excel and MS Word • Experience documenting work and creating ETL design and mapping documentation • Experienced in Data Warehousing Concepts • Experience executing Star and Snowflake schemas • Ability to write technical documentation • ERwin • Experience with Software Development Life Cycle • Experience with ETL Tools: SSIS • Experience with Ddatabase & Utilities: Microsoft SQL Server 2012+ • Experience with platforms primarily Microsoft, some Unix • Experience with SQL Language ------------------------------------------ Thanks & Regards *Prahlad Kumar Gupta Resource Manager-**Recruitments* 609-478-0027 (Cell) 12 Roszel Road Suite 204-C | Princeton, NJ 08540 prahla...@nea-consulting.com -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to us_itgroups+unsubscr...@googlegroups.com. To post to this group, send email to us_itgroups@googlegroups.com. Visit this group at https://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.