*Title: Senior Data Warehouse Developer* *Duration: 6+ months Contract to Hire (No H1B)* *Location: Las Vegas, NV *
*Kindly Reply on: lisa.d...@itbtalent.com <lisa.d...@itbtalent.com>* *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. *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: * - 4 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. - Experience with Informatica PowerCenter - Experience with Extract, Transform, and Load (ETL) tools - Experience with MS SQL Server: T-SQL; SSIS; Jobs Management. *Regards,* *Lisa Dutt - Staffing Manager* *Desk No # 609-935-3773 EXT 102 | Email : lisa.d...@itbtalent.com <lisa.d...@itbtalent.com>* *Fax 727 499 0906* *ITBrainiac Inc. * *116 Village Blvd, Suite 200 - Princeton, NJ 08540* *www.itbrainiac.com <http://www.itbrainiac.com/>* -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at https://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.