Dear All, Kindly go through the requirement and reply with suitable fits, ASAP.
Job title: *Data warehouse Operations Lead*. Length: 1 year Location: *Groton**, CT* / *New York City**, NY* Experience: 6 Years + database admin and management Education: Undergraduate Degree or related experience Required Travel: Local Travel Required (150 Mile Radius) BAU-based; 1 year long; MUST be local (will not pay for commuting costs to and from home). Occasional travel between CT/NJ/NYC offices and this can be separately expensed. REQUIRED PERSONALITY TRAITS: Detailed oriented, process aware, disciplined, good sense of humor. People without experience as a data warehouse support/operations lead (analytical, operational, transactional or master data) will be automatically declined. *Job Description*: *Pfizer Strategic Architecture Services - Master Data Management Support/Operations Lead * * * Under the direction of the Director of Enterprise Master Data in the Strategic Architecture Services team the MDM Support/Operations Lead will supervise a team in monitoring and operating the 365/24/7 operations of the Pfizer Global Master Data System. As the MDM Support Lead you are responsible for providing 2nd level support by interfacing with Tier III developers/vendors when resolving and reporting system issues/bugs for MDM systems. This position will utilize ITIL/SDLC frameworks and industry best practices to support cost effective MDM operation including: - Production job scheduling. - Job monitoring. - Incident management. - Ad hoc troubleshooting. - Change Request management. - Status and metrics reporting. - Coordination with other Pfizer support organizations (SAMs). *Details Duties**: * * * - Supervise the complex calendar of MDM ETL and Siperian processes that extract, transform, de-duplicate and load data into the Global Master Data system. - Manage ongoing maintenance of the data warehouse environment to ensure high availability, performance and data integrity. - Oversee monitoring and troubleshooting jobs, loads and client data access. - Oversee monitoring of the automated system alerts, log files and change requests. - Manage the process related activities and troubleshooting MDM jobs according to established SLA's. - Research problem tickets, incidents to implement processes to prevent repetitive issues. - Provide weekly report on DW activities, status and metrics, as well as communicate timely updates when there are issues with the Data Warehouse. - Schedule and inform management and client base on planned and unplanned outages of the system. - Interact with and coordinate activities of Tier I,II support, other Support teams, as well as Development, Integration groups. - Work on projects to better improve DW Support model. - Maintain all documentation related to support activities. - Coordinate infrastructure changes with MDM Architecture team. - Understand and implement appropriate security models to support ad hoc data access while ensuring conformance to Pfizer security and privacy regulations. - Coordinate activities of onshore and offshore contracted staff in performance of support/operations tasks. - Provide off-hours support when necessary and respond to emergencies in a timely manner. *Qualifications:* - 5-7 Years experience as a *Data Warehouse Support Manager or Lead*. - 3-5 years of hands-on *BI/DW development or support experience*, with a strong foundation *in ETL (DataStage), Oracle, Multi-dimensional data, and preferably Master Data Management Systems* (experience in a corporate-wide CRM warehouse would be acceptable). - Knowledge of *Siperian Master Data Management* Hub strongly recommended. - Knowledge of job scheduling tools - mandatory *(UC4/Autosys).* - Experience with *data warehouse/data mart lifecycles and methodologies*. - Proficient in one or more relational database such as *Oracle or MS SQL Server*. - Extensive experience using *SQL to develop queries.** * - Strong understanding of relational and dimensional data modeling. - Strong analytical/troubleshooting skills. - Ability to effectively communicate with Business Units, Team Leads and IT. - Management to implement, support, and monitor DW systems. - Four-year degree in Information Technology, Computer Science, Business Administration or related field. Best of luck in your career pursuit. Looking forward to hear from you. Thanks and Regards, Sree Indam Inc. 6 Opatut Ct. Morganville, NJ 07751 T: 732.410.8757 F: 732.536.8523 [EMAIL PROTECTED] Indam Jobs --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DIRECT CLIENT IT NEED" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/direct-client-it-need?hl=en -~----------~----~----~----~------~----~------~--~---
