*Please share your consultant profile at **[email protected] <[email protected]>*
*Job Details:* *Job Title : Data Warehouse/ETL Developer With Oracle/PL/SQL Exp.* *Location : **Las Vegas, NV* *Duration : 6+ Months* We need a *Data Warehouse / ETL Developer *with *Oracle PL/SQL *expertise for a 6+ month contract roles with a major *Healthcare* client in *Las Vegas, NV*. *Position Description: *This senior database developer position involves *Datamart design, Data Modeling, Data source mapping, Production process troubleshooting, Database development, Source data reconciliations, ETL system development, ETL Administration*, and SDLC/Design Documentation. Database structures/processes will be developed in *Oracle PL/SQL* involving various sources of data consisting of Health Plan claims: Medical, Pharmacy, Vision and Dental (to name a few). *Informatica Power Center* will be utilized for *ETL* processes where appropriate. *Data Marts* will be built and maintained to support BI reporting and strategic analyses. Healthcare Informatics is looking for a dynamic individual to join the Data Management team and become part of our successful group. *Duties and responsibilities include: *- Contribute to the success of the *Healthcare Informatics Data Management* team - Design, develop, maintain, monitor and execute *production ETL processes* - Investigate *production ETL issues / problems* - Map database sources to specified data formats - Verify and validate ETL deliverables incoming/outgoing - Provide direction and mentorship to junior colleagues on topics related to datamart design and ETL deliverables - Lead troubleshooting episodes and communicate solutions/resolutions to the team - Translate concepts to requirements, then design, and develop into an automated production process - Act as a subject matter expert for other team members on assigned processes - Complete projects and development activities timely and accurately while following the System Development Life Cycle (SDLC) - Suggest changes and enhancements for processes. - Maintain ongoing self-study program to enhance knowledge *of PL/SQL development, Oracle RDBMS Best Practices and Informatica PowerCenter* - Document hours of development activities by following SDLC and IS Change Management *Minimum Position Requirements:* - 3 or more years experience in *Datamart design with Oracle 10g/11g databases* - 3 or more years experience in *PL/SQL development *- Strong knowledge of *Data Warehousing schema design* - Data Warehouse Extract, Transform, and Load knowledge - *Production ETL operations and monitoring *- Bachelor's degree in Information Systems, Computer Science or 5 years of related work experience. *Additional Assets: *- Experience with MS SQL Server: T-SQL; SSIS; Jobs Management - Experience with Informatica PowerCenter - Experience with Extract, Transform, and Load (ETL) tools *Thanks and Regards* *Nilesh Awadhiya* *Sage Group Consulting, Inc.* *3400 Highway 35, Suite # 9, Hazlet, NJ 07730 * *Office: 732-767-0010 X 227* *Direct: 732-658-5828* *Fax: 732-658-5828* *Email : [email protected] <[email protected]>* *Website : www.sageci.com <http://www.sageci.com/>* *Gtalk: nilesh.awadhiya |Yahoo IM: n_awadhiya* -- You received this message because you are subscribed to the Google Groups "Open Source Erp & Crm" 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/open-source-erp-crm. For more options, visit https://groups.google.com/d/optout.
