Mandatory Qualifications: - Level III- More than seven (7) years of experience working on complex projects with 2 or more years in a leadership role as a Developer
- Seven or more years of hands-on experience in implementing and maintaining data integration processes using Informatica suite of products such as Master Data Management (MDM), Informatica PowerCenter and/or Informatica Data Quality or similar products.
- Between two to three years of domain knowledge and experience in an Integrated Eligibility System within a Health and Human Services programs such as PA, TA, SNAP, HEAP, Fair Hearings, Child Support, etc.
Desirable Qualifications: - Seven years or more of hands-on experience using ETL tools like Informatica PowerCenter to migrate data from various sources and targets including databases, flat files, and XML files, UNIX shell scripts.
- Seven or more years of experience with Data Quality processes, approaches, measurement techniques and business cases for data profiling, data cleansing, standardization, match and merge functionality using tools such as Informatica Data Quality.
- Seven or more years of experience developing complex SQL, PLSQL objects with Oracle 11g or higher such as stored procedures, triggers, packages, materialized view and using Oracle supplied utilities including: SQL Loader, external tables, and Oracle built in packages to migrate data.
- Seven or more years of experience writing complex UNIX scripts to validate and ftp files, and for scheduling / automating ETL processes.
- Seven or more years of experience with implementing ETL solutions for medium to large scale OLTP and OLAP projects.
- Seven or more years of experience in writing technical specifications including ETL source to target mapping documents, ETL design documents, implementation documents.
Duties/Responsibilities: Analyze requirements, design & develop end to end Master Data Management (MDM) solutions.
Design & build data models, data quality rules, match & survivorship rules etc.
Perform analysis, design, development and implementation, including data analysis, data access, data structures, data transformation, data reporting solutions and user documentation.
Manage and administer ETL solutions for medium to large scale OLTP and OLAP projects.
Monitor daily ETL jobs and processes that identify load and performance issues and determine the resolution and revise the incorrect operational processes.
Communicate and coordinate with members of the development team to work across multiple projects.
Explore, actively support and work on new technology initiatives that may be of interest to the organization.
Actively participate in troubleshooting any technical issues that the program may have.
Other duties as assigned.
Consultants may be eligible to telecommute for more than 50% of their work hours, up to and including 100% remote work. Telecommuting arrangements require direct manager approval and are subject to change based on program needs. Consultants approved for 100% remote work must attend monthly in-person meetings at the Albany office and be available for major milestone meetings as needed.
