*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 "SAP BASIS" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-basis+unsubscr...@googlegroups.com. To post to this group, send email to sap-basis@googlegroups.com. Visit this group at https://groups.google.com/group/sap-basis. For more options, visit https://groups.google.com/d/optout.