*EDW Tech Lead & Designer * *Location: Lisle, IL*
*Duration: 6 Months* *Rate: DOE* * * * * *Face to Face interview is must……locals are preferred * * * * Overall 7+ years of Data Warehousing and Business Intelligence Experience* *Designing Experience* 1. Experience with translating *Business Requirements into Technical Design (Must)* 2. Experience with designing *Star Schemas for storage and access (Must)* 3. Experience with designing *Aggregate and Summary Tables (Must) * 4. Experience with *ETL design with emphasis on reuse (Must)* 5. Experience with *Cube design with emphasis on Security and Groups (Must)* *Tools Experience* Candidate has to be proficient with *MS SQL Server 2008 components with emphasis on* *1. **SQL Server Integration Services (Must) * *2. **SQL Server Reporting Services (Must) * *3. **SQL Server Analysis Services (Must) * *4. **SQL Server (T-SQL) (Must) * *5. **Data Modeling in ErWin, ER/Studio, PowerDesigner or any other industry tool is acceptable (Preferred)* *Other Expectations* - Must be able to *multi-task in a relatively small team (Must)* - Excellent *documentation and communication skills are necessary (Must)* - *Candidate must be able to demonstrate end-end data warehousing and business intelligence skills applied on at least two projects (Preferred) ** *** - Candidate is expected to *maintain regular activity logs and status reports (Preferred)** * - *Integration Experience – meaning Integration of DataMarts** *** - *Familiarity with Integration Framework – like Ralph Kimball methodology** *** - *Bus Architecture** *** - *Data Modeling – Hands on experience with Dimensional Modeling** *** *Role and Responsibilities* · Candidate will have to* work on all design components mentioned above.* · *Candidate will have to provide direction, tune performance and resolve technical issues associated with the MS tools suite * · *Candidate may have to work on tools as and when necessary* *Thank you and have a great day,* *Kavita Singh* *Technical Recruiter*** *ZIETA Technologies * * ----We make it happen* PH: 678-248-2096 x 266 | FX: 404-601-9910 [email protected] <[email protected]%20> | www.zietatech.com -- You received this message because you are subscribed to the Google Groups "ORACLE DWH DBA" 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-dwh-dba?hl=en.
