*Hi friends,* *Please send Profiles to **[email protected]* <[email protected]>
*Need locals Only* SQL DEVELOPERS – CLIENT IS AMERISOURCE BERGEN, FRISCO, TX 3-6 M **DataWarehouse development in Microsoft SQL 2000 or 2005 environment **Strong knowledge of T-SQL, Stored Procedures, Triggers and DTS development **SQL Server Data Replication **DBA Skills are a plus **Ability to Create and modify Tables; Create and modify Indexes; Create, modify and debug Procedures; Create, modify and debug Functions; Create, modify and debug Triggers; Create, modify and debug Views; Ability Perform SQL optimization; Create complex Joins using ANSI **SQL Server architectural understanding **Event Logging **Resource management **Log files **File and File Groups **Security **Backup and Recovery Responsibilities: Ensure Data warehouse development follows the ABSG SDLC process Design, construct, test and implement extraction and transformation programs, processes and cycles for historical and current source data Creates technical specifications, test plans and test data to support ETL processes Follows data standards, resolves data issues, completes unit testing and completes system documentation for ETL processes Collaborate with business analysts, source system experts, and other EBI team members to determine data extraction and transformation requirements Collaborate with IT operations and testing organizations to ensure timely releases of projects and database environments are sustainable Collaborate with IT operations for support in problem resolution and root cause analysis. Required skills and experience: A proven record in Datawarehouse development in Microsoft SQL 2000 or 2005 environment Strong knowledge of T-SQL, Stored Procedures, Triggers and DTS development Must have experience with SQL Server Data Replication DBA Skills are a plus Ability to Create and modify Tables Create and modify Indexes Create, modify and debug Procedures Create, modify and debug Functions Create, modify and debug Triggers Create, modify and debug Views Ability Perform SQL optimization Create complex Joins using ANSI Good SQL Server architectural understanding Event Logging Resource management Log files File and File Groups Security Backup and Recovery Experience with DataMirror ETL tool preferred Knowledge of Dimensional Modeling Concepts Strong analytical and problem solving skills Good oral and written communication skills Ability to multi-task -- -- Thanks & Regards, Rudhra | Cigniti Inc. W: 214 - 295 - 4833 F: 972 - 767 - 0948 E: [email protected] --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle-Distribution" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-Distribution -~----------~----~----~----~------~----~------~--~---
