Timberhorn is in search of a SQL/BI Developer for a contract/contract to hire engagement. This candidate will be part of our client's Data Warehouse Build team and will be responsible for: Trend Analysis Ad hock Reporting Multi-dimensional aggregation Designing SSIS packages Writing fine-tuned queries
Skill Set Required: SSIS SQL Oracle C#
SQL Server Integration Services (SSIS) ˆ most important is that they are very comfortable with SSIS development and testing. Candidates should have 4 or more years of ETL type development so they have some experience in development techniques to deal with high volume processing (example: a 1.5 million row Mayo study may generate 20+million rows of SCDM output) as well as fully understanding advanced SSIS techniques. C# Scripting ˆ Ability to code moderate to complex script tasks in SSIS packages. SQL Server Stored Procedure / Advance Query ˆshould understand best practices for stored procedures (set based over cursors, etc.).
Key Skills:
SQL Server Reporting Services (SSRS) ˆ Ability to create new and modify existing reports. Data Transformation Services (DTS) ˆThey would NOT be developing anything in DTS, but as we make changes we are converting ETL from DTS to SSIS.