Hello,
We have a hot opening for....... Job Title: Sr. SSIS (SQL BI) Developer Location: Anaheim, CA- Local Consultant ONLY Duration: 6-12+ Months Contact Job Summary: Data Warehouse & Business Intelligence Developer is responsible for design and implementation of Data Warehouse and BI platform along with providing technical support for enterprise reporting requirements. Essential Values-Based, Leadership and Management Competencies: Demonstrates competencies in line with the four core values that are the foundation of all activities performed by management employees in order to achieve the Mission of the St. Joseph Health System (see attached list of behavioral definitions): Dignity: Demonstrates competence in communication, interpersonal relations and leading courageously. Excellence: Demonstrates competence in continuous improvement, continuous learning, accountability, teamwork, motivating and developing others, problem-solving and decision making, displaying financial understanding, managing daily operations, and demonstrating business / job specific knowledge. Service: Demonstrates competence in customer/patient focus, adaptability, and shaping change. Justice: Demonstrates competence in community orientation, stewardship, and strategic planning and action. Essential Functions: Conduct or participate in meetings with key system owners to understand current data and systems environment. Develop the BI Data Model & lead the Data Profiling/Data Mapping aspect of the initiative(s) Build and refines the Data Warehouse data model in a complex distributed database environment, participate in data architecture, analysis, and design. Designs ETL processes and develop source to target data mappings. Develop, test, and deploy ETL routines using ETL tools and external programming/scripting languages, as necessary Develop technical best practices for data movement, data quality, data cleansing, and other ETL-related activities Develops accurate LOEs (Level of Effort) as part of iteration/sprint planning. Design and implements star schema and ETL for Data marts using Microsoft BI suite (SSIS). Implement cubes and reports using Microsoft BI suites (SSAS/SSRS) Design and develop BI/Reporting solutions that may include cubes, dashboards, published reports, etc. Additional Responsibilities: Actively participates in weekly build and release process along with development and Production Support team. Knowledge / Skills / Abilities: Expert in designing data warehouse databases working with Microsoft SQL Server 2008 or 2012 Expert with Extract Transformation Load (ETL) tools such as MS SQL Server Integration Services (SSIS), Informatica, etc. Fair amount of experience in developing BI solutions/Reports using SharePoint, SSRS and Performance Point tools. Good experience in designing analysis cubes working with Microsoft MS Analysis Services (MSAS) Fair experience writing complex SQL scripts to validate and test the accuracy of database content. All Applicants must also have: Must understand core BI, data warehouse and advanced analytics concepts and architecture principles Must have technical experience in integration of multiple source systems feeding a Data Warehouse. Must have a technical understanding of mainstream data warehouse database platforms, ETL tools, BI tools and advanced analytics tools, and how the independent systems work together and should be architected. Must be able to determine scope, duration, resources required prior to beginning a project. Demonstrated analytical and conceptual skills. Comprehensive knowledge of database applications. Excellent oral and written communications skills. Technical documentation skills. Experience working in a team-oriented, collaborative environment Preferred Qualifications: Exposure to Amalga Unified Intelligence System (Amalga UIS 2.0). A Microsoft certification is preferred, with the ideal candidate possessing one or more of the following certifications: MCTS, MCITP, MCA, or MCM Good experience in Dashboard development using PerformancePoint on SharePoint 2010 platform. Exposure to SharePoint 2010 administration configuration. Good understanding of Healthcare ecosystem and Clinical Data. Also has fair understanding of HIPAA and HL7 standards Information Management: Treats all information and data within the scope of the position with appropriate confidentiality and security. Risk Management: Cooperates fully in all risk management activities and investigations. Additional Requirements: Occasional night and weekend work On-call Cell Phone Minimum Position Qualifications: Education: A bachelor's degree in Information Technology Sciences or equivalent work experience (4 years minimum with at least 2 full life cycle implementation project as Data Warehouse and/or Business Intelligence Solution Consultant) Experience: Three or more years of Data Warehouse & BI development Experience developing ETL processes. Experience working with appropriate programming languages, operating systems and software Experience working with relational databases to facilitate programming software 2 -3 years IT operation with strong understanding of database structures, theories, principles, and practices Experience with data management and data processing flowcharting techniques Fair understanding of Healthcare Clinical Data Management. Data modeling experience for Data Warehouse/Data Marts Advance level SQL programming skills Performance tuning of SQL and Stored Procedures Training: Trained on MS BI Suites like SSIS with additional training on SSRS, SSAS, development and environment management License / Certification: A Microsoft certification is preferred, with the ideal candidate possessing one or more of the following certifications: MCTS, MCITP, MCA, or MCM Right-click here to download pictures. To help protect your privacy, Outlook prevented automatic download of this picture from the Internet. data:image/gif;base64,R0lGODlhAQABAID/AMDAwAAAACH5BAEAAAAALAAAAAABAAEAAAICRA EAOw==Please send me your Updated Resume and these details ASAP: Full Name: Contact No: E-mail ID: Availability: Visa Status/Citizenship: Current Location: Rate on C2C/ Employer details: Regards, Yaman Sahu Gain America, Inc. I 13804 Hull Street Road Midlothian, VA 23112 Office: 703-880-8775/ Direct: 703-828-5215 I Fax: 917-475-8362 I ya...@gainam.net I P Please consider the environment before printing this e-mail NOTICE:This message, and any attachments, contain(s) information that may be confidential or protected by privilege from disclosure and is intended only for the individual or entity named above. No one else may disclose, copy, distribute or use the contents of this message for any purpose. Its unauthorized use, dissemination or duplication is strictly prohibited and may be unlawful. If you receive this message in error or you otherwise are not an authorized recipient, please immediately delete the message and any attachments and notify the sender. In order to not be in the recipients-list for this mail, please reply to us with "REMOVE" either in the subject. Please include all pertinent email addresses. Our apologies for any inconveniences caused by this mail. -- You received this message because you are subscribed to the Google Groups "OracleD2K" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracled2k+unsubscr...@googlegroups.com. To post to this group, send email to oracled2k@googlegroups.com. Visit this group at http://groups.google.com/group/oracled2k?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
<<image001.gif>>