*Hello,* *Hope you are doing great!!!!!*
*Job Title: Product Specialist 5 / PS5 ETL Developer * *Duration:6+Months* *Location: Columbus, OH (Need Locals )* *Interviews: First round onsite. Second round phone.* *Mandatory skills: Data Modeling and SSIS and Data Warehousing* *Prod Specialist 5 (ETL developer)* DODD operates a significant enterprise suite of applications. Included within this suite are Medicaid related applications and applications supporting health, safety and welfare of DODD consumers. Many of these applications support processes based on ORC statute and Administrative rules as well. In order to have a strong enterprise application suite DODD maintains a Microsoft SQL server environment. This environment supports both the noted applications and associated reporting. In order to maintain a robust database infrastructure DODD continues to optimize existing data structures and provide a framework for migration of data across transactional reporting environments to data warehouse environments. Current ETL work is focused on supporting development of a hub and spoke DW environment to support the DW pilot project within the county boards. This project allows counties better access to key data and maintains health and safety for consumers. DODD is proposing to retain key modeling, and enterprise transformation experts in order to complete the initiative. Specific worker characteristics are: The Product Specialist is the expert for a technical development or execution environment product or set of products. The primary responsibility of a Product Specialist is to ensure the availability and facilitate the productive use of a product for Application Teams or end users. The DODD Product Specialist for this engagement will be well versed in COGNOS and standard ETL tools processes and databases associated with BI/DW The Department of Developmental Disabilities (DODD) is the fourth largest state agency with over 3000 employees providing direct care to individuals. Over 300 staff located in central Ohio, provide oversight for almost 100,000 individuals receiving services from county boards; central office staff also administer 3 Medicaid waiver programs whose 8000 providers deliver service and supports to 27,000 individuals representing 1.2 billion dollars in claims. The data warehouse program was implemented to provide data integration using cutting edge technologies to support business process improvement. The data warehouse is built on cutting edge technologies and hardware with demonstrated cost benefits. The warehouse presents data in a common aggregated format supported by advanced ETL processes that allow users to do ad hoc reporting on data in order to allow for fresh perspectives on data while supporting common results. The approach also maintains access to historical data reporting. DODD has focused on multi-faceted approach to ensure success of the project. Efforts include infrastructure, ETL, and process. DODD is currently seeking a senior level person with complete and demonstrable understanding of data warehousing concepts. Additionally, the candidate should possess a strong knowledge of ETL processes including a complete functional understanding with hands on experience using Microsoft SSIS packages for the migration of data between OLTP, staging and OLAP environments. This understanding would include hands on experience in control and data flow with SSIS. The candidate will also possess fluency in normalization of table structures and have demonstrated modeling experience with hub and spoke architectures. The candidate will be part of the DODD BI DW team working on support and continued enhancements of the aforementioned project. 1. 5 years of supporting ETL in a production environment a. Understands and can independently setup/configure SISS packages to run in production 2. 4 years of senior level SSIS experience a. Knows control flow and data flow items and can demonstrate usage of each 3. 4 years Senior level SQL skills that include database development activities 4. 5 years of data modeling experience (hub and spoke, dimensional, data vault) 5. Has a complete understanding of database normalization and can fluently speak about the various normal forms (1st – 6th) 6. 3 years of experience developing or supporting a hub and spoke database architecture, this person must have a complete and demonstrable understanding of data warehousing concepts. ______________________________ *Hello,* *Hope you are doing great!!!!* *Role: Java with salesforce.com <http://salesforce.com>* *Location: Columbus, OH* *Length of Project: This will likely be extended into 2017* *Interview Process: Face To Face Interview* *Position id : 39558 * *Job description:* Notes From Manager: For this role we are looking for someone that has strong Object Oriented Programming and Experience Specifically in Java Development to work on Sales-force application. We will teach the resource Sales-force. A big plus is if someone has Apex or lightening. This is an excellent opportunity for someone to learn how to develop on Sales-force. DSA is currently developing communities web pages for our Sales-force Environment. We need additional help on the developing side to develop our backlog of community requests. This person would come in and develop community sites for business offices within DSA*. Sales-force* experience is not required, but must have Java experience as the code bases are similar. Ideal candidate will have broad based past experience in designing, prototyping, and building custom data centric web based applications in either MS or Oracle based client/server environments. The developer would be asked to work with business users on helping to develop requirements and functionality that is desired by the business, so excellent communication skills are a must. Required Skills HTML, XML, scripting languages (JavaScript, PL SQL) is essential, and experience with one or more of the following platforms is Required -- Object oriented programming knowledge - JAVA -- *Salesforce.com Development environment - S-Controls, AJAX Toolkit, Apex API* Notes Form Manager Call Please break down the following or % of time that will be spent on the following. o New Development -70% o Maintenance – 10% o Enhancements – 10% o Support – 10% • Will they work with users on the front end of the process to gather specifications--- No, we have a BA for this, but may work with business during development time if they have questions. • What is the size and makeup of the team and where will this person rank---- We currently have another developer, a BA, and 3 database admins on the team. We are working to hire two more staff ( a database admin and developer) This person would work along with the current developer and develop Salesforce communities. • Will they do their own testing---- Yes • Will they implement the applications they write---- yes, they will implement and provide support • Please describe the project/goals from a high level ---- Salesforce Communities are being used to communicate with external businesses, it will allow a central login for all applications within DSA. We currently have several projects that we are not able to handle with the current staff level, so we are getting a contractor temporarily to help us keep up with demand. Please revert back with the below requested information along with a latest copy of your profile. Full Name: Phone: Email: Location: Availability: Available for Face to Face: Work Authorization: Validity if H1b: Skype: Rate (Hourly): Thanks and Regards, *Kalyan Kumar* *Data Systems Integration Group Inc, *5131 Post Rd, Suite 175, Dublin, OH - 43017 Email : kal...@dsiginc.com Gmail & Yahoo :* kalyankumar.recruiter* Direct: 614-344-4600 x 113 -- <http://www.anveta.com/> -- You received this message because you are subscribed to the Google Groups "US_IT_ Jobs" group. To unsubscribe from this group and stop receiving emails from it, send an email to chandrakants+unsubscr...@googlegroups.com. To post to this group, send email to chandrakants@googlegroups.com. Visit this group at https://groups.google.com/group/chandrakants. For more options, visit https://groups.google.com/d/optout.