Please send resumes only to [EMAIL PROTECTED] Position: Operational Data Warehouse Lead
Duration: 10 Months Location: One in NYC and the other in Groton, CT ONLY TELEPHONIC INTERVIEW - 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 - - 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. Thanks & Regards, Lisa Valentine Account Manager Data Group Inc 732-734-5335 [EMAIL PROTECTED] --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "IT provider" group. To post to this group, send email to IT-provider@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.co.in/group/IT-provider?hl=en -~----------~----~----~----~------~----~------~--~---