Kindly share some matching resume to *ami...@idctechnologies.com <ami...@idctechnologies.com>*
*Role - ETL Informatica Consultant Location – Columbus, OH Duration – 12+ Months * *Onsite interviews only.* Needed is building SSAS CUBEs and SSRS Reports. Candidates should have PROVEN work experience and able to speak to that in the interview. *Description of Duties:* 20% of Total Work Effort: Meet business users to understand and analyze their processes 25% of Total Work Effort: Analyze the data generated by the business process, define the granularity, source to target mapping of the data elements, and create Indexes and Aggregate tables for the data warehouse design and development 30% of Total Work Effort: Lead Data Modeling, System/Data Analysis, Design and Development for Data warehousing environments (the physical modelling using Erwin will be done by the database analyst from ODE). Build Logical Data models (Dimensional & Relational) using concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables. Our Data Warehouse system resides on an Oracle environment. 5% of Total Work Effort: Assist the ETL developer in populating the data from the transactional system to the data warehouse system. ODE uses Informatica for ETL 10% of Total Work Effort: Create CUBE using Microsoft Analysis Service -- Create dimensions, measures and measure groups. These cubes will source the data from the data warehouse system 10% of Total Work Effort:Create Microsoft SSRS/Train ODE .NET developers in SSRS report creation *Experience Requirements:* · 8-10 years' overall experience in IT · 5-7 years in data warehouse design / maintenance. · 3--5 years' experience in each position skill listed below: · Meeting business users and analyze the requirements for the dimensional purpose. · Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables. Modelling experience in an Oracle database environment is preferred. · Must have experience in designing dimensional data models/facts from scratch. Highly recommended but not required skills. 1-2 years' experience in each position skill listed below: · Building CUBE using Microsoft Analysis Service. · Building reports using Microsoft SSRS Recommended but not required skills. 1-2 years' experience in each position skill listed below: · Microsoft SSIS/Informatica for ETL · PL/SQL and/or T-SQL · MDX Queries The selected resource will be fully integrated into a team of developers and will work directly with stakeholders representing program offices across the agency Resource will be working on: EAS (Enterprise Application Service) is a .NET system that supports multiple business processes in ODE. The current system doesn’t have any dashboard and reporting capabilities. This project will address those shortcomings. First phase of the project will create an OLAP (Data warehouse for the systems) database. This is where we expect the contractor to spend most of the time. In the second phase, after the OLAP is designed, Microsoft Analysis Cubes will be built using the OLAP data. In the last phase, the dashboard will source the data from the Microsoft Analysis Cubes and display the data using a 3rd party charting controls. The SSRS reports will source the data from same or similar MS Cubes. The reports will be available only for internal business users whereas the dashboard will be available to both internal and external audiences. *Regards,* AMIT KUMAR *Sr. Recruiter* *IDC Technologies Inc.*| *1851 McCarthy Boulevard, Suite 116, Milpitas, CA , USA, 95035* *408 668 8348 I ami...@idctechnologies.com <ami...@idctechnologies.com> I Gtalk: Recruiter.amitk | Skype: Amitiilm* *Web: www.idctechnologies.com <http://www.idctechnologies.com/>* "Under Bill s. 1618 Title III passed by the 105th U.S. Congress this mail can not be considered spam as long as we include a way to be removed from our mailing list. Simply send us an e-mail with REMOVE in the subject and we will gladly REMOVE you from our mailing list." -- You received this message because you are subscribed to the Google Groups "SAP BASIS" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at https://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.