State of Arizona

Job Page

State of Arizona$71K — $100K *
US-AnywhereRemote in Arizona, US
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree or 5+ years of advanced Informatica design and development experience
  • Proficiency with Informatica SAS MDM and Power Exchange
  • Strong SQL skills with understanding of dimensional data models
  • Experience in ETL workflows using Designer, Workflow Manager, and Repository Manager
  • Knowledge of Informatica Cloud and MS SQL Server

Responsibilities

  • Design, develop, and optimize ETL workflows with Informatica
  • Troubleshoot and resolve technical software issues
  • Document ETL processes and best practices
  • Collaborate with data stakeholders to meet integration needs
  • Manage Informatica Administration tasks

Benefits

  • Affordable medical, dental, life, and short-term disability insurance
  • Participation in Arizona State Retirement System and long-term disability plans
  • 10 paid holidays and vacation/sick time
  • Paid parental leave of up to 12 weeks
  • Tuition reimbursement and career advancement opportunities
Full Job Description
SENIOR INFORMATICA DEVELOPER
(Applications Developer Senior)

Job Location:

Division of Technology Services (DTS)
1400 West Washington Street, Phoenix, Arizona 85007


Posting Details:

Salary: $71,677 to $100,744 Grade: 27 Closing Date: 06/21/2026

Job Summary:

The Department of Economic Security, Division of Technology Services, is seeking an experienced and highly motivated professional to join our team as a Senior Informatica IDMC Developer (Applications Development Senior). The individual in this role will be responsible for the complete life cycle and the management of Master Data Management (MDM) processes and database systems. Collaborating with business, development, and testing teams, this role will facilitate accurate Match, Merge and Survivalship of Client domain data within the organization's standards and maintain 24/7 system availability, investigate and analyze issues, as well as research opportunities for improvement of processes. Provide technical advice and guidance to the junior developers on the team while collaborating with business analysts and architects to contribute to projects that enhance system functionality and support business requirements.

This position may offer the ability to work remotely, within Arizona, based upon the department's business needs and continual meeting of expected performance measures.

The State of Arizona strives for a work culture that affords employees flexibility, autonomy, and trust. Across our many agencies, boards, and commissions, many State employees participate in the State's Remote Work Program and are able to work remotely in their homes, in offices, and in hoteling spaces. All work, including remote work, should be performed within Arizona unless an exception is properly authorized in advance.

Job Duties:

Essential Duties and Responsibilities include but are not limited to:
• Design, develop, and optimize ETL workflows and mappings using Informatica SAS MDM and Intelligent Data Management Cloud (IDMC)
• Troubleshooting and resolving technical issues. Fixing bugs or issues within the software.
• Document ETL processes, workflows, and best practices.
• Collaborate with data architects, analysts, and business stakeholders to understand data integration needs and implement solutions.
• Informatica Administration.

Knowledge, Skills & Abilities (KSAs):

Knowledge of:
• Informatica REST APIs
• Informatica Cloud, specifically SAS MDM (IDMC)
• MS SQL Server
• Data warehousing concepts and BI architecture
• Different scripting languages
• Data Modeling / Data Warehouse Designing concepts
• AZURE DEVOPS

Skills In:
• Expertise in Master Data Management aspects - Data collection, standardization, Ingestion, Match / Merge rules and Survival conditions.
• Expertise in ETL data management areas such as ETL and database architecture and design, data warehouse design and implementation, and administration
• Developing, maintaining and testing all IDMC workflows.
• Strong problem-solving and analytical skills, conducting the testing process, and resolving all defects
• Strong SQL experience and an understanding of dimensional data models to design a robust and secure Data modeling experience to design Datawarehouse
• Strong skills in all phases of the Software Development Life Cycle (SDLC) using Agile methodologies
• Excellent communication skills

Ability to:
• Translate business requirements into technical solutions
• Work effectively
• Prioritize tasks and work concurrently on multiple tasks
• Build strong relationships inside and outside
• the organization.
• Write technical documentation.
• Work well independently and in a team environment
• Use or maintain testing frameworks, test libraries, databases, and test environments.

Selective Preference(s):

The ideal candidate for this position will have:
• Bachelor's degree OR Five plus years of advanced Informatica design and development skills using Informatica SAS MDM and Power Exchange.
• Experience in developing Informatica ETL mappings using Designer, Workflow Manager, Workflow Monitor, and Repository Manager.

Benefits:

The Arizona Department of Economic Security offers a comprehensive benefits package to include:
• Affordable medical, dental, life, and short-term disability insurance plans
• Participation in the Arizona State Retirement System (ASRS) and long-term disability plans
• 10 paid holidays per year
• Paid vacation and sick time
• Paid Parental Leave-Up to 12 weeks per year paid leave for newborn or newly-placed foster/adopted child.
• Deferred compensation plan
• Wellness plans
• Tuition Reimbursement
• Stipend Opportunities
• Infant at Work Program
• Rideshare and Public Transit Subsidy
• Career Advancement & Employee Development Opportunities

By providing the option of a full-time or part-time remote work schedule, employees enjoy improved work/life balance, report higher job satisfaction, and are more productive. Remote work is a management option and not an employee entitlement or right. An agency may terminate a remote work agreement at its discretion.

Learn more about the Paid Parental Leave program here . For a complete list of benefits provided by The State of Arizona, please visit our benefits page

Retirement:

State employees are required to participate in the Arizona State Retirement System (ASRS), the state-sponsored retirement contribution plan and the Long-Term Disability (LTD) program after a 27-week waiting period. The ASRS defined benefit plan provides for life-long income upon retirement. You will also have the option to participate in a voluntary deferred compensation program to take advantage of tax-deferred retirement investments.

On or shortly after your first day of work, you will be provided with additional information about the available insurance plans, enrollment instructions, submission deadlines and effective dates.

Contact Us:

For questions about this career opportunity, please contact Shannon Anguiano at [email protected].

About State of Arizona

The State of Arizona is a government entity responsible for providing a variety of services to its residents, including education, healthcare, and public safety. The state was admitted to the Union in 1912 and has since grown to become the 14th largest state in the United States. Arizona is known for its diverse geography, including the Grand Canyon and other natural wonders. The state government is committed to promoting economic growth and improving the quality of life for all Arizonans.
Learn more about State of Arizona
Size
52,000 employees
Industry

Similar Jobs

More Jobs at State of Arizona

  • State of Arizona
    Job Page
    $85K — $90K *
    Phoenix, AZ 85032 (Maricopa County)
    Education, Government & Non-Profit
    In-Person
  • State of Arizona
    Job Page
    $85K — $115K *
    Phoenix, AZ 85032 (Maricopa County)
    Healthcare
    In-Person
  • State of Arizona
    Job Page
    $90K *
    Phoenix, AZ 85032 (Maricopa County)
    Transportation
    In-Person
  • State of Arizona
    Job Page
    $102K *
    Phoenix, AZ 85032 (Maricopa County)
    Education, Government & Non-Profit
    In-Person
  • State of Arizona
    Job Page
    $110K — $120K *
    Remote
    Education, Government & Non-Profit
    Remote in Arizona, US

More Information Technology Jobs

Find similar Job Page jobs: