JobPosting_ITS53_InformaticaAdmin-FY14-DOT-001a.docx

Specifications for ITS53 Staff Augmentation Posting ITS53_InformaticaAdmin-FY14-DOT-001a Informatica Admin __ New Posting _X_ RePosting: __ No suitable resumes received, reposted with no changes (please do not resubmit resumes)

General Requirements:

CORI requirements: _X_After candidate selection __ Other (including special requirements):

Interview requirements: _X_ Initial contact by phone, interview may be in person __ Other:

Maximum acceptable hourly rate: $_95.00__

May be filled PRIOR TO CLOSE DATE: __Yes _X_No

Additional Resume Submission Specifications and Requirements:

· Total number of positions sought: _1_

· Maximum number of resumes per ITS53 Vendors: _5_

· All Bidders must complete line item on Candidate Bid Sheet for each resume submitted.

· Resumes and Candidate Bid Sheet must be emailed to: john.cadorette@state.ma.us

· The subject line of the email must read: ITS53_InformaticaAdmin-FY14-DOT-001a

· If more than one vendor submits the same candidate name, then the lowest bill rate is used or if bill rate is the same then the vendor with the earliest submittal date to issuer is used.

· No phone calls please – email questions to: john.cadorette@state.ma.us

· Indicate on resume if candidate is presently working for another State Agency or has worked for another State Agency within the past 12 months (if so, indicate State Agency name)

· Include candidate Pay Rate in the email that accompanies the resume

· Rates are all-inclusive (travel and any additional expenses are included in the rate)

Worksite Address: MassDOT, RMV Division, 25 Newport Ave, Quincy, MA 02171 Contract Length: 1 Year (renewable) Project(s) Duration: N/A Hours per Week: ~40 Other Schedule Related: none

Interviewer: John Reinikainen, IDEA Manager, RMVM

Rate Card Title from the Rate Card posted on Comm-PASS: Software Systems Analyst/Programmer – Senior Informatica Administrator

Summary of the Position This position is with the Massachusetts Department of Transportation (MassDOT) Registry of Motor Vehicles Modernization (RMVM) Program. The RMVM is searching for a talented Informatica Administrator to join its new Service Delivery Team. A firm understanding of data modeling and database integration with front end applications for operational reporting and analytics is a foundation for this role. Do you have a strong sense of ownership? Do you want an environment that will allow you to work autonomously and stretch your technical expertise? If you are a self-starter who would like the opportunity to work in a startup-like environment working within the RMVM Program implementing the Commonwealth’s new licensing and registration system, we’d love to talk to you. A key component of this position is that this person becomes part of a team that will support and maintain the RMVM new licensing and registration systems put in place as part of the upgrade for Automated License and Registration System (ALARS) and provide strategic guidance to the program team, senior management, vendors, MassDOT and the Commonwealth Information Technology Division (ITD). This role will act as the main point of contact for RMVM development projects with respect to Informatica applications and configuration management. This position is part of the established governance structure managed by the RMVM Executive Program Manager.

Primary Responsibilities The Informatica administrator will help develop the technical solution that meets the requirements of the RMVM Program. You should be able to design large, significant, and highly complex systems. You should be skilled at assessing existing systems and recommending technical improvements (e.g., performance upgrades). In addition you will be asked to make recommendations, establish business cases, automate testing, and assist others in building proposed program modifications, methods, and procedures. This position will involve interaction with other entities such as MassDOT IT and Commonwealth of Mass ITD teams, contractors to MassDOT and management.

Responsibilities include but are not limited to: Managing development and production system infrastructure and related processes, middleware failure analysis and recovery and will participate in disaster recovery activities.

1. Provide Subject Matter Expertise in the Informatica suite of products including but not limited to PowerCenter 9.x, Messaging Queues, Web Services (Oracle), Power Exchange for VSAM, Power Exchange for IDMS, Power Exchange for Oracle, Data Quality, MDM, Dynamic Data Masking, IDQ, Data Archive, and Test Data Management.

1. Installation, migration, configuration, maintenance, technical support and troubleshooting of Informatica ETL Server implementations.

1. Ability to prioritize and resolve multiple complex and critical issues, and provide performance and tuning solutions to development teams.

