*PLEASE SEND UPDATED RESUMES TO ki...@bsmsys.com <ki...@bsmsys.com>*
*Job: Sr. ETL Consultant with Global Data Warehouse and SAP* *Duration: 6+ Months* *Location: Chicago, IL* *Relevant Exp : 10+yrs* *Rate : $60-65/hr max* *Scope of Services Requested * *Please note Global Data Warehouse project is must * *We would like to bring an onsite Contractor to design and architect the data model and ETL Framework for the Global Data Warehouse project. * *The contractors will be responsible for the design and development of the Global Data Warehouse framework and foundation layer. He/She must demonstrate an ability to understand business processes, solve complex technical problems, take responsibility in delivering complex solutions, and adhere to Resources IT practices. The contractor will interact with the technical leads and solution architects, project and program manager, infrastructure and hosting. * *The position requires strong ETL experience, dimensional data modeling and a thorough understanding of the SDLC process. Strong technical analysis background is a must-have to ensure that deliverables provide flexible infrastructure with the ability to reuse in future components.* *The ability to collaborate with co-workers, onsite and offshore contractors, and cross-functional teams is required.* *This is considered a “hands on” technical position. The candidate will be accountable for the definition of viable conceptual and ETL designs to meet specific business needs, as well as code ETL, as appropriate * *Contractor will produce the following deliverables:* *• Analysis of the business report utilization, KPI’s and data objects* *• Interact with Business Systems Analyst and SME to understand business needs * *• Interact with Business Intelligence team members, architects to expend upon technical solutions * *• Develop a logical and physical database design by applying Resources IT data design standards and guidelines for all in scope work * *o Up to 200 global/regional reports, dashboards* *o 10 cubes, * *o 13-15 data marts* *• Design and develop ETL Framework* *o Create and design reusable ETL templates* *o Design and document ETL release approach* *o Deliver ETL configuration, source to target mapping * *o Development of the transformation SSIS jobs* *o Development using SSRS* *• Understand source data components and how they integrate with each other and existing EDW structures. * *• Ensure solution designs address performance requirements, reusability, availability, integrity, security challenges, and business functional requirements* *•Provide estimates of work to be done.* *Work will be assigned and managed by Resources IT* *Job Skills Required:* *• Proven record implementing end to end DW solutions* *• Strong verbal and written communication skills* *• Ability to work and deliver independently * *• 10+ years of Data warehouse and BI experience* *• 10+ years ETL and DW architect level experience in implementing large scale platforms. Experience with MS SSIS, reusable ETL* *• Experience with MS SSRS* *• 6+ years dimensional modeling experience - Star Schema Design and data warehouse standards knowledge* *• Ability to understand a Report Requirement and business logic and incorporate it to the Global Dimensional Model * *• Functional Flows knowledge of SAP Financials modules: Vendor, Time, Billing & Revenue, Job management, HR a plus* *• Good understanding of SAP objects (ECC and BW) * *• Experience with Row and Role Level Security* *• AD (Active Directory) and SharePoint authentication and authorization * *• Strong experience with ETL concepts and tools such as: SSIS, SQL stored procedures, Informatica, DataStage * *• Programming experience (SQL, Visual Basic, C, C++); Web / Internet experience (MS .Net, HTML, ASP, XML, XSL, JavaScript) * *• Hands-on development experience (60-70% hands-on development and 30-40% architecture). * *• Expert RDBMS knowledge of MS SQL Server with strong experience on backend processes and engineering (additional experience with Oracle preferred)* *• Implementation experience with Data Modeling concept (star schema) and tools such as ERwin* *• Recent relevant experience developing large scale data warehouses / data marts, ETL solutions, OLTP & OLAP platforms, reporting solutions and dashboards* *• Knowledge with BI / Reporting tools such as MS SSRS, Cognos, Business Object, Hyperion * *• Advertising and Financial industry experience preferred* Thanks, *Kiran Nallolla* Sr. Executive – Client Relations 732 777 0800 ext. *518* BSM - 14 years in business with referable clients - Minority & Women Owned Business Enterprise - Microsoft & Oracle Certified Partner HQ: 2 Tower Center Blvd., 20th Floor, Suite # 2004 | East Brunswick, NJ – 08816 | United States Website <http://www.bsm.us.com/> | Facebook <https://www.facebook.com/pages/BSM-Business-Success-Management/186763063930> | LinkedIn <http://www.linkedin.com/company/bsm-business-success-management> | Twitter <https://twitter.com/BSM_now> The information contained in this e-mail transmission is confidential and may be privileged. It is intended only for the addressee(s) stated above. If you are not an addressee, any use, dissemination, distribution, publication, or copying of the information contained in this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately notify us in reply *with the word "REMOVE" in the subject line*. We apologize for inconvenience, if any caused. -- You received this message because you are subscribed to the Google Groups "SAP or Oracle Financials" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-or-oracle-financials+unsubscr...@googlegroups.com. To post to this group, send email to sap-or-oracle-financials@googlegroups.com. Visit this group at http://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/d/optout.
