*SQL BI Architect * *Location: charlotte, NC*
*rate: $67/hr C2C * *Only GC, EAD GC and USC* Key responsibilities: Need person to build a process and build a way to get from the source system in to PCE. Need to have experience in understanding different approaches to acquire the data for the data analyst to inquire.... Need someone experienced in Health IT Systems... Premier deals with a very large historical load.. may identify that they need 100 datasets and would have to get that.. may get information from patient files.... need experience in building incremental data flows building Ex: Customer moving from Epic 2010 to Epic 2014... need someone who can implement and have understanding of hardware configuration... Need someone willing to learn and recommend modifications to ensure that things are efficient and executed on design... Rely heavily on a ETL tool... Java project that does all the extract.. Java code for extracting and code as well... does not rely on any other ETL tool. build on Java... Whole project is developed so do not need coding on Need to understand the flow of the java program and change accordingly for source systems / databases... respond to change according to customers source system. need to know how to load .... need to capture the metadata... need to get the DDLs (may not always be provided by customer)... make changes in the java tables according to the table structure.. Understand the whole flow of the program.... understand each module of the project, source system and make java changes accordingly Comfortable with Unix or Linux Systems.... all the Servers are Unix Servers... would need to deploy the projects on the Unix Servers and trigger the projects to start the extraction / load project to run the java.. need experience in extracting data from health IT systems ( Epic, Cerner, Allscripts, etc.) Required: At least 100 million records (know how to split the data into multiple files and to configure in Java and load in database) Good understanding of Java (any OO background would be helpful in customizing code) Exposure to Unix environment - at least 1 year. Database background Must be able to write SQL queries (Any database queries: PL/SQL, MySQL) Programming skills (at least a couple of years to understand the process) 1 year Unix experience ETL skills (understand how to split datasets in to multiple data and incremental) Need to have Epic, Cerner or some other Healthcare System experience..... CDC - Change Data Capture Knowledge Unix Shell Scripting (Loading in Unix Shell Scripting... Need Strong Shell Scripting.. will be responsible in supporting the process) Must have an appetite for change, very adaptable, can embrace fast moving pace and learn new technology Experience in extracting data from health IT systems (i.e. Epic, Cerner, Allscripts, etc...) experience with loading, handling large datasets, hardware configuration, understanding / experience in working on deployment (will pull data in to one environment - need people who can deploy that data throughout that environment; deployment activity) *Thanks & Regards* Sunny Mehta Sage Group Consulting Inc. Direct: 732-784-6481 Office: 732-767-0010 Extn: 601 Email: [email protected] GTalk: sunny.recruiter2012 | Skype: sunnymehta89| Yahoo: sunnymehta89 -- You received this message because you are subscribed to the Google Groups "USITCV" 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/usitcv. For more options, visit https://groups.google.com/d/optout.