1. Contribute to both application functionality and capacity requirements in a rapidly growing, changing and complex environment.

1. Assist in determining the impact of operational issues and provide input into their resolution via data extraction and quantification.

1. Coordinate and prioritize all escalated activities, including testing, implementation of system upgrades, enhancements, and bug fixes.

1. Provide end-user support on Informatica products to multiple organizations within the agency when issues arise.

1. Perform regular administration tasks; migrations, setups, server accessibility requests, decommission and cleanup activities.

1. Support audit and compliance reporting requests.

1. Participate in and contribute to the implementation of best practices and standards for the Data Integration environment including Disaster Recovery and Business Continuity Planning.

1. Support the operation of Informatica products on a 24/7 basis as needed

1. Other duties as assigned.

Qualifications Education, Skills and Competencies:

Experience should include but not limited to:

1. Bachelor's degree Information Technology or related field or equivalent years of experience

1. 8-10+ years of experience in product implementation and administration of ETL with concentration on the Informatica suite of products.

1. Experience working with the following database technologies (Oracle, IDMS, VSAM, and MSSQL).

1. Experience working with Data Warehousing, ETL Development and ETL Architecture

1. Working knowledge and experience with Red Hat Enterprise Linux and Windows 2003/2008 operating systems installed within a VMware environment.

1. Working knowledge and experience with Red Hat Enterprise Linux, Windows 2003/2008, and Z/OS operating systems.

1. Knowledge and experience in implementing user and data level security using IBM TIM/TAM (ISIM/ISAM).

1. Basic understanding of IIS, Tomcat and WebLogic application servers as it relates to the Informatica infrastructure.

1. Excellent communication and troubleshooting skills.

1. Experience in the support/operation of an enterprise wide data warehouse, (6-8 yrs. preferred).

1. Practical experience of SQL skills and basic PL/SQL knowledge.

1. Understanding of DNS, Firewall and VPN, SFTP configuration.

1. Excellent documentation skills.

1. Ability to learn quickly and perform under extreme conditions.

1. Technical expertise in troubleshooting and resolving Informatica related problems.

1. Knowledge of scheduling jobs and automation.

1. Prior experience on projects with federal, state or local government is desirable, but not required.

1. Prior experience with ITIL v3 is a plus.

RMV Modernization Program Summary

The RMV is responsible for the issuance of all Massachusetts driver’s licenses, vehicle registrations and titles, processing over 6 million transactions daily and collecting over $1 Billion in revenue annually. The RMV also handles a number of additional areas such as safety and emissions inspections, excise tax collection, citation processing, un-paid parking ticket enforcement and administration of the Safe Driver Program. Some of the RMV’s major external partners include Law Enforcement, the Courts, municipalities, Insurance Agents and Companies, auto dealers, and AAA among others. The mission of the RMV is constantly expanding and new enhancements are being introduced regularly, most recently the Ignition Interlock system and expanded internet transaction capability. However, the technical limitations of the system are a major limiting factor in achieving the RMV’s future goals. Recognizing the need for an upgrade to both the underlying system infrastructure and the business environment responsible for delivery of services to the RMV’s customers and partners, MassDOT has received approval for capital funding to replace ALARS. The scope of the ALARS replacement project includes the design, development, configuration, implementation, and deployment of the new system. Funding for the full 5 year phased effort is anticipated to be provided through FY 16. For those joining this modernization effort, we expect significant opportunities to support the ongoing operations of the RMV and other areas within MassDOT.

A program team has been established and has already accomplished the following major milestones:

1. Contracted with Deloitte to be the system integrator.

1. Created program schedule and established the governance structure.

1. Begin efforts to support gathering high level business and technical requirements.

Upcoming activity over the next year includes:

1. Complete the general system design and gathering of high level requirements through requirements sessions.

1. Kickoff change management activities including planning for training.

1. Planning and positioning for data conversion.

1. Establish User Acceptance Test plan.

1. Establish solution architecture, security, and technical infrastructure.

If you are interested in being part of an innovative and exciting effort that will influence the design of RMV’s business in the future and you are motivated by actively participating in the introduction of significant changes to the RMV environment, this is an ideal opportunity for you.