Job Description :
Title : Sr. SQL Developer ( Need Perfect Match ) and locals ( SSIS , SSRS.T-SQL, ETL )
Duration : 6 months and potential to longer up to 18 months
Location : Downtown -Denver – CO
Visa : GC/USC/H4EAD(Locals )

Description:
SQL Developer/Integration Specialist
A. Overview i. Develop SQL scripts for integration, data movement, and reporting ii. Develop data models to implement business-specific requirements iii. Develop ETL scripts using SSIS iv
B. . Report development in general; Spotfire and SSRS in particular
C. Essential 1. Proficiency in SQL programming (T-SQL, stored procedures, etc 2. Some experience with developing reports using SSRS 3. Significant experience with developing ETL packages using SSIS 4. Proficiency in translating business requirements into data specifications 5. Strong business facing communication skills 6. Some experience with developing data models (ERD’s) from data specifications to meet business specific requirements ii. Preferred
D. 1. Some experience with Oracle PL-SQL programming 2. Some experience with Spotfire analytics/visualization package 3. Some experience with Microsoft spatial data c. Activities i. SQL Development/Integration/Reporting
E. 1. Meet with business representatives and/or BA’s to understand business requirements; translate requirements into data models/specs 2. Develop SQL Scripts (primarily T-SQL, but also some PL-SQL) to implement reporting requirements 3. Ongoing report and query development, primarily using Spotfire and some SSRS 4. Develop and maintain SSIS packages; maintain ETL best practices ii.
F. Overall accountability, environment support and project work 1. Support build out of an evolving Enterprise Data Warehouse via collaboration with the Data Warehouse Architect following Integration Strategy guidelines 2. Support project work – support project development 3. Ongoing environment support – break-fix, environment management, configuration changes d. Experience i. Junior to Mid-level experience with the essential skillsets:
G. 1. Writing and improving T-SQL and queries 2. Developing SSIS ETL packages 3. Report development in general; Spotfire and SSRS in particular. 4. Working directly with the business users. ii. Experience with Data Warehouse environments and working with a Data Warehouse Architect iii. Experience working with waterfall and agile project methodologies