Informatica Administrator

City of New York•New York, NY

10d•Hybrid

About The Position

The NYC Department of Finance (DOF) administers the city’s tax revenue laws and provides technology solutions that support revenue collection and customer service. Within DOF’s Finance Information Technology Division, the Citywide Payment Applications Unit maintains systems that collect revenue and fees for DOF and 30 other NYC agencies, including CityPay websites for online payments. The Informatica Administrator will help design and develop mappings, transformations, sessions, and workflows, and deploy integration solutions. The role also leads ongoing tuning, maintenance, and support of the Citywide Payment Services & Standards Informatica Power Center application. The position reports to the Informatica Manager and includes day-to-day and non-business-hours support, production deployments, and managing a transition from the existing in-house Linux-based application to a cloud-based application. The position may be eligible for remote work up to two days per week under the City’s Remote Work Pilot Program.

Requirements

A baccalaureate degree in computer science, engineering, human computer interaction, interactive media, digital and graphics design, data visualization, communication, or a related field, plus four years of satisfactory full-time related experience and specialization in a relevant technology, process, methodology, or domain; or an equivalent qualifying combination of education and experience.
Alternatively, an associate degree in one of the listed or related fields plus six years of satisfactory full-time related experience and relevant specialization.
Alternatively, a baccalaureate degree in any field plus eight years of satisfactory full-time related experience and relevant specialization.
Experience and specialization related to the required areas of the particular position.
Knowledge of Informatica Cloud to manage the transition to a cloud-based application.
Ability to support an Informatica Power Center application, including ETL development, installation, tuning, maintenance, and production deployments.

Responsibilities

Drive improvement initiatives using collaboration techniques, emerging methodologies, and automation tools.
Create interaction models and interface designs for IT projects based on standards, business and technical requirements, and functional team input.
Participate in human-centered design activities, user research, software prototyping, and usability testing.
Ensure software products and solutions are tested against functional usability and technical performance requirements.
Create test cases, test scripts, and defect reports; execute test scripts and document progress and results.
Collaborate with business analysts to understand business requirements and with technical teams to understand application capabilities, environment setup, and defect fixes.
Research emerging technologies and coordinate demonstrations and proof-of-concept initiatives; liaise with vendors as necessary.
Recommend and manage the application of methodologies or technologies on IT projects, or advocate for exceptions to established practices when needed to meet project objectives.
Use specialized business-domain knowledge to define requirements based on customer business needs and objectives.
Code ETL data loads and transformations, including new and modified transformations.
Maintain and support the Department of Finance Citywide Payment Services & Standards Informatica Power Center application.
Perform day-to-day and non-business-hours support functions.
Install new Informatica instances and related services, validate installations, and arrange team testing.
Tune and maintain all installation instances by reviewing logs for errors and delays and addressing them.
Serve as the primary contact for Informatica Support to resolve coding or infrastructure issues.
Execute production deployments.
Manage the transition from the current in-house Linux-based application to a cloud-based application using knowledge of Informatica Cloud.