NYS IES PRD-20241002-383 Developer Level 3 (Informatica MDM)
Voyatek

Opportunity Details

Full Time NYS IES PRD-20241002-383 Developer Level 3 (Informatica MDM)

Albany, NY

Outcomes. Delivered.

Voyatek, formerly GCOM Software and OnCore Consulting, delivers outcome-driven technology solutions to public sector agencies and higher education institutions nationwide.

For example, our technology:

• Facilitates access to nutritious food for children of mothers participating in the WIC program
• Supports first responders in reducing opioid overdoses within their communities
• Empowers colleges and universities to identify and thwart financial aid fraud
• Equips teachers with valuable insights to identify students requiring additional support
• Enhances efficiency for state tax agencies, leading to 99% faster return processing and quicker refunds for taxpayers

With a focus on Tax & Revenue, Health & Human Services, and Justice & Public Safety, Voyatek combines the scale to support large complex projects with the agility and accessibility of a boutique solutions provider. Together, Voyatek and its customers work to improve population wellbeing, create safer communities, and foster a thriving economy.

We're more than a technology company -- we're an outcomes company.

We encourage our employees to think differently, ask tough questions, and relentlessly pursue what's best for our customers and the residents they serve.

We believe that the value of technology is defined by its human impact. If you agree, you've come to the right place.

Voyatek is seeking applicants to occupy the position of Level 3 Developer to join our NYS Integrated Eligibility System Team located in Albany, NY. This role is On site, (then becomes Hybrid, 50% in office required) and is a long term contract, 28 months. The mission of the Integrated Eligibility System (IES) is to enhance the well-being of New Yorkers by transforming health and human service delivery through coordinated business practices, modernized technology, and strategic partnerships. IES will provide eligibility, enrollment, case management, and payment functionality for Health and Human Service programs currently served by the Welfare Management System, Benefits Issuance Control System and other State systems. IES will build on the successful opening of the New York State of Health (NYSoH) by leveraging assets created for the health benefit exchange to modernize the eligibility system for health and human service programs.

Key Responsibilities:

Daily activities will include, but are not limited to:

• As part of the product development team, you will work in an agile environment and collaborate and develop solutions to solve data integration challenges.
• As part of the Data Migration team, you will perform data migration activities to migrate data from legacy systems such as the mainframe, extracted data files, and databases to a modern data platform.
• As part of the Data Migration team, you will perform activities such as analyzing, designing, developing, testing, and deploying Extract, Transform, and Load (ETL) solutions.
• As part of the Data Migration team, you will perform data preparation activities such as data extraction, data analysis, data profiling, and data cleansing.
• As part of the Data Conversion team, you will perform data conversion activities such as data mapping and data consolidation of duplicate and redundant data.
• As part of the Data Management team, you will monitor daily ETL jobs and processes that identify load and performance issues and determine the resolution and revise the incorrect operational processes.
• As part of the Data Management team, you will create ETL design, source to target mapping documents, and implementation documentation.
• Communicate and coordinate with members of the product team to work across multiple projects.
• Other duties as assigned.

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

More than seven (7) years of experience working on complex data migration projects with 2 or more years in a leadership role as a Developer performing data extraction, data transformation, and data loading (ETL) from legacy systems to a modern data platform.

More than (7) years of hands-on experience in implementing and maintaining data integration and master data management processes using Informatica suite of products such as Informatica PowerCenter, Informatica Data Quality, and Informatica Master Data Management (MDM).

Desirable Qualifications:

Seven years or more of hands-on experience using Informatica PowerCenter to migrate data from various sources and targets including databases, flat files, JSON, and XML files.

Five or more years of experience with Data Quality processes, approaches, measurement techniques and business cases for data analysis, data profiling, data cleansing, data standardization, match and merge functionality using Informatica Data Quality.

Three or more years of hands-on professional experience performing MDM activities such as data cleansing, data ingestion pipelines, matching, merging, deduplication, hierarchy management, automation, and orchestration using Informatica MDM.

Five years or more experience in implementing concepts such as Slowly Changing Dimension (SCD Type) and Change Data Capture (CDC) functionality for data migration projects.

Seven or more years of experience developing complex SQL, T-SQL, PL/SQL objects with Oracle 19c or SQL Server 2019, or higher such as stored procedures, triggers, packages, materialized views, and performance tuning.

Three or more years of experience writing complex UNIX shell scripts to validate and ftp files, and for scheduling / automating ETL processes.

The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions. This includes, but is not limited to, skill sets, experience and training, licensure and certifications, and geographic location. At Voyatek, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. A range for this position would be $83.00-$93.00 per hour.

If you think you are a good fit for us, we encourage you to apply. Check out our career website for all open positions!

Voyatek provides equal employment opportunities to all employees and applicants for employment without regard to race, color, creed, ancestry, national origin, citizenship, sex or gender (including pregnancy, childbirth, and pregnancy-related conditions), gender identity or expression (including transgender status), sexual orientation, marital status or domestic violence victim status, religion, age, disability, genetic information, service in the military, or any other characteristic protected by applicable federal, state, or local laws and ordinances. Equal employment opportunity applies to all terms and conditions of employment, including recruitment and hiring, job assignment/placement, promotion, upgrading, demotion, termination, layoff, recall, transfer, leave of absence, rates of pay or other compensation, internship, and training.

---