*Job Title: Data Warehouse Analyst* *Ideal candidate will have experience designing Data Warehouse and BI solutions, and development experience with both Informatica PowerCenter and Business Objects. *
*Location: Madison, WI* *Duration: 9 Months* Job Description: DOT is looking for a candidate that can help us build our Data Warehouse & BI practice. The candidate will be working on Data Warehouse & BI projects, gathering & documenting requirements, designing solutions, developing ETL using Informatica PowerCenter, developing universes and reports using Business Objects, testing, and implementing solutions. They will be responsible for both ETL and business intelligence report design, development, testing, maintenance, metadata, and implementation of data warehouse initiatives. Understand user requirements, and implement solutions that ensure requirements can be achieved through high quality deliverables. Develop ETL mapping specifications for loading information into the data warehouse and for ensuring reliability of information loaded. Seek continuous improvement in performance & tuning of data warehouse and ensure security of data. Perform analysis and testing of relational databases and investigate any data load failures or data retrieval issues. Proven methodology experience for complex systems integration projects and demonstrated ability to achieve deliverables on time and on budget. Works with other IT technical teams and Business users to understand requirements, and recommend & implement solutions. Works with moderate supervision with some latitude for independent judgment performing a variety of complex tasks. Requires advanced skill sets and developing proficiency within discipline. Typically requires 5 - 7 years experience or equivalent education. Ideal candidate will have experience designing Data Warehouse and BI solutions, and development experience with both Informatica PowerCenter and Business Objects. DW & BI Knowledge areas: 1. Data warehouse/data marts using Kimball & Inmon methodologies 2. Informatica PowerCenter ETL 3. SAP Business Objects universe and report design/development 4. Xcelcius Dashboard design and development 5. Crystal reports 6. Oracle, DB2 and SQL Server 7. Dimensional Data Modeling 8. Slowly Changing Dimensions 9. Infoburst 10. Requirements gathering 11. Project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support 12. Excellent written and oral communications 13. Independent worker Informatica PowerCenter - ETL (5+years experience): • Data warehouse design • Data warehouse development Business Objects (5+ years experience): • SAP Business Objects Universe design and development • SAP Business Objects report design and development • Xcelsius dashboards Database Knowledge (5+years experience): • ORACLE • SQL Server • DB2 • Complex SQL statements Thanks & Regards, Vivek Jha | Account Manager Email: [email protected] | 4800 Patrick Henry Drive | Santa Clara | CA | 95054 Cell: 408-459-1656| Desk: (408) 874-8333 extn. 248 www.droisys.com *Seven-Time Inc. 5000 Honoree *2008, 2009, 2010, 2011, 2012, 2013, 2014 <http://www.inc.com/profile/droisys> -- You received this message because you are subscribed to the Google Groups "SAP Resource Center" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sap-resource-center. For more options, visit https://groups.google.com/d/optout.
